-// 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
- $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `nickname`='%s' LIMIT 1",
- array($ref), __FILE__, __LINE__);
-
- // 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);
- } // END - if
-
- // Also edit this 0 !
- if (empty($ref)) $ref = 0;