##############################################################
## 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.
##
##			UPDATE FROM RC5 TO RC6.
##
##
## MOD Version:		1.5.0 RC6
## 
## Installation Level:	Easy
## Installation Time:	~5 Minutes
## Files To Edit: (2)
## 			includes/page_header.php
## 			viewonline.php
##
## Included Files: (4)
## 			admin/admin_ranks_whosonline.php
## 			templates/subSilver/admin/whosonline_ranks_edit_body.tpl
## 			templates/subSilver/admin/whosonline_ranks_list_body.tpl
##			language/lang_french/lang_erc.php
## 			
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################
#
#-----[ SQL ]------------------------------------------
# 
ALTER TABLE `phpbb_whosonline_ranks` ADD `whosonline_rank_order` INT NOT NULL ;

#
#-----[ COPY ]------------------------------------------------
#
copy root/language/lang_english/lang_erc.php to language/lang_english/lang_erc.php
copy root/admin/admin_ranks_whosonline.php to admin/admin_ranks_whosonline.php
copy root/templates/subSilver/admin/whosonline_ranks_edit_body.tpl to templates/subSilver/admin/whosonline_ranks_edit_body.tpl
copy root/templates/subSilver/admin/whosonline_ranks_list_body.tpl to templates/subSilver/admin/whosonline_ranks_list_body.tpl

# 
#-----[ OPEN ]----- 
# 
includes/page_header.php 

# 
#-----[ FIND ]----- 
# 
	$ranks_sql= " SELECT * from " . WHOSONLINE_RANKS_TABLE . " ";

# 
#-----[ REPLACE WITH ]----- 
#
	$ranks_sql= " SELECT * from " . WHOSONLINE_RANKS_TABLE . " ORDER BY whosonline_rank_order";

# 
#-----[ FIND ]----- 
# 
	$group_user_sql= "SELECT ug.group_id, ug.user_id, g.group_color from " . USER_GROUP_TABLE . " ug," . GROUPS_TABLE . " g
                         WHERE  ug.group_id=g.group_id
                         and g.group_color <> '0'";

# 
#-----[ REPLACE WITH ]----- 
#
	$group_user_sql= "SELECT ug.group_id, ug.user_id, g.group_color from " . USER_GROUP_TABLE . " ug," . GROUPS_TABLE . " g, " . WHOSONLINE_RANKS_TABLE . " wr
		WHERE  ug.group_id=g.group_id
			AND g.group_color <> '0' 
			AND wr.whosonline_rank_id = g.group_color
		ORDER BY wr.whosonline_rank_order DESC";

# 
#-----[ OPEN ]----- 
# 
viewonline.php

# 
#-----[ FIND ]----- 
# 
	$ranks_sql= " SELECT * from " . WHOSONLINE_RANKS_TABLE . " ";

# 
#-----[ REPLACE WITH ]----- 
#
	$ranks_sql= " SELECT * from " . WHOSONLINE_RANKS_TABLE . " ORDER BY whosonline_rank_order";

# 
#-----[ FIND ]----- 
# 
	$group_user_sql= "SELECT ug.group_id, ug.user_id, g.group_color from " . USER_GROUP_TABLE . " ug," . GROUPS_TABLE . " g
                         WHERE  ug.group_id=g.group_id
                         and g.group_color <> '0'";

# 
#-----[ REPLACE WITH ]----- 
#
	$group_user_sql= "SELECT ug.group_id, ug.user_id, g.group_color from " . USER_GROUP_TABLE . " ug," . GROUPS_TABLE . " g, " . WHOSONLINE_RANKS_TABLE . " wr
		WHERE  ug.group_id=g.group_id
			AND g.group_color <> '0' 
			AND wr.whosonline_rank_id = g.group_color
		ORDER BY wr.whosonline_rank_order DESC";

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM 