]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/guest/what-active.php
SQL fix and renamed language string fixed
[mailer.git] / inc / modules / guest / what-active.php
index 7e017196db325b43b2f6db6be0ef7b31cb47c340..559ecb44d2d6361ffc2e00d2bdf8b26e5e291422 100644 (file)
@@ -62,7 +62,8 @@ $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__);
@@ -79,7 +80,7 @@ if (!SQL_HASZERONUMS($result)) {
                $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),
                );