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 9e505a9e9e3eda2a189bf298f6f7c5ae199e0e2f..4e50fd3fc8bf6261cf991cd5306ace2cf0426a52 100644 (file)
--- a/inc/modules/admin/what-list_network_types.php
+++ b/inc/modules/admin/what-list_network_types.php
@@ -6,9 +6,9 @@
  * -------------------------------------------------------------------- *
  * 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::                                                            $ *
@@ -16,8 +16,8 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * 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 *
@@ -50,66 +50,84 @@ if (doVerifyExpertSettings() != 'agreed') {
 } // END - if
 
 // By default we should display list/add new forms
-$GLOBALS['network_display'] = true;
+$GLOBALS['network_display'] = TRUE;
 
 // Handle form here
 doNetworkHandleForm();
 
 // Display forms?
-if ($GLOBALS['network_display'] === false) {
+if ($GLOBALS['network_display'] === FALSE) {
        // Abort here
        return;
 } // END - if
 
-// Do we have a network selected?
-if (isGetRequestParameterSet('network')) {
+// Is there a network selected?
+if (isGetRequestElementSet('network_id')) {
        // Get its data for template
-       $networkData = getNetworkDataById(getRequestParameter('network'));
+       $networkData = getNetworkDataFromId(getRequestElement('network_id'));
 
        // Init disabled list
        $GLOBALS['network_types_disabled'] = array();
 
        // Load all advert types for given network
-       $result = SQL_QUERY_ESC("SELECT
-       `network_type_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`
+       $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_handle` ASC",
-               array(getRequestParameter('network')), __FILE__, __LINE__);
+       `network_type_handler` ASC',
+               array(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__);
 
-       // Do we have entries?
-       if (!SQL_HASZERONUMS($result)) {
+       // Are there entries?
+       if (!ifSqlHasZeroNumRows($result)) {
                // List all entries
                $OUT = '';
-               while ($row = SQL_FETCHARRAY($result)) {
-                       // Add/translate some data
-                       $row['network_type_banner_url'] = fixNullEmptyToDashes($row['network_type_banner_url'], 3);
-
+               while ($row = sqlFetchArray($result)) {
                        // Set disabled entry
-                       $GLOBALS['network_types_disabled'][$row['network_type_handle']] = true;
+                       $GLOBALS['network_types_disabled'][$row['network_type_handler']] = TRUE;
 
                        // Add row template and switch color
-                       $OUT .= loadTemplate('admin_list_network_types_row', true, $row);
+                       $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, $OUT);
+               loadTemplate('admin_list_network_types', FALSE, $content);
        } else {
                // No entries found
-               displayMessage('{%message,ADMIN_NETWORK_TYPES_404=' . $networkData['network_title'] . '%}');
+               displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_404=' . $networkData['network_title'] . '%}');
        }
 
        // Free result
-       SQL_FREERESULT($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);
+       loadTemplate('admin_add_network_type', FALSE, $networkData);
 } else {
        // Generate network list for this script
-       outputHtml(generateAdminNetworkList());
+       $OUT = generateAdminNetworkList();
+
+       // Is it not empty?
+       if (!empty($OUT)) {
+               // Output it
+               outputHtml($OUT);
+       } // END - if
 }
 
 // [EOF]