Rewrite to save queries
authorRoland Häder <roland@mxchange.org>
Mon, 17 Aug 2009 17:57:15 +0000 (17:57 +0000)
committerRoland Häder <roland@mxchange.org>
Mon, 17 Aug 2009 17:57:15 +0000 (17:57 +0000)
inc/libs/nickname_functions.php

index f3e258b..fc575fb 100644 (file)
@@ -55,25 +55,11 @@ function NICKNAME_IS_ACTIVE ($uidNick) {
                // Increment cache counter
                incrementConfigEntry('cache_hits');
        } else {
-               // Init result
-               $result = false;
-
                // Nickname or userid used?
-               if (''.round($uidNick).'' === ''.$uidNick.'') {
-                       // Userid given
-                       $result = SQL_QUERY_ESC("SELECT `userid`  FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid` =%s LIMIT 1",
-                               array(bigintval($uidNick)), __FUNCTION__, __LINE__);
-               } else {
-                       // Nickname given
-                       $result = SQL_QUERY_ESC("SELECT `userid`  FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `nickname`='%s' LIMIT 1",
-                               array($uidNick), __FUNCTION__, __LINE__);
-               }
-
-               // Check existence of nickname
-               $ret = (SQL_NUMROWS($result) == 1);
+               $nick = NICKNAME_GET_NICK($uidNick);
 
                // Put it in cache
-               $GLOBALS['cache_array']['nick_active'][$uidNick] = $ret;
+               $GLOBALS['cache_array']['nick_active'][$uidNick] = (!empty($nick));
 
                // Free result
                SQL_FREERESULT($result);
@@ -96,9 +82,19 @@ function NICKNAME_GET_NICK ($userid) {
                // Increment cache counter
                incrementConfigEntry('cache_hits');
        } elseif (NICKNAME_IS_ACTIVE($userid)) {
-               // Search for non-empty nickname
-               $result = SQL_QUERY_ESC("SELECT nickname FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s AND nickname != '' LIMIT 1",
-               array(bigintval($userid)), __FUNCTION__, __LINE__);
+               // Init result
+               $result = false;
+
+               // Nickname or userid used?
+               if (''.round($uidNick).'' === ''.$uidNick.'') {
+                       // Userid given
+                       $result = SQL_QUERY_ESC("SELECT `userid`  FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid` =%s LIMIT 1",
+                               array(bigintval($uidNick)), __FUNCTION__, __LINE__);
+               } else {
+                       // Nickname given
+                       $result = SQL_QUERY_ESC("SELECT `userid`  FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `nickname`='%s' LIMIT 1",
+                               array($uidNick), __FUNCTION__, __LINE__);
+               }
 
                // Found?
                if (SQL_NUMROWS($result) == 1) {