X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=ref.php;h=730799b089100b6473261d2ae044cf01d839155f;hp=8e5e88b0a15821bb689dc5baf0176fbd7e450b1e;hb=01bba674617344a3505992b650a86cd0d7c0eb0d;hpb=3f51c40f4fede87228216f9285b745a339e3891d

diff --git a/ref.php b/ref.php
index 8e5e88b0a1..730799b089 100644
--- a/ref.php
+++ b/ref.php
@@ -72,8 +72,8 @@ if (!empty($ref)) {
 	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);
@@ -98,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!)