X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-beg2.php;h=a0ff700d637b9f85fc45ea9e9e22965739a755c2;hb=34db702d004b245e5528b0ba20c6de441f61820a;hp=54e20b229e46be6b0f5bf71f0b1f9e3e48f2f6bf;hpb=e5fe5afb17a5c8106f4c890234dfa39419e70f5d;p=mailer.git

diff --git a/inc/modules/member/what-beg2.php b/inc/modules/member/what-beg2.php
index 54e20b229e..a0ff700d63 100644
--- a/inc/modules/member/what-beg2.php
+++ b/inc/modules/member/what-beg2.php
@@ -18,6 +18,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -52,50 +53,52 @@ if ((!isExtensionActive('beg')) && (!isAdmin())) {
 } // END - if
 
 // Autopurge installed?
-$lastOnline = "%s";
+$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
-	`userid`, `beg_points` AS beg, `last_online`
+	`userid`, `beg_points` AS points, `last_online`
 FROM
 	`{?_MYSQL_PREFIX?}_user_data`
 WHERE
-	`beg_points` > 0 AND `status`='CONFIRMED'".$lastOnline."
+	`beg_points` > 0 AND
+	`status`='CONFIRMED'
+	" . $lastOnline . "
 ORDER BY
-	`beg_points` DESC, `last_online` DESC, `userid` ASC LIMIT %s",
+	`beg_points` DESC,
+	`last_online` DESC,
+	`userid` ASC
+LIMIT {?beg_ranks?}",
 	array(
-		$ONLINE,
-		getConfig('beg_ranks')
+		$ONLINE
 	), __FILE__, __LINE__);
 
 // Reset temporary variable and check for users
 $OUT = '';
-if (SQL_NUMROWS($result) > 0) {
+if (!SQL_HASZERONUMS($result)) {
 	// Load our winners...
-	$SW = 2; $cnt = 1;
+	$cnt = 1;
 	while ($content = SQL_FETCHARRAY($result)) {
 		// Prepare data for the template
 		$content = array(
-			'sw'     => $SW,
-			'cnt'    => $cnt,
-			'userid'    => bigintval($content['userid']),
-			'points' => translateComma($content['beg']),
-			'last_online'   => generateDateTime($content['last_online'], 2),
+			'cnt'         => $cnt,
+			'userid'      => $content['userid'],
+			'points'      => $content['points'],
+			'last_online' => generateDateTime($content['last_online'], 2),
 		);
 
 		// Load row template
 		$OUT .= loadTemplate('member_list_beg_row', true, $content);
 
-		// Count one up and switch colors
-		$cnt++; $SW = 3 - $SW;
-	}
+		// Count one up
+		$cnt++;
+	} // END - while
 } else {
 	// No one is interested in our "active rallye" ! :-(
 	$OUT = loadTemplate('member_beg_404', true);
@@ -110,5 +113,5 @@ SQL_FREERESULT($result);
 // Load final template
 loadTemplate('member_list_beg', false, $content);
 
-//
+// [EOF]
 ?>