##############################################################
## MOD Title: Last visit on admin
## MOD Author: BigZ <
bigzounet@hotmail.com > (Romain Richard)
http://www.denturax.com/phpBB2
## MOD Description: Ce mod permet de voir qui a visité le forum aujourd'hui depuis le paneau d'admin
##
## MOD Version: 1.0
## Compatibility: 2.0.6
##
## Installation Level: Easy
## Installation Time: 5 minute
##
## Files To Edit: 3
## admin/index.php
## language/lang_admin.php
## templates/subSilver/admin/index_body.tpl
##
## Included Files: 0
##
##############################################################
## Pour des raisons de sécurité, veuillez ne télécharger ce mod
## que sur le site
http://forum.phpbb.biz ou sur mon site personnel
## Vous etes aussi prié de me ( BigZ <
bigzounet@hotmail.com > )
## demander mon accord avant de réadapter ou redistribuer
## ce mod.
##############################################################
#
#-----[ OPEN ]------------------------------------------------
#
admin/index.php
#
#-----[ SEARCH ]------------------------------------------------
#
"L_STARTED" => $lang['Login'],
#
#-----[ AFTER, ADD ]------------------------------------------------
#
"L_WHOSONLINE_ADMIN" => sprintf($lang['Admin_online_color'], '<span style="color:#' . $theme['fontcolor3'] . '">', '</span>'),
"L_WHOSONLINE_MOD" => sprintf($lang['Mod_online_color'], '<span style="color:#' . $theme['fontcolor2'] . '">', '</span>'),
"L_USER_TODAY" => $lang['user_today'],
#
#-----[ SEARCH ]------------------------------------------------
#
$template->assign_vars(array(
"NUMBER_OF_POSTS" => $total_posts,
#
#-----[ BEFORE, ADD ]------------------------------------------------
#
// Start add - Last visit admin ADD ON
$time_now=time();
$time1Hour=$time_now-3600;
$minutes = date('is', $time_now);
$hour_now = $time_now - (60*($minutes[0].$minutes[1])) - ($minutes[2].$minutes[3]);
$dato=create_date('H', $time_now,$board_config['board_timezone']);
$timetoday = $hour_now - (3600*$dato);
$sql = 'SELECT session_ip, MAX(session_time) as session_time FROM '.SESSIONS_TABLE.' WHERE session_user_id="'.ANONYMOUS.'" AND session_time >= '.$timetoday.' AND session_time< '.($timetoday+86399).' GROUP BY session_ip';
if (!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, "Couldn't retrieve guest user today data", "", __LINE__, __FILE__, $sql);
while( $guest_list = $db->sql_fetchrow($result))
{
if ($guest_list['session_time'] >$time1Hour) $users_lasthour++;
}
$guests_today = $db->sql_numrows($result);
$sql = 'SELECT user_id,username,user_allow_viewonline,user_level,user_lastlogon FROM ' . USERS_TABLE . ' WHERE user_id!="'.ANONYMOUS.'" AND user_session_time >= '.$timetoday.' AND user_session_time< '.($timetoday+86399).' ORDER BY username';
if (!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, "Couldn't retrieve user today data", "", __LINE__, __FILE__, $sql);
while( $todayrow = $db->sql_fetchrow($result))
{
$style_color = "";
if ($todayrow['user_lastlogon']>=$time1Hour)
{
$users_lasthour++;
}
switch ($todayrow['user_level'])
{
case ADMIN :
$todayrow['username'] = '<b>' . $todayrow['username'] . '</b>';
$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
break;
case MOD :
$todayrow['username'] = '<b>' . $todayrow['username'] . '</b>';
$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
break;
}
$users_today_list.=( $todayrow['user_allow_viewonline'])?' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $todayrow['user_id']) . '"' . $style_color .'>' . $todayrow['username'] . '</a>,' : (($userdata[user_level]==ADMIN) ? ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $todayrow['user_id']) . '"' . $style_color .'><i>' . $todayrow['username'] . '</i></a>,' : '');
if (!$todayrow['user_allow_viewonline']) $logged_hidden_today++;
else $logged_visible_today++;
}
if ($users_today_list)
{
$users_today_list[ strlen( $users_today_list)-1] = ' ';
} else
{
$users_today_list = $lang['None'];
}
$total_users_today = $db->sql_numrows($result)+$guests_today;
$users_today_list = $lang['Registered_users'].' ' . $users_today_list;
$l_today_user_s = ($total_users_today) ? ( ( $total_users_today == 1 )? $lang['User_today_total'] : $lang['Users_today_total'] ) : $lang['Users_today_zero_total'];
$l_today_r_user_s = ($logged_visible_today) ? ( ( $logged_visible_today == 1 ) ? $lang['Reg_user_total'] : $lang['Reg_users_total'] ) : $lang['Reg_users_zero_total'];
$l_today_h_user_s = ($logged_hidden_today) ? (($logged_hidden_today == 1) ? $lang['Hidden_user_total'] : $lang['Hidden_users_total'] ) : $lang['Hidden_users_zero_total'];
$l_today_g_user_s = ($guests_today) ? (($guests_today == 1) ? $lang['Guest_user_total'] : $lang['Guest_users_total']) : $lang['Guest_users_zero_total'];
$l_today_users = sprintf($l_today_user_s, $total_users_today);
$l_today_users .= sprintf($l_today_r_user_s, $logged_visible_today);
$l_today_users .= sprintf($l_today_h_user_s, $logged_hidden_today);
$l_today_users .= sprintf($l_today_g_user_s, $guests_today);
// End add - Last visit admin ADD ON
#
#-----[ SEARCH ]------------------------------------------------
#
"GZIP_COMPRESSION" => ( $board_config['gzip_compress'] ) ? $lang['ON'] : $lang['OFF'])
#
#-----[ REPLACE BY ]------------------------------------------------
#
"GZIP_COMPRESSION" => ( $board_config['gzip_compress'] ) ? $lang['ON'] : $lang['OFF'],
// Start add - Last visit admin ADD ON
'USERS_TODAY_LIST' => $users_today_list,
'L_USERS_LASTHOUR' =>($users_lasthour)?sprintf($lang['Users_lasthour_explain'],$users_lasthour):$lang['Users_lasthour_none_explain'],
'L_USERS_TODAY' =>$l_today_users)
// End add - Last visit admin ADD ON
#
#-----[ OPEN ]------------------------------------------------
#
language/lang_french/lang_admin.php
#
#-----[ SEARCH ]------------------------------------------------
#
//
// That's all Folks!
#
#-----[ BEFORE, ADD ]------------------------------------------------
#
$lang['user_today'] = 'Utilisteurs ayant visité le forum aujourd\'hui';
#
#-----[ OPEN ]------------------------------------------------
#
templates/subSilver/admin/index_body.tpl
#
#-----[ SEARCH ]------------------------------------------------
#
<tr>
<td class="row1" nowrap="nowrap" align="right">{L_DB_SIZE}:</td>
<td class="row2">{DB_SIZE}</td>
<td class="row1" align="right">{L_GZIP_COMPRESSION}:</td>
<td class="row2">{GZIP_COMPRESSION}</td>
</tr>
#
#-----[ AFTER, ADD ]------------------------------------------------
#
<tr>
<td class="row1" nowrap="nowrap" align="right">{L_USER_TODAY}</td>
<td class="row1" align="left" colspan="3"><span class="gensmall">{L_USERS_TODAY} {L_USERS_LASTHOUR}<br />
[ <strong>{L_WHOSONLINE_ADMIN}</strong> ] [ <strong>{L_WHOSONLINE_MOD}</strong> ]<br />
{USERS_TODAY_LIST}</br>
{TOTAL_USERS_ONLINE} <br />
{RECORD_USERS}<br />
{LOGGED_IN_USER_LIST}</span></td>
</tr>
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
http://www.phpbb.nl/kb.php?mode=article&k=24
