More improved SQL queries

[mailer.git] / inc / modules / guest / what-active.php

diff --git a/inc/modules/guest/what-active.php b/inc/modules/guest/what-active.php
index 990a16b09387c80303f4b7cc3d188a16364c2d11..6221433fef60c5551a0ec103d062c338a67f92ac 100644 (file)
--- a/inc/modules/guest/what-active.php
+++ b/inc/modules/guest/what-active.php
@@ -51,8 +51,8 @@ if (EXT_IS_ACTIVE("nickname")) $ADD = "nickname";
 
 // Check for members who were active only this day
 $result = SQL_QUERY_ESC("SELECT userid, ".$ADD.", last_online
-FROM `{!MYSQL_PREFIX!}_user_data`
-WHERE last_online >= %s AND status='CONFIRMED'
+FROM `{!_MYSQL_PREFIX!}_user_data`
+WHERE last_online >= %s AND `status`='CONFIRMED'
 ORDER BY last_online DESC LIMIT %s",
        array(START_TDAY, getConfig('active_limit')), __FILE__, __LINE__);
 
@@ -60,7 +60,7 @@ ORDER BY last_online DESC LIMIT %s",
 if (SQL_NUMROWS($result) > 0) {
        // At least one member was online so let's load them all
        $OUT = ""; $SW = 2;
-       while(list($uid, $nick, $last) = SQL_FETCHROW($result)) {
+       while (list($uid, $nick, $last) = SQL_FETCHROW($result)) {
                $nick2 = "---";
                if (($nick != $uid) && (!empty($nick))) $nick2 = $nick;