|
#21
|
|||
|
|||
I have Problem
Can somebody give me the SQL file for Shoutbox? |
#22
|
|||
|
|||
lol
whoever uses this source and have not the slighest ideea about php.. should know better before using this source. not only that it's full of bugs... but you will get hacked in 10 secs
|
#23
|
||||
|
||||
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'; |
Tags |
source |
|
|