This is all of the posts from the archives that have to do with the color mods. I made sure that each one had pertinent information.
By the way how do I get the Advanced Color Mod to work with Integramod. It appears that too much of the code has been changed to be able to implement it. For example: usercp_profile.php.
I really need help getting some sort of color into the users, not just the default amount.
############################################################## ## ## MOD Title]----------------------------------------------------------- CREATE TABLE `phpbb_advanced_username_color` ( `group_id` int(10) unsigned NOT NULL auto_increment, `group_name` varchar(255) NOT NULL default '', `group_color` varchar(6) NOT NULL default '', `group_weight` smallint(2) NOT NULL default '', `group_color_specs` text, PRIMARY KEY (`group_id`)) TYPE=MyISAM ; INSERT INTO phpbb_advanced_username_color VALUES ('1', 'Spider Bots', '1', '1', 'd-<::>g-<::>c-d47100<::>b-1<::>s-<INSERT> ----------------------------------- ----[ BEFORE, ADD ]--------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== function CheckUsernameColor($options, $text, $admin = '') { global $board_config, $phpbb_root_path, $phpEx, $db; global $coloring, $donaters, $auc_new_users; $options = str_replace('[', '', $options); $options = str_replace(']', '', $options); if ( ($board_config['auc_use_donate']) && (!$options) ) { for ($x = 0; $x < count($donaters); $x++) { if (!$donaters[$x]['u_user_id']) break; if ($donaters[$x]['u_username'] == $text) { $options = 3; break; } } } if ( ($board_config['auc_use_new_members']) && (!$options) ) { for ($x = 0; $x < count($auc_new_users); $x++) { if (!$auc_new_users[$x]['username']) break; if ($auc_new_users[$x]['username'] == $text) { $options = 2; break; } } } for ($x = 0; $x </b>sql_query($sql); $smilies = $db->sql_fetchrow($result); $image = '<img>'; $text = $image .' '. $text .' '. $image; } return $text; } function CheckBotColor($onlinelist) { global $lang, $phpbb_root_path, $phpEx, $auc_spiders, $board_config; include_once($phpbb_root_path .'includes/functions_auc_bots.'. $phpEx); include_once($phpbb_root_path .'language/lang_'. $board_config['default_lang'] .'/lang_auc.'. $phpEx); for ($x = 0; $x < count($auc_spiders); $x++) { $ip1 = decode_ip($auc_spiders[$x]['session_ip']); $ip2 = explode('.', $ip1); $ip = $ip2[0] .'.'. $ip2[1] .'.'. $ip2[2]; if (in_array($ip, $google)) $onlinelist .= (!$onlinelist) ? CheckUsernameColor(1, $lang['auc_google_bot']) : ', '. CheckUsernameColor(1, $lang['auc_google_bot']); if (in_array($ip, $yahoo)) $onlinelist .= (!$onlinelist) ? CheckUsernameColor(1, $lang['auc_yahoo_bot']) : ', '. CheckUsernameColor(1, $lang['auc_yahoo_bot']); if (in_array($ip, $msn)) $onlinelist .= (!$onlinelist) ? CheckUsernameColor(1, $lang['auc_msn_bot']) : ', '. CheckUsernameColor(1, $lang['auc_msn_bot']); if (in_array($ip, $altavista)) $onlinelist .= (!$onlinelist) ? CheckUsernameColor(1, $lang['auc_alta_bot']) : ', '. CheckUsernameColor(1, $lang['auc_alta_bot']); if (in_array($ip, $lycos)) $onlinelist .= (!$onlinelist) ? CheckUsernameColor(1, $lang['auc_lycos_bot']) : ', '. CheckUsernameColor(1, $lang['auc_lycos_bot']); if (in_array($ip, $wise)) $onlinelist .= (!$online_list) ? CheckUsernameColor(1, $lang['auc_wisenut_bot']) : ', '. CheckUsernameColor(1, $lang['auc_wisenut_bot']); if (in_array($ip, $ask)) $onlinelist .= (!$onlinelist) ? CheckUsernameColor(1, $lang['auc_jeeves_bot']) : ', '. CheckUsernameColor(1, $lang['auc_jeeves_bot']); } return $onlinelist; }#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/includes/page_header.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- if ( $row['user_level'] == ADMIN ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'style="color:#' . $theme['fontcolor3'] . '"'; } else if ( $row['user_level'] == MOD ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'style="color:#' . $theme['fontcolor2'] . '"'; } ----------------------------------- ----[ ADD, AFTER ]---------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $row['username'] = CheckUsernameColor($row['user_color_gc'], $row['username']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- if ( empty($online_userlist) ) ----------------------------------- ----[ ADD, BEFORE ]--------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $online_userlist = CheckBotColor($online_userlist);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- //// The following assigns all _common_ variables that may be used at any point// in a template.//$template->assign_vars(array( ----------------------------------- ----[ ADD, BEFORE ]--------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== for ($a = 0; $a <count>assign_block_vars('colors', array( 'GROUPS' => ' [ <a>'. CheckUsernameColor($coloring[$a]['group_id'], $coloring[$a]['group_name']) .'</a> ] ') ); } if ( ($coloring[$a]['group_id'] == 2) && ($board_config['auc_use_new_members']) ) { $template->assign_block_vars('colors', array( 'GROUPS' => ' [ <a>'. CheckUsernameColor($coloring[$a]['group_id'], $coloring[$a]['group_name']) .'</a> ] ') ); } if ( ($coloring[$a]['group_id'] == 3) && ($board_config['auc_use_donate']) ) { $template->assign_block_vars('colors', array( 'GROUPS' => ' [ <a>'. CheckUsernameColor($coloring[$a]['group_id'], $coloring[$a]['group_name']) .'</a> ] ') ); } if ($coloring[$a]['group_id'] > 3) { $template->assign_block_vars('colors', array( 'GROUPS' => ' [ <a>'. CheckUsernameColor($coloring[$a]['group_id'], $coloring[$a]['group_name']) .'</a> ] ') ); } }#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/includes/usercp_viewprofile.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- 'USERNAME' => $profiledata['username'], ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== 'USERNAME' => CheckUsernameColor($profiledata['user_color_gc'], $profiledata['username']),#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- 'L_VIEWING_PROFILE' => sprintf($lang['Viewing_user_profile'], $profiledata['username']), ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== 'L_VIEWING_PROFILE' => sprintf($lang['Viewing_user_profile'], CheckUsernameColor($profiledata['user_color_gc'], $profiledata['username'])), #====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- includes/usercp_register.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $sql = "UPDATE " . USERS_TABLE . " ----------------------------------- ----[ ADD, BEFORE ]--------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#====$color_group = intval($HTTP_POST_VARS['color_group']);$username_sql = ($color_group) ? "user_color_gc = '[". $color_group ."]', ". $username_sql : $username_sql;#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $form_enctype = ( @$ini_val('file_uploads') == '0' || strtolower(@$ini_val('file_uploads') == 'off') || phpversion() == '4.0.4pl1' || !$board_config['allow_avatar_upload'] || ( phpversion() < '4.0.3' && @$ini_val('open_basedir') != '' ) ) ? '' : 'enctype="multipart/form-data"'; ----------------------------------- ----[ ADD, AFTER ]---------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== if ( ($userdata['user_id'] != ANONYMOUS) && ($userdata['user_color_gc']) ) { include_once($phpbb_root_path .'language/lang_'. $board_config['default_lang'] .'/lang_auc.'. $phpEx); $q = 'SELECT * FROM '. COLORS; $r = $db->sql_query($q); $rows = $db->sql_fetchrowset($r); $auc_groups_arr = array(); $auc_groups = $userdata['user_color_gi']; $auc_groups_exp = explode(']', $auc_groups); for ($x = 0; $x < count($auc_groups_exp); $x++) $auc_groups_arr[] = str_replace('[', '', $auc_groups_exp[$x]); $auc_group_id = str_replace('[', '', str_replace(']', '', $userdata['user_color_gc'])); $auc_groups_drop = '<select>'; for ($x = 0; $x </option>assign_block_vars('auc', array( 'L_AUC_COLOR' => $lang['auc_choose_group'], 'AUC_COLOR' => $auc_groups_drop) ); }#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/common.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- ?> ----------------------------------- ----[ ADD, BEFORE ]--------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== define('COLORS', $table_prefix .'advanced_username_color'); $q = "SELECT * FROM ". COLORS ." WHERE group_id > '0' ORDER BY group_weight ASC"; $r = $db->sql_query($q); $coloring = $db->sql_fetchrowset($r); if ($board_config['auc_use_donate']) { $q = "SELECT a.user_id AS a_user_id, u.user_id AS u_user_id, u.username AS u_username FROM ". ACCT_HIST_TABLE ." a, ". USERS_TABLE ." u WHERE a.user_id = u.user_id AND a.user_id != ". ANONYMOUS ." AND `comment` LIKE 'donate%' AND `status` LIKE '%Completed%' AND `lw_money` > '0' GROUP BY a.user_id"; $r = $db->sql_query($q); $donaters = $db->sql_fetchrowset($r); } if ($board_config['auc_use_new_members']) { $days = $board_config['auc_use_new_members_days']; $q = "SELECT username, user_id FROM ". USERS_TABLE ." WHERE user_regdate >= '". (time() - (86400 * intval($days)) ) ."'"; $r = $db->sql_query($q); $auc_new_users = $db->sql_fetchrowset($r); } if ($board_config['auc_use_spiders']) { $q = "SELECT session_time, session_ip FROM ". SESSIONS_TABLE ." WHERE session_time >= '". (time() - 300) ."' AND session_user_id = '". ANONYMOUS ."' GROUP BY session_ip"; $r = $db->sql_query($q); $auc_spiders = $db->sql_fetchrowset($r); }#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/search.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- if ( $show_results == 'posts' ) { $sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.user_id, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- else { $sql = "SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.user_id, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc as color1, u2.user_color_gc as color2, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $poster .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? $searchset[$i]['username'] : ( ( $searchset[$i]['post_username'] != "" ) ? $searchset[$i]['post_username'] : $lang['Guest'] ); ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $poster .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? CheckUsernameColor($searchset[$i]['user_color_gc'], $searchset[$i]['username']) : ( ( CheckUsernameColor($searchset[$i]['user_color_gc'], $searchset[$i]['post_username']) != "" ) ? CheckUsernameColor($searchset[$i]['user_color_gc'], $searchset[$i]['post_username']) : $lang['Guest'] );#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $topic_author .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? $searchset[$i]['username'] : ( ( $searchset[$i]['post_username'] != '' ) ? $searchset[$i]['post_username'] : $lang['Guest'] ); ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $topic_author .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? CheckUsernameColor($searchset[$i]['color1'], $searchset[$i]['username']) : ( ( CheckUsernameColor($searchset[$i]['color1'], $searchset[$i]['post_username']) != '' ) ? CheckUsernameColor($searchset[$i]['color1'], $searchset[$i]['post_username']) : $lang['Guest'] );#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $last_post_author = ( $searchset[$i]['id2'] == ANONYMOUS ) ? ( ($searchset[$i]['post_username2'] != '' ) ? $searchset[$i]['post_username2'] . ' ' : $lang['Guest'] . ' ' ) : '<a>' . $searchset[$i]['user2'] . '</a>'; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $last_post_author = ( $searchset[$i]['id2'] == ANONYMOUS ) ? ( ($searchset[$i]['post_username2'] != '' ) ? $searchset[$i]['post_username2'] . ' ' : $lang['Guest'] . ' ' ) : '<a>' . CheckUsernameColor($searchset[$i]['color2'], $searchset[$i]['user2']) . '</a>';#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/groupcp.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- // // Get moderator details for this group // $sql = "SELECT username, user_id, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- user_id, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- // // Get user information for this group // $sql = "SELECT u.username, u.user_id, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.user_id, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $db->sql_freeresult($result); $sql = "SELECT u.username, u.user_id, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.user_id, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- // // Add the moderator // $username = $group_moderator['username']; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== // // Add the moderator // $username = CheckUsernameColor($group_moderator['user_color_gc'], $group_moderator['username']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- // // Dump out the remaining users // for($i = $start; $i < min($board_config['topics_per_page'] + $start, $members_count); $i++) { $username = $group_members[$i]['username']; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== // // Dump out the remaining users // for($i = $start; $i < min($board_config['topics_per_page'] + $start, $members_count); $i++) { $username = CheckUsernameColor($group_members[$i]['user_color_gc'], $group_members[$i]['username']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $username = $modgroup_pending_list[$i]['username']; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $username = CheckUsernameColor($modgroup_pending_list[$i]['user_color_gc'], $modgroup_pending_list[$i]['username']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/privmsg.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- // // Major query obtains the message ... // $sql = "SELECT u.username ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username ----------------------------------- ----[ IN-LINE ADD, BEFORE ]------------------------------------------- u.user_color_gc AS color1, u2.user_color_gc AS color2, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $username_from = $privmsg['username_1']; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $username_from = CheckUsernameColor($privmsg['color1'], $privmsg['username_1']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $username_to = $privmsg['username_2']; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $username_to = CheckUsernameColor($privmsg['color2'], $privmsg['username_2']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- //// General SQL to obtain messages//$sql_tot = "SELECT COUNT(privmsgs_id) AS total FROM " . PRIVMSGS_TABLE . " ";$sql = "SELECT pm.privmsgs_type, pm.privmsgs_id, pm.privmsgs_date, pm.privmsgs_subject, u.user_id, u.username ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- , u.user_color_gc ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $msg_username = $row['username']; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $msg_username = CheckUsernameColor($row['user_color_gc'], $row['username']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/memberlist.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $sql = "SELECT username, user_id, user_viewemail, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- username, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- 'USERNAME' => $username, ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== 'USERNAME' => CheckUsernameColor($row['user_color_gc'], $row['username']),#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/index.php ----------------------------------- ----[ FIND (3 Occurances) ]------------------------------------------- $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.user_id ----------------------------------- ----[ IN-LINE AFTER, ADD ]-------------------------------------------- , u.user_color_gc ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- // // Obtain list of moderators of each forum // First users, then groups ... broken into two queries // $sql = "SELECT aa.forum_id, u.user_id, u.username ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- , u.user_color_gc ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $forum_moderators[$row['forum_id']][] = '<a>' . $row['username'] . '</a>'; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $forum_moderators[$row['forum_id']][] = '<a>' . CheckUsernameColor($row['user_color_gc'], $row['username']) . '</a>';#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a>' . $forum_data[$j]['username'] . '</a> '; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a>' . CheckUsernameColor($forum_data[$j]['user_color_gc'], $forum_data[$j]['username']) . '</a> ';#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/viewforum.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- //// Obtain list of moderators of each forum// First users, then groups ... broken into two queries//$sql = "SELECT u.user_id, u.username ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- , u.user_color_gc ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $moderators[] = '<a>' . $row['username'] . '</a>'; ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $moderators[] = '<a>' . CheckUsernameColor($row['user_color_gc'], $row['username']) . '</a>';#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- //// All announcement data, this keeps announcements// on each viewforum page ...//$sql = "SELECT t.*, u.username, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u2.username as user2, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u2.user_color_gc as color2, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- //// Grab all the basic data (all topics except announcements)// for this forum//$sql = "SELECT t.*, u.username ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u2.username as user2, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u2.user_color_gc as color2, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $goto_page .= ' ] '; } else { $goto_page = ''; } ----------------------------------- ----[ ADD, AFTER ]---------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $topic_rowset[$i]['username'] = CheckUsernameColor($topic_rowset[$i]['user_color_gc'], $topic_rowset[$i]['username']); $topic_rowset[$i]['username2'] = CheckUsernameColor($topic_rowset[$i]['user_color_gc'], $topic_rowset[$i]['username2']); $topic_rowset[$i]['user2'] = CheckUsernameColor($topic_rowset[$i]['color2'], $topic_rowset[$i]['user2']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/viewtopic.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- //// Go ahead and pull all data for this topic//$sql = "SELECT ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- 'POSTER_NAME' => $poster, ----------------------------------- ----[ REPLACE WITH ]-------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== 'POSTER_NAME' => CheckUsernameColor($postrow[$i]['user_color_gc'], $postrow[$i]['username']),#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/viewonline.php ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- /// Get user list//$sql = "SELECT u.user_id, u.username, ----------------------------------- ----[ IN-LINE FIND ]-------------------------------------------------- u.username, ----------------------------------- ----[ IN-LINE ADD, AFTER ]-------------------------------------------- u.user_color_gc, ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- $style_color = ''; if ( $row['user_level'] == ADMIN ) { $username = '<b>' . $username . '</b>'; } else if ( $row['user_level'] == MOD ) { $username = '<b>' . $username . '</b>'; } ----------------------------------- ----[ ADD, AFTER ]---------------------------------------------------- #======================================================================= |#==== Start: == Advanced Username Color ================================ |#==== v1.0.6 =========================================================== |#==== $username = CheckUsernameColor($row['user_color_gc'], $row['username']);#====#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-tweaks.com] = |#==== End: ==== Advanced Username Color ================================ | #======================================================================= | ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/templates/*/index_body.tpl ----------------------------------- ----[ FIND ]----------------------- ----------------------------------- <td><span>{TOTAL_USERS_ONLINE} [ {L_WHOSONLINE_ADMIN} ] [ {L_WHOSONLINE_MOD} ]<br>{RECORD_USERS}<br>{LOGGED_IN_USER_LIST}</span></td> ----------------------------------- ----[ REPLACE WITH ]---------------------------------------------------- <td><span>{TOTAL_USERS_ONLINE} [ {L_WHOSONLINE_ADMIN} ] [ {L_WHOSONLINE_MOD} ] <BEGIN> {colors.GROUPS} <END> <br>{RECORD_USERS}<br>{LOGGED_IN_USER_LIST}</span></td> ----------------------------------- ----[ CLOSE & SAVE ]-------------------------------------------------- ----------------------------------- ----[ OPEN ]----------------------- ----------------------------------- Root/templates/*/profile_add_body.tpl ----------------------------------- ----[ FIND SIMILAR ]-------------------------------------------------- <tr> <td><span>{L_DATE_FORMAT}:</span><br> <span>{L_DATE_FORMAT_EXPLAIN}</span></td> <td> <input> </td> </tr> ----------------------------------- ----[ ADD, AFTER ]---------------------------------------------------- <BEGIN> <tr> <td><span>{auc.L_AUC_COLOR}</span></td> <td>{auc.AUC_COLOR}</td> </tr> <END> ----------------------------------- ----[ CLOSE & SAVE ]--------------------------------------------------