Some variable rewrites

[mailer.git] / inc / libs / sponsor_functions.php

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index 5d99a7d5a59d749c8c179a99ce76090b7b7621d2..4f2fd8fa348a89e073e73ef414dbc2d7a20035e9 100644 (file)
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -120,18 +120,18 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
                if ((empty($POST['force'])) || (!IS_ADMIN())) $POST['force'] = 0;
 
                // SQL and message string is empty by default
-               $SQL = ""; $MSG = "";
+               $sql = ""; $MSG = "";
 
                // Update?
                if ($UPDATE) {
                        // Update his data
-                       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET ";
+                       $sql = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET ";
                        foreach ($DATA['keys'] as $k => $v) {
-                               $SQL .= $v."='%s', ";
+                               $sql .= $v."='%s', ";
                        }
 
                        // Remove last ", " from SQL string
-                       $SQL = substr($SQL, 0, -2)." WHERE id='%s' LIMIT 1";
+                       $sql = substr($sql, 0, -2)." WHERE id='%s' LIMIT 1";
                        $DATA['values'][] = bigintval(REQUEST_GET('id'));
 
                        // Generate message
@@ -160,7 +160,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
                        $VALUES = str_repeat("%s', '", count($DATA['values']) - 1);
 
                        // Generate string
-                       $SQL = "INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_data` (".$KEYS.") VALUES ('".$VALUES."%s')";
+                       $sql = "INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_data` (".$KEYS.") VALUES ('".$VALUES."%s')";
 
                        // Generate message
                        $MSG = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_ADDED'), "added", $MSGs);
@@ -186,9 +186,9 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
                        $ret = "already";
                }
 
-               if (!empty($SQL)) {
+               if (!empty($sql)) {
                        // Run SQL command
-                       $result = SQL_QUERY_ESC($SQL, $DATA['values'], __FUNCTION__, __LINE__);
+                       $result = SQL_QUERY_ESC($sql, $DATA['values'], __FUNCTION__, __LINE__);
                }
 
                // Output message
@@ -401,10 +401,10 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
        $DATA = array();
 
        // Prepare SQL string
-       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET";
+       $sql = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET";
        foreach ($POST as $key => $value) {
                // Mmmmm, too less security here???
-               $SQL   .= " ".strip_tags($key)."='%s',";
+               $sql   .= " ".strip_tags($key)."='%s',";
 
                // We will secure this later inside the SQL_QUERY_ESC() function
                $DATA[] = strip_tags($value);
@@ -420,7 +420,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
                        $EMAIL = true;
 
                        // Okay, has changed then add status with UNCONFIRMED and new hash code
-                       $SQL .= " `status`='EMAIL', hash='%s',";
+                       $sql .= " `status`='EMAIL', hash='%s',";
 
                        // Generate hash code
                        $HASH = md5(session_id().":".$POST['email'].":".GET_REMOTE_ADDR().":".GET_USER_AGENT().":".time());
@@ -429,10 +429,10 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
        }
 
        // Remove last commata
-       $SQL = substr($SQL, 0, -1);
+       $sql = substr($sql, 0, -1);
 
        // Add SQL tail data
-       $SQL .= " WHERE id='%s' AND password='%s' LIMIT 1";
+       $sql .= " WHERE id='%s' AND password='%s' LIMIT 1";
        $DATA[] = bigintval(get_session('sponsorid'));
        $DATA[] = get_session('sponsorpass');
 
@@ -472,7 +472,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
        if (SQL_AFFECTEDROWS() == 1) {
                if (!empty($templ) && !empty($subj)) {
                        // Run SQL command and check for success
-                       $result = SQL_QUERY_ESC($SQL, $DATA, __FUNCTION__, __LINE__);
+                       $result = SQL_QUERY_ESC($sql, $DATA, __FUNCTION__, __LINE__);
 
                        // Add all data to content
                        global $DATA;