X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_beg.php;h=b3d19ef974405dd29b3e2aa5198f859c9e5a89a5;hp=cbb750f414a451cf5a26c15768292b5b30a4ca56;hb=a50f5113fe25ed5f125e3377914a5c0d84b4c1ae;hpb=60494e212a67fe360bfbb481eb4928480a6f379b diff --git a/inc/modules/admin/what-list_beg.php b/inc/modules/admin/what-list_beg.php index cbb750f414..b3d19ef974 100644 --- a/inc/modules/admin/what-list_beg.php +++ b/inc/modules/admin/what-list_beg.php @@ -10,9 +10,14 @@ * -------------------------------------------------------------------- * * 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 * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -32,108 +37,101 @@ ************************************************************************/ // Some security stuff... -if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin())) -{ - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; - require($INC); +if ((!defined('__SECURITY')) || (!isAdmin())) { + die(); } + // Add description as navigation point -ADD_DESCR("admin", basename(__FILE__)); +addMenuDescription('admin', __FILE__); -if ($_CONFIG['beg_rallye'] == 'Y') -{ +if (getConfig('beg_rallye') == 'Y') { // Shall I withdraw now? - if (isset($_POST['withdraw'])) - { + if (isPostRequestElementSet(('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); + loadTemplate('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 (isExtensionActive('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']) - { - // Maybe he can win his active beg? - $WIN1 = ""; - $WIN2 = ""; - } + $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')) { + // Mark him + $WIN1 = ''; + $WIN2 = ''; + } // END - if + + // Prepare content $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, + 'userid' => $content['userid'], + 'email' => generateEmailLink($content['email'], 'user_data'), + 'gender' => translateGender($content['gender']), + 'surname' => $content['surname'], + 'family' => $content['family'], + 'turbo' => translateComma($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); - $SW = 3 - $SW; $cnt++; $total += $turbo; + $OUT .= loadTemplate('admin_list_beg_rows', true, $content); + $SW = 3 - $SW; $cnt++; $total += $content['beg_points']; } - define('__BEG_ROWS', $OUT); - define('__TOTAL', TRANSLATE_COMMA($total)); + + $content['rows'] = $OUT; + $content['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 - { + $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 - define('__AUTOPURGE_TIMEOUT', MAKE_DATETIME(time() - $_CONFIG['ap_in_since'], "2")); + if (isExtensionActive('autopurge')) { + $content['autopurge_timeout'] = generateDateTime(time() - getConfig('ap_inactive_since'), 2); + } else { + $content['autopurge_timeout'] = loadTemplate('admin_settings_saved', true, sprintf(getMessage('EXTENSION_PROBLEM_NOT_INSTALLED'), 'autopurge')); + } // Load final template - LOAD_TEMPLATE("admin_list_beg"); - } - else - { + loadTemplate('admin_list_beg', false, $content); + } else { // No one has joined the begging rallye... - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_NO_RALLYE); + loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BEG_NO_RALLYE')); } -} - else -{ +} else { // Rallye deactivated - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_RALLYE_DEACTIVATED); + loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BEG_RALLYE_DEACTIVATED')); } -// +// [EOF] ?>