##############################################################
## MOD Title: Olympus Group Colours
## MOD Author: smithy_dll < n/a > (David Smith)
http://phpbbstuff.ddblog.org" onclick="window.open(this.href);return false;
## MOD Description: This MOD for phpBB2.0 implements user group colours simillar to phpBB olympus (3.0).
## MOD Version: 1.0.4c
## MOD Traduction: Zuker -
http://www.eddb.com.ar" onclick="window.open(this.href);return false;
##
## Installation Level: Moderate
## Installation Time: 47 minutes
## Files To Edit: groupcp.php
## index.php
## viewtopic.php
## admin/admin_groups.php
## admin/admin_users.php
## includes/page_header.php
## includes/usercp_viewprofile.php
## language/lang_english/lang_admin.php
## language/lang_english/lang_main.php
## templates/subSilver/index_body.tpl
## templates/subSilver/admin/group_edit_body.tpl
## templates/subSilver/admin/user_edit_body.tpl
## Included Files:
## Generator: MOD Studio 3.0 Beta 2 [mod functions 0.4.1818.26949]
##############################################################
## For Security Purposes, Please Check:
http://www.phpbb.com/mods/" onclick="window.open(this.href);return false; for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at:
http://www.phpbb.com/mods/" onclick="window.open(this.href);return false;
##############################################################
## Author Notes:
##
## First assign a group a colour in the group administration panel, then edit the default
## group a user belongs to in the administration panel for the user's name to appear
## coloured on the index, viewtopic, viewprofile and groupcp.
##
## A user can belong two multiple coloured groups, but can only belong to one default
## group of which they inherit the groups colour.
##
## You can also set wether or not a group shows up in the Legend on the forum index.
##
## Hidden groups will be shown if you tell them to, however it is up to the admin wether
## they give a hidden group a colour and tell it to display in the legend.
##
##############################################################
## MOD History:
##
## 2005-03-06 - Version 1.0.4
##
## - Fixed groupcp display bug, and legend display bug
##
## 2005-02-27 - Version 1.0.3
##
## - Removed some Olympus specific code and cleaned up an SQL edit
##
## 2005-02-26 - Version 1.0.2
##
## - Added missing ALTER TABLE column group_id on phpbb_users
##
## 2005-02-26 - Version 1.0.1
##
## - Fixed a few bugs in the MOD Template file
##
## 2005-02-26 - Version 1.0.0
##
## - The first release of the Olympus style group colour MOD for phpBB2.0.
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_groups ADD group_colour VARCHAR(6) NOT NULL;
ALTER TABLE phpbb_groups ADD group_legend TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_colour VARCHAR(6) NOT NULL;
ALTER TABLE phpbb_users ADD group_id MEDIUMINT(8) NOT NULL;
#
#-----[ OPEN ]------------------------------------------
#
groupcp.php
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm
#
#-----[ IN-LINE FIND ]------------------------------------------
#
user_msnm
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, user_colour
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending
#
#-----[ IN-LINE FIND ]------------------------------------------
#
user_msnm
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, u.user_colour
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm
#
#-----[ IN-LINE FIND ]------------------------------------------
#
user_msnm
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, u.user_colour
#
#-----[ FIND ]------------------------------------------
#
$s_hidden_fields .= '';
#
#-----[ AFTER, ADD ]------------------------------------------
#
$group_name = $group_info['group_name'];
if ($group_info['group_colour'])
{
$group_name = '<span style="color: #' . $group_info['group_colour'] . '">' . $group_name . '</span>';
}
if ($group_moderator['user_colour'])
{
$username = '<b style="color: #' . $group_moderator['user_colour'] . ';">' . $username . '</b>';
}
# Y SIGUEE.