X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-active.php;h=5c7c03c0a8763760218d1b092eb559bcf9c1730e;hp=c089956b340f16316147442e69f0f64616cae9b1;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=2f0357c7ac9da6c17d361b8e7cb0b1ad09eb85f6 diff --git a/inc/modules/guest/what-active.php b/inc/modules/guest/what-active.php index c089956b34..5c7c03c0a8 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 = sqlQuery("SELECT + `userid`, + `last_online` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `last_online` >= {?START_TDAY?} AND + `status`='CONFIRMED' + " . runFilterChain('user_exclusion_sql', ' ') . " +ORDER BY + `last_online` DESC +LIMIT {?active_limit?}", __FILE__, __LINE__); // Entries found? -if (SQL_NUMROWS($result) > 0) { +if (!ifSqlHasZeroNumRows($result)) { // At least one member was online so let's load them all - $OUT = ''; $SW = 2; - while (list($uid, $nick, $last) = SQL_FETCHROW($result)) { - $nick2 = '---'; - if (($nick != $uid) && (!empty($nick))) $nick2 = $nick; + $OUT = ''; + while ($content = sqlFetchArray($result)) { + // If ext-nickname is not installed, set 'nickname' to empty + if (!isExtensionActive('nickname')) { + $content['nickname'] = ''; + } // END - if - // Transfer data to array - $content = array( - 'sw' => $SW, - 'uid' => $uid, - 'nick' => $nick2, - 'points' => TRANSLATE_COMMA(GET_TOTAL_DATA($uid, 'user_points', 'points') - GET_TOTAL_DATA($uid, 'user_data', 'used_points')), - 'last' => MAKE_DATETIME($last, '2'), - ); + // Translate comma + $content['last_online'] = generateDateTime($content['last_online'], '2'); // Load template - $OUT .= LOAD_TEMPLATE('guest_active_row', true, $content); - - // Switch colors - $SW = 3 - $SW; - } + $OUT .= loadTemplate('guest_list_active_row', TRUE, $content); + } // END - while } else { // No member was online today! :-( - $OUT = LOAD_TEMPLATE('guest_active_none_row', true); + $OUT = loadTemplate('guest_list_active_row_none', TRUE); } -// Remember output in constant -define('__ACTIVE_ROWS', $OUT); - // Load template -LOAD_TEMPLATE('guest_active_table'); +loadTemplate('guest_list_active', FALSE, $OUT); -// +// [EOF] ?>