IntegraMOD

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

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_"

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.

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

That was it.

Your the man Helter...

Thanks