X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fuser_functions.php;h=f1ff8fe10bee503900719c611631634ddfb51cbb;hp=d5db1536f0b17bf9e3249ed5120891ca7ebd3573;hb=15b8b078e6a74ddd57f2cf77a9e525b7fa5d7480;hpb=452578b5bf17d14099ee44956deb4e4dc0832874 diff --git a/inc/libs/user_functions.php b/inc/libs/user_functions.php index d5db1536f0..f1ff8fe10b 100644 --- a/inc/libs/user_functions.php +++ b/inc/libs/user_functions.php @@ -10,14 +10,14 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Spezielle Funktionen fuer die user-Erweiterung * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * - * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 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!!!!!! * * -------------------------------------------------------------------- * - * Copyright (c) 2003 - 2008 by Roland Haeder * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -38,29 +38,28 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; - require($INC); + die(); } // Add links for selecting some users function alpha ($sortby, $colspan, $return=false) { - if (!REQUEST_ISSET_GET(('offset'))) REQUEST_SET_GET('offset', 0); - $ADD = "&page=".REQUEST_GET(('page'))."&offset=".REQUEST_GET(('offset')); - if (REQUEST_ISSET_GET(('mode'))) $ADD .= "&mode=".REQUEST_GET(('mode')); + if (!isGetRequestElementSet('offset')) setRequestGetElement('offset', 0); + $add = "&page=".getRequestElement('page')."&offset=".getRequestElement('offset'); + if (isGetRequestElementSet('mode')) $add .= "&mode=".getRequestElement('mode'); /* Creates the list of letters and makes them a link. */ - $alphabet = array(getMessage('_ALL2'),"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",getMessage('_OTHERS')); + $alphabet = explode(',', getMessage('_ALL2') . ',A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,' . getMessage('_OTHERS')); $num = count($alphabet) - 1; - $OUT = ""; + $OUT = ''; while (list($counter, $ltr) = each($alphabet)) { - if (REQUEST_GET('letter') == $ltr) { + if (getRequestElement('letter') == $ltr) { // Current letter is letter from URL $OUT .= "".$ltr.""; } else { // Output link to letter - $OUT .= "".$ltr.""; + $OUT .= "".$ltr.""; } if ((($counter / getConfig('user_alpha')) == round($counter / getConfig('user_alpha'))) && ($counter > 0)) { @@ -70,148 +69,148 @@ function alpha ($sortby, $colspan, $return=false) { } } // END - while - define('__ALPHA_LIST', $OUT); - // Load template - $OUT = LOAD_TEMPLATE("admin_list_user_alpha", true); + $OUT = loadTemplate('admin_list_user_alpha', true, $OUT); if ($return === true) { // Return generated code return $OUT; } else { // Output generated code - OUTPUT_HTML($OUT); + outputHtml($OUT); } } // Add links for sorting -function SortLinks ($letter, $sortby, $colspan, $return=false) { - $OUT = ""; - if (!REQUEST_ISSET_GET(('offset'))) REQUEST_SET_GET('offset', 0); - if (!REQUEST_ISSET_GET(('page'))) REQUEST_SET_GET('page' , 0); +function addSortLinks ($letter, $sortby, $colspan, $return=false) { + $OUT = ''; + if (!isGetRequestElementSet('offset')) setRequestGetElement('offset', 0); + if (!isGetRequestElementSet('page')) setRequestGetElement('page' , 0); // Add page and offset - $ADD = "&page=".REQUEST_GET(('page'))."&offset=".REQUEST_GET(('offset')); + $add = '&page=' . getRequestElement('page') . '&offset=' . getRequestElement('offset'); // Add status or mode - if (REQUEST_ISSET_GET(('status'))) $ADD .= "&mode=".REQUEST_GET(('status')); - elseif (REQUEST_ISSET_GET(('mode'))) $ADD .= "&mode=".REQUEST_GET(('mode')); + if (isGetRequestElementSet('status')) $add .= '&mode=' . getRequestElement('status'); + elseif (isGetRequestElementSet('mode')) $add .= '&mode=' . getRequestElement('mode'); // Makes order by links.. - if ($letter == "front") $letter = getMessage('_ALL2'); + if ($letter == 'front') $letter = getMessage('_ALL2'); // Prepare array with all possible sorters $list = array( - 'userid' => getMessage('_UID'), - 'family' => getMessage('FAMILY_NAME'), - 'email' => getMessage('ADDY'), - 'REMOTE_ADDR' => getMessage('REMOTE_IP') + 'userid' => getMessage('_UID'), + 'family' => getMessage('FAMILY_NAME'), + 'email' => getMessage('EMAIL_ADDRESS'), + 'REMOTE_ADDR' => getMessage('REMOTE_IP') ); // Add nickname if extension is installed - if (EXT_IS_ACTIVE("nickname")) { + if (isExtensionActive('nickname')) { $list['nickname'] = getMessage('NICKNAME'); } // END - if foreach ($list as $sort => $title) { if ($sortby == $sort) { - $OUT .= "".$title." | "; + $OUT .= "" . $title . " | "; } else { - $OUT .= "".$title." | "; + $OUT .= "" . $title . " | "; } } // END - foreach - define('__SORT_LIST', substr($OUT, 0, -13)); + $content['list'] = substr($OUT, 0, -13); // Load template - $OUT = LOAD_TEMPLATE("admin_list_user_sort", true); + $OUT = loadTemplate('admin_list_user_sort', true, $content); + + // Should we return or output? if ($return === true) { // Return code return $OUT; } else { // Output code - OUTPUT_HTML($OUT); + outputHtml($OUT); } } // Add page navigation -function ADD_PAGENAV ($PAGES, $offset, $show_form, $colspan,$return=false) { - if (!$show_form) { - // Empty row - define('__FORM_HEADER', " "); - } else { - // Load form for changing number of lines - define('__FORM_HEADER', LOAD_TEMPLATE("admin_list_user_sort_form", true)); - } - - if (!$show_form) { - // Add line with bottom border - define('__FORM_FOOTER', " "); - } else { - // Add line without bottom border - define('__FORM_FOOTER', " "); - } - - $OUT = ""; +function addPageNavigation ($PAGES, $offset, $show_form, $colspan,$return=false) { + // @TODO These two constants are no longer used, maybe we reactivate this code? + //if ($show_form === true) { + // // Load form for changing number of lines + // define('__FORM_HEADER', loadTemplate('admin_list_user_sort_form', true)); + // define('__FORM_FOOTER', ' '); + //} else { + // // Empty row + // define('__FORM_HEADER', ' '); + // define('__FORM_FOOTER', ' '); + //} + + $OUT = ''; for ($page = 1; $page <= $PAGES; $page++) { - if (($page == REQUEST_GET('page')) || ((!REQUEST_ISSET_GET(('page'))) && ($page == "1"))) { - $OUT .= "-"; + if (($page == getRequestElement('page')) || ((!isGetRequestElementSet('page')) && ($page == 1))) { + $OUT .= '-'; } else { - if (!REQUEST_ISSET_GET(('letter'))) REQUEST_SET_GET('letter', getMessage('_ALL2')); - if (!REQUEST_ISSET_GET(('sortby'))) REQUEST_SET_GET('sortby', "userid"); + if (!isGetRequestElementSet('letter')) setRequestGetElement('letter', getMessage('_ALL2')); + if (!isGetRequestElementSet('sortby')) setRequestGetElement('sortby', 'userid'); // Base link - $OUT .= ""; + // Letter and so on + $OUT .= '&letter=' . getRequestElement('letter') . '&sortby=' . getRequestElement('sortby') . '&page=' . $page . '&offset=' . $offset . '">'; } $OUT .= $page; - if (($page == REQUEST_GET('page')) || ((!REQUEST_ISSET_GET(('page'))) && ($page == "1"))) { - $OUT .= "-"; + if (($page == getRequestElement('page')) || ((!isGetRequestElementSet('page')) && ($page == 1))) { + $OUT .= '-'; } else { - $OUT .= ""; + $OUT .= ''; } - if ($page < $PAGES) $OUT .= " | "; + if ($page < $PAGES) $OUT .= ' | '; } // END - for - define('__PAGENAV_LIST', $OUT); + // Remember the list + $content['list'] = $OUT; // Load template - $OUT = LOAD_TEMPLATE("admin_list_user_pagenav", true); + $OUT = loadTemplate('admin_list_user_pagenav', true, $content); if ($return === true) { // Return code return $OUT; } else { // Output code - OUTPUT_HTML($OUT); + outputHtml($OUT); } } // Create email link to user's account -function USER_CREATE_EMAIL_LINK($email, $mod="admin") { +function generateUserEmailLink($email, $mod = 'admin') { // Show contact link only if user is confirmed by default $locked = " AND `status`='CONFIRMED'"; // But admins shall always see it - if (IS_ADMIN()) $locked = ""; - - $result = SQL_QUERY_ESC("SELECT userid -FROM `{!_MYSQL_PREFIX!}_user_data` -WHERE email='%s'".$locked." LIMIT 1", - array($email), __FUNCTION__, __LINE__); + if (isAdmin()) $locked = ''; + + $result = SQL_QUERY_ESC("SELECT + `userid` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `email`='%s'" . $locked." +LIMIT 1", + array($email), __FUNCTION__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Load userid - list($uid) = SQL_FETCHROW($result); + list($userid) = SQL_FETCHROW($result); // Rewrite email address to contact link - $email = "{!URL!}/modules.php?module=".$mod."&what=user_contct&uid=".bigintval($uid); + $email = '{?URL?}/modules.php?module=' . $mod . '&what=user_contct&userid=' . bigintval($userid); } // END - if // Free memory @@ -222,14 +221,14 @@ WHERE email='%s'".$locked." LIMIT 1", } // Selects a random user id as the new referal id if they have at least X confirmed mails in this run -function SELECT_RANDOM_REFID () { +function determineRandomReferalId () { // Default is zero refid $refid = 0; // Is the extension version fine? - if (GET_EXT_VERSION("user") >= "0.3.4") { + if (getExtensionVersion('user') >= '0.3.4') { // Get all user ids - $totalUsers = GET_TOTAL_DATA("CONFIRMED", "user_data", "userid", "status", true, " AND `rand_confirmed` >= ".getConfig('user_min_confirmed').""); + $totalUsers = countSumTotalData('CONFIRMED', 'user_data', 'userid', 'status', true, " AND `rand_confirmed` >= ".getConfig('user_min_confirmed').""); // Do we have at least one? if ($totalUsers > 0) { @@ -237,8 +236,8 @@ function SELECT_RANDOM_REFID () { $randNum = mt_rand(0, ($totalUsers - 1)); // Look for random user - $result = SQL_QUERY_ESC("SELECT `userid` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' AND `rand_confirmed` >= %s ORDER BY `rand_confirmed` DESC LIMIT %s, 1", - array(getConfig('user_min_confirmed'), $randNum), __FUNCTION__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' AND `rand_confirmed` >= {?user_min_confirmed?} ORDER BY `rand_confirmed` DESC LIMIT %s, 1", + array($randNum), __FUNCTION__, __LINE__); // Do we have one entry there? if (SQL_NUMROWS($result) == 1) { @@ -246,7 +245,7 @@ function SELECT_RANDOM_REFID () { list($refid) = SQL_FETCHROW($result); // Reset this user's counter - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `rand_confirmed`=0 WHERE userid=%s LIMIT 1", + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `rand_confirmed`=0 WHERE `userid`=%s LIMIT 1", array($refid), __FUNCTION__, __LINE__); } // END - if @@ -260,116 +259,130 @@ function SELECT_RANDOM_REFID () { } // Do the user login -function USER_DO_LOGIN ($uid, $passwd) { +function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.php?module=index&what=login&login=') { + // Init variables + $dmy = ''; $add = ''; + $errorCode = 0; + // Add last_login if available - $lastOnline = ""; - if (GET_EXT_VERSION("sql_patches") >= "0.2.8") { - $lastOnline = ", last_login"; + $lastOnline = ''; + if (getExtensionVersion('sql_patches') >= '0.2.8') { + $lastOnline = ', `last_login`'; } // END - if + // Init array + $content = array( + 'password' => '', + 'userid' => '', + 'last_online' => 0, + 'last_login' => 0, + 'hash' => '' + ); + // Check login data - $password = ""; $uid2 = ""; $dmy = ""; $online = 0; $login = 0; - if ((EXT_IS_ACTIVE("nickname")) && (NICKNAME_PROBE_ON_USERID($uid))) { + if ((isExtensionActive('nickname')) && (isNicknameOrUserid($userid))) { // Nickname entered - $result = SQL_QUERY_ESC("SELECT userid, password, last_online".$lastOnline." FROM `{!_MYSQL_PREFIX!}_user_data` WHERE nickname='%s' AND `status`='CONFIRMED' LIMIT 1", - array($uid), __FUNCTION__, __LINE__); - list($uid2, $password, $online, $login) = SQL_FETCHROW($result); - if (!empty($uid2)) $uid = bigintval($uid2); + $result = SQL_QUERY_ESC("SELECT `userid`, `password`, `last_online`" . $lastOnline . " FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `nickname`='%s' AND `status`='CONFIRMED' LIMIT 1", + array($userid), __FUNCTION__, __LINE__); } else { // Direct userid entered - $result = SQL_QUERY_ESC("SELECT userid, password, last_online".$lastOnline." FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s AND `status`='CONFIRMED' LIMIT 1", - array($uid, $hash), __FUNCTION__, __LINE__); - list($uid2, $password, $online, $login) = SQL_FETCHROW($result); + $result = SQL_QUERY_ESC("SELECT `userid`, `password`, `last_online`" . $lastOnline . " FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s AND `status`='CONFIRMED' LIMIT 1", + array($userid, $content['hash']), __FUNCTION__, __LINE__); } + // Load entry + $content = SQL_FETCHARRAY($result); + if (!empty($content['userid'])) $userid = bigintval($content['userid']); + // Is there an entry? - if ((SQL_NUMROWS($result) == 1) && ((($probe_nickname) && (!empty($uid2))) || ($uid2 == $uid))) { + if ((SQL_NUMROWS($result) == 1) && ((isNicknameUsed($content['userid'] === true) && (!empty($content['userid']))) || ($content['userid'] == $userid))) { // Free result SQL_FREERESULT($result); - // By default the hash is empty - $hash = ""; - // Check for old MD5 passwords - if ((strlen($password) == 32) && (md5($passwd) == $password)) { + if ((strlen($content['password']) == 32) && (md5($passwd) == $content['password'])) { // Just set the hash to the password from DB... :) - $hash = $password; + $content['hash'] = $content['password']; } else { // Hash password with improved way for comparsion - $hash = generateHash($passwd, substr($password, 0, -40)); + $content['hash'] = generateHash($passwd, substr($content['password'], 0, -40)); } - if ($hash == $password) { + // Does the password match the hash? + if ($content['hash'] == $content['password']) { // New hashed password found so let's generate a new one - $hash = generateHash($passwd); + $content['hash'] = generateHash($passwd); // ... and update database - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET password='%s' WHERE userid=%s AND `status`='CONFIRMED' LIMIT 1", - array($hash, $uid), __FUNCTION__, __LINE__); + // @TODO Make this filter working: $ADDON = runFilterChain('post_login_update', $content); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `password`='%s' WHERE `userid`=%s AND `status`='CONFIRMED' LIMIT 1", + array($content['hash'], $userid), __FUNCTION__, __LINE__); // No login bonus by default - // @TODO Make this filter working: $ADDON = runFilterChain('post_login_update', array('login' => $login, 'online' => $online)); - $BONUS = false; + $GLOBALS['bonus_payed'] = false; // Probe for last online timemark - $probe = time() - $online; - if (!empty($login)) $probe = time() - $login; - if ((GET_EXT_VERSION("bonus") >= "0.2.2") && ($probe >= getConfig('login_timeout'))) { + $probe = time() - $content['last_online']; + if (!empty($content['last_login'])) $probe = time() - $content['last_login']; + if ((getExtensionVersion('bonus') >= '0.2.2') && ($probe >= getConfig('login_timeout'))) { // Add login bonus to user's account - $ADD = sprintf(", login_bonus=login_bonus+%s", + $add = sprintf(", `login_bonus`=`login_bonus`+%s", (float)getConfig('login_bonus') ); - $BONUS = true; + $GLOBALS['bonus_payed'] = true; // Subtract login bonus from userid's account or jackpot - if ((GET_EXT_VERSION("bonus") >= "0.3.5") && (getConfig('bonus_mode') != "ADD")) BONUS_POINTS_HANDLER('login_bonus'); + if ((getExtensionVersion('bonus') >= '0.3.5') && (getConfig('bonus_mode') != 'ADD')) handleBonusPoints('login_bonus'); } // END - if - // Init variables - $login = false; - // Calculate new hash with the secret key and master salt together - $hash = generatePassString($hash); + $content['hash'] = generatePassString($content['hash']); // Update global array - // @TODO Make this filter working: $URL = runFilterChain('do_login', array('uid' => $uid, 'hash' => $hash, 'addon' => $ADDON)); - setUserId($uid); + // @TODO Make this filter working: $URL = runFilterChain('do_login', array('content' => $content, 'addon' => $ADDON)); + setUserId($userid); // Try to set session data (which shall normally always work!) - if ((set_session('userid', $uid )) && (set_session('u_hash', $hash))) { + if ((setSession('userid', $userid )) && (setSession('u_hash', $content['hash']))) { // Update database records - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET total_logins=total_logins+1".$ADD." WHERE userid=%s LIMIT 1", - array($uid), __FUNCTION__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `total_logins`=`total_logins`+1" . $add . " WHERE `userid`=%s LIMIT 1", + array($userid), __FUNCTION__, __LINE__); if (SQL_AFFECTEDROWS() == 1) { - // Procedure to checking for login data - if (($BONUS) && (EXT_IS_ACTIVE("bonus"))) { - // Bonus added (just displaying!) - $URL = "modules.php?module=chk_login&mode=bonus"; + // Is a success URL set? + if (empty($successUrl)) { + // Procedure to checking for login data + if (($GLOBALS['bonus_payed']) && (isExtensionActive('bonus'))) { + // Bonus added (just displaying!) + $URL = 'modules.php?module=chk_login&mode=bonus'; + } else { + // Bonus not added + $URL = 'modules.php?module=chk_login&mode=login'; + } } else { - // Bonus not added - $URL = "modules.php?module=chk_login&mode=login"; + // Use this URL + $URL = $successUrl; } } else { // Cannot update counter! - $URL = "modules.php?module=index&what=login&login=".getCode('CNTR_FAILED'); + $errorCode = getCode('CNTR_FAILED'); } } else { // Cookies not setable! - $URL = "modules.php?module=index&what=login&login=".getCode('NO_COOKIES'); + $errorCode = getCode('NO_COOKIES'); } - } elseif (GET_EXT_VERSION("sql_patches") >= "0.6.1") { + } elseif (getExtensionVersion('sql_patches') >= '0.6.1') { // Update failture counter - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET login_failures=login_failures+1,last_failure=NOW() WHERE userid=%s LIMIT 1", - array($uid), __FUNCTION__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `login_failures`=`login_failures`+1,`last_failure`=NOW() WHERE `userid`=%s LIMIT 1", + array($userid), __FUNCTION__, __LINE__); // Wrong password! - $URL = "modules.php?module=index&what=login&login=".getCode('WRONG_PASS'); + $errorCode = getCode('WRONG_PASS'); } - } elseif ((($probe_nickname) && (!empty($uid2))) || ($uid2 == $uid)) { + } elseif (((isNicknameUsed($content['userid'])) && (!empty($content['userid']))) || ($content['userid'] == $userid)) { // Other account status? // @TODO Can this query be merged with above query? - $result = SQL_QUERY_ESC("SELECT status FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", - array($uid), __FUNCTION__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `status` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1", + array($userid), __FUNCTION__, __LINE__); // Entry found? if (SQL_NUMROWS($result) == 1) { @@ -377,84 +390,87 @@ function USER_DO_LOGIN ($uid, $passwd) { list($status) = SQL_FETCHROW($result); // Create an error code from given status - $ERROR = GEN_ERROR_CODE_FROM_ACCOUNT_STATUS($status); + $errorCode = generateErrorCodeFromUserStatus($status); } else { // ID not found! - $ERROR = getCode('WRONG_ID'); + $errorCode = getCode('WRONG_ID'); } - - // Construct URL - $URL = "modules.php?module=index&what=login&login=".$ERROR; } else { // ID not found! - $URL = "modules.php?module=index&what=login&login=".getCode('WRONG_ID'); + $errorCode = getCode('WRONG_ID'); } + // Error code provided? + if ($errorCode > 0) { + // Then reconstruct the URL + $URL = $errorUrl . $errorCode; + } // END - if + // Return URL return $URL; } // Try to send a new password for the given user account -function USER_DO_NEW_PASSWORD ($email, $uid) { +function doNewUserPassword ($email, $userid) { // Compile email when found in address (only secure chars!) - if (!empty($email)) $email = str_replace("{DOT}", '.', $email); + if (!empty($email)) $email = str_replace('{DOT}', '.', $email); // Init result and error - $ERROR = ""; + $errorCode = ''; $result = false; // Probe userid/nickname - if ((EXT_IS_ACTIVE("nickname")) && (NICKNAME_PROBE_ON_USERID($uid))) { + if ((isExtensionActive('nickname')) && (isNicknameOrUserid($userid))) { // Nickname entered - $result = SQL_QUERY_ESC("SELECT userid, status FROM `{!_MYSQL_PREFIX!}_user_data` WHERE nickname='%s' OR email='%s' LIMIT 1", - array($uid, $email), __FUNCTION__, __LINE__); - } elseif (($uid > 0) && (empty($email))) { + $result = SQL_QUERY_ESC("SELECT `userid`, `status` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `nickname`='%s' OR `userid`='%s' OR `email`='%s' LIMIT 1", + array($userid, $userid, $email), __FUNCTION__, __LINE__); + } elseif (($userid > 0) && (empty($email))) { // Direct userid entered - $result = SQL_QUERY_ESC("SELECT userid, status FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", - array(bigintval($uid)), __FUNCTION__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `userid`, `status` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1", + array(bigintval($userid)), __FUNCTION__, __LINE__); } elseif (!empty($email)) { // Email entered - $result = SQL_QUERY_ESC("SELECT userid, status FROM `{!_MYSQL_PREFIX!}_user_data` WHERE email='%s' LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `userid`, `status` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `email`='%s' LIMIT 1", array($email), __FUNCTION__, __LINE__); } else { // Userid not set! - DEBUG_LOG(__FUNCTION__, __LINE__, "Userid is not set! BUG!"); - $ERROR = getCode('WRONG_ID'); + logDebugMessage(__FUNCTION__, __LINE__, 'Userid is not set! BUG!'); + $errorCode = getCode('WRONG_ID'); } // Any entry found? if (SQL_NUMROWS($result) == 1) { // This data is valid, so we create a new pass... :-) - list($uid, $status) = SQL_FETCHROW($result); + list($userid, $status) = SQL_FETCHROW($result); - if ($status == "CONFIRMED") { + if ($status == 'CONFIRMED') { // Ooppps, this was missing! ;-) We should update the database... - $NEW_PASS = GEN_PASS(); - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET password='%s' WHERE userid=%s LIMIT 1", - array(generateHash($NEW_PASS), $uid), __FUNCTION__, __LINE__); + $NEW_PASS = generatePassword(); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `password`='%s' WHERE `userid`=%s LIMIT 1", + array(generateHash($NEW_PASS), $userid), __FUNCTION__, __LINE__); // Prepare data and message for email - $msg = LOAD_EMAIL_TEMPLATE("new-pass", array('new_pass' => $NEW_PASS), $uid); + $message = loadEmailTemplate('new-pass', array('new_pass' => $NEW_PASS, 'nickname' => $userid), $userid); // ... and send it away - SEND_EMAIL($uid, getMessage('GUEST_NEW_PASSWORD'), $msg); + sendEmail($userid, getMessage('GUEST_NEW_PASSWORD'), $message); // Output note to user - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('GUEST_NEW_PASSWORD_SEND')); + loadTemplate('admin_settings_saved', false, getMessage('GUEST_NEW_PASSWORD_SEND')); } else { // Account is locked or unconfirmed - $ERROR = GEN_ERROR_CODE_FROM_ACCOUNT_STATUS($status); + $errorCode = generateErrorCodeFromUserStatus($status); // Load URL - LOAD_URL("modules.php?module=index&what=login&login=".$ERROR); + redirectToUrl('modules.php?module=index&what=login&login='.$errorCode); } } else { // ID or email is wrong - LOAD_TEMPLATE("admin_settings_saved", false, "{--GUEST_WRONG_ID_EMAIL--}"); + loadTemplate('admin_settings_saved', false, '{--GUEST_WRONG_ID_EMAIL--}'); } // Return the error code - return $ERROR; + return $errorCode; } // [EOF]