Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.

[mailer.git] / inc / modules / admin / what-list_network_types.php

diff --git a/inc/modules/admin/what-list_network_types.php b/inc/modules/admin/what-list_network_types.php
index fc31ab8560e52297bd74ca6d46c4d34b1b6b3a94..4e50fd3fc8bf6261cf991cd5306ace2cf0426a52 100644 (file)
--- a/inc/modules/admin/what-list_network_types.php
+++ b/inc/modules/admin/what-list_network_types.php
@@ -6,19 +6,18 @@
  * -------------------------------------------------------------------- *
  * File              : what-list_network_types.php                      *
  * -------------------------------------------------------------------- *
- * Short description : List/manage network advertising types            *
+ * Short description : List/manage network advertising type handlers    *
  * -------------------------------------------------------------------- *
- * Kurzbeschreibung  : Verwaltet Werbearten                             *
+ * Kurzbeschreibung  : Verwaltet Werbeart-Handler                       *
  * -------------------------------------------------------------------- *
  * $Revision::                                                        $ *
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -42,7 +41,94 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 } // END - if
 
 // Add description as navigation point
-addMenuDescription('admin', __FILE__);
+addYouAreHereLink('admin', __FILE__);
+
+// These are expert settings!
+if (doVerifyExpertSettings() != 'agreed') {
+       // Abort here
+       return;
+} // END - if
+
+// By default we should display list/add new forms
+$GLOBALS['network_display'] = TRUE;
+
+// Handle form here
+doNetworkHandleForm();
+
+// Display forms?
+if ($GLOBALS['network_display'] === FALSE) {
+       // Abort here
+       return;
+} // END - if
+
+// Is there a network selected?
+if (isGetRequestElementSet('network_id')) {
+       // Get its data for template
+       $networkData = getNetworkDataFromId(getRequestElement('network_id'));
+
+       // Init disabled list
+       $GLOBALS['network_types_disabled'] = array();
+
+       // Load all advert types for given network
+       $result = sqlQueryEscaped('SELECT
+       `network_type_id`,
+       `network_type_handler`,
+       `network_type_api_url`,
+       `network_type_click_url`,
+       `network_type_banner_url`,
+       `network_type_reload_time_unit`,
+       `network_text_encoding`
+FROM
+       `{?_MYSQL_PREFIX?}_network_types`
+WHERE
+       `network_id`=%s
+ORDER BY
+       `network_type_handler` ASC',
+               array(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__);
+
+       // Are there entries?
+       if (!ifSqlHasZeroNumRows($result)) {
+               // List all entries
+               $OUT = '';
+               while ($row = sqlFetchArray($result)) {
+                       // Set disabled entry
+                       $GLOBALS['network_types_disabled'][$row['network_type_handler']] = TRUE;
+
+                       // Add row template and switch color
+                       $OUT .= loadTemplate('admin_list_network_types_row', TRUE, $row);
+               } // END - while
+
+               // Generate array
+               $content = array(
+                       'rows'       => $OUT,
+                       'network_id' => bigintval(getRequestElement('network_id'))
+               );
+
+               // Load main template
+               loadTemplate('admin_list_network_types', FALSE, $content);
+       } else {
+               // No entries found
+               displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_404=' . $networkData['network_title'] . '%}');
+       }
+
+       // Free result
+       sqlFreeResult($result);
+
+       // Add content for reload time unit
+       $networkData['network_type_reload_time_unit'] = generateTimeUnitSelectionBox('h', 'network_type_reload_time_unit', array('W', 'D', 'h', 'm', 's'));
+
+       // Add form for adding new types
+       loadTemplate('admin_add_network_type', FALSE, $networkData);
+} else {
+       // Generate network list for this script
+       $OUT = generateAdminNetworkList();
+
+       // Is it not empty?
+       if (!empty($OUT)) {
+               // Output it
+               outputHtml($OUT);
+       } // END - if
+}
 
 // [EOF]
 ?>