X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=beg.php;h=d207d5cf542a3e959cc5d853b64a7efb3dba2822;hb=b16264628f03c4e4cf84251cdcb4a600387792a7;hp=eb9bf9442276d956f2aa9f06eaf44e84b082798a;hpb=5a2865bf1bc27149d22b1da492565a89a28445de;p=mailer.git

diff --git a/beg.php b/beg.php
index eb9bf94422..d207d5cf54 100644
--- a/beg.php
+++ b/beg.php
@@ -69,13 +69,13 @@ 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__);
 		}
 
 		// Check if locked in so don't pay points
 		$login = false; $status = "failed";
-		if (IS_LOGGED_IN()) {
+		if (IS_MEMBER()) {
 			// Logged in user detected!
 			$login = true;
 		}
@@ -103,7 +103,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 				define('__BEG_POINTS', TRANSLATE_COMMA($points));
 			} else {
 				// Other status
-				$uid = "0";
+				$uid = 0;
 			}
 		}
 
@@ -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
@@ -137,7 +137,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 				// Is begging rallye active?
 				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