X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=beg.php;h=e92a8f11bd96189c45fb9fb8ae8648091511ad15;hp=cdfbfc70bee97abf92f19f249a23d17557972998;hb=61dec4b03dbfb49cbbeb19628d966c6e34f3b59a;hpb=2ec9007220186d54f84846871ed1f7638c29baf7

diff --git a/beg.php b/beg.php
index cdfbfc70be..e92a8f11bd 100644
--- a/beg.php
+++ b/beg.php
@@ -74,8 +74,8 @@ if (REQUEST_ISSET_GET('uid')) {
 	if (''.(REQUEST_GET('uid') + 0).'' !== ''.REQUEST_GET('uid').'') {
 		if (EXT_IS_ACTIVE('nickname')) {
 			// Maybe we have found a nickname?
-			$result = SQL_QUERY_ESC("SELECT userid, beg_clicks, ref_payout, status, last_online FROM `{!_MYSQL_PREFIX!}_user_data` WHERE nickname='%s' LIMIT 1",
-			array(REQUEST_GET('uid')), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("SELECT `userid`, `beg_clicks`, `ref_payout`, `status`, `last_online` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `nickname`='%s' LIMIT 1",
+				array(REQUEST_GET('uid')), __FILE__, __LINE__);
 		} else {
 			// Nickname entered but nickname is not active
 			$msg = getCode('EXTENSION_PROBLEM');
@@ -83,8 +83,8 @@ if (REQUEST_ISSET_GET('uid')) {
 		}
 	} else {
 		// Direct userid
-		$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(REQUEST_GET('uid'))), __FILE__, __LINE__);
+		$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(REQUEST_GET('uid'))), __FILE__, __LINE__);
 	}
 
 	// Check if locked in so don't pay points
@@ -122,8 +122,8 @@ if (REQUEST_ISSET_GET('uid')) {
 	// User id valid and not webmaster's id?
 	if (($uid > 0) && (getConfig('beg_uid') != $uid)) {
 		// Update counter
-		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__);
+		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 > (UNIX_TIMESTAMP() - ".getConfig('beg_timeout').") OR (timeout > (UNIX_TIMESTAMP() - ".getConfig('beg_uid_timeout').") AND `userid`=%s)) AND (remote_ip='%s' OR sid='%s') LIMIT 1",