X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-active.php;h=559ecb44d2d6361ffc2e00d2bdf8b26e5e291422;hb=27faaef0ff9ca5c5e240a1d0144485d59592548c;hp=cdeed4e5831c83ed5534143e7582b9a829762858;hpb=e2148142f8b1a8f40fd6e7ca32185569c5a9083e;p=mailer.git diff --git a/inc/modules/guest/what-active.php b/inc/modules/guest/what-active.php index cdeed4e583..559ecb44d2 100644 --- a/inc/modules/guest/what-active.php +++ b/inc/modules/guest/what-active.php @@ -18,6 +18,7 @@ * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * + * Copyright (c) 2009, 2010 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -61,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' => translateComma(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);