where is the sql for it as its not in the download and in the sql thats there no shoutbox in it
PHP Code:
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(40) NOT NULL default '',
`old_password` varchar(40) NOT NULL default '',
`passhash` varchar(32) NOT NULL default '',
`secret` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`status` enum('pending','confirmed') NOT NULL default 'pending',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`last_login` datetime NOT NULL default '0000-00-00 00:00:00',
`last_access` datetime NOT NULL default '0000-00-00 00:00:00',
`editsecret` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`privacy` enum('strong','normal','low') NOT NULL default 'normal',
`stylesheet` int(10) default '1',
`info` text,
`acceptpms` enum('yes','friends','no') NOT NULL default 'yes',
`ip` varchar(15) NOT NULL default '',
`class` tinyint(3) unsigned NOT NULL default '0',
`avatar` varchar(100) NOT NULL default '',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`title` varchar(30) NOT NULL default '',
`country` int(10) unsigned NOT NULL default '0',
`notifs` varchar(100) NOT NULL default '',
`modcomment` text NOT NULL,
`enabled` enum('yes','no') NOT NULL default 'yes',
`avatars` enum('yes','no') NOT NULL default 'yes',
`donor` enum('yes','no') NOT NULL default 'no',
`warned` enum('yes','no') NOT NULL default 'no',
`warneduntil` datetime NOT NULL default '0000-00-00 00:00:00',
`torrentsperpage` int(3) unsigned NOT NULL default '0',
`topicsperpage` int(3) unsigned NOT NULL default '0',
`postsperpage` int(3) unsigned NOT NULL default '0',
`deletepms` enum('yes','no') NOT NULL default 'yes',
`savepms` enum('yes','no') NOT NULL default 'no',
`parked` enum('yes','no') NOT NULL default 'no',
`announce` enum('yes','no') NOT NULL default 'no',
`passkey` varchar(32) NOT NULL,
`last_browse` int(11) NOT NULL default '0',
`language` int(10) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `status_added` (`status`,`added`),
KEY `ip` (`ip`),
KEY `uploaded` (`uploaded`),
KEY `downloaded` (`downloaded`),
KEY `country` (`country`),
KEY `last_access` (`last_access`),
KEY `enabled` (`enabled`),
KEY `warned` (`warned`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `old_password`, `passhash`, `secret`, `email`, `status`, `added`, `last_login`, `last_access`, `editsecret`, `privacy`, `stylesheet`, `info`, `acceptpms`, `ip`, `class`, `avatar`, `uploaded`, `downloaded`, `title`, `country`, `notifs`, `modcomment`, `enabled`, `avatars`, `donor`, `warned`, `warneduntil`, `torrentsperpage`, `topicsperpage`, `postsperpage`, `deletepms`, `savepms`, `parked`, `announce`, `passkey`, `last_browse`, `language`) VALUES
(1, 'Phogo', '', '751c074b8f309c7d49f44c852ea92a7d', 0xc2bdc2a4c3967f45c3b9c3b50d7bc3b1c397c3afc2b0c3b3081521766873, 'info@moynahanmultimedia.com', 'confirmed', '2010-07-02 10:13:17', '2010-07-02 11:20:33', '2010-07-02 10:28:16', '', 'normal', 1, '', 'yes', '127.0.0.1', 6, '', 0, 0, '', 12, '', '', 'yes', 'yes', 'no', 'no', '0000-00-00 00:00:00', 0, 0, 0, 'yes', 'no', 'no', 'no', '', 0, 1);