SQL fix and renamed language string fixed

[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 17e4d337976e17f695a58345c38f4ea852cf9d7c..559ecb44d2d6361ffc2e00d2bdf8b26e5e291422 100644 (file)
--- a/inc/modules/guest/what-active.php
+++ b/inc/modules/guest/what-active.php
@@ -62,13 +62,14 @@ $result = SQL_QUERY("SELECT
 FROM
        `{?_MYSQL_PREFIX?}_user_data`
 WHERE
-       `last_online` >= {?START_TDAY?} AND `status`='CONFIRMED'
+       `last_online` >= {?START_TDAY?} AND
+       `status`='CONFIRMED'
 ORDER BY
        `last_online` DESC
 LIMIT {?active_limit?}", __FILE__, __LINE__);
 
 // Entries found?
-if (SQL_NUMROWS($result) > 0) {
+if (!SQL_HASZERONUMS($result)) {
        // At least one member was online so let's load them all
        $OUT = '';
        while (list($userid, $nick, $last) = SQL_FETCHROW($result)) {
@@ -79,7 +80,7 @@ if (SQL_NUMROWS($result) > 0) {
                $content = array(
                        'userid'      => $userid,
                        'nickname'    => $nick2,
-                       'points'      => (countSumTotalData($userid, 'user_points', 'points') - countSumTotalData($userid, 'user_data', 'used_points')),
+                       'points'      => getTotalPoints($userid),
                        'last_online' => generateDateTime($last, 2),
                );