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);
+ // Do we have an entry?
+ if (SQL_NUMROWS($result) == 1) {
+ // Load userid
+ list($ref) = SQL_FETCHROW($result);
+ } else {
+ // 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
SQL_FREERESULT($result);