X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fnickname_functions.php;h=3304c010744a2679b7b347e1c845724a1162d027;hp=3d08495f346f1cffa5c15097cb573bf9983a9d0c;hb=4d64a8575593f7cc8f69aec74d14c29ba6e8ef6c;hpb=e01fcf1ca8ddeb72af76465df3ef72301a1cdae7 diff --git a/inc/libs/nickname_functions.php b/inc/libs/nickname_functions.php index 3d08495f34..3304c01074 100644 --- a/inc/libs/nickname_functions.php +++ b/inc/libs/nickname_functions.php @@ -10,10 +10,10 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Nickname-Funktionen * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * - * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. March 2009) $ * + * $Revision:: $ * + * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * - * $Author:: stelzi $ * + * $Author:: $ * * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * @@ -38,11 +38,11 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } -// +// Checks wether the nickname is active function NICKNAME_IS_ACTIVE ($uidNick) { // By default nothing is found... $ret = false; @@ -55,29 +55,21 @@ function NICKNAME_IS_ACTIVE ($uidNick) { // Increment cache counter incrementConfigEntry('cache_hits'); } else { - // Search in database - // @TODO Can we replace this with GET_TOTAL_DATA() ? - $result = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s OR nickname='%s' LIMIT 1", - array(bigintval($uidNick), $uidNick), __FUNCTION__, __LINE__); - - // Check existence of nickname - $ret = (SQL_NUMROWS($result) == 1); + // Nickname or userid used? + $nick = NICKNAME_GET_NICK($uidNick); // Put it in cache - $GLOBALS['cache_array']['nick_active'][$uidNick] = $ret; - - // Free result - SQL_FREERESULT($result); + $GLOBALS['cache_array']['nick_active'][$uidNick] = (!empty($nick)); } // Return nickname return $ret; } -// +// "Getter" for nickname for specfied userid function NICKNAME_GET_NICK ($userid) { // If not found... - $ret = ""; + $ret = ''; // Found in cache? if (isset($GLOBALS['cache_array']['nicknames'][$userid])) { @@ -86,10 +78,20 @@ 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__); + } else { + // Init result + $result = false; + + // Nickname or userid used? + if (''.round($userid).'' === ''.$userid.'') { + // Userid given + $result = SQL_QUERY_ESC("SELECT `userid` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid` =%s LIMIT 1", + array(bigintval($userid)), __FUNCTION__, __LINE__); + } else { + // Nickname given + $result = SQL_QUERY_ESC("SELECT `userid` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `nickname`='%s' LIMIT 1", + array($userid), __FUNCTION__, __LINE__); + } // Found? if (SQL_NUMROWS($result) == 1) { @@ -108,10 +110,5 @@ function NICKNAME_GET_NICK ($userid) { return $ret; } -// Simple wrapper function -function NICKNAME_PROBE_ON_USERID ($uid) { - return (NICKNAME_GET_NICK($uid) != ""); -} - // ?>