X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Flibs%2Fuser_functions.php;h=566c762b0c3752b84821dd0849dcd09c4ca36fe9;hb=dab685829937da2709107db11da8dd224c828140;hp=63fb9f9bc3448756091091e86c7225a246fc1417;hpb=f0f8c5c1eb49a13b41d70fbb5c6546f2d6be4afa;p=mailer.git diff --git a/inc/libs/user_functions.php b/inc/libs/user_functions.php index 63fb9f9bc3..566c762b0c 100644 --- a/inc/libs/user_functions.php +++ b/inc/libs/user_functions.php @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * + * 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 * @@ -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','do','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 @@ -159,7 +161,7 @@ function addPageNavigation ($numPages) { } // END - foreach // Letter and so on - $OUT .= '&letter=' . getRequestElement('letter') . '&sortby=' . getRequestElement('sortby') . '&page=' . $page . '&offset=' . getConfig('user_limit') . '%}">'; + $OUT .= '&letter=' . getRequestElement('letter') . '&sortby=' . getRequestElement('sortby') . '&page=' . $page . '&offset=' . getUserLimit() . '%}">'; } $OUT .= $page; @@ -224,29 +226,31 @@ LIMIT 1", } // Selects a random user id as the new referral id if they have at least X confirmed mails in this run -// @TODO Double-check configuration entry here 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? 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? if (SQL_NUMROWS($result) == 1) { // 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 @@ -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 @@ -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'); @@ -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 @@ -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,83 @@ function getConfirmationMessageFromUserStatus ($status) { return $message; } +// "Getter" for total tester accounts +function getTotalTesterUsers () { + // Do we have 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; +} + +//----------------------------------------------------------------------------- +// EL code functions +//----------------------------------------------------------------------------- + // Expression call-back function for fetching user data function doExpressionUser ($data) { // Use current userid by default @@ -759,6 +843,10 @@ 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" @@ -782,7 +870,7 @@ function doTemplateDisplayUsername ($template, $clear = false, $userid = NULL) { // Is a userid set? if (!isValidUserId($userid)) { // Please don't call this without a valid userid - debug_report_bug(__FUNCTION__, __LINE__, 'template=' . $template . ',clear=' . intval($clear) . ',userid[' . gettype($userid) . ']=' . intval($userid) . ' - Invalid userid provided.'); + reportBug(__FUNCTION__, __LINE__, 'template=' . $template . ',clear=' . intval($clear) . ',userid[' . gettype($userid) . ']=' . intval($userid) . ' - Invalid userid provided.'); } // END - if // Do we have cache? @@ -795,5 +883,153 @@ function doTemplateDisplayUsername ($template, $clear = false, $userid = NULL) { return $GLOBALS[__FUNCTION__][$userid]; } +// ---------------------------------------------------------------------------- +// Wrapper functions for configuration entries +// ---------------------------------------------------------------------------- + +// Getter for user_alpha +function getUserAlpha () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have 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 () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('tester_user_email'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + // [EOF] ?>