break;
} // END - switch
-// Get referal ID from ref or refid variable
+// Get referal id from ref or refid variable
if (isGetRequestElementSet('ref')) $ref = getRequestElement('ref');
elseif (isGetRequestElementSet('refid')) $ref = getRequestElement('refid');
if (!empty($ref)) {
// Test if nickname or numeric id
if (isExtensionActive('nickname')) {
- // Nickname in URL, so load the ID
+ // 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);
} else {
- // No entry found
- $ref = 0;
+ // So do we have a userid?
+ $result2 = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`='%s' LIMIT 1",
+ array($ref), __FILE__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result2) == 0) {
+ // No entry, so no referal id
+ $ref = 0;
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result2);
}
// Free result