X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_beg.php;h=aa529945939a792020ebc9660e152796a05ff664;hb=00797d46cc0b7e2c4e8c084eb4c6ac26cd0336e1;hp=013330c1d0cfb24d5a55ce4ef1a3527565899950;hpb=75ad748a68473ace540251427a74fb781b1145e9;p=mailer.git diff --git a/inc/modules/admin/what-list_beg.php b/inc/modules/admin/what-list_beg.php index 013330c1d0..aa52994593 100644 --- a/inc/modules/admin/what-list_beg.php +++ b/inc/modules/admin/what-list_beg.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Mitglieder in Bettel-Rallye auflisten * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $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 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -32,107 +37,99 @@ ************************************************************************/ // Some security stuff... -if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin())) -{ - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; +if ((!defined('__SECURITY')) || (!IS_ADMIN())) { + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } // Add description as navigation point -ADD_DESCR("admin", basename(__FILE__)); +ADD_DESCR('admin', __FILE__); -if ($CONFIG['beg_rallye'] == "Y") -{ +if (getConfig('beg_rallye') == 'Y') { // Shall I withdraw now? - if (isset($_POST['withdraw'])) - { + if (REQUEST_ISSET_POST(('withdraw'))) { // Okay, let's prepare... - $curr = date("m", time()) - 1; - if (strlen($curr) == 1) $curr = "0".$curr; - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET beg_month='%s' WHERE config='0' LIMIT 1", - array($curr), __FILE__, __LINE__); - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_WITHDRAW_PREPARED); - OUTPUT_HTML("
"); - } + $curr = date('m', time()) - 1; + if (strlen($curr) == 1) $curr = '0'.$curr; + updateConfiguration('last_month', $curr); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_BEG_WITHDRAW_PREPARED')); + } // END - if // Autopurge installed? - $LAST = "%s"; $ONLINE = ""; - if (EXT_IS_ACTIVE("autopurge")) - { + $lastOnline = "%s"; $ONLINE = ''; + if (EXT_IS_ACTIVE('autopurge')) { // Use last online timestamp to keep inactive members away from here - $LAST = " AND last_online >= %s"; - $ONLINE = bigintval(time() - $CONFIG['ap_in_since']); - } + $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - %s)"; + $ONLINE = getConfig('ap_inactive_since'); + } // END - if // Check if at least one is in the active rallye - $result = SQL_QUERY_ESC("SELECT userid, email, sex, surname, family, beg_points, last_online -FROM "._MYSQL_PREFIX."_user_data -WHERE status='CONFIRMED' AND beg_points > 0".$LAST." + $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__); + array($ONLINE), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + if (SQL_NUMROWS($result) > 0) { // List users - $OUT = "";$SW = 2; $cnt = 1; $total = 0; - while(list($uid, $email, $sex, $sname, $fname, $turbo, $last) = SQL_FETCHROW($result)) - { - // Generate array fore the dynamic template - $WIN1 = ""; $WIN2 = ""; - if ($cnt <= $CONFIG['beg_ranks']) - { + $OUT = '';$SW = 2; $cnt = 1; $total = 0; + while ($content = SQL_FETCHARRAY($result)) { + // Init variables + $WIN1 = ''; $WIN2 = ''; + if ($cnt <= getConfig('beg_ranks')) { // Maybe he can win his active beg? - $WIN1 = ""; - $WIN2 = ""; - } + $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' => $uid, - 'email' => CREATE_EMAIL_LINK($email, "user_data"), - 'salut' => TRANSLATE_SEX($sex), - 'sname' => $sname, - 'fname' => $fname, - 'turbo' => TRANSLATE_COMMA($turbo), - 'last' => MAKE_DATETIME($last, "2"), - 'sw' => $SW, - 'win1' => $WIN1, - 'win2' => $WIN2, - 'cnt' => $cnt, + '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, ); // Load template and add it $OUT .= LOAD_TEMPLATE("admin_list_beg_rows", true, $content); - $SW = 3 - $SW; $cnt++; $total += $turbo; + $SW = 3 - $SW; $cnt++; $total += $content['beg_points']; } define('__BEG_ROWS', $OUT); - define('__TOTAL', TRANSLATE_COMMA($total)); + define('__TOTAL', translateComma($total)); // Check if we need to display form or not with manuel withdraw - if ($CONFIG['beg_month'] == date("m", time())) - { + if (getConfig('last_month') == date('m', time())) { // Load form define('__BEG_WITHDRAW_FORM', LOAD_TEMPLATE("admin_list_beg_form", true)); - } - else - { + } else { // Display message "no manual withdraw possible" - define('__BEG_WITHDRAW_FORM', "".ADMIN_BEG_ALREADY_WITHDRAW.""); + define('__BEG_WITHDRAW_FORM', "
{--ADMIN_BEG_ALREADY_WITHDRAW--}
"); } // Prepare constant for timemark - define('__AUTOPURGE_TIMEOUT', MAKE_DATETIME(time() - $CONFIG['ap_in_since'], "2")); + if (EXT_IS_ACTIVE('autopurge')) { + define('__AUTOPURGE_TIMEOUT', generateDateTime(time() - getConfig('ap_inactive_since'), '2')); + } else { + define('__AUTOPURGE_TIMEOUT', sprintf(getMessage('EXTENSION_PROBLEM_NOT_INSTALLED'), 'autopurge')); + } // Load final template LOAD_TEMPLATE("admin_list_beg"); - } - else - { + } else { // No one has joined the begging rallye... - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_NO_RALLYE); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_BEG_NO_RALLYE')); } -} - else -{ +} else { // Rallye deactivated - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_RALLYE_DEACTIVATED); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_BEG_RALLYE_DEACTIVATED')); } //