X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_bonus.php;h=492f1a0311119005003c3fe466823f40be2c43b2;hp=6a273ad932cef6662cbf60f95f631c90e46bb224;hb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8;hpb=d9f35786166902b9bc3f402d4f2abeed5ae0528d diff --git a/inc/modules/admin/what-list_bonus.php b/inc/modules/admin/what-list_bonus.php index 6a273ad932..492f1a0311 100644 --- a/inc/modules/admin/what-list_bonus.php +++ b/inc/modules/admin/what-list_bonus.php @@ -14,8 +14,6 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009, 2010 by Mailer Developer Team * @@ -45,14 +43,14 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { // Add description as navigation point addMenuDescription('admin', __FILE__); -if (getConfig('bonus_active') == 'Y') { +if (isBonusRallyeActive()) { // Shall I withdraw now? if (isPostRequestParameterSet('withdraw')) { // Okay, let's prepare... - $curr = date('m', time()) - 1; + $curr = getMonth() - 1; if (strlen($curr) == 1) $curr = '0' . $curr; updateConfiguration('last_month', $curr); - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BONUS_WITHDRAW_PREPARED')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_BONUS_WITHDRAW_PREPARED--}'); } // END - if if (isExtensionInstalledAndNewer('bonus', '0.6.9')) { @@ -66,27 +64,34 @@ if (getConfig('bonus_active') == 'Y') { $USE .= ')'; } else { // Old version ??? - $USE = 'turbo_bonus'; + $USE = '`turbo_bonus`'; } // Autopurge installed? - $lastOnline = "%s"; $ONLINE = ''; + $lastOnline = '%s'; $ONLINE = ''; if (isExtensionActive('autopurge')) { // Use last online timestamp to keep inactive members away from here - $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - %s)"; - $ONLINE = getConfig('ap_inactive_since'); - } + $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})"; + } // END - if // Check if at least one is in the active rallye - $result = SQL_QUERY_ESC("SELECT `userid`, `email`, `gender`, `surname`, `family`, ".$USE." AS points, `last_online` -FROM `{?_MYSQL_PREFIX?}_user_data` -WHERE `status`='CONFIRMED' AND ".$USE." > 0".$lastOnline." -ORDER BY `points` DESC, `last_online` DESC, `userid` ASC", - array($ONLINE), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT + `userid`, `email`, `gender`, `surname`, `family`, ".$USE." AS points, `last_online` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `status`='CONFIRMED' AND + ".$USE." > 0 + ".$lastOnline." +ORDER BY + `points` DESC, + `last_online` DESC, + `userid` ASC", + array($ONLINE), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // List users - $OUT = '';$SW = 2; $cnt = 1; $total = '0'; + $OUT = ''; $cnt = 1; $total = '0'; while ($content = SQL_FETCHARRAY($result)) { // Add total points $total += $content['points']; @@ -100,50 +105,46 @@ ORDER BY `points` DESC, `last_online` DESC, `userid` ASC", } // END - if // Prepare content - $content['userid'] = generateUserProfileLink($content['userid']); $content['email'] = generateEmailLink($content['email'], 'user_data'); - $content['gender'] = translateGender($content['gender']); - $content['points'] = translateComma($content['points']); $content['last_online'] = generateDateTime($content['last_online'], 2); - $content['sw'] = $SW; $content['win1'] = $WIN1; $content['win2'] = $WIN2; $content['cnt'] = $cnt; // Load template and add it $OUT .= loadTemplate('admin_list_bonus_rows', true, $content); - $SW = 3 - $SW; $cnt++; + $cnt++; } // END - while $content['rows'] = $OUT; $content['total'] = translateComma($total); // Check if we need to display form or not with manuel withdraw - if (getConfig('last_month') == date('m', time())) { + if (getConfig('last_month') == getMonth()) { // Load form $content['withdraw_form'] = loadTemplate('admin_list_bonus_form', true); } else { // Display message "no manual withdraw possible" - $content['withdraw_form'] = loadTemplate('admin_settings_saved', true, '
{--ADMIN_BONUS_ALREADY_WITHDRAW--}
'); + $content['withdraw_form'] = loadTemplate('admin_settings_unsaved', true, '{--ADMIN_BONUS_ALREADY_WITHDRAW--}'); } // Prepare constant for timemark // @TODO Can't this be moved into our expression language? if (isExtensionActive('autopurge')) { - $content['autopurge_timeout'] = generateDateTime(time() - getConfig('ap_inactive_since'), 2); + $content['autopurge_timeout'] = generateDateTime(time() - getApInactiveSince(), 2); } else { - $content['autopurge_timeout'] = getMaskedMessage('EXTENSION_PROBLEM_NOT_INSTALLED', 'autopurge'); + $content['autopurge_timeout'] = generateExtensionInactiveNotInstalledMessage('autopurge'); } // Load final template loadTemplate('admin_list_bonus', false, $content); } else { // No one has become an "activity bonus"... - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BONUS_NO_ACTIVE_RALLYE')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_BONUS_NO_ACTIVE_RALLYE--}'); } } else { // Aktive-Rallye not activated - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BONUS_RALLYE_DEACTIVATED')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_BONUS_RALLYE_DEACTIVATED--}'); } // [EOF]