X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_bonus.php;h=0c8129d11d2f89124b69b5f526b192b2695a0ff6;hb=5c4d360166de238420eec3e5f4e694befb09ab5d;hp=06731189cccf177302244265ad27a9ed5bad26f6;hpb=35c88a3dc0b3f34c29d5a56998579b244e506785;p=mailer.git

diff --git a/inc/modules/admin/what-list_bonus.php b/inc/modules/admin/what-list_bonus.php
index 06731189cc..0c8129d11d 100644
--- a/inc/modules/admin/what-list_bonus.php
+++ b/inc/modules/admin/what-list_bonus.php
@@ -67,27 +67,28 @@ if (isBonusRallyeActive()) {
 		$USE = '`turbo_bonus`';
 	}
 
+	// Init variables
+	$lastOnline = '';
+
 	// Autopurge installed?
-	$lastOnline = '%s'; $ONLINE = '';
-	if (isExtensionActive('autopurge')) {
+	if ((isExtensionActive('autopurge')) && ((getApInactiveSince() > 0))) {
 		// Use last online timestamp to keep inactive members away from here
-		$lastOnline   = " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})";
+		$lastOnline = ' AND (UNIX_TIMESTAMP() - `last_online`) >= {?ap_inactive_since?}';
 	} // END - if
 
 	// Check if at least one is in the active rallye
-	$result = SQL_QUERY_ESC("SELECT
+	$result = SQL_QUERY("SELECT
 	`userid`, `email`, `gender`, `surname`, `family`, ".$USE." AS `points`, `last_online`
 FROM
 	`{?_MYSQL_PREFIX?}_user_data`
 WHERE
 	`status`='CONFIRMED' AND
-	".$USE." > 0
-	".$lastOnline."
+	" . $USE . " > 0
+	" . $lastOnline . "
 ORDER BY
 	`points` DESC,
 	`last_online` DESC,
-	`userid` ASC",
-		array($ONLINE), __FILE__, __LINE__);
+	`userid` ASC", __FILE__, __LINE__);
 
 	if (!SQL_HASZERONUMS($result)) {
 		// List users
@@ -131,7 +132,7 @@ ORDER BY
 		// Prepare constant for timemark
 		// @TODO Can't this be moved into our expression language?
 		if (isExtensionActive('autopurge')) {
-			$content['autopurge_timeout'] = generateDateTime(time() - getApInactiveSince(), 2);
+			$content['autopurge_timeout'] = '{%message,ADMIN_BONUS_TIMEOUT=' . generateDateTime(time() - getApInactiveSince(), 2) . '%}';
 		} else {
 			$content['autopurge_timeout'] = generateExtensionInactiveNotInstalledMessage('autopurge');
 		}