X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-beg2.php;h=99ffbfe1cc581cbeb2c7b585a70430508d5bb3b7;hb=b8aa17b98b99c27eafbdca0fa090bae63527da9a;hp=3c61941be4753f07fdca556d38af01265b7adddf;hpb=ae80e170b5d25a4782af90a7c3d81fbb176fa293;p=mailer.git diff --git a/inc/modules/member/what-beg2.php b/inc/modules/member/what-beg2.php index 3c61941be4..99ffbfe1cc 100644 --- a/inc/modules/member/what-beg2.php +++ b/inc/modules/member/what-beg2.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Alle moeglichen Gewinner der Bettel-Rallye aufl. * * -------------------------------------------------------------------- * - * * + * $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,68 +37,67 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; +if (!defined('__SECURITY')) { + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); -} - elseif (!IS_MEMBER()) -{ - LOAD_URL("modules.php[5~?module=index"); -} - elseif ((!EXT_IS_ACTIVE("beg")) && (!IS_ADMIN())) -{ - ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "beg"); +} elseif (!IS_MEMBER()) { + redirectToUrl('modules.php?module=index'); +} elseif ((!EXT_IS_ACTIVE('beg')) && (!IS_ADMIN())) { + addFatalMessage(__FILE__, __LINE__, generateExtensionInactiveNotInstalledMessage('beg')); return; } // Add description as navigation point -ADD_DESCR("member", basename(__FILE__)); -OUTPUT_HTML("
"); +ADD_DESCR('member', __FILE__); // 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 -// Let's check if there are some points left we can "pay"... -$result = SQL_QUERY_ESC("SELECT userid, beg_points AS beg, last_online FROM "._MYSQL_PREFIX."_user_data -WHERE beg_points > 0 AND status='CONFIRMED'".$LAST." -ORDER BY beg_points DESC, last_online DESC, userid LIMIT %s", - array($ONLINE, $_CONFIG['beg_ranks']), __FILE__, __LINE__); +// Let's check if there are some points left we can 'pay'... +$result = SQL_QUERY_ESC("SELECT + `userid`, `beg_points` AS beg, `last_online` +FROM + `{!_MYSQL_PREFIX!}_user_data` +WHERE + `beg_points` > 0 AND `status`='CONFIRMED'".$lastOnline." +ORDER BY + `beg_points` DESC, `last_online` DESC, `userid` ASC LIMIT %s", + array( + $ONLINE, + getConfig('beg_ranks') + ), __FILE__, __LINE__); // Reset temporary variable and check for users -$OUT = ""; -if (SQL_NUMROWS($result) > 0) -{ +$OUT = ''; +if (SQL_NUMROWS($result) > 0) { // Load our winners... $SW = 2; $cnt = 1; - while(list($uid, $turbo, $last) = SQL_FETCHROW($result)) - { + while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the template $content = array( 'sw' => $SW, 'cnt' => $cnt, - 'uid' => bigintval($uid), - 'points' => TRANSLATE_COMMA($turbo), - 'last' => MAKE_DATETIME($last, "2"), + 'uid' => bigintval($content['userid']), + 'points' => translateComma($content['beg']), + 'last' => generateDateTime($content['last_online'], '2'), ); // Load row template - $OUT .= LOAD_TEMPLATE("member_list_beg_row", true, $content); + $OUT .= LOAD_TEMPLATE('member_list_beg_row', true, $content); // Count one up and switch colors - $cnt++;$SW = 3 - $SW; + $cnt++; $SW = 3 - $SW; } -} - else -{ +} else { // No one is interested in our "active rallye" ! :-( - $OUT = LOAD_TEMPLATE("member_beg_404", true); + $OUT = LOAD_TEMPLATE('member_beg_404', true); } // Free memory @@ -103,7 +107,7 @@ SQL_FREERESULT($result); define('__BEG_ROWS', $OUT); // Load final template -LOAD_TEMPLATE("member_list_beg"); +LOAD_TEMPLATE('member_list_beg'); // ?>