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

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

diff --git a/inc/modules/admin/what-config_payouts.php b/inc/modules/admin/what-config_payouts.php
index dc8bb05633cf7ad06ec7a98509a39723afd8ec44..6517b412102c1f01ee689c42eb3e3f643b53b541 100644 (file)
--- a/inc/modules/admin/what-config_payouts.php
+++ b/inc/modules/admin/what-config_payouts.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 *
@@ -46,11 +46,11 @@ addYouAreHereLink('admin', __FILE__);
 // Do we add an entry?
 if ((isFormSent('add')) && (isPostRequestElementSet('title')) && (postRequestElement('rate') > 0)) {
        // Add new payout type
-       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE type='%s' LIMIT 1",
+       $result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE type='%s' LIMIT 1",
                array(postRequestElement('title')), __FILE__, __LINE__);
-       if (SQL_HASZERONUMS($result)) {
+       if (ifSqlHasZeroNumRows($result)) {
                // Add now
-               SQL_QUERY_ESC("INSERT INTO
+               sqlQueryEscaped("INSERT INTO
        `{?_MYSQL_PREFIX?}_payout_types`
 (
        `type`, `rate`, `min_points`, `from_account`, `from_pass`, `engine_url`, `engine_ret_ok`, `engine_ret_failed`, `pass_enc`, `allow_url`
@@ -74,7 +74,7 @@ if ((isFormSent('add')) && (isPostRequestElementSet('title')) && (postRequestEle
                $message = '{--ADMIN_PAYOUT_TYPE_ADDED--}';
        } else {
                // Free memory
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
 
                // Does already exist
                $message = '<div class="bad">{--ADMIN_PAYOUT_TYPE_ALREADY--}</div>';
@@ -82,7 +82,7 @@ if ((isFormSent('add')) && (isPostRequestElementSet('title')) && (postRequestEle
 }
 
 // Payout requests by your members
-$result_mem = SQL_QUERY("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_payouts` WHERE `status`='NEW' ORDER BY payout_timestamp DESC", __FILE__, __LINE__);
+$result_mem = sqlQuery("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_payouts` WHERE `status`='NEW' ORDER BY payout_timestamp DESC", __FILE__, __LINE__);
 
 $display = TRUE;
 if ((isFormSent('edit')) && (ifPostContainsSelections())) {
@@ -91,10 +91,10 @@ if ((isFormSent('edit')) && (ifPostContainsSelections())) {
        $OUT = '';
        foreach (postRequestElement('sel') as $id => $sel) {
                // Load data
-               $result = SQL_QUERY_ESC("SELECT `id`, `type`, `rate`, `min_points`, `allow_url` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
+               $result = sqlQueryEscaped("SELECT `id`, `type`, `rate`, `min_points`, `allow_url` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
                        array(bigintval($id)), __FILE__, __LINE__);
-               $content = SQL_FETCHARRAY($result);
-               SQL_FREERESULT($result);
+               $content = sqlFetchArray($result);
+               sqlFreeResult($result);
 
                // Prepare data for the row template
                $content['allow_url'] = addSelectionBox('yn', $content['allow_url'], 'allow_url[' . $content['id'] . ']');
@@ -118,7 +118,7 @@ if ((isFormSent('edit')) && (ifPostContainsSelections())) {
                // Edit only if something is entered
                if ((isPostRequestElementSet('type', $id)) && (postRequestElement('rate', $id) > 0)) {
                        // Update entry
-                       addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_payout_types` SET
+                       addSql(sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_payout_types` SET
        `type`='%s',
        `rate`=%s,
        `min_points`=%s,
@@ -149,10 +149,10 @@ LIMIT 1",
                $id = bigintval($id);
 
                // Load data
-               $result = SQL_QUERY_ESC("SELECT `id`, `type`, `rate`, `min_points` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
+               $result = sqlQueryEscaped("SELECT `id`, `type`, `rate`, `min_points` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
                        array($id), __FILE__, __LINE__);
-               $content = SQL_FETCHARRAY($result);
-               SQL_FREERESULT($result);
+               $content = sqlFetchArray($result);
+               sqlFreeResult($result);
 
                // Load row template and switch color
                $OUT .= loadTemplate('admin_delete_payouts_row', TRUE, $content);
@@ -166,7 +166,7 @@ LIMIT 1",
 
        // Delete entries
        foreach (postRequestElement('sel') as $id => $sel) {
-               addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
+               addSql(sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
                        array(bigintval($id)), __FILE__, __LINE__, FALSE));
        } // END - foreach
 
@@ -183,7 +183,7 @@ if (!empty($message)) {
 } // END - if
 
 // Payout types
-$result_type = SQL_QUERY('SELECT
+$result_type = sqlQuery('SELECT
        `id`,
        `type`,
        `rate`,
@@ -194,23 +194,23 @@ FROM
 ORDER BY
        `type` ASC', __FILE__, __LINE__);
 
-if ((!SQL_HASZERONUMS($result_type)) && ($display)) {
+if ((!ifSqlHasZeroNumRows($result_type)) && ($display)) {
        // List all payout types
        $OUT = '';
-       while ($content = SQL_FETCHARRAY($result_type)) {
+       while ($content = sqlFetchArray($result_type)) {
                // Load row template and switch color
                $OUT .= loadTemplate('admin_config_payouts_row', TRUE, $content);
        } // END - while
 
        // Free memory
-       SQL_FREERESULT($result_type);
+       sqlFreeResult($result_type);
 
        // Load main template
        loadTemplate('admin_config_payouts', FALSE, $OUT);
 } // END - if
 
 // Does your members request payouts?
-if ((!SQL_HASZERONUMS($result_mem)) && ($display === TRUE)) {
+if ((!ifSqlHasZeroNumRows($result_mem)) && ($display === TRUE)) {
        // Members has requested payouts
        displayMessage('<a href="{%url=modules.php?module=admin&amp;what=list_payouts%}">{--ADMIN_PAYOUT_LIST_REQUESTS--}</a>');
 } elseif ($display === TRUE) {
@@ -219,7 +219,7 @@ if ((!SQL_HASZERONUMS($result_mem)) && ($display === TRUE)) {
 }
 
 // Free result
-SQL_FREERESULT($result_mem);
+sqlFreeResult($result_mem);
 
 // Add new payout type
 if ($display === TRUE) {