Some SQL queries improved, sponsor registration fixed:

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

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index a625a5517e9fca8dc6f41e5a69917d8ef8d4f9c7..46e4a13b0f7c3541ae61fb1429bf914551ef35a2 100644 (file)
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -137,7 +137,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray=array(),
                                }
 
                                // 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(getRequestParameter('id'));
 
                                // Generate message
@@ -259,7 +259,7 @@ function isSponsor () {
 FROM
        `{?_MYSQL_PREFIX?}_sponsor_data`
 WHERE
-       `id`='%s' AND `password`='%s' AND `status`='CONFIRMED'
+       `id`=%s AND `password`='%s' AND `status`='CONFIRMED'
 LIMIT 1",
                        array(
                                bigintval(getSession('sponsor_id')),
@@ -382,9 +382,14 @@ function updateSponsorLogin () {
        // Is sponsor?
        if (isSponsor()) {
                // Update last online timestamp
-               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data`
-SET `last_online`=UNIX_TIMESTAMP()
-WHERE `id`='%s' AND `password`='%s' LIMIT 1",
+               SQL_QUERY_ESC("UPDATE
+       `{?_MYSQL_PREFIX?}_sponsor_data`
+SET
+       `last_online`=UNIX_TIMESTAMP()
+WHERE
+       `id`=%s AND
+       `password`='%s'
+LIMIT 1",
                        array(
                                bigintval(getSession('sponsor_id')),
                                getSession('sponsorpass')