X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=ref.php;h=730799b089100b6473261d2ae044cf01d839155f;hp=527d4e9ffc59a7dd6f313dfcbb533b9bde24cce1;hb=e0eb0432f1049f2b645a84d964d7d40adc8a11bb;hpb=0fd6858b423d41e7eee9ffa3d5138d318e08cc1c

diff --git a/ref.php b/ref.php
index 527d4e9ffc..730799b089 100644
--- a/ref.php
+++ b/ref.php
@@ -39,10 +39,6 @@
 // Load security stuff here
 require('inc/libs/security_functions.php');
 
-// Init "action" and "what"
-$GLOBALS['what'] = '';
-$GLOBALS['action'] = '';
-
 // Set module
 $GLOBALS['module'] = 'ref';
 $GLOBALS['output_mode'] = -1;
@@ -68,16 +64,16 @@ switch (getConfig('refid_target')) {
 }
 
 // Get referal ID from ref or refid variable
-if (REQUEST_ISSET_GET(('ref')))        $ref = REQUEST_GET('ref');
-elseif (REQUEST_ISSET_GET(('refid'))) $ref = REQUEST_GET('refid');
+if (REQUEST_ISSET_GET('ref'))        $ref = REQUEST_GET('ref');
+ elseif (REQUEST_ISSET_GET('refid')) $ref = REQUEST_GET('refid');
 
 if (!empty($ref)) {
 	// Test if nickname or numeric id
 	if ($ref != ''.($ref + 0).'') {
 		if (EXT_IS_ACTIVE('nickname')) {
 			// Nickname in URL, so load the ID
-			$result = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE nickname='%s' LIMIT 1",
-			array($ref), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("SELECT `userid` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `nickname`='%s' LIMIT 1",
+				array($ref), __FILE__, __LINE__);
 
 			// Load userid
 			list($ref) = SQL_FETCHROW($result);
@@ -102,8 +98,8 @@ if (!empty($ref)) {
 	// Is the refid valid?
 	if ($ref > 0) {
 		// Update ref counter
-		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET ref_clicks=ref_clicks+1 WHERE userid=%s LIMIT 1",
-		array(bigintval($ref)), __FILE__, __LINE__);
+		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `ref_clicks`=`ref_clicks`+1 WHERE `userid`=%s LIMIT 1",
+			array(bigintval($ref)), __FILE__, __LINE__);
 	} // END - if
 } else {
 	// No refid and we add our refid (don't forget to set $def_refid!)