ok bud, thanks, that worked! now...I get this....
Database error in vBulletin 3.0.6:
Invalid SQL:
ALTER TABLE `user` ADD `teamid` INT( 10 ) DEFAULT '1' NOT NULL ,
ADD `teamadmin` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `team_chat_pref_font_face` VARCHAR( 255 ) NOT NULL ,
ADD `team_chat_pref_font_color` VARCHAR( 255 ) NOT NULL ,
ADD `team_chat_pref_user_ignore` TEXT NOT NULL ,
ADD `team_chat_pref_status` VARCHAR( 10 ) NOT NULL ,
ADD `team_chat_pref_auto_on` TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD `team_chat_pref_auto_msg` VARCHAR( 255 ) NOT NULL ;
mysql error: Duplicate column name 'teamid'
mysql error number: 1060
So...then I try to add a new team and I get this:
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT *
FROM forum
WHERE `teamid` !=0
mysql error: Unknown column 'teamid' in 'where clause'
mysql error number: 1054
If someone can please just help me get this damn hack working,lol. Ive tried alot to get it going and need it for my site. So please pm me if you can help, thanks!
|