X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-active.php;h=bf342cfea86888313db1b12d43ff4e6af3582ac8;hb=8f14df8c3232a31917df0ac57363dbd6e975c147;hp=9fedf82f0e88305d0df42f35019fb7cac52852eb;hpb=ccc4a69ce9b17aa8d7b1554a3b2b017db091821b;p=mailer.git diff --git a/inc/modules/guest/what-active.php b/inc/modules/guest/what-active.php index 9fedf82f0e..bf342cfea8 100644 --- a/inc/modules/guest/what-active.php +++ b/inc/modules/guest/what-active.php @@ -1,7 +1,7 @@ = %s AND `status`='CONFIRMED' -ORDER BY last_online DESC LIMIT %s", -array(START_TDAY, getConfig('active_limit')), __FILE__, __LINE__); +$result = SQL_QUERY("SELECT + `userid`, `".$add."`, `last_online` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `last_online` >= {?START_TDAY?} AND `status`='CONFIRMED' +ORDER BY + `last_online` DESC +LIMIT {?active_limit?}", __FILE__, __LINE__); // Entries found? 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($userid, $nick, $last) = SQL_FETCHROW($result)) { $nick2 = '---'; - if (($nick != $uid) && (!empty($nick))) $nick2 = $nick; + if (($nick != $userid) && (!empty($nick))) $nick2 = $nick; // Transfer data to array $content = array( - 'sw' => $SW, - 'uid' => $uid, - 'nick' => $nick2, - 'points' => translateComma(GET_TOTAL_DATA($uid, 'user_points', 'points') - GET_TOTAL_DATA($uid, 'user_data', 'used_points')), - 'last' => generateDateTime($last, '2'), + 'sw' => $SW, + 'userid' => $userid, + 'nickname' => $nick2, + 'points' => (countSumTotalData($userid, 'user_points', 'points') - countSumTotalData($userid, 'user_data', 'used_points')), + 'last_online' => generateDateTime($last, 2), ); // Load template - $OUT .= LOAD_TEMPLATE('guest_active_row', true, $content); + $OUT .= loadTemplate('guest_active_row', true, $content); // Switch colors $SW = 3 - $SW; } } else { // No member was online today! :-( - $OUT = LOAD_TEMPLATE('guest_active_none_row', true); + $OUT = loadTemplate('guest_active_none_row', true); } -// Remember output in constant -define('__ACTIVE_ROWS', $OUT); - // Load template -LOAD_TEMPLATE('guest_active_table'); +loadTemplate('guest_active_table', false, $OUT); -// +// [EOF] ?>