X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_beg.php;h=7bf2f906c7b85ec460f966c8382d8df716c3b74d;hb=648afd5e9ca91e878a755fdb5438ac6103a4ac7e;hp=3bb5aba71f942586923c3e552d17eecd63b77fee;hpb=7b0f17cd637e388049d2167811e4332cec1e979b;p=mailer.git diff --git a/inc/modules/admin/what-list_beg.php b/inc/modules/admin/what-list_beg.php index 3bb5aba71f..7bf2f906c7 100644 --- a/inc/modules/admin/what-list_beg.php +++ b/inc/modules/admin/what-list_beg.php @@ -1,7 +1,7 @@ = (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, 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) { // List users - $OUT = '';$SW = 2; $cnt = 1; $total = 0; + $OUT = '';$SW = 2; $cnt = 1; $total = '0'; while ($content = SQL_FETCHARRAY($result)) { // Init variables $WIN1 = ''; $WIN2 = ''; + + // Maybe he can win his active beg? if ($cnt <= getConfig('beg_ranks')) { - // Maybe he can win his active beg? - $WIN1 = ""; - $WIN2 = ""; + // Mark him + $WIN1 = ''; + $WIN2 = ''; } // END - if // Prepare content - // @TODO Rewrite templates so s/fname will be replaced by surname/family - // @TODO to shorten this block. Please also do so with uid->userid $content = array( - 'uid' => $content['userid'], - 'email' => generateMemberEmailLink($content['email'], "user_data"), - 'gender' => translateGender($content['gender']), - 'sname' => $content['surname'], - 'fname' => $content['family'], - 'turbo' => translateComma($content['beg_points']), - 'last' => generateDateTime($content['last_online'], "2"), - 'sw' => $SW, - 'win1' => $WIN1, - 'win2' => $WIN2, - 'cnt' => $cnt, + 'userid' => $content['userid'], + 'email' => generateEmailLink($content['email'], 'user_data'), + 'gender' => $content['gender'], + 'turbo' => $content['beg_points'], + 'last_online' => generateDateTime($content['last_online'], 2), + 'sw' => $SW, + 'win1' => $WIN1, + 'win2' => $WIN2, + 'cnt' => $cnt, ); // Load template and add it - $OUT .= LOAD_TEMPLATE("admin_list_beg_rows", true, $content); + $OUT .= loadTemplate('admin_list_beg_rows', true, $content); $SW = 3 - $SW; $cnt++; $total += $content['beg_points']; - } - define('__BEG_ROWS', $OUT); - define('__TOTAL', translateComma($total)); + } // 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())) { // Load form - define('__BEG_WITHDRAW_FORM', LOAD_TEMPLATE("admin_list_beg_form", true)); + $content['withdraw_form'] = loadTemplate('admin_list_beg_form', true); } else { // Display message "no manual withdraw possible" - define('__BEG_WITHDRAW_FORM', "
{--ADMIN_BEG_ALREADY_WITHDRAW--}
"); + $content['withdraw_form'] = loadTemplate('admin_settings_saved', true, '
{--ADMIN_BEG_ALREADY_WITHDRAW--}
'); } // Prepare constant for timemark - if (EXT_IS_ACTIVE('autopurge')) { - define('__AUTOPURGE_TIMEOUT', generateDateTime(time() - getConfig('ap_inactive_since'), "2")); + if (isExtensionActive('autopurge')) { + $content['autopurge_timeout'] = generateDateTime(time() - getConfig('ap_inactive_since'), 2); } else { - define('__AUTOPURGE_TIMEOUT', sprintf(getMessage('EXTENSION_PROBLEM_NOT_INSTALLED'), 'autopurge')); + $content['autopurge_timeout'] = loadTemplate('admin_settings_saved', true, getMaskedMessage('EXTENSION_PROBLEM_EXTENSION_NOT_INSTALLED', 'autopurge')); } // Load final template - LOAD_TEMPLATE("admin_list_beg"); + loadTemplate('admin_list_beg', false, $content); } else { // No one has joined the begging rallye... - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_BEG_NO_RALLYE')); + loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BEG_NO_RALLYE')); } } else { // Rallye deactivated - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_BEG_RALLYE_DEACTIVATED')); + loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BEG_RALLYE_DEACTIVATED')); } -// +// [EOF] ?>