phpBB.nl

Code: Selecteer alles

## MOD Title:   Users of the day
## MOD Version: 2.1
## Author:     ZoZo <zozo@etoiles.net> 
## 
## Description:  
## Displays, under the online users list, a list of the registered users
## who have visited during the last XX hours. Can also display the list
## of the users who didn't come. (see "Edit below")

Code: Selecteer alles

## MOD Title:		Extend rank color
## MOD Author:		Gendo < gendo@denturax.com > (Matthieu V.) http://www.denturax.com
## MOD Author:		BigZ  < bigz@denturax.com > (Romain R.) http://www.denturax.com
## MOD Description:
##			This mod gives the possibility to add colour ranks into "Who is online" 
##			page and into "Who is online" part in bottom of the index. You can 
##			create colour ranks via the ACP. You can also put in colour your various 
##			groups of users (phpBB Usergroups) on the index and the sight of 
##			viewonline.

Code: Selecteer alles

#
#
#-----[ START FIND ]-----
#
//
// Users of the day MOD
//
 
# 
#-----[ FIND ]----- 
# 
$sql = "SELECT user_id, username, user_allow_viewonline, user_level, user_session_time

#
#-----[ IN-LINE FIND ]------------------------------------------
#
, user_level

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, user_whosonline_color

# 
#-----[ FIND ]----- 
# 
	if ( $row['user_level'] == ADMIN )
	{
		$row['username'] = '<b>' . $row['username'] . '</b>';
		$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
	}

#
#-----[ REPLACE WITH ]------------------------------------------
#
	if ( $row['user_whosonline_color'] )
	{
		$row['username'] = '<b>' . $row['username'] . '</b>';
		$style_color .= 'style="color:' . $id_color[$row[user_whosonline_color]] . '"';
	}
	else if ( $row['user_level'] == ADMIN )
	{
		$row['username'] = '<b>' . $row['username'] . '</b>';
		$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
	}

# 
#-----[ FIND ]----- 
# 
	else if ( $row['user_level'] == MOD )
	{
		$row['username'] = '<b>' . $row['username'] . '</b>';
		$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
	}

#
#-----[ AFTER, ADD ]------------------------------------------
#
	else if ( $user_group_color[$row['user_id']] )
	{
		$row['username'] = '<b>' . $row['username'] . '</b>';
		$style_color .= 'style="color:' . $user_group_color[$row['user_id']] . '"';
	}

Code: Selecteer alles

Algemene fout 
  
Could not obtain user/day information

DEBUG MODE

SQL Error : 1109 Unknown table 'u' in field list

SELECT user_id, username, user_allow_viewonline, user_level, u.user_whosonline_color , user_session_time FROM phpbb_users WHERE user_id > 0 ORDER BY IF(user_level=1,3,user_level) DESC, username ASC

Line : 278
File : page_header.php