$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 {
+ // No entry found
+ $ref = 0;
+ }
// Free result
SQL_FREERESULT($result);