Some old lost copyright lines fixed, edit/delete admin functions rewritten
[mailer.git] / beg.php
diff --git a/beg.php b/beg.php
index c5442df..e402809 100644 (file)
--- a/beg.php
+++ b/beg.php
@@ -69,7 +69,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
                        }
                } else {
                        // Direct userid
-                       $result = SQL_QUERY_ESC("SELECT userid, beg_clicks, ref_payout, status, last_online FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
+                       $result = SQL_QUERY_ESC("SELECT userid, beg_clicks, ref_payout, status, last_online FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
                         array(bigintval($_GET['uid'])), __FILE__, __LINE__);
                }
 
@@ -112,11 +112,11 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 
                if (($uid > 0) && ($_CONFIG['beg_uid'] != $uid)) {
                        // Update counter
-                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET beg_clicks=beg_clicks+1 WHERE userid=%d AND status='CONFIRMED' LIMIT 1",
+                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET beg_clicks=beg_clicks+1 WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
                         array($uid), __FILE__, __LINE__);
 
                        // Check for last entry for userid w/o IP number
-                       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_beg_ips WHERE (timeout > ".(time() - $_CONFIG['beg_timeout'])." OR (timeout > ".(time() - $_CONFIG['beg_uid_timeout'])." AND userid=%d)) AND remote_ip='%s' LIMIT 1",
+                       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_beg_ips WHERE (timeout > ".(time() - $_CONFIG['beg_timeout'])." OR (timeout > ".(time() - $_CONFIG['beg_uid_timeout'])." AND userid=%s)) AND remote_ip='%s' LIMIT 1",
                         array($uid, getenv('REMOTE_ADDR')), __FILE__, __LINE__);
                        if ((SQL_NUMROWS($result) == 0) && ($points > 0) && (!$login)) {
                                // Free memory
@@ -132,12 +132,12 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 
                                // Set mode depending on how many mails the member has to confirm
                                $locked = false;
-                               if (($ref_payout > 0) && ($_CONFIG['allow_direct_pay'] == 'N')) $locked = true;
+                               if (($ref_payout > 0) && ($_CONFIG['allow_direct_pay'] == "N")) $locked = true;
 
                                // Is begging rallye active?
-                               if ($_CONFIG['beg_rallye'] == 'Y') {
+                               if ($_CONFIG['beg_rallye'] == "Y") {
                                        // Add points to rallye account
-                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points=beg_points+%s WHERE userid=%d LIMIT 1",
+                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points=beg_points+%s WHERE userid=%s LIMIT 1",
                                         array($points, $uid), __FILE__, __LINE__);
                                } else {
                                        // Add points to account
@@ -148,14 +148,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
                                // Subtract begged points from member account if the admin has selected one
                                if ($_CONFIG['beg_uid'] > 0) {
                                        // Subtract from this account
-                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET used_points=used_points+%s WHERE userid=%d LIMIT 1",
-                                        array($points, bigintval($_CONFIG['beg_uid'])), __FILE__, __LINE__);
-
-                                       // Update mediadata as well
-                                       if (GET_EXT_VERSION("mediadata") >= "0.0.4") {
-                                               // Update database
-                                               MEDIA_UPDATE_ENTRY(array("total_points"), "sub", $points);
-                                       }
+                                       SUB_POINTS($_CONFIG['beg_uid'], $points);
                                }
 
                                // Set message