X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-active.php;h=559ecb44d2d6361ffc2e00d2bdf8b26e5e291422;hb=78d3ca2c21277839c7902c84767bd769c4dfca31;hp=bf342cfea86888313db1b12d43ff4e6af3582ac8;hpb=8f14df8c3232a31917df0ac57363dbd6e975c147;p=mailer.git diff --git a/inc/modules/guest/what-active.php b/inc/modules/guest/what-active.php index bf342cfea8..559ecb44d2 100644 --- a/inc/modules/guest/what-active.php +++ b/inc/modules/guest/what-active.php @@ -62,34 +62,31 @@ $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 = ''; $SW = 2; + $OUT = ''; while (list($userid, $nick, $last) = SQL_FETCHROW($result)) { $nick2 = '---'; if (($nick != $userid) && (!empty($nick))) $nick2 = $nick; // Transfer data to array $content = array( - 'sw' => $SW, 'userid' => $userid, 'nickname' => $nick2, - 'points' => (countSumTotalData($userid, 'user_points', 'points') - countSumTotalData($userid, 'user_data', 'used_points')), + 'points' => getTotalPoints($userid), 'last_online' => generateDateTime($last, 2), ); // Load template $OUT .= loadTemplate('guest_active_row', true, $content); - - // Switch colors - $SW = 3 - $SW; - } + } // END - while } else { // No member was online today! :-( $OUT = loadTemplate('guest_active_none_row', true);