phpBB.de

Code: Alles auswählen

######################################################## 
## Mod Title:   Show Online In View Topic 
## Mod Version: 2.0.0
## Author:      AJ Quick, (http://www.ajquick.com/)
##
## Description:  
## This mod will show the status of a user in viewtopic
## next to their post. Stating if they are online or not.
##
## This mod is for phpBB2 ver 2.0.X
## 
## Portions of this script were inspired/written by
## other people. I can only claim partial credit.
##
## Installation Level:  Easy 
## Installation Time:   1-2 Minutes 
## Files To Edit:      2 
##	viewtopic.php
##	/templates/SubSilver/Viewtopic_body.tpl
##
##########################################################
## 
## Installation Notes: 
##
## There is some customization that will need to be 
## done in Viewtopic_body.tpl It is really up to you
## where you want it to be placed.
##
######################################################## 

# 
#-----[ OPEN ]------------------------------------------ 
# 

Viewtopic.php

# 
#-----[ FIND ]------------------------------------------ 
# 

u.user_allowavatar, u.user_allowsmile, 

# 
#-----[ ADD AFTER ]------------------------------------------ 
# 

u.user_allow_viewonline, u.user_session_time, 

# 
#-----[ FIND ]------------------------------------------ 
# 

	//
	// Again this will be handled by the templating
	// code at some point
	//
	$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
	$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 

//User Online Hack
//By AJ Quick (http://www.ajquick.com/)
if($postrow[$i]['user_session_time'] >= (time()-60)){
if($postrow[$i]['user_allow_viewonline']){
$status = '<b><a href="viewonline.php">Online!</a></b>';
}else{
$status = "Offline";
}
}else{
$status = "Offline";
}

# 
#-----[ FIND ]------------------------------------------ 
# 

		'POSTER_JOINED' => $poster_joined,
		'POSTER_POSTS' => $poster_posts,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 

		'POSTER_STATUS' => $status,

# 
#-----[ OPEN ]------------------------------------------ 
#

templates/SubSilver/Viewtopic_body.tpl

# 
#-----[ FIND: Something Similar ]------------------------------------------ 
#

		<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br /><br /><div align="center">{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}</div><br /><br /> {postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}</span></td>

# 
#-----[ Somewhere... ADD ]------------------------------------------ 
# 

Status: {postrow.POSTER_STATUS}

# That's It!
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM 

Code: Alles auswählen

	$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";

Code: Alles auswählen

	$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() - 60 ) . "
			$user_forum_sql
		ORDER BY u.username ASC, s.session_ip ASC";

Code: Alles auswählen

$sql = "SELECT u.user_id, u.username, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_time, s.session_page, s.session_ip
	FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
	WHERE u.user_id = s.session_user_id
		AND s.session_time >= ".( time() - 300 ) . "
	ORDER BY u.username ASC, s.session_ip ASC";

Code: Alles auswählen

	$sql = "SELECT u.user_id, u.username, u.user_session_time, u.user_session_page, s.session_logged_in, s.session_ip, s.session_start 
		FROM " . USERS_TABLE . " u, " . SESSIONS_TABLE . " s
		WHERE s.session_logged_in = " . TRUE . " 
			AND u.user_id = s.session_user_id 
			AND u.user_id <> " . ANONYMOUS . " 
			AND u.user_session_time >= " . ( time() - 300 ) . " 
		ORDER BY u.user_session_time DESC";

Code: Alles auswählen

	$sql = "SELECT session_page, session_logged_in, session_time, session_ip, session_start   
		FROM " . SESSIONS_TABLE . "
		WHERE session_logged_in = 0
			AND session_time >= " . ( time() - 300 ) . "
		ORDER BY session_time DESC";