Bravo List
Register
Go Back   > Bravo List > P2P > Forum > Community Cafe
Reply
  #21  
Old 5th June 2009, 22:31
helvijs13 helvijs13 is offline
Senior Member
 
Join Date: Sep 2008
Posts: 23
Exclamation
I have Problem

Can somebody give me the SQL file for Shoutbox?
Reply With Quote
  #22  
Old 16th June 2010, 08:35
crztz crztz is offline
Senior Member
 
Join Date: Apr 2009
P2P
Posts: 34
Default 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
Reply With Quote
  #23  
Old 16th June 2010, 13:04
Phogo's Avatar
Phogo Phogo is offline
VIP
 
Join Date: Jan 2008
United Kingdom
Posts: 902
Default
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';
Reply With Quote
Reply

Tags
source

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 16:10. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.