X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_beg.php;h=459ea16c3bb665db23eccef1eea5cacb46a0e7a8;hb=c6017cf76200e2a5e68bd1984fa2d31f0e3be9d8;hp=9ec24929a60d9068983e0097f5fbc0f213a59c62;hpb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60;p=mailer.git diff --git a/inc/modules/admin/what-list_beg.php b/inc/modules/admin/what-list_beg.php index 9ec24929a6..459ea16c3b 100644 --- a/inc/modules/admin/what-list_beg.php +++ b/inc/modules/admin/what-list_beg.php @@ -1,7 +1,7 @@ 0))) { // 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 (UNIX_TIMESTAMP() - `last_online`) >= {?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, beg_points, last_online -FROM `{?_MYSQL_PREFIX?}_user_data` -WHERE `status`='CONFIRMED' AND beg_points > 0".$lastOnline." -ORDER BY beg_points DESC, last_online DESC, userid", - array($ONLINE), __FILE__, __LINE__); + $result = SQL_QUERY("SELECT `userid`, `gender`, `surname`, `family`, `email`, `beg_points`, `last_online` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `status`='CONFIRMED' AND + `beg_points` > 0 + " . $lastOnline . " +ORDER BY + `beg_points` DESC, + `last_online` DESC, + `userid` ASC", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // List users - $OUT = '';$SW = 2; $cnt = 1; $total = '0'; + $OUT = ''; $count = 1; $total = '0'; while ($content = SQL_FETCHARRAY($result)) { // Init variables $WIN1 = ''; $WIN2 = ''; // Maybe he can win his active beg? - if ($cnt <= getConfig('beg_ranks')) { + if ($count <= getBegRanks()) { // Mark him $WIN1 = ''; $WIN2 = ''; @@ -87,50 +93,47 @@ ORDER BY beg_points DESC, last_online DESC, userid", $content = array( 'userid' => $content['userid'], 'email' => generateEmailLink($content['email'], 'user_data'), - 'gender' => translateGender($content['gender']), - 'surname' => $content['surname'], - 'family' => $content['family'], - 'turbo' => translateComma($content['beg_points']), + 'gender' => $content['gender'], + 'turbo' => $content['beg_points'], 'last_online' => generateDateTime($content['last_online'], 2), - 'sw' => $SW, 'win1' => $WIN1, 'win2' => $WIN2, - 'cnt' => $cnt, + 'cnt' => $count, ); // Load template and add it $OUT .= loadTemplate('admin_list_beg_rows', true, $content); - $SW = 3 - $SW; $cnt++; $total += $content['beg_points']; - } + $count++; $total += $content['beg_points']; + } // END - while $content['rows'] = $OUT; - $content['total'] = translateComma($total); + $content['total_points'] = $total; // Check if we need to display form or not with manuel withdraw - if (getConfig('last_month') == date('m', time())) { + if (getLastMonth() == getMonth()) { // Load form $content['withdraw_form'] = loadTemplate('admin_list_beg_form', true); } else { // Display message "no manual withdraw possible" - $content['withdraw_form'] = loadTemplate('admin_settings_saved', true, "
{--ADMIN_BEG_ALREADY_WITHDRAW--}
"); + $content['withdraw_form'] = displayMessage('{--ADMIN_BEG_ALREADY_WITHDRAW--}', true); } // Prepare constant for timemark if (isExtensionActive('autopurge')) { - $content['autopurge_timeout'] = generateDateTime(time() - getConfig('ap_inactive_since'), 2); + $content['autopurge_timeout'] = generateDateTime(time() - getApInactiveSince(), 2); } else { - $content['autopurge_timeout'] = loadTemplate('admin_settings_saved', true, sprintf(getMessage('EXTENSION_PROBLEM_NOT_INSTALLED'), 'autopurge')); + $content['autopurge_timeout'] = displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=autopurge%}', true); } // Load final template loadTemplate('admin_list_beg', false, $content); } else { // No one has joined the begging rallye... - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BEG_NO_RALLYE')); + displayMessage('{--ADMIN_BEG_NO_RALLYE--}'); } } else { // Rallye deactivated - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BEG_RALLYE_DEACTIVATED')); + displayMessage('{--ADMIN_BEG_RALLYE_DEACTIVATED--}'); } // [EOF]