X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-beg2.php;h=67bc6e328171876e29c7fb7a8a339ac04bed354b;hb=9f5f55cd28eebd7b389c13f7c3be500ff43d0a28;hp=67bbd992eb1a654d6e8f843cf77eff32d054740a;hpb=8a9324b2d931f54f54f4319fd7234910af77012c;p=mailer.git diff --git a/inc/modules/member/what-beg2.php b/inc/modules/member/what-beg2.php index 67bbd992eb..67bc6e3281 100644 --- a/inc/modules/member/what-beg2.php +++ b/inc/modules/member/what-beg2.php @@ -1,7 +1,7 @@
"); +addMenuDescription('member', __FILE__); + +if ((!isExtensionActive('beg')) && (!isAdmin())) { + loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('beg')); + return; +} // 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 -// 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"), + 'userid' => bigintval($content['userid']), + 'points' => translateComma($content['beg']), + 'last_online' => generateDateTime($content['last_online'], 2), ); // Load row template - $OUT .= LOAD_TEMPLATE("member_list_beg_row", true, $content); + $OUT .= loadTemplate('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 = loadTemplate('member_beg_404', true); } +// Prepare content +$content['rows'] = $OUT; + // Free memory SQL_FREERESULT($result); -// Remeber row(s) for the template -define('__BEG_ROWS', $OUT); - // Load final template -LOAD_TEMPLATE("member_list_beg"); +loadTemplate('member_list_beg', false, $content); // ?>