Advanced Username Color 1.0.5 by aUsTiN

CurtisH · Posted: Sat Nov 05, 2005 10:14 am

I have decide to update aUsTiN's Advanced Username Color 1.0.5 for BBtoNuke.

Only registered users can see links on this board!
Get registered or login to the forums!

aUsTiN has given us permission to update this one. When I have completed the update I will post the details as well as the files in this thread for testing.

NOTE: Updated files are now available for testing. See

Only registered users can see links on this board!
Get registered or login to the forums!

for details.

duhokame · New Member Joined: Jan 12, 2006 Posts: 1

Hello

I have downloaded Advanced Username Color And I Updated All Files
this is coming all the time
ERROR!

DEBUG MODE

SQL Error : 1054 Unknown column 'user_color_gi' in 'field list'

UPDATE nuke_users SET user_color_gi = '--0--', user_color_gc = '' WHERE user_id = '2'

Line : 331
File : /home/virtual/site52/fst/var/www/html/modules/Forums/admin/admin_advanced_username_color_m.php

can anybady Help me ? out tell me what to do
Thanks

CurtisH · Posted: Thu Jan 12, 2006 9:51 am

It sounds like you have not ran the needed SQL

You were supposed to run the following using phpmyAdmin:

Code:

CREATE TABLE `nuke_bbadvanced_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 '',
PRIMARY KEY (`group_id`)
) TYPE=MyISAM ;

ALTER TABLE nuke_users ADD user_color_gc VARCHAR(6) DEFAULT '';
ALTER TABLE nuke_users ADD user_color_gi TEXT DEFAULT NULL;

Look at your nuke_users table and verify that you have user_color_gi

aaly · New Member Joined: Jan 02, 2006 Posts: 19

site is down and I need this mod ? can someone show me an alternative download location

sam1el · New Member Joined: Jul 16, 2008 Posts: 9

CurtisH wrote:

It sounds like you have not ran the needed SQL

You were supposed to run the following using phpmyAdmin:

Code:

CREATE TABLE `nuke_bbadvanced_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 '',
PRIMARY KEY (`group_id`)
) TYPE=MyISAM ;

ALTER TABLE nuke_users ADD user_color_gc VARCHAR(6) DEFAULT '';
ALTER TABLE nuke_users ADD user_color_gi TEXT DEFAULT NULL;

Look at your nuke_users table and verify that you have user_color_gi

been trying to do this for a bit but sql throws this error at me

Code:

#1067 - Invalid default value for 'group_weight'

not sure what else to set it to

montego · Posted: Wed Jul 30, 2008 6:12 am

Try removing the "default ''" after the "NOT NULL"... Not sure what impact that will have on the script's running. Really depends on how its written.

kynlore · New Member Joined: Aug 04, 2007 Posts: 13

Anyone know if anything like this is currently out there. I'm looking for the ability to change the color of admin and mod username colors throughout the forums.

I saw a couple on the phpBB site, but it didn't look like they would port over to me.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4887

I have the download. I'll post it for your downloading pleasure.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4887

Only registered users can see links on this board!
Get registered or login to the forums!

you go. I haven't installed it though.

kynlore · New Member Joined: Aug 04, 2007 Posts: 13

Thanks!

Edit* This does work. A little long on the installation, but it works. Make sure to upload the additional files. Smile

kynlore · New Member Joined: Aug 04, 2007 Posts: 13

Ok here's two minor issues that showed up. Maybe someone can help.

The mod works pretty well. I noticed an odd change in the size of the usernames after applying the mod.

The top username with the mod applied has a font size of 11 and the bottom has 12. The modded one should be 12. Here's the source code:

Code:

<a name="11"></a>Kynlore

<a name="12"></a>Mikayla

I know I need to change it to 12, and probably drop the class, but I'm not sure how it got in there in the first place.

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2856

Probably the class "gensmall" is defined as 11px size while the normal is 12px

kynlore · New Member Joined: Aug 04, 2007 Posts: 13

That was it. I found it in the /includes/function.php file, at the very end if someone else is looking to fix that issue.

I want to add one more if someone has the answer:

With this mod I can of course create a group and change their color. I made my admin group and my moderator group match the defaults shown in my forums.

But if I change the group color to red, where is the code to change the [Admistrator] and [Moderator] as shown in the picture?

I searched the style.css file in my theme for the hex code that matches that color, as well as a few other files. I can go through all the files in the directory, but I was hoping someone might know off the top of their head what file I can find that in.

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2856

May be defined in Styles in your Forums admin panel

kynlore · New Member Joined: Aug 04, 2007 Posts: 13

evaders99 wrote:

May be defined in Styles in your Forums admin panel

That does work. I assumed it wouldn't because the subsilver theme isn't used, but apparently it does draw from there. Although it does change the titles on the forum ACP. Wink