X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fuser_functions.php;h=06d621c0a877b29488a5ceaab649235c502666d0;hp=527ed293e163d9735f3ba385e726aa49aaee9188;hb=e937b6540b932d537f72e827de76dd5be4aefe48;hpb=2379934be6a196a54f4155bb8e24c49b20736969 diff --git a/inc/libs/user_functions.php b/inc/libs/user_functions.php index 527ed293e1..06d621c0a8 100644 --- a/inc/libs/user_functions.php +++ b/inc/libs/user_functions.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -41,17 +41,19 @@ if (!defined('__SECURITY')) { } // END - if // Add links for selecting some users -function alpha ($sortby) { +function addAlphabeticalSorting ($sortby) { $add = ''; - foreach (array('page','offset','mode','status') as $param) { + foreach (array('page', 'offset', 'do', 'status') as $param) { if (isGetRequestElementSet($param)) { $add .= '&' . $param . '=' . getRequestElement($param); } // END - if } // END - foreach - /* Creates the list of letters and makes them a link. */ + // Creates the list of letters and makes them a link. $alphabet = explode(',', '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,'); $num = count($alphabet) - 1; + + // Add all letter links $OUT = ''; while (list($counter, $ltr) = each($alphabet)) { if (getRequestElement('letter') == $ltr) { @@ -62,16 +64,16 @@ function alpha ($sortby) { $OUT .= '' . $ltr . ''; } - if ((($counter / getConfig('user_alpha')) == round($counter / getConfig('user_alpha'))) && ($counter > 0)) { + if ((($counter / getUserAlpha()) == round($counter / getUserAlpha())) && ($counter > 0)) { $OUT .= ']
['; - } elseif ( $counter != $num ) { + } elseif ($counter != $num) { $OUT .= '|'; } } // END - while // Prepare content $content = array ( - 'alpha_selection' => $OUT + 'alpha_selection' => $OUT, ); // Load template @@ -91,7 +93,7 @@ function addSortLinks ($letter, $sortby) { $add = '&page=' . getRequestElement('page') . '&offset=' . getRequestElement('offset'); // Add status/ mode - foreach (array('mode','status') as $param) { + foreach (array('do','status') as $param) { if (isGetRequestElementSet($param)) { $add .= '&' . $param . '=' . getRequestElement($param); } // END - if @@ -152,14 +154,14 @@ function addPageNavigation ($numPages) { $OUT .= ''; + $OUT .= '&letter=' . getRequestElement('letter') . '&sortby=' . getRequestElement('sortby') . '&page=' . $page . '&offset=' . getUserLimit() . '%}">'; } $OUT .= $page; @@ -207,7 +209,7 @@ WHERE LIMIT 1", array($email), __FUNCTION__, __LINE__); - // Do we have an entry? + // Is there an entry? if (SQL_NUMROWS($result) == 1) { // Load userid list($userid) = SQL_FETCHROW($result); @@ -223,30 +225,32 @@ LIMIT 1", return $email; } -// 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 () { +// Selects a random user id as the new referral id if they have at least X confirmed mails in this run +function determineRandomReferralId () { // Default is zero refid $refid = NULL; // Is the extension version fine? - if (isExtensionInstalledAndNewer('user', '0.3.4')) { + if ((isRandomReferralIdEnabled()) && (isExtensionInstalledAndNewer('user', '0.3.4'))) { // Get all user ids - $totalUsers = countSumTotalData('CONFIRMED', 'user_data', 'userid', 'status', true, " AND `rand_confirmed` >= {?user_min_confirmed?}"); + $totalUsers = countSumTotalData('CONFIRMED', 'user_data', 'userid', 'status', true, runFilterChain('user_exclusion_sql', ' AND `rand_confirmed` >= {?user_min_confirmed?}')); - // Do we have at least one? + // Is there at least one? if ($totalUsers > 0) { - // Then choose random number - $randNum = mt_rand(0, ($totalUsers - 1)); + // Then choose random userid + $randUserid = 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` >= {?user_min_confirmed?} ORDER BY `rand_confirmed` DESC LIMIT %s, 1", - array($randNum), __FUNCTION__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` " . runFilterChain('user_exclusion_sql', "WHERE `status`='CONFIRMED'") . ' AND `rand_confirmed` >= {?user_min_confirmed?} ORDER BY `rand_confirmed` DESC LIMIT %s, 1', + array($randUserid), __FUNCTION__, __LINE__); - // Do we have one entry there? + // Is there one entry there? if (SQL_NUMROWS($result) == 1) { - // Use that userid as new referal id + // Use that userid as new referral id list($refid) = SQL_FETCHROW($result); + + // Debug message + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'refid=' . $refid . ' - choosen!'); } // END - if // Free result @@ -279,7 +283,7 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p // Check login data if ((isExtensionActive('nickname')) && (isNicknameUsed($userid))) { // Nickname entered - fetchUserData($userid, 'nickname'); + $isFound = fetchUserData($userid, 'nickname'); } elseif (isNicknameUsed($userid)) { // No nickname installed $errorCode = getCode('EXTENSION_PROBLEM'); @@ -298,6 +302,9 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p } // END - if } // END - if + // Debug message + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',isUserDataValid()=' . intval(isUserDataValid()) . ',userStatus=' . getUserData('status') . ',errorCode=' . $errorCode . ',ext=' . $ext . ',isFound=' . intval($isFound)); + // Is there an entry? if (($errorCode == '0') && (isUserDataValid()) && (getUserData('status') == 'CONFIRMED') && (!empty($content['userid']))) { // Check for old MD5 passwords @@ -334,7 +341,7 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p // Is the timeout reached? if ($probe >= getConfig('login_timeout')) { // Add login bonus to user's account - $add = ', `login_bonus`=`login_bonus`+{?login_bonus?}'; + $add = ',`login_bonus`=`login_bonus`+{?login_bonus?}'; $GLOBALS['bonus_payed'] = true; // Subtract login bonus from userid's account or jackpot @@ -361,10 +368,10 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p // Procedure to checking for login data 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&do=bonus'; } else { // Bonus not added - $url = 'modules.php?module=chk_login&mode=login'; + $url = 'modules.php?module=chk_login&do=login'; } } else { // Use this URL @@ -391,7 +398,7 @@ function doUserLogin ($userid, $passwd, $successUrl = '', $errorUrl = 'modules.p $errorCode = generateErrorCodeFromUserStatus(getUserData('status')); // Set userid in session - setSession('current_userid', getUserData('userid')); + setSession('userid', getUserData('userid')); } elseif (!isUserDataValid()) { // User id not found $errorCode = getCode('WRONG_ID'); @@ -468,8 +475,8 @@ function doNewUserPassword ($email, $userid) { redirectToUrl('modules.php?module=index&what=login&login=' . $errorCode); } } else { - // id or email is wrong - displayMessage('{--GUEST_WRONG_ID_EMAIL--}'); + // Id or email is wrong + displayMessage('{--GUEST_WRONG_ID_EMAIL--}'); } // Return the error code @@ -575,7 +582,7 @@ function doConfirmUserAccount ($hash) { // Fetch user data if (!fetchUserData($userid)) { // Not found, should not happen - debug_report_bug(__FILE__, __LINE__, 'User account ' . $userid . ' not found.'); + reportBug(__FILE__, __LINE__, 'User account ' . $userid . ' not found.'); } // END - if // Load all data and add points @@ -601,12 +608,12 @@ LIMIT 1", // And send him right away the confirmation mail sendEmail($userid, '{--GUEST_THANX_CONFIRM--}', $message); - // Maybe he got "referaled"? + // Maybe he got "referraled"? if ((isValidUserId($refid)) && ($refid != $userid)) { - // Select the referal userid + // Select the referral userid if (fetchUserData($refid)) { // Update ref counter... - updateReferalCounter($refid); + updateReferralCounter($refid); // If version matches add ref bonus to refid's account if ((isExtensionInstalledAndNewer('bonus', '0.4.4')) && (isBonusRallyeActive())) { @@ -618,15 +625,15 @@ LIMIT 1", handleBonusPoints(getConfig('bonus_ref'), $refid); } // END - if - // Add one-time referal bonus over referal system or directly - initReferalSystem(); - addPointsThroughReferalSystem('referal_bonus', $refid, getPointsRef(), bigintval($userid)); + // Add one-time referral bonus over referral system or directly + initReferralSystem(); + addPointsThroughReferralSystem('referral_bonus', $refid, getPointsRef(), bigintval($userid)); } // END - if } // END - if if (isExtensionActive('rallye')) { // Add user to rallye (or not?) - addUserToReferalRallye(bigintval($userid)); + addUserToReferralRallye(bigintval($userid)); } // END - if // Account confirmed! @@ -708,7 +715,7 @@ function getConfirmationMessageFromUserStatus ($status) { break; default: // This should not happen - debug_report_bug(__FUNCTION__, __LINE__, 'Unknown user status ' . $status . ' detected.'); + reportBug(__FUNCTION__, __LINE__, 'Unknown user status ' . $status . ' detected.'); break; } // END - switch @@ -716,6 +723,110 @@ function getConfirmationMessageFromUserStatus ($status) { return $message; } +// "Getter" for total tester accounts +function getTotalTesterUsers () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = countSumTotalData('', 'user_data', 'userid', '', true, runFilterChain('user_inclusion_sql')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Checks whether the admin is allowed to create more tester accounts +function isNewUserTesterAllowed () { + // By default only admins are allowed + if (!isAdmin()) { + // This should not happen and must be fixed + reportBug(__FUNCTION__, __LINE__, 'isAdmin()=false - Not allowed.'); + } // END - if + + // Are more tester accounts allowed? + $isAllowed = (getTotalTesterUsers() < bigintval(getTesterUserMaximum() + 1)); + + // Return result + return $isAllowed; +} + +// "Getter" for next free tester account number +function getNextFreeTesterUserNumber () { + // Get current total amount because we start with zero + $nextTester = getTotalTesterUsers(); + + // Prepend zeros + $nextTester = prependZeros($nextTester, 6); + + // Return it + return $nextTester; +} + +// Wrapper function to return a selection box for tester user default referral id +function addTesterUserDefaultRefidSelectionBox ($fieldName = 'tester_user_default_refid') { + // Return it + return addMemberSelectionBox(getConfig('tester_user_default_refid'), false, true, true, $fieldName, " WHERE `surname` LIKE '{?tester_user_surname_prefix?}%'"); +} + +// Checks whether given surname is a test user name +function isTesterUserName ($surname) { + // Determine it + return (substr($surname, 0, strlen(getTesterUserSurnamePrefix())) == getTesterUserSurnamePrefix()); +} + +// Creates a tester account from given POST data +function createTesterUserAccount () { + // Add generated surname + setPostRequestElement('surname', (getTesterUserSurnamePrefix() . getNextFreeTesterUserNumber())); + + // Is the registration data complete? + if (!isRegistrationDataComplete()) { + // Then abort here + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'isRegistrationDataComplete()=false, please check if you e.g. have selected the required minimum of categories.'); + return false; + } // END - if + + // Do registration + $isCreated = doUserRegistration(); + + // Remove cache to force recalculation of total tester accounts + unset($GLOBALS['getTotalTesterUsers']); + + // Return status + return $isCreated; +} + +// Checks whether the given sub id is fused by current member +function isMemberSubIdFree ($subId) { + // Check it + $isFree = (countSumTotalData(getMemberId(), 'user_subids', 'id', 'userid', true, sprintf(" AND `subid`='%s'", $subId)) == 0); + + // Return result + return $isFree; +} + +// Prepares given sub id for storage in database +function prepareSubId ($subId) { + // First convert any spaces/dashes to underscores + $subId = str_replace(' ', '_', str_replace('-', '_', $subId)); + + // Then filter out any unwanted characters + $subId = preg_replace('/([^a-zA-Z0-9_])/', '', $subId); + + // Then Check if it is available + if (!isMemberSubIdFree($subId)) { + // Is not free + $subId = false; + } // END - if + + // Return prepared sub id + return $subId; +} + +//----------------------------------------------------------------------------- +// EL code functions +//----------------------------------------------------------------------------- + // Expression call-back function for fetching user data function doExpressionUser ($data) { // Use current userid by default @@ -723,12 +834,12 @@ function doExpressionUser ($data) { // User-related data, so is there a userid? if (!empty($data['matches'][4][$data['key']])) { - // Do we have a userid or $userid? + // Is there 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? + // Is there 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']] . "')"; @@ -742,7 +853,7 @@ function doExpressionUser ($data) { $functionName = "getUserData('" . $data['callback'] . "')"; } - // Do we have another function to run (e.g. translations) + // Is there another function to run (e.g. translations) if (!empty($data['extra_func'])) { // Surround the original function call with it $functionName = $data['extra_func'] . '(' . $functionName . ')'; @@ -759,23 +870,204 @@ function doExpressionUser ($data) { return $code; } +//----------------------------------------------------------------------------- +// Template helper functions +//----------------------------------------------------------------------------- + // 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? + // Is there a 'status' or 'do' set? if (isGetRequestElementSet('status')) { // Set title according to the 'status' $code = sprintf("{--ADMIN_LIST_STATUS_%s_ACCOUNTS--}", strtoupper(getRequestElement('status'))); - } elseif (isGetRequestElementSet('mode')) { - // Set title according to the "mode" - $code = sprintf("{--ADMIN_LIST_MODE_%s_ACCOUNTS--}", strtoupper(getRequestElement('mode'))); + } elseif (isGetRequestElementSet('do')) { + // Set title according to 'do' + $code = sprintf("{--ADMIN_LIST_DO_%s_ACCOUNTS--}", strtoupper(getRequestElement('do'))); } // Return the code return $code; } +// Template call-back function for displaying "username" +function doTemplateDisplayUsername ($template, $clear = false, $userid = NULL) { + // Is a userid set? + if (!isValidUserId($userid)) { + // Please don't call this without a valid userid + reportBug(__FUNCTION__, __LINE__, 'template=' . $template . ',clear=' . intval($clear) . ',userid[' . gettype($userid) . ']=' . intval($userid) . ' - Invalid userid provided.'); + } // END - if + + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__][$userid])) { + // Generate code + $GLOBALS[__FUNCTION__][$userid] = $userid . ' ({%user,nickname,fixEmptyContentToDashes=' . $userid . '%})'; + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__][$userid]; +} + +// ---------------------------------------------------------------------------- +// XML call-back functions +// ---------------------------------------------------------------------------- + +// For 'doing' add subid, the column-index is required +function addXmlSpecialMemberAddDoUserSubid () { + // So set it all here + $GLOBALS['__COLUMN_INDEX']['doXmlCallbackFunction'] = 'column'; + $GLOBALS['__XML_ARGUMENTS']['doXmlCallbackFunction']['column_index'] = 'column'; +} + +// ---------------------------------------------------------------------------- +// Wrapper functions for configuration entries +// ---------------------------------------------------------------------------- + +// Getter for user_alpha +function getUserAlpha () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('user_alpha'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for user_limit +function getUserLimit () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('user_limit'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_surname_prefix +function getTesterUserSurnamePrefix () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_surname_prefix'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_maximum +function getTesterUserMaximum () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_maximum'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_check_cat +function getTesterUserCheckCat () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_check_cat'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_gender +function getTesterUserGender () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_gender'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_family +function getTesterUserFamily () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_family'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_password +function getTesterUserPassword () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_password'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_street_nr +function getTesterUserStreetNr () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_street_nr'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_zip +function getTesterUserZip () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_zip'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_city +function getTesterUserCity () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_city'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for tester_user_email +function getTesterUserEmail () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_email'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + // [EOF] ?>