X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-bonus.php;h=df6251fa0959d9abdbcdb7465c92dd4d674688df;hb=fc162164725588cf75969f707faead9c9cd8e68b;hp=5c9871a969c333a9ccda3f18a087520a6a03561b;hpb=e45e218c4f629ec63f0788cab231bfc88b3fa46e;p=mailer.git diff --git a/inc/modules/member/what-bonus.php b/inc/modules/member/what-bonus.php index 5c9871a969..df6251fa09 100644 --- a/inc/modules/member/what-bonus.php +++ b/inc/modules/member/what-bonus.php @@ -68,12 +68,11 @@ if (isExtensionInstalledAndNewer('bonus', '0.6.9')) { } // Autopurge installed? -$lastOnline = "%s"; $ONLINE = ''; +$lastOnline = '%s'; $ONLINE = ''; if (isExtensionActive('autopurge')) { // Use last online timestamp to keep inactive members away from here - $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - %s)"; - $ONLINE = getConfig('ap_inactive_since'); -} + $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})"; +} // END - if // Let's check if there are some points left we can 'pay'... $result = SQL_QUERY_ESC("SELECT @@ -81,15 +80,16 @@ $result = SQL_QUERY_ESC("SELECT FROM `{?_MYSQL_PREFIX?}_user_data` WHERE - ".$USE." > 0 AND `status`='CONFIRMED'".$lastOnline." + " . $USE . " > 0 AND + `status`='CONFIRMED' + " . $lastOnline . " ORDER BY `points` DESC, last_online DESC, userid ASC -LIMIT %s", +LIMIT {?bonus_ranks?}", array( - $ONLINE, - getConfig('bonus_ranks') + $ONLINE ), __FILE__, __LINE__); // Reset temporary variable and check for users @@ -100,11 +100,11 @@ if (SQL_NUMROWS($result) > 0) { while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the template $content = array( - 'sw' => $SW, - 'cnt' => $cnt, - 'userid' => bigintval($content['userid']), - 'points' => translateComma($content['points']), - 'last_online' => generateDateTime($content['last_online'], 2) + 'sw' => $SW, + 'cnt' => $cnt, + 'userid' => $content['userid'], + 'points' => $content['points'], + 'last_online' => generateDateTime($content['last_online'], 2) ); // Load row template @@ -112,7 +112,7 @@ if (SQL_NUMROWS($result) > 0) { // Count one up and switch colors $cnt++; $SW = 3 - $SW; - } + } // END - while } else { // No one is interested in our "active rallye" ! :-( $OUT = loadTemplate('member_bonus_404', true);