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 07e6d4ab31021d285e212f4fb51375b0f2727152..4e50fd3fc8bf6261cf991cd5306ace2cf0426a52 100644 (file)
--- a/inc/modules/admin/what-list_network_types.php
+++ b/inc/modules/admin/what-list_network_types.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * $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 *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *


@@ -70,7 +70,7 @@ if (isGetRequestElementSet('network_id')) {
        $GLOBALS['network_types_disabled'] = array();
 
        // Load all advert types for given network
        $GLOBALS['network_types_disabled'] = array();
 
        // Load all advert types for given network

-       $result = SQL_QUERY_ESC('SELECT
+       $result = sqlQueryEscaped('SELECT

        `network_type_id`,
        `network_type_handler`,
        `network_type_api_url`,
        `network_type_id`,
        `network_type_handler`,
        `network_type_api_url`,


@@ -87,10 +87,10 @@ ORDER BY
                array(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__);
 
        // Are there entries?
                array(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__);
 
        // Are there entries?

-       if (!SQL_HASZERONUMS($result)) {
+       if (!ifSqlHasZeroNumRows($result)) {

                // List all entries
                $OUT = '';
                // List all entries
                $OUT = '';

-               while ($row = SQL_FETCHARRAY($result)) {
+               while ($row = sqlFetchArray($result)) {

                        // Set disabled entry
                        $GLOBALS['network_types_disabled'][$row['network_type_handler']] = TRUE;
 
                        // Set disabled entry
                        $GLOBALS['network_types_disabled'][$row['network_type_handler']] = TRUE;
 


@@ -112,7 +112,7 @@ ORDER BY
        }
 
        // Free result
        }
 
        // 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 content for reload time unit
        $networkData['network_type_reload_time_unit'] = generateTimeUnitSelectionBox('h', 'network_type_reload_time_unit', array('W', 'D', 'h', 'm', 's'));