[SOLVED] AGCM Help

[.QUACK.Major.Pain]

I had the advanced group color management installed and working, and I think I messed something up.

It's been working for quite some time, but now I don't have the option in the users profile to change their usergroup color. I have uploaded all the files again, but still nothing.

I think I may have screwed something in the database.
I was removing some old tables I didn't want anymore, and possibly removed something I shouldn't have.

How do I reinstall the tables for this mod to see if it fixes it?
I uploaded the install folder, but tells me it is already installed.

Thanks

[obiku]

Try to do these database changes by phpMyAdmin

Code: Select all

ALTER TABLE phpbb_groups ADD group_weight MEDIUMINT(8) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_groups ADD group_legend SMALLINT(1) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_groups ADD group_color SMALLINT(1) DEFAULT '0' NOT NULL;  ##--[ Colors Table ]-------------------------------------#  CREATE TABLE phpbb_color (   group_id mediumint(8) NOT NULL default '0',   color_code varchar(6) NOT NULL default '',   themes_id mediumint(8) NOT NULL default '0',   hover_bold smallint(1) NOT NULL default '0',   hover_italic smallint(1) NOT NULL default '0',   hover_underline smallint(1) NOT NULL default '0',   bold smallint(1) NOT NULL default '0',   italic smallint(1) NOT NULL default '0',   underline smallint(1) NOT NULL default '0',   KEY group_id (group_id),   KEY themes_id (themes_id));  ##--[ Users Table ]--------------------------------------#ALTER TABLE phpbb_users ADD user_group_id MEDIUMINT(8) DEFAULT 'GROUP_REGISTERED' NOT NULL;

Remind to change the prefix to your own "phpbb_"

[.QUACK.Major.Pain]

Thanks

I tried each one at a time, and all the tables are already there.
Gave an error each time.

Just can't seem to figure out why the option is missing in the user profiles to change it.

[Helter]

you may have set it to over ride user choice in acp/General Admin/Configuration+

[.QUACK.Major.Pain]

That was it.

Your the man Helter...

Thanks