got
Quote:
Originally Posted by Phogo
(Post 23892)
all in one package
|
where is the sql for it as its not in the download and in the sql thats there no shoutbox in it:muscle:
i do not want to recode my site just need the sql for shoutbox :smack:
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);
SO WHERE IS THE SQL FOR SHOUTBOX ?:unknown:
And the rest of the phps files to ad too:cool:
|