#################################################################
## Mod Title: Counter user access to a box of forum
## Mod Author: BaoChung (VietNam) < wall85vn@yahoo.com >
## Mod Version: 1.0.2
## Mod Time: 22/03/06
## Mod Description: This will help users can see how many user are
## viewing into forums. It like "12 viewing"
##
## Installation Level: Easy
## Installation Time: 15 Minutes
##
## Files To Edit: 3 (it is 4 if Easy Sub-Forums was installed)
## index.php
## viewforum.php (if Easy Sub-Forums was installed)
## includes/session.php
## templates/yourtemplate/index_body.tpl
##
## Included Files: (none)
##
## NOTE: it can have some non-acuracy, tell me if you have
## a problem with it. See website http://vietshare.tk for the demo
##
#################################################################
## WHAT'S NEW IN THIS VERSION (1.0.2)?
## - fix code to show more correcly
## - make it can work with Easy Sub-Forums MOD v1.0.8
#################################################################
## THANKS TO
## Phuong < anhchang_pcit@yahoo.com > for report some error
##
#################################################################
#
#-----[ SQL Query ]----------------------------------------------
# If your phpbb table prefix is different, then change it to
# reflect the correct one.
ALTER TABLE `phpbb_sessions` ADD `session_forum` INT( 15 ) NOT NULL DEFAULT '0';
#################################################################
#
#-----[ OPEN ]---------------------------------------------------
#
index.php
#
#-----[ FIND ]---------------------------------------------------
#
//
// Start page proper
//
$sql = "SELECT c.cat_id, c.cat_title, c.cat_order
#
#-----[ BEFORE, ADD ]--------------------------------------------
#
//
// BEGIN: number of user view forum
//
$sql = "SELECT s.session_forum, count(*) as numviewforum
FROM ".SESSIONS_TABLE." s
WHERE (s.session_time >= ".( time() - 300 ) . ")
GROUP BY s.session_forum";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain reg user/online information', '', __LINE__, __FILE__, $sql);
}
$session_forum_rows = array();
while( $row = $db->sql_fetchrow($result) )
{
$session_forum_rows[] = $row;
}
$db->sql_freeresult($result);
function getIDsessionforum($n)
{
global $session_forum_rows;
for ($i=0; $i<count($session_forum_rows); $i++)
if($session_forum_rows[$i]['session_forum']==$n) return $i;
return -1;
}
//
// END: number of user view forum
//
#
#-----[ FIND ]---------------------------------------------------
#
for($j = 0; $j < $total_forums; $j++)
{
if ( $forum_data[$j]['cat_id'] == $cat_id )
{
#
#-----[ AFTER, ADD ]---------------------------------------------
#
$nviewforum=0;
#
#-----[ FIND ]---------------------------------------------------
# it has just been used if Easy Sub-Forums MOD was installed
$sub_forum_id = $value['forum_id'];
if ($value['attached_forum_id']==$forum_id && $is_auth_ary[$sub_forum_id]['auth_view'])
{
#
#-----[ AFTER, ADD ]---------------------------------------------
# it has just been used if Easy Sub-Forums MOD was installed
$nviewforum+=$session_forum_rows[getIDsessionforum($sub_forum_id)]['numviewforum'];
#
#-----[ FIND ]---------------------------------------------------
#
$template->assign_block_vars('catrow.forumrow', array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'FORUM_FOLDER_IMG' => $folder_image,
'FORUM_NAME' => $forum_data[$j]['forum_name'],
#
#-----[ BEFORE, ADD ]--------------------------------------------
#
$nviewforum+=$session_forum_rows[getIDsessionforum($j+1)]['numviewforum'];
#
#-----[ AFTER, ADD ]---------------------------------------------
#
'FORUM_VIEW' => ($nviewforum)?'('.$nviewforum.' viewing)':'',
#################################################################
#-----[ OPEN ]---------------------------------------------------
# it has just been used if Easy Sub-Forums MOD was installed
viewforum.php
#
#-----[ FIND ]---------------------------------------------------
# it has just been used if Easy Sub-Forums MOD was installed
$attach_forum_link = append_sid('viewforum.php?f=' . $value['forum_id']);
#
#-----[ BEFORE, ADD ]--------------------------------------------
# it has just been used if Easy Sub-Forums MOD was installed
$sql3 = "SELECT count(*) as numviewforum
FROM ".SESSIONS_TABLE." s
WHERE (s.session_forum=".$value['forum_id'].") AND (s.session_time >= ".( time() - 300 ) . ")
GROUP BY s.session_forum LIMIT 1";
if ( !($result3 = $db->sql_query($sql3)) )
{
message_die(GENERAL_ERROR, 'Could not obtain reg user/online information', '', __LINE__, __FILE__, $sql3);
}
$snumusersforum = "";
if ( $row3 = $db->sql_fetchrow($result3) )
{
$snumusersforum = ($row3['numviewforum'])?'('.$row3['numviewforum'].' viewing)':'';
}
$db->sql_freeresult($result3);
#
#-----[ FIND ]---------------------------------------------------
# it has just been used if Easy Sub-Forums MOD was installed
$attach_forum_name = '<a href="' . append_sid('viewforum.php?f=' . $value['forum_id']) . '">' . $value['forum_name'] . '</a>' ;
#
#-----[ REPLACE ]------------------------------------------------
# it has just been used if Easy Sub-Forums MOD was installed
$attach_forum_name = '<a href="' . append_sid('viewforum.php?f=' . $value['forum_id']) . '">' . $value['forum_name'] . '</a> ' . $snumusersforum ;
#################################################################
#-----[ OPEN ]---------------------------------------------------
#
includes/session.php
#
#-----[ FIND ]---------------------------------------------------
#
//
// Adds/updates a new session to the database for the given userid.
// Returns the new session ID on success.
//
#
#-----[ AFTER, ADD ]---------------------------------------------
#
$myforum=(!empty($HTTP_GET_VARS['f']))?$HTTP_GET_VARS['f']:0;
#
#-----[ FIND ]---------------------------------------------------
#
function session_begin($user_id, $user_ip, $page_id, $auto_create = 0, $enable_autologin = 0, $admin = 0)
{
global $db, $board_config;
#
#-----[ AFTER, ADD ]---------------------------------------------
#
global $myforum;
#
#-----[ FIND ]---------------------------------------------------
#
$sql = "INSERT INTO " . SESSIONS_TABLE . "
(session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin)
VALUES ('$session_id', $user_id, $current_time, $current_time, '$user_ip', $page_id, $login, $admin)";
#
#-----[ REPLACE ]------------------------------------------------
#
$sql = "INSERT INTO " . SESSIONS_TABLE . "
(session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin, session_forum)
VALUES ('$session_id', $user_id, $current_time, $current_time, '$user_ip', $page_id, $login, $admin, $myforum)";
#
#-----[ FIND ]---------------------------------------------------
#
function session_pagestart($user_ip, $thispage_id)
{
global $db, $lang, $board_config;
#
#-----[ AFTER, ADD ]---------------------------------------------
#
global $myforum;
#
#-----[ FIND ]---------------------------------------------------
#
//
// Only update session DB a minute or so after last update
//
if ( $current_time - $userdata['session_time'] > 60 )
{
// A little trick to reset session_admin on session re-usage
$update_admin = (!defined('IN_ADMIN') && $current_time - $userdata['session_time'] > ($board_config['session_length']+60)) ? ', session_admin = 0' : '';
$sql = "UPDATE " . SESSIONS_TABLE . "
SET session_time = $current_time, session_page = $thispage_id$update_admin
WHERE session_id = '" . $userdata['session_id'] . "'";
#
#-----[ REPLACE ]------------------------------------------------
#
$sql = "UPDATE " . SESSIONS_TABLE . "
SET session_forum = $myforum
WHERE session_id = '" . $userdata['session_id'] . "'";
if ( !$db->sql_query($sql) )
{
message_die(CRITICAL_ERROR, 'Error updating sessions table', '', __LINE__, __FILE__, $sql);
}
//
// Only update session DB a minute or so after last update
//
if ( $current_time - $userdata['session_time'] > 60 )
{
// A little trick to reset session_admin on session re-usage
$update_admin = (!defined('IN_ADMIN') && $current_time - $userdata['session_time'] > ($board_config['session_length']+60)) ? ', session_admin = 0' : '';
$sql = "UPDATE " . SESSIONS_TABLE . "
SET session_time = $current_time, session_page = $thispage_id$update_admin, session_forum = $myforum
WHERE session_id = '" . $userdata['session_id'] . "'";
#################################################################
#-----[ OPEN ]---------------------------------------------------
#
templates/yourtempate/index_body.tpl
#
#-----[ FIND ]---------------------------------------------------
#
<a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a>
#
#-----[ AFTER, ADD ]---------------------------------------------
#
</span><span class="gensmall"> {catrow.forumrow.FORUM_VIEW}
#
#-----[ SAVE/CLOSE ALL FILES ]-----------------------------------
#
#EoM
Borgo San Michele
