<?php
define('IN_PHPBB', true);
$phpbb_root_path = 'forum/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
define('SHOW_ONLINE', true);
if (defined('SHOW_ONLINE'))
{
$user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = " . intval($forum_id) : '';
$sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip
FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
WHERE u.user_id = s.session_user_id
AND s.session_time >= ".( time() - 300 ) . "
$user_forum_sql
ORDER BY u.username ASC, s.session_ip ASC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user/online information', '', __LINE__, __FILE__, $sql);
}
// $userlist_ary = array();
$userlist_visible = array();
while( $row = $db->sql_fetchrow($result) )
{
if ( $row['session_logged_in'] )
{
if ( $row['user_id'] != $prev_user_id )
{
if ( $row['user_allow_viewonline'] )
{
$logged_visible_online++;
}
else
{
$logged_hidden_online++;
}
}
}
else
{
if ( $row['session_ip'] != $prev_session_ip )
{
$guests_online++;
}
}
$prev_session_ip = $row['session_ip'];
}
$db->sql_freeresult($result);
if ( empty($online_userlist) )
{
$online_userlist = $lang['None'];
}
$total_online_users = $logged_visible_online + $logged_hidden_online + $guests_online;
/* if ( $total_online_users > $board_config['record_online_users'])
{
$sql = "UPDATE " . CONFIG_TABLE . "
SET config_value = '$total_online_users'
WHERE config_name = 'record_online_users'";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update online user record (nr of users)', '', __LINE__, __FILE__, $sql);
}
}*/
if ( $total_online_users == 0 )
{
$l_t_user_s = $lang['Online_users_zero_total_'];
}
else if ( $total_online_users == 1 )
{
$l_t_user_s = $lang['Online_user_total_'];
}
else
{
$l_t_user_s = $lang['Online_users_total_'];
}
/* if ( $logged_visible_online == 0 )
{
$l_r_user_s = $lang['Reg_users_zero_total_'];
}
else if ( $logged_visible_online == 1 )
{
$l_r_user_s = $lang['Reg_user_total_'];
}
else
{
$l_r_user_s = $lang['Reg_users_total_'];
}
if ( $logged_hidden_online == 0 )
{
$l_h_user_s = $lang['Hidden_users_zero_total_'];
}
else if ( $logged_hidden_online == 1 )
{
$l_h_user_s = $lang['Hidden_user_total_'];
}
else
{
$l_h_user_s = $lang['Hidden_users_total_'];
}
if ( $guests_online == 0 )
{
$l_g_user_s = $lang['Guest_users_zero_total_'];
}
else if ( $guests_online == 1 )
{
$l_g_user_s = $lang['Guest_user_total_'];
}
else
{
$l_g_user_s = $lang['Guest_users_total_'];
}*/
$l_online_users = sprintf($l_t_user_s, $total_online_users);
/* $l_online_users .= sprintf($l_r_user_s, $logged_visible_online);
$l_online_users .= sprintf($l_h_user_s, $logged_hidden_online);
$l_online_users .= sprintf($l_g_user_s, $guests_online);*/
}
$template->assign_vars(array(
'TOTAL_USERS_ONLINE' => $l_online_users)
);
$template->set_filenames(array(
'body' => 'viewonline.tpl')
);
$template->pparse('body');
?>
<?
$users_count = mysql_query("SELECT COUNT(user_id) FROM ".$table_prefix."users");
$users_count_result = mysql_fetch_array($users_count);
$count = $users_count_result['COUNT(user_id)']-1;
$last_user = mysql_query("SELECT username,user_id FROM ".$table_prefix."users WHERE user_id =(SELECT MAX(user_id) FROM ".$table_prefix."users) ");
$last_user_result = mysql_fetch_array($last_user);
echo "<br>
We have ".$count." registered user<br>
The newest registered user is <a href='$phpbb_root_path/profile.php?mode=viewprofile&u=".$last_user_result['user_id'].">".$last_user_result['username']."</a><br>";
?>
