X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fuser_functions.php;h=029ab472ff5fbdb2c3f837c63051bc233ed405b2;hp=1fdb5105002af5de754c12ea0b394be5a8f137d3;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=9f6c30cc0e06098171d773d671292081ecee3d29 diff --git a/inc/libs/user_functions.php b/inc/libs/user_functions.php index 1fdb510500..029ab472ff 100644 --- a/inc/libs/user_functions.php +++ b/inc/libs/user_functions.php @@ -1,7 +1,7 @@ ".$ltr.""; + $OUT .= '' . $ltr . ''; } else { // Output link to letter - $OUT .= "".$ltr.""; + $OUT .= '' . $ltr . ''; } if ((($counter / getConfig('user_alpha')) == round($counter / getConfig('user_alpha'))) && ($counter > 0)) { - $OUT .= " ]
[ "; + $OUT .= ']
['; } elseif ( $counter != $num ) { - $OUT .= " | "; + $OUT .= '|'; } } // END - while + // Prepare content + $content = array ( + 'alpha_selection' => $OUT + ); + // Load template - $OUT = loadTemplate('admin_list_user_alpha', true, $OUT); - if ($return === true) { - // Return generated code - return $OUT; - } else { - // Output generated code - outputHtml($OUT); - } + $OUT = loadTemplate('admin_list_user_alpha', true, $content); + + // Return generated code + return $OUT; } // Add links for sorting -function addSortLinks ($letter, $sortby, $colspan, $return=false) { +function addSortLinks ($letter, $sortby) { $OUT = ''; - if (!isGetRequestElementSet('offset')) setRequestGetElement('offset', 0); - if (!isGetRequestElementSet('page')) setRequestGetElement('page' , 0); + if (!isGetRequestParameterSet('offset')) setGetRequestParameter('offset', 0); + if (!isGetRequestParameterSet('page')) setGetRequestParameter('page' , 0); // Add page and offset - $add = '&page=' . getRequestElement('page') . '&offset=' . getRequestElement('offset'); + $add = '&page=' . getRequestParameter('page') . '&offset=' . getRequestParameter('offset'); - // Add status or mode - if (isGetRequestElementSet('status')) $add .= '&mode=' . getRequestElement('status'); - elseif (isGetRequestElementSet('mode')) $add .= '&mode=' . getRequestElement('mode'); + // Add status/ mode + foreach (array('mode','status') as $param) { + if (isGetRequestParameterSet($param)) { + $add .= '&' . $param . '=' . getRequestParameter($param); + } // END - if + } // END - foreach // Makes order by links.. - if ($letter == 'front') $letter = getMessage('_ALL2'); + if ($letter == 'front') { + $letter = ''; + } // END - if // Prepare array with all possible sorters $list = array( - 'userid' => getMessage('_UID'), - 'family' => getMessage('FAMILY_NAME'), - 'email' => getMessage('EMAIL_ADDRESS'), - 'REMOTE_ADDR' => getMessage('REMOTE_IP') + 'userid' => '{--_USERID--}', + 'family' => '{--FAMILY--}', + 'email' => '{--EMAIL--}', + 'REMOTE_ADDR' => '{--REMOTE_IP--}' ); // Add nickname if extension is installed if (isExtensionActive('nickname')) { - $list['nickname'] = getMessage('NICKNAME'); + $list['nickname'] = '{--NICKNAME--}'; } // END - if foreach ($list as $sort => $title) { if ($sortby == $sort) { - $OUT .= "" . $title . " | "; + $OUT .= '' . $title . '|'; } else { - $OUT .= "" . $title . " | "; + $OUT .= '' . $title . '|'; } } // END - foreach - $content['list'] = substr($OUT, 0, -13); + // Add output + $content['list'] = substr($OUT, 0, -1); // Load template $OUT = loadTemplate('admin_list_user_sort', true, $content); - // Should we return or output? - if ($return === true) { - // Return code - return $OUT; - } else { - // Output code - outputHtml($OUT); - } + // Return code + return $OUT; } // Add page navigation -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', ' '); - //} - +function addPageNavigation ($numPages) { + // Start with empty content $OUT = ''; - for ($page = 1; $page <= $PAGES; $page++) { - if (($page == getRequestElement('page')) || ((!isGetRequestElementSet('page')) && ($page == 1))) { - $OUT .= '-'; - } else { - if (!isGetRequestElementSet('letter')) setRequestGetElement('letter', getMessage('_ALL2')); - if (!isGetRequestElementSet('sortby')) setRequestGetElement('sortby', 'userid'); - // Base link - $OUT .= ''; - } + // Add status/mode + foreach (array('mode','status') as $param) { + if (isGetRequestParameterSet($param)) { + $OUT .= '&' . $param . '=' . getRequestParameter($param); + } // END - if + } // END - foreach - $OUT .= $page; + // Letter and so on + $OUT .= '&letter=' . getRequestParameter('letter') . '&sortby=' . getRequestParameter('sortby') . '&page=' . $page . '&offset=' . getConfig('user_limit') . '%}">'; + } - if (($page == getRequestElement('page')) || ((!isGetRequestElementSet('page')) && ($page == 1))) { - $OUT .= '-'; - } else { - $OUT .= ''; - } + $OUT .= $page; - if ($page < $PAGES) $OUT .= ' | '; - } // END - for + if (($page == getRequestParameter('page')) || ((!isGetRequestParameterSet('page')) && ($page == 1))) { + $OUT .= '-'; + } else { + $OUT .= ''; + } - // Remember the list - $content['list'] = $OUT; + if ($page < $numPages) { + $OUT .= '|'; + } // END - if + } // END - for - // Load template - $OUT = loadTemplate('admin_list_user_pagenav', true, $content); - if ($return === true) { - // Return code - return $OUT; - } else { - // Output code - outputHtml($OUT); - } + // Add list output + $content['list'] = $OUT; + + // Load template + $OUT = loadTemplate('admin_list_user_pagenav', true, $content); + } // END - if + + // Return code + return $OUT; } // Create email link to user's account -function generateUserEmailLink($email, $mod = 'admin') { +function generateUserEmailLink ($email, $mod = 'admin') { // Show contact link only if user is confirmed by default $locked = " AND `status`='CONFIRMED'"; @@ -210,7 +207,7 @@ LIMIT 1", list($userid) = SQL_FETCHROW($result); // Rewrite email address to contact link - $email = '{?URL?}/modules.php?module=' . $mod . '&what=user_contct&userid=' . bigintval($userid); + $email = '{%url=modules.php?module=' . $mod . '&what=user_contct&userid=' . bigintval($userid) . '%}'; } // END - if // Free memory @@ -221,14 +218,15 @@ LIMIT 1", } // Selects a random user id as the new referal id if they have at least X confirmed mails in this run +// @TODO Double-check configuration entry here function determineRandomReferalId () { // Default is zero refid - $refid = 0; + $refid = NULL; // Is the extension version fine? - if (getExtensionVersion('user') >= '0.3.4') { + if (isExtensionInstalledAndNewer('user', '0.3.4')) { // Get all user ids - $totalUsers = countSumTotalData('CONFIRMED', 'user_data', 'userid', 'status', true, " AND `rand_confirmed` >= ".getConfig('user_min_confirmed').""); + $totalUsers = countSumTotalData('CONFIRMED', 'user_data', 'userid', 'status', true, " AND `rand_confirmed` >= {?user_min_confirmed?}"); // Do we have at least one? if ($totalUsers > 0) { @@ -243,10 +241,6 @@ function determineRandomReferalId () { if (SQL_NUMROWS($result) == 1) { // Use that userid as new referal id 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", - array($refid), __FUNCTION__, __LINE__); } // END - if // Free result @@ -263,13 +257,9 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p // Init variables $dmy = ''; $add = ''; - $errorCode = 0; - - // Add last_login if available - $lastOnline = ''; - if (getExtensionVersion('sql_patches') >= '0.2.8') { - $lastOnline = ', `last_login`'; - } // END - if + $errorCode = '0'; + $ext = ''; + $isFound = false; // Init array $content = array( @@ -281,31 +271,40 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p ); // Check login data - if ((isExtensionActive('nickname')) && (isNicknameOrUserid($userid))) { + if ((isExtensionActive('nickname')) && (isNicknameUsed($userid))) { // Nickname entered fetchUserData($userid, 'nickname'); + } elseif (isNicknameUsed($userid)) { + // No nickname installed + $errorCode = getCode('EXTENSION_PROBLEM'); + $ext = 'nickname'; } else { // Direct userid entered - fetchUserData($userid); + $isFound = fetchUserData($userid); } - // Load entry - $content = getUserDataArray(); - if (!empty($content['userid'])) $userid = bigintval($content['userid']); + // No error found? + if (($errorCode == '0') && ($isFound === true)) { + // Get user data array and set userid (e.g. important if we login with nickname) + $content = getUserDataArray(); + if (!empty($content['userid'])) { + $userid = bigintval($content['userid']); + } // END - if + } // END - if // Is there an entry? - if ((isUserDataValid()) && (getUserData('status') == 'CONFIRMED') && ((isNicknameUsed($content['userid'] === true) && (!empty($content['userid']))) || ($content['userid'] == $userid))) { + if (($errorCode == '0') && (isUserDataValid()) && (getUserData('status') == 'CONFIRMED') && (!empty($content['userid']))) { // Check for old MD5 passwords - if ((strlen($content['password']) == 32) && (md5($passwd) == $content['password'])) { + if ((strlen(getUserData('password')) == 32) && (md5($passwd) == getUserData('password'))) { // Just set the hash to the password from DB... :) - $content['hash'] = $content['password']; + $content['hash'] = getUserData('password'); } else { // Hash password with improved way for comparsion - $content['hash'] = generateHash($passwd, substr($content['password'], 0, -40)); + $content['hash'] = generateHash($passwd, substr(getUserData('password'), 0, -40)); } // Does the password match the hash? - if ($content['hash'] == $content['password']) { + if ($content['hash'] == getUserData('password')) { // New hashed password found so let's generate a new one $content['hash'] = generateHash($passwd); @@ -317,44 +316,53 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p // No login bonus by default $GLOBALS['bonus_payed'] = false; - // Probe for last online timemark - $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 = ', `login_bonus`=`login_bonus`+{?login_bonus?}'; - $GLOBALS['bonus_payed'] = true; - - // Subtract login bonus from userid's account or jackpot - if ((getExtensionVersion('bonus') >= '0.3.5') && (getConfig('bonus_mode') != 'ADD')) handleBonusPoints('login_bonus'); + // Is bonus up-to-date? + if (isExtensionInstalledAndNewer('bonus', '0.2.2')) { + // Probe for last online timemark + $probe = time() - getUserData('last_online'); + if (getUserData('last_login') > 0) { + // Use timestamp from last login + $probe = time() - getUserData('last_login'); + } // END - if + + // Is the timeout reached? + if ($probe >= getConfig('login_timeout')) { + // Add login bonus to user's account + $add = ', `login_bonus`=`login_bonus`+{?login_bonus?}'; + $GLOBALS['bonus_payed'] = true; + + // Subtract login bonus from userid's account or jackpot + if ((isExtensionInstalledAndNewer('bonus', '0.3.5')) && (getBonusMode() != 'ADD')) { + handleBonusPoints('login_bonus'); + } // END - if + } // END - if } // END - if - // Calculate new hash with the secret key and master salt together - $content['hash'] = generatePassString($content['hash']); + // @TODO Make this filter working: $url = runFilterChain('do_login', array('content' => $content, 'addon' => $ADDON)); - // Update global array - // @TODO Make this filter working: $URL = runFilterChain('do_login', array('content' => $content, 'addon' => $ADDON)); - setUserId($userid); + // Set member id + setMemberId($userid); // Try to set session data (which shall normally always work!) - if ((setSession('userid', $userid )) && (setSession('u_hash', $content['hash']))) { + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',hash=' . $content['hash'] . '(' . strlen($content['hash']) . ')'); + if ((setSession('userid', $userid )) && (setSession('u_hash', encodeHashForCookie($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($userid), __FUNCTION__, __LINE__); - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { // Is a success URL set? if (empty($successUrl)) { // Procedure to checking for login data - if (($GLOBALS['bonus_payed']) && (isExtensionActive('bonus'))) { + if (($GLOBALS['bonus_payed'] === true) && (isExtensionActive('bonus'))) { // Bonus added (just displaying!) - $URL = 'modules.php?module=chk_login&mode=bonus'; + $url = 'modules.php?module=chk_login&mode=bonus'; } else { // Bonus not added - $URL = 'modules.php?module=chk_login&mode=login'; + $url = 'modules.php?module=chk_login&mode=login'; } } else { // Use this URL - $URL = $successUrl; + $url = $successUrl; } } else { // Cannot update counter! @@ -362,103 +370,397 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p } } else { // Cookies not setable! - $errorCode = getCode('NO_COOKIES'); + $errorCode = getCode('COOKIES_DISABLED'); } - } elseif (getExtensionVersion('sql_patches') >= '0.6.1') { - // Update failture counter + } elseif (isExtensionInstalledAndNewer('sql_patches', '0.6.1')) { + // Update failure counter 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! $errorCode = getCode('WRONG_PASS'); } - } elseif (((isNicknameUsed($content['userid'])) && (!empty($content['userid']))) || ($content['userid'] == $userid)) { - // Other account status? - if (fetchUserData($userid)) { - // Create an error code from given status - $errorCode = generateErrorCodeFromUserStatus(getUserData('status')); - } else { - // id not found! - $errorCode = getCode('WRONG_ID'); - } - } else { - // id not found! + } elseif ((isUserDataValid()) && (getUserData('status') != 'CONFIRMED')) { + // Create an error code from given status + $errorCode = generateErrorCodeFromUserStatus(getUserData('status')); + + // Set userid in session + setSession('current_userid', getUserData('userid')); + } elseif (!isUserDataValid()) { + // User id not found $errorCode = getCode('WRONG_ID'); + } else { + // Unknown error + $errorCode = getCode('UNKNOWN_ERROR'); } // Error code provided? if ($errorCode > 0) { // Then reconstruct the URL - $URL = $errorUrl . $errorCode; + $url = $errorUrl . $errorCode; + + // Extension set? Then add it as well. + if (!empty($ext)) { + $url .= '&ext=' . $ext; + } // END - if } // END - if // Return URL - return $URL; + return $url; } // Try to send a new password for the given user account function doNewUserPassword ($email, $userid) { - // Compile email when found in address (only secure chars!) - if (!empty($email)) $email = str_replace('{DOT}', '.', $email); - - // Init result and error + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'email=' . $email . ',userid=' . $userid . ' - ENTERED!'); + // Init found-status and error $errorCode = ''; - $result = false; + $accountFound = false; // Probe userid/nickname - // @TODO We should try to rewrite this to fetchUserData() somehow - if ((isExtensionActive('nickname')) && (isNicknameOrUserid($userid))) { + if (!empty($email)) { + // Email entered + $accountFound = fetchUserData($email, 'email'); + } elseif ((isExtensionActive('nickname')) && (isNicknameOrUserid($userid))) { // Nickname entered - $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))) { + $accountFound = fetchUserData($userid, 'nickname'); + } elseif ((isValidUserId($userid)) && (empty($email))) { // Direct userid entered - $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", - array($email), __FUNCTION__, __LINE__); + $accountFound = fetchUserData($userid); } else { // Userid not set! - logDebugMessage(__FUNCTION__, __LINE__, 'Userid is not set! BUG!'); - $errorCode = getCode('WRONG_ID'); + logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',email=' . $email . ': Important variables are empty.'); } // Any entry found? - if (SQL_NUMROWS($result) == 1) { - // This data is valid, so we create a new pass... :-) - list($userid, $status) = SQL_FETCHROW($result); - - if ($status == 'CONFIRMED') { - // Ooppps, this was missing! ;-) We should update the database... + if ($accountFound === true) { + // Is the account confirmed + if (getUserData('status') == 'CONFIRMED') { + // Generate new password $NEW_PASS = generatePassword(); + + // Update database SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `password`='%s' WHERE `userid`=%s LIMIT 1", - array(generateHash($NEW_PASS), $userid), __FUNCTION__, __LINE__); + array(generateHash($NEW_PASS), getUserData('userid')), __FUNCTION__, __LINE__); // Prepare data and message for email - $message = loadEmailTemplate('new-pass', array('new_pass' => $NEW_PASS, 'nickname' => $userid), $userid); + $message = loadEmailTemplate('guest_new_password', + array( + 'new_pass' => $NEW_PASS, + 'nickname' => $userid + ), bigintval(getUserData('userid'))); // ... and send it away - sendEmail($userid, getMessage('GUEST_NEW_PASSWORD'), $message); + sendEmail(bigintval(getUserData('userid')), '{--GUEST_NEW_PASSWORD--}', $message); // Output note to user - loadTemplate('admin_settings_saved', false, getMessage('GUEST_NEW_PASSWORD_SEND')); + displayMessage('{--GUEST_NEW_PASSWORD_SEND--}'); } else { // Account is locked or unconfirmed - $errorCode = generateErrorCodeFromUserStatus($status); + $errorCode = generateErrorCodeFromUserStatus(getUserData('status')); // Load URL - redirectToUrl('modules.php?module=index&what=login&login='.$errorCode); + redirectToUrl('modules.php?module=index&what=login&login=' . $errorCode); } } else { // id or email is wrong - loadTemplate('admin_settings_saved', false, '{--GUEST_WRONG_ID_EMAIL--}'); + displayMessage('{--GUEST_WRONG_ID_EMAIL--}'); } // Return the error code + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'email=' . $email . ',userid=' . $userid . ',errorCode=' . $errorCode . ' - EXIT!'); return $errorCode; } +// Get timestamp for given stats type and data +function getEpocheTimeFromUserStats ($statsType, $statsData, $userid = NULL) { + // Default timestamp is zero + $data['inserted'] = '0'; + + // User id set? + if ((isMemberIdSet()) && ($userid == '0')) { + $userid = getMemberId(); + } // END - if + + // Is the extension installed and updated? + if ((!isExtensionActive('sql_patches')) || (isExtensionInstalledAndOlder('sql_patches', '0.5.6'))) { + // Return zero here + return $data['inserted']; + } // END - if + + // Try to find the entry + $result = SQL_QUERY_ESC("SELECT + UNIX_TIMESTAMP(`inserted`) AS inserted +FROM + `{?_MYSQL_PREFIX?}_user_stats_data` +WHERE + `userid`=%s AND + `stats_type`='%s' AND + `stats_data`='%s' +LIMIT 1", + array( + bigintval($userid), + $statsType, + $statsData + ), __FUNCTION__, __LINE__); + + // Is the entry there? + if (SQL_NUMROWS($result) == 1) { + // Get this stamp + $data = SQL_FETCHARRAY($result); + } // END - if + + // Free result + SQL_FREERESULT($result); + + // Return stamp + return $data['inserted']; +} + +// Inserts user stats +function insertUserStatsRecord ($userid, $statsType, $statsData) { + // Is the extension installed and updated? + if ((!isExtensionActive('sql_patches')) || (isExtensionInstalledAndOlder('sql_patches', '0.5.6'))) { + // Return zero here + return false; + } // END - if + + // Does it exist? + if ((!getEpocheTimeFromUserStats($statsType, $statsData, $userid)) && (!is_array($statsData))) { + // Then insert it! + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_stats_data` (`userid`,`stats_type`,`stats_data`) VALUES (%s,'%s','%s')", + array( + bigintval($userid), + $statsType, + $statsData + ), __FUNCTION__, __LINE__); + } elseif (is_array($statsData)) { + // Invalid data! + logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',type=' . $statsType . ',data=' . gettype($statsData) . ': Invalid statistics data type!'); + } +} + +// Confirms a user account +function doConfirmUserAccount ($hash) { + // Init content + $content = array( + 'message' => '{--GUEST_CONFIRMED_FAILED--}', + 'userid' => 0, + ); + + // Initialize the user id + $userid = NULL; + + // Search for an unconfirmed or confirmed account + $result = SQL_QUERY_ESC("SELECT `userid`,`refid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `user_hash`='%s' AND (`status`='UNCONFIRMED' OR `status`='CONFIRMED') LIMIT 1", + array($hash), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 1) { + // Ok, he want's to confirm now so we load some data + list($userid, $refid) = SQL_FETCHROW($result); + + // Fetch user data + if (!fetchUserData($userid)) { + // Not found, should not happen + debug_report_bug(__FILE__, __LINE__, 'User account ' . $userid . ' not found.'); + } // END - if + + // Load all data and add points + $content = getUserDataArray(); + + // Unlock his account (but only when it is on UNCONFIRMED!) + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_user_data` +SET + `status`='CONFIRMED', + `user_hash`=NULL +WHERE + `user_hash`='%s' AND + `status`='UNCONFIRMED' +LIMIT 1", + array($hash), __FILE__, __LINE__); + + // Was it updated? + if (!SQL_HASZEROAFFECTED()) { + // Send email if updated + $message = loadEmailTemplate('guest_user_confirmed', $content, bigintval($userid)); + + // And send him right away the confirmation mail + sendEmail($userid, '{--GUEST_THANX_CONFIRM--}', $message); + + // Maybe he got "referaled"? + if ((isValidUserId($refid)) && ($refid != $userid)) { + // Select the referal userid + if (fetchUserData($refid)) { + // Update ref counter... + updateReferalCounter($refid); + + // If version matches add ref bonus to refid's account + if ((isExtensionInstalledAndNewer('bonus', '0.4.4')) && (isBonusRallyeActive())) { + // Add points (directly only!) + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `bonus_ref`=`bonus_ref`+{?bonus_ref?} WHERE `userid`=%s LIMIT 1", + array(bigintval($refid)), __FILE__, __LINE__); + + // Subtract points from system + handleBonusPoints(getConfig('bonus_ref')); + } // END - if + + // Add one-time referal bonus over referal system or directly + initReferalSystem(); + addPointsThroughReferalSystem('referal_bonus', $refid, getPointsRef(), bigintval($userid)); + } // END - if + } // END - if + + if (isExtensionActive('rallye')) { + // Add user to rallye (or not?) + addUserToReferalRallye(bigintval($userid)); + } // END - if + + // Account confirmed! + if (isExtensionActive('lead')) { + // Set special lead cookie + setSession('lead_userid', bigintval($userid)); + + // Lead-Code mode enabled + redirectToUrl('lead-confirm.php'); + } else { + $content['message'] = '{--GUEST_CONFIRMED_DONE--}'; + $content['userid'] = bigintval($userid); + } + } elseif (isExtensionActive('lead')) { + // Set special lead cookie + setSession('lead_userid', bigintval($userid)); + + // Lead-Code mode enabled + redirectToUrl('lead-confirm.php'); + } else { + // Nobody was found unter this hash key... or our new member want's to confirm twice? + $content['message'] = '{--GUEST_CONFIRMED_TWICE--}'; + } + } else { + // Nobody was found unter this hash key... or our new member want's to confirm twice? + $content['message'] = '{--GUEST_CONFIRMED_TWICE--}'; + } + + // Load template + displayMessage($content['message']); +} + +// Does resend the user's confirmation link for given email address +function doResendUserConfirmationLink ($email) { + // Email address not registered is default message + $message = '{--EMAIL_404--}'; + + // Confirmation link requested + if (fetchUserData($email, 'email')) { + // Email address found + $content = getUserDataArray(); + + // Is the account unconfirmed? + if ($content['status'] == 'UNCONFIRMED') { + // Load email template + $message = loadEmailTemplate('guest_request_confirm', array(), $content['userid']); + + // Send email + sendEmail($content['userid'], '{--GUEST_REQUEST_CONFIRM_LINK_SUBJECT--}', $message); + } // END - if + + // Create message based on the status + $message = getConfirmationMessageFromUserStatus($content['status']); + } // END - if + + // Output message + displayMessage($message); +} + +// Get a message (somewhat translation) from user status for confirmation link. +// This is different to translateUserStatus() in text messages. +function getConfirmationMessageFromUserStatus ($status) { + // Default is 'UNKNOWN' + $message = '{%message,GUEST_LOGIN_ID_UNKNOWN_STATUS=' . $status . '%}'; + + // Which status is it? + switch ($status) { + case 'UNCONFIRMED': // Account is unconfirmed + // And set message + $message = '{--GUEST_CONFIRM_LINK_SENT--}'; + break; + + case 'CONFIRMED': // Account already confirmed + $message = '{--GUEST_LOGIN_ID_CONFIRMED--}'; + break; + + case 'LOCKED': // Account is locked + $message = '{--GUEST_LOGIN_ID_LOCKED--}'; + break; + + default: // This should not happen + debug_report_bug(__FUNCTION__, __LINE__, 'Unknown user status ' . $status . ' detected.'); + break; + } // END - switch + + // Return message + return $message; +} + +// Expression call-back function for fetching user data +function doExpressionUser ($data) { + // Use current userid by default + $functionName = 'getMemberId()'; + + // User-related data, so is there a userid? + if (!empty($data['matches'][4][$data['key']])) { + // Do we have a userid or $userid? + if (substr($data['matches'][4][$data['key']], 0, 1) == '$') { + // Use dynamic call + $functionName = "getFetchedUserData('userid', " . $data['matches'][4][$data['key']] . ", '" . $data['callback'] . "')"; + } elseif (!empty($data['matches'][4][$data['key']])) { + // Do we have a number or a dollar sign in front of it? + if (preg_replace('/[^0123456789]/', '', $data['matches'][4][$data['key']]) != $data['matches'][4][$data['key']]) { + // Possible database column, so get it again + $data['matches'][4][$data['key']] = "getFetchedUserData('userid', getMemberId(), '" . $data['matches'][4][$data['key']] . "')"; + } // END - if + + // Fix all together + $functionName = "getFetchedUserData('userid', " . $data['matches'][4][$data['key']] . ", '" . $data['callback'] . "')"; + } + } elseif ((!empty($data['callback'])) && (isUserDataValid())) { + // "Call-back" alias column for current logged in user's data + $functionName = "getUserData('" . $data['callback'] . "')"; + } + + // Do we have another function to run (e.g. translations) + if (!empty($data['extra_func'])) { + // Surround the original function call with it + $functionName = $data['extra_func'] . '(' . $functionName . ')'; + } // END - if + //* NOISY-DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'functionName=' . $functionName); + + // Generate replacer + $replacer = '{DQUOTE} . ' . $functionName . ' . {DQUOTE}'; + + // Now replace the code + $code = replaceExpressionCode($data, $replacer); + + // Return replaced code + return $code; +} + +// Template call-back function for list_user admin function +function doTemplateAdminListUserTitle ($template, $clear = false) { + // Init title with "all accounts" + $code = '{--ADMIN_LIST_ALL_ACCOUNTS--}'; + + // Do we have a 'status' or 'mode' set? + if (isGetRequestParameterSet('status')) { + // Set title according to the 'status' + $code = sprintf("{--ADMIN_LIST_STATUS_%s_ACCOUNTS--}", strtoupper(getRequestParameter('status'))); + } elseif (isGetRequestParameterSet('mode')) { + // Set title according to the "mode" + $code = sprintf("{--ADMIN_LIST_MODE_%s_ACCOUNTS--}", strtoupper(getRequestParameter('mode'))); + } + + // Return the code + return $code; +} + // [EOF] ?>