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

[mailer.git] / inc / filter / earning_filter.php

diff --git a/inc/filter/earning_filter.php b/inc/filter/earning_filter.php
index fcc23d78bc94b8d149ed7045e17747fbe64628c1..a658857f59ee9d76152260bac66cbe21f1e932a9 100644 (file)
--- a/inc/filter/earning_filter.php
+++ b/inc/filter/earning_filter.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2013 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,7 +50,7 @@ function FILTER_ADD_EARNING_GROUP_POPUP ($filterData) {
        } // END - if
 
        // Now check if the user has subscription and amount left
-       $result = SQL_QUERY_ESC("SELECT
+       $result = sqlQueryEscaped("SELECT
        `d`.`earning_id`,
        `d`.`earning_provider`,
        `u`.`earning_current_amount`,
@@ -77,9 +77,9 @@ ORDER BY
                ), __FUNCTION__, __LINE__);
 
        // Are there entries left?
-       if (!SQL_HASZERONUMS($result)) {
+       if (!ifSqlHasZeroNumRows($result)) {
                // Load all names
-               while ($content = SQL_FETCHARRAY($result)) {
+               while ($content = sqlFetchArray($result)) {
                        // Merge the $filterData array in
                        $content = merge_array($content, $filterData);
 
@@ -96,7 +96,7 @@ ORDER BY
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return filter data
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!');