More rewrites/templates swapped out:

[mailer.git] / inc / modules / admin / what-list_beg.php

diff --git a/inc/modules/admin/what-list_beg.php b/inc/modules/admin/what-list_beg.php
index ebe814aa938c22f0d6cbe27627f868b3ddd6eacd..7bf2f906c7b85ec460f966c8382d8df716c3b74d 100644 (file)
--- a/inc/modules/admin/what-list_beg.php
+++ b/inc/modules/admin/what-list_beg.php
@@ -56,19 +56,22 @@ if (getConfig('beg_rallye') == 'Y') {
        } // END - if
 
        // Autopurge installed?
-       $lastOnline = "%s"; $ONLINE = '';
+       $lastOnline = '';
        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
 
        // Check if at least one is in the active rallye
-       $result = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, beg_points, last_online
-FROM `{?_MYSQL_PREFIX?}_user_data`
-WHERE `status`='CONFIRMED' AND beg_points > 0".$lastOnline."
-ORDER BY beg_points DESC, last_online DESC, userid",
-       array($ONLINE), __FILE__, __LINE__);
+       $result = SQL_QUERY("SELECT `userid`, `gender`, `surname`, `family`, `email`, `beg_points`, `last_online`
+FROM
+       `{?_MYSQL_PREFIX?}_user_data`
+WHERE
+       `status`='CONFIRMED' AND beg_points > 0".$lastOnline."
+ORDER BY
+       `beg_points` DESC,
+       `last_online` DESC,
+       `userid` ASC", __FILE__, __LINE__);
 
        if (SQL_NUMROWS($result) > 0) {
                // List users
@@ -88,10 +91,8 @@ ORDER BY beg_points DESC, last_online DESC, userid",
                        $content = array(
                                'userid'      => $content['userid'],
                                'email'       => generateEmailLink($content['email'], 'user_data'),
-                               'gender'      => translateGender($content['gender']),
-                               'surname'     => $content['surname'],
-                               'family'      => $content['family'],
-                               'turbo'       => translateComma($content['beg_points']),
+                               'gender'      => $content['gender'],
+                               'turbo'       => $content['beg_points'],
                                'last_online' => generateDateTime($content['last_online'], 2),
                                'sw'          => $SW,
                                'win1'        => $WIN1,
@@ -102,7 +103,7 @@ ORDER BY beg_points DESC, last_online DESC, userid",
                        // Load template and add it
                        $OUT .= loadTemplate('admin_list_beg_rows', true, $content);
                        $SW = 3 - $SW; $cnt++; $total += $content['beg_points'];
-               }
+               } // END - while
 
                $content['rows']  = $OUT;
                $content['total'] = translateComma($total);