to make shoutbox work run these sql queries:
Code:
CREATE TABLE `shoutbox` (
`id` bigint(10) NOT NULL auto_increment,
`userid` bigint(6) NOT NULL default '0',
`to_user` int(10) NOT NULL default '0',
`username` varchar(25) NOT NULL default '',
`date` int(11) NOT NULL default '0',
`text` text NOT NULL,
`text_parsed` text NOT NULL,
PRIMARY KEY (`id`),
KEY `for` (`to_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Code:
ALTER TABLE users ADD `show_shout` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'yes';
ALTER TABLE users ADD `chatpost` int(11) NOT NULL default '1';
ALTER TABLE users ADD `shoutboxbg` enum('1','2','3') character set utf8 collate utf8_bin NOT NULL default '1';
ALTER TABLE `users` ADD `smile_until` int(10) NOT NULL default '0';