Continued:

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

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index b5cbe201a128ab1c26912f89bd91df981141000d..5e811f1e8ca44768b35981e503bba85758010c56 100644 (file)
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2016 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -56,8 +56,8 @@ if (isFormSent()) {
                        );
 
                        // Load his personal data
-                       $result_main = SQL_QUERY_ESC("SELECT
-       `id`, `gender`, `surname`, `family`, `email`, `remote_addr`,
+                       $result_main = sqlQueryEscaped("SELECT
+       `id`, `sex`, `surname`, `family`, `email`, `remote_addr`,
        UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`,
        `points_amount`, `points_used`,
        (`points_amount` + `points_used`) AS `points`,
@@ -71,12 +71,12 @@ LIMIT 1",
                        array($content['id']), __FILE__, __LINE__);
 
                        // Is there an entry?
-                       if (SQL_NUMROWS($result_main) == 1) {
+                       if (sqlNumRows($result_main) == 1) {
                                // Load data
-                               $content = SQL_FETCHARRAY($result_main);
+                               $content = sqlFetchArray($result_main);
 
                                // Check for open payments and close them
-                               $result = SQL_QUERY_ESC("SELECT
+                               $result = sqlQueryEscaped("SELECT
        `so`.`admin_id`,
        `so`.`pay_count`,
        UNIX_TIMESTAMP(`so`.`pay_ordered`) AS `pay_ordered`,
@@ -95,9 +95,9 @@ WHERE
 ORDER BY
        `sp`.`pay_name` ASC",
                                        array($content['id']), __FILE__, __LINE__);
-                               if (!SQL_HASZERONUMS($result)) {
+                               if (!ifSqlHasZeroNumRows($result)) {
                                        // Payment does exist
-                                       while ($content2 = SQL_FETCHARRAY($result)) {
+                                       while ($content2 = sqlFetchArray($result)) {
                                                // Merge both arrays
                                                $content = merge_array($content, $content2);
 
@@ -125,7 +125,7 @@ ORDER BY
                                }
 
                                // Free memory
-                               SQL_FREERESULT($result);
+                               sqlFreeResult($result);
                        } else {
                                // Not found
                                displayMessage('{%message,ADMIN_SPONSOR_ACCOUNT_404_ALREADY_CONFIRMED=' . $content['id'] . '%}');
@@ -133,10 +133,10 @@ ORDER BY
                        }
 
                        // Free memory
-                       SQL_FREERESULT($result_main);
+                       sqlFreeResult($result_main);
 
                        // Unlock sponsor account
-                       SQL_QUERY_ESC("UPDATE
+                       sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_sponsor_data`
 SET
        `status`='CONFIRMED'
@@ -149,7 +149,7 @@ LIMIT 1",
                        // Update, if applyable, referral count and points
                        if ((isValidId($content['refid'])) && ($content['refid'] != $content['id'])) {
                                // Update referral account
-                               SQL_QUERY_ESC("UPDATE
+                               sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_sponsor_data`
 SET
        `points_amount`=`points_amount`+{?sponsor_ref_points?},
@@ -160,11 +160,11 @@ LIMIT 1",
                                        array(bigintval($content['refid'])), __FILE__, __LINE__);
 
                                // Whas that update fine?
-                               if (!SQL_HASZEROAFFECTED()) {
+                               if (!ifSqlHasZeroAffectedRows()) {
                                        // Load referral's data
-                                       $result = SQL_QUERY_ESC("SELECT
+                                       $result = sqlQueryEscaped("SELECT
        `id`,
-       `gender`,
+       `sex`,
        `surname`,
        `family`,
        `email`,
@@ -177,7 +177,7 @@ WHERE
        `id`=%s
 LIMIT 1",
                                        array(bigintval($content['refid'])), __FILE__, __LINE__);
-                                       $REFERRAL = SQL_FETCHARRAY($result);
+                                       $REFERRAL = sqlFetchArray($result);
 
                                        // Send warnings out?
                                        if ($REFERRAL['receive_warnings'] == 'Y') {
@@ -187,7 +187,7 @@ LIMIT 1",
                                        } // END - if
 
                                        // Free memory
-                                       SQL_FREERESULT($result);
+                                       sqlFreeResult($result);
                                } // END - if
                        } // END - if
 
@@ -202,8 +202,8 @@ LIMIT 1",
 } // END - if
 
 // Begin listing of all pending sponsor accounts
-$result = SQL_QUERY("SELECT
-       `id`, `gender`, `surname`, `family`, `email`, `remote_addr`,
+$result = sqlQuery("SELECT
+       `id`, `sex`, `surname`, `family`, `email`, `remote_addr`,
        UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`
 FROM
        `{?_MYSQL_PREFIX?}_sponsor_data`
@@ -212,10 +212,10 @@ WHERE
 ORDER BY
        `id`", __FILE__, __LINE__);
 
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNumRows($result)) {
        // Entries found so let's list them!
        $OUT = '';
-       while ($content = SQL_FETCHARRAY($result)) {
+       while ($content = sqlFetchArray($result)) {
                // Translate some data
                $content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2);
 
@@ -231,7 +231,7 @@ if (!SQL_HASZERONUMS($result)) {
 }
 
 // Free memory
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // [EOF]
 ?>