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

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

diff --git a/inc/modules/admin/what-list_network_data.php b/inc/modules/admin/what-list_network_data.php
index aa4a9321bdcb4db94496cd75270a5899ab47b42e..428c3ce06f5a8f103f4a7bd2fa04ce72113ed1a6 100644 (file)
--- a/inc/modules/admin/what-list_network_data.php
+++ b/inc/modules/admin/what-list_network_data.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * 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 *
@@ -50,19 +50,19 @@ 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
 
 // Query for networks
-$result = SQL_QUERY('SELECT
+$result = sqlQuery('SELECT
        `network_id`,
        `network_short_name`,
        `network_title`,
@@ -79,23 +79,23 @@ ORDER BY
        `network_short_name` ASC', __FILE__, __LINE__);
 
 // Are there entries?
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNumRows($result)) {
        // List all
        $OUT = '';
-       while ($content = SQL_FETCHARRAY($result)) {
+       while ($content = sqlFetchArray($result)) {
                // Load row template
-               $OUT .= loadTemplate('admin_list_network_data_row', true, $content);
+               $OUT .= loadTemplate('admin_list_network_data_row', TRUE, $content);
        } // END - while
 
        // Load main template
-       loadTemplate('admin_list_network_data', false, $OUT);
+       loadTemplate('admin_list_network_data', FALSE, $OUT);
 } else {
        // Display a message that there are sponsor networks supported, yet
        displayMessage('{--ADMIN_NETWORK_NONE_SUPPORTED--}');
 }
 
 // Free result
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // Add form for adding new entry
 loadTemplate('admin_add_network');