- // Get referral ID from ref or refid variable
- if (!empty($_GET['ref'])) $ref = secureString($_GET['ref']);
- elseif (!empty($_GET['refid'])) $ref = secureString($_GET['refid']);
-
- if (!empty($ref)) {
- // Test if nickname or numeric id
- if ((EXT_IS_ACTIVE("nickname")) && ($ref != "".bigintval($ref)."")) {
- // 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__);
- list($ref) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
- } // END - if
-
- // Also edit this 0 !
- if (empty($ref)) $ref = 0;
-
- // Update session
- set_session('refid', $ref);
-
- // We have an refid here. So we simply add it
- $URL .= bigintval($ref);
-
- // Is the refid valid?
- if ($ref > 0) {
- // Update ref counter
- $result = 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
+if (!empty($ref)) {
+ // Test if nickname or numeric id
+ 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__);
+
+ // Load userid
+ list($ref) = SQL_FETCHROW($result);
+
+ // Free result
+ SQL_FREERESULT($result);