|
#51
|
||||
|
||||
Beta 4 is now ready for down load at https://sourceforge.net/project/show...ease_id=632334
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#52
|
|||
|
|||
error in sql
There is the error on the sql part here is it
Code:
Error executing SQL Query CREATE TABLE `torrent_users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(25) NOT NULL default '', `clean_username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '', `name` varchar(50) default NULL, `email` varchar(255) NOT NULL default '', `regdate` datetime NOT NULL default '0000-00-00 00:00:00', `password` varchar(40) NOT NULL default '', `theme` varchar(255) default NULL, `language` varchar(15) default NULL, `avatar` varchar(255) NOT NULL default 'blank.gif', `accept_mail` enum('yes','no') NOT NULL default 'no', `pm_notify` enum('true','false') NOT NULL default 'true', `aim` varchar(255) default NULL, `icq` varchar(10) default NULL, `jabber` varchar(255) default NULL, `msn` varchar(255) default NULL, `skype` varchar(255) default NULL, `yahoo` varchar(255) default NULL, `level` enum('user','premium','moderator','admin') NOT NULL default 'user', `uploaded` bigint(32) unsigned NOT NULL default '0', `downloaded` bigint(32) unsigned NOT NULL default '0', `active` tinyint(1) default '0', `ban` int(1) unsigned NOT NULL default '0', `act_key` varchar(32) default NULL, `passkey` varchar(32) default NULL, `newpasswd` varchar(40) default NULL, `banreason` varchar(255) default NULL, `lastip` int(10) unsigned NOT NULL default '0', `lasthost` varchar(255) NOT NULL default '', `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `rem` enum('yes','no') NOT NULL default 'no', `modcomment` varchar(225) NOT NULL default '', `warned` int(1) unsigned NOT NULL default '0', `warn_kapta` int(11) NOT NULL default '0', `warn_hossz` int(11) NOT NULL default '0', `invited_by` int(10) NOT NULL default '0', `invitees` varchar(100) NOT NULL default '', `invites` smallint(5) NOT NULL default '0', `country` int(10) NOT NULL default '0', `seedbonus` decimal(10,1) NOT NULL default '0.0', `seedbox` int(10) unsigned NOT NULL default '0.0.0.0', `tzoffset` smallint(4) NOT NULL default '0', `can_shout` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true', `Show_online` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true', `invitedate` datetime NOT NULL default '0000-00-00 00:00:00', `donated` int(5) unsigned NOT NULL default '0', `dondate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`), UNIQUE KEY `passkey` (`passkey`), KEY `lastip` (`lastip`), KEY `lasthost` (`lasthost`), KEY `date` (`regdate`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0; Error ID: 1067 Error Message: Invalid default value for 'seedbox' Last edited by joeroberts; 15th October 2008 at 16:22. |
#53
|
||||
|
||||
replace steup/sql/install-MySQL with this
Code:
CREATE TABLE `#prefix#_addedrequests` ( `id` int(10) unsigned NOT NULL auto_increment, `requestid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`id`), KEY `userid` (`userid`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_admin_forum` -- CREATE TABLE `#prefix#_admin_forum` ( `prefix` varchar(60) NOT NULL default '', `cookie_name` varchar(60) NOT NULL default '', `cookie_domain` varchar(60) NOT NULL default '', `cookie_path` varchar(60) NOT NULL default '', `cookie_time` varchar(60) NOT NULL default '0', `base_folder` varchar(60) NOT NULL default '', `forum_share` enum('true','false') NOT NULL default 'true', `auto_post` enum('true','false') NOT NULL default 'false', `auto_post_forum` varchar(60) NOT NULL default '0' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_avps` -- CREATE TABLE `#prefix#_avps` ( `arg` varchar(20) NOT NULL default '', `value_s` text NOT NULL, `value_i` int(11) NOT NULL default '0', `value_u` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`arg`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_bans` -- CREATE TABLE `#prefix#_bans` ( `id` int(11) unsigned NOT NULL auto_increment, `ipstart` int(10) unsigned NOT NULL default '0', `ipend` int(10) unsigned NOT NULL default '0', `reason` varchar(255) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `ip_unique` (`ipstart`,`ipend`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_blackjack` -- CREATE TABLE `#prefix#_blackjack` ( `userid` int(11) NOT NULL default '0', `points` int(11) NOT NULL default '0', `status` enum('playing','waiting') NOT NULL default 'playing', `cards` text NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`userid`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_bonus` -- CREATE TABLE `#prefix#_bonus` ( `id` int(5) NOT NULL auto_increment, `bonusname` varchar(50) NOT NULL default '', `points` decimal(4,1) NOT NULL default '000.0', `description` text NOT NULL, `art` varchar(10) NOT NULL default 'traffic', `menge` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_cards` -- CREATE TABLE `#prefix#_cards` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `pic` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_casino` -- CREATE TABLE `#prefix#_casino` ( `userid` int(10) NOT NULL default '0', `win` bigint(20) default NULL, `lost` bigint(20) default NULL, `trys` int(11) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `enableplay` enum('yes','no') NOT NULL default 'yes', `deposit` bigint(20) NOT NULL default '0', PRIMARY KEY (`userid`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_casino_bets` -- CREATE TABLE `#prefix#_casino_bets` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) NOT NULL default '0', `proposed` varchar(40) NOT NULL default '', `challenged` varchar(40) NOT NULL default '', `amount` bigint(20) NOT NULL default '0', `time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `userid` (`userid`,`proposed`,`challenged`,`amount`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_casino_config` -- CREATE TABLE `#prefix#_casino_config` ( `name` varchar(255) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_categories` -- CREATE TABLE `#prefix#_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `sort_index` int(10) unsigned NOT NULL default '0', `image` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `sort_index` (`sort_index`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_comments` -- CREATE TABLE `#prefix#_comments` ( `id` int(10) unsigned NOT NULL auto_increment, `user` int(10) unsigned NOT NULL default '0', `torrent` int(10) unsigned NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', `text` text NOT NULL, `ori_text` text NOT NULL, `news` int(10) NOT NULL default '0', `nzb` int(10) NOT NULL default '0', `offer` int(11) NOT NULL default '0', `editedat` datetime NOT NULL default '0000-00-00 00:00:00', `editedby` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `user` (`user`), KEY `torrent` (`torrent`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_comments_notify` -- CREATE TABLE `#prefix#_comments_notify` ( `torrent` int(11) NOT NULL default '0', `user` int(11) NOT NULL default '0', `status` enum('active','stopped') NOT NULL default 'active', PRIMARY KEY (`torrent`,`user`), KEY `torrent` (`torrent`,`status`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_complaints` -- CREATE TABLE `#prefix#_complaints` ( `torrent` int(15) unsigned NOT NULL default '0', `user` int(11) unsigned NOT NULL default '0', `host` varchar(60) NOT NULL default '', `datetime` datetime NOT NULL default '0000-00-00 00:00:00', `score` smallint(1) unsigned zerofill NOT NULL default '0', PRIMARY KEY (`torrent`,`user`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_config` -- CREATE TABLE `#prefix#_config` ( `sitename` varchar(255) NOT NULL default '', `siteurl` varchar(255) NOT NULL default '', `cookiedomain` varchar(30) NOT NULL default '', `cookiepath` varchar(60) NOT NULL default '', `admin_email` varchar(60) NOT NULL default '', `language` varchar(15) NOT NULL default '', `theme` varchar(255) NOT NULL default '', `force_passkey` enum('true','false') NOT NULL default 'false', `welcome_message` longtext, `announce_text` varchar(255) default NULL, `allow_html` enum('true','false') NOT NULL default 'true', `rewrite_engine` enum('true','false') NOT NULL default 'true', `torrent_prefix` varchar(255) default NULL, `torrent_per_page` int(10) unsigned NOT NULL default '10', `onlysearch` enum('true','false') NOT NULL default 'true', `max_torrent_size` int(11) unsigned NOT NULL default '0', `announce_interval_min` int(10) unsigned NOT NULL default '0', `announce_interval` int(10) unsigned NOT NULL default '0', `dead_torrent_interval` int(10) unsigned NOT NULL default '0', `minvotes` smallint(5) unsigned NOT NULL default '0', `time_tracker_update` int(10) unsigned NOT NULL default '0', `best_limit` smallint(5) unsigned NOT NULL default '0', `down_limit` smallint(5) unsigned NOT NULL default '0', `torrent_complaints` enum('true','false') NOT NULL default 'false', `torrent_global_privacy` enum('true','false') NOT NULL default 'true', `disclaimer_check` enum('true','false') NOT NULL default 'false', `gfx_check` enum('true','false') NOT NULL default 'true', `upload_level` enum('all','user','premium') NOT NULL default 'user', `download_level` enum('all','user','premium') NOT NULL default 'all', `announce_level` enum('all','user') NOT NULL default 'all', `max_num_file` smallint(5) unsigned NOT NULL default '0', `max_share_size` bigint(8) unsigned NOT NULL default '0', `min_size_seed` mediumint(8) unsigned NOT NULL default '0', `min_share_seed` bigint(8) unsigned NOT NULL default '0', `global_min_ratio` float unsigned NOT NULL default '0', `autoscrape` enum('true','false') NOT NULL default 'true', `min_num_seed_e` smallint(5) unsigned NOT NULL default '0', `min_size_seed_e` bigint(8) unsigned NOT NULL default '0', `minupload_size_file` int(10) unsigned NOT NULL default '0', `allow_backup_tracker` enum('true','false') NOT NULL default 'false', `stealthmode` enum('true','false') NOT NULL default 'true', `version` varchar(5) NOT NULL default '', `upload_dead` enum('true','false') NOT NULL default 'false', `invites_open` enum('true','false') NOT NULL default 'false', `invite_only` enum('true','false') NOT NULL default 'false', `max_members` int(10) unsigned NOT NULL default '0', `auto_clean` int(10) unsigned NOT NULL default '0', `free_dl` enum('true','false') NOT NULL default 'false', `GIGSA` int(10) NOT NULL default '0', `RATIOA` decimal(10,2) NOT NULL default '0.00', `WAITA` int(10) NOT NULL default '0', `GIGSB` int(10) NOT NULL default '0', `RATIOB` decimal(10,2) NOT NULL default '0.00', `WAITB` int(10) NOT NULL default '0', `GIGSC` int(10) NOT NULL default '0', `RATIOC` decimal(10,2) NOT NULL default '0.00', `WAITC` int(10) NOT NULL default '0', `GIGSD` int(10) NOT NULL default '0', `RATIOD` decimal(10,2) NOT NULL default '0.00', `WAITD` int(10) NOT NULL default '0', `wait_time` enum('true','false') NOT NULL default 'false', `addprivate` enum('true','false') NOT NULL default 'false', `search_cloud_block` enum('true','false') NOT NULL default 'true', `pivate_mode` enum('true','false') NOT NULL default 'false' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_countries` -- CREATE TABLE `#prefix#_countries` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(50) default NULL, `flagpic` varchar(50) default NULL, `domain` char(3) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_download_completed` -- CREATE TABLE `#prefix#_download_completed` ( `user` int(11) unsigned NOT NULL default '0', `torrent` int(15) unsigned NOT NULL default '0', `completed` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`user`,`torrent`), KEY `torrent` (`torrent`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_faq` -- CREATE TABLE `#prefix#_faq` ( `id` int(10) NOT NULL auto_increment, `type` set('categ','item') NOT NULL default 'item', `question` text NOT NULL, `answer` text NOT NULL, `flag` set('0','1','2','3') NOT NULL default '1', `categ` int(10) NOT NULL default '0', `order` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_files` -- CREATE TABLE `#prefix#_files` ( `id` int(20) unsigned NOT NULL auto_increment, `torrent` int(15) unsigned NOT NULL default '0', `filename` varchar(255) NOT NULL default '', `size` bigint(20) unsigned NOT NULL default '0', `md5sum` varchar(32) default NULL, `ed2k` varchar(255) default NULL, `magnet` varchar(255) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `torrent_2` (`torrent`,`filename`), KEY `torrent` (`torrent`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_filter` -- CREATE TABLE `#prefix#_filter` ( `id` int(10) unsigned NOT NULL auto_increment, `keyword` varchar(50) NOT NULL default '', `reason` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `keyword` (`keyword`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_flashscores` -- CREATE TABLE `#prefix#_flashscores` ( `ID` int(11) NOT NULL auto_increment, `game` int(11) NOT NULL default '0', `user` int(11) NOT NULL default '0', `level` int(11) NOT NULL default '0', `score` int(11) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ID`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_lottery_config` -- CREATE TABLE `#prefix#_lottery_config` ( `name` varchar(255) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_offers` -- CREATE TABLE `#prefix#_offers` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `name` varchar(225) default NULL, `descr` text NOT NULL, `added` datetime NOT NULL default '0000-00-00 00:00:00', `for` int(10) unsigned NOT NULL default '0', `against` int(10) unsigned NOT NULL default '0', `category` int(11) NOT NULL default '0', `comments` int(11) NOT NULL default '0', `allowed` enum('allowed','pending','denied') NOT NULL default 'pending', `votes` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `userid` (`userid`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_offervotes` -- CREATE TABLE `#prefix#_offervotes` ( `id` int(10) unsigned NOT NULL auto_increment, `offerid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `vote` enum('for','against') NOT NULL default 'for', PRIMARY KEY (`id`), KEY `userid` (`userid`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_offres_config` -- CREATE TABLE `#prefix#_offres_config` ( `name` varchar(255) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_online_users` -- CREATE TABLE `#prefix#_online_users` ( `id` int(60) unsigned NOT NULL default '0', `page` varchar(255) NOT NULL default '', `logged_in` datetime NOT NULL default '0000-00-00 00:00:00', `last_action` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_paypal` -- CREATE TABLE `#prefix#_paypal` ( `siteurl` varchar(255) NOT NULL default '', `paypal_email` varchar(60) NOT NULL default '', `sitecost` varchar(60) NOT NULL default '', `reseaved_donations` varchar(60) NOT NULL default '', `donatepage` longtext NOT NULL, `donation_block` enum('true','false') NOT NULL default 'true', `nodonate` enum('EU','UK','US') NOT NULL default 'US' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_peers` -- CREATE TABLE `#prefix#_peers` ( `id` int(10) unsigned NOT NULL auto_increment, `uid` int(11) unsigned NOT NULL default '0', `torrent` int(10) unsigned NOT NULL default '0', `peer_id` varchar(20) binary NOT NULL default '', `unique_id` varchar(20) default NULL, `ip` int(10) unsigned NOT NULL default '0', `port` smallint(5) unsigned NOT NULL default '0', `real_ip` int(10) unsigned NOT NULL default '0', `uploaded` bigint(20) unsigned NOT NULL default '0', `downloaded` bigint(20) unsigned NOT NULL default '0', `download_speed` int(11) unsigned NOT NULL default '0', `upload_speed` int(11) unsigned NOT NULL default '0', `to_go` bigint(20) unsigned NOT NULL default '0', `seeder` enum('yes','no') NOT NULL default 'no', `started` datetime NOT NULL default '0000-00-00 00:00:00', `last_action` datetime NOT NULL default '0000-00-00 00:00:00', `connectable` enum('yes','no') NOT NULL default 'yes', `client` varchar(60) default NULL, `version` varchar(10) NOT NULL default '', `user_agent` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`), UNIQUE KEY `torrent_3` (`torrent`,`unique_id`), KEY `torrent` (`torrent`), KEY `last_action` (`last_action`), KEY `torrent_2` (`torrent`,`seeder`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_pollanswers` -- CREATE TABLE `#prefix#_pollanswers` ( `id` int(10) unsigned NOT NULL auto_increment, `pollid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `selection` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`pollid`), KEY `selection` (`selection`), KEY `userid` (`userid`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_polls` -- CREATE TABLE `#prefix#_polls` ( `id` int(10) unsigned NOT NULL auto_increment, `added` datetime NOT NULL default '0000-00-00 00:00:00', `question` varchar(255) NOT NULL default '', `option0` varchar(40) NOT NULL default '', `option1` varchar(40) NOT NULL default '', `option2` varchar(40) NOT NULL default '', `option3` varchar(40) NOT NULL default '', `option4` varchar(40) NOT NULL default '', `option5` varchar(40) NOT NULL default '', `option6` varchar(40) NOT NULL default '', `option7` varchar(40) NOT NULL default '', `option8` varchar(40) NOT NULL default '', `option9` varchar(40) NOT NULL default '', `sort` enum('yes','no') NOT NULL default 'yes', PRIMARY KEY (`id`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_privacy_backup` -- CREATE TABLE `#prefix#_privacy_backup` ( `master` int(11) unsigned NOT NULL default '0', `slave` int(11) NOT NULL default '0', `torrent` int(11) NOT NULL default '0', `status` enum('pending','denied','granted') NOT NULL default 'pending', PRIMARY KEY (`slave`,`torrent`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_privacy_file` -- CREATE TABLE `#prefix#_privacy_file` ( `master` int(11) unsigned NOT NULL default '0', `slave` int(11) unsigned NOT NULL default '0', `torrent` int(15) unsigned NOT NULL default '0', `status` enum('pending','denied','granted') NOT NULL default 'pending', PRIMARY KEY (`slave`,`torrent`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_privacy_global` -- CREATE TABLE `#prefix#_privacy_global` ( `master` int(11) unsigned NOT NULL default '0', `torrent` int(11) NOT NULL default '0', `slave` int(11) unsigned NOT NULL default '0', `status` enum('blacklist','whitelist') NOT NULL default 'whitelist', PRIMARY KEY (`master`,`slave`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_private_messages` -- CREATE TABLE `#prefix#_private_messages` ( `id` int(20) unsigned zerofill NOT NULL auto_increment, `sender` int(11) unsigned NOT NULL default '0', `recipient` int(11) unsigned NOT NULL default '0', `subject` varchar(255) NOT NULL default '', `text` longtext NOT NULL, `is_read` enum('true','false') NOT NULL default 'false', `sent` datetime NOT NULL default '0000-00-00 00:00:00', `sender_del` enum('true','false') NOT NULL default 'false', `recipient_del` enum('true','false') NOT NULL default 'false', PRIMARY KEY (`id`), KEY `from` (`sender`), KEY `to` (`recipient`), FULLTEXT KEY `text` (`text`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_private_messages_blacklist` -- CREATE TABLE `#prefix#_private_messages_blacklist` ( `master` int(11) unsigned NOT NULL default '0', `slave` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`master`,`slave`), KEY `master` (`master`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_private_messages_bookmarks` -- CREATE TABLE `#prefix#_private_messages_bookmarks` ( `master` int(11) unsigned NOT NULL default '0', `slave` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`master`,`slave`), KEY `master` (`master`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_ratings` -- CREATE TABLE `#prefix#_ratings` ( `torrent` int(10) unsigned NOT NULL default '0', `user` int(10) unsigned NOT NULL default '0', `rating` tinyint(3) unsigned NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`torrent`,`user`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_ratiowarn` -- CREATE TABLE `#prefix#_ratiowarn` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(11) NOT NULL default '0', `warned` enum('yes','no') NOT NULL default 'no', `banned` enum('yes','no') NOT NULL default 'no', `ratiodate` datetime NOT NULL default '0000-00-00 00:00:00', `warntime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_ratiowarn_config` -- CREATE TABLE `#prefix#_ratiowarn_config` ( `name` varchar(255) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_requests` -- CREATE TABLE `#prefix#_requests` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `request` varchar(225) default NULL, `descr` text NOT NULL, `added` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(10) unsigned NOT NULL default '0', `cat` int(10) unsigned NOT NULL default '0', `filled` varchar(75) NOT NULL default '', `filledby` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `userid` (`userid`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_requist_config` -- CREATE TABLE `#prefix#_requist_config` ( `name` varchar(255) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_rules` -- CREATE TABLE `#prefix#_rules` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `text` tinytext NOT NULL, `public` enum('yes','no') NOT NULL default 'yes', `level` enum('user','premium','moderator','admin') NOT NULL default 'user', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_search_text` -- CREATE TABLE `#prefix#_search_text` ( `id` int(20) unsigned NOT NULL auto_increment, `text` varchar(25) NOT NULL default '', `hit` int(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `text` (`text`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_seeder_notify` -- CREATE TABLE `#prefix#_seeder_notify` ( `torrent` int(11) NOT NULL default '0', `user` int(11) NOT NULL default '0', `status` enum('active','stopped') NOT NULL default 'active', PRIMARY KEY (`torrent`,`user`), KEY `contacts` (`torrent`,`status`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_shouts` -- CREATE TABLE `#prefix#_shouts` ( `id` bigint(20) unsigned NOT NULL auto_increment, `user` int(10) unsigned NOT NULL default '0', `text` varchar(255) NOT NULL default '', `posted` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `anti_flood` (`user`,`text`), KEY `posted` (`posted`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_smiles` -- CREATE TABLE `#prefix#_smiles` ( `id` int(5) unsigned NOT NULL auto_increment, `code` varchar(15) NOT NULL default '', `file` varchar(30) NOT NULL default '', `alt` varchar(50) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_snatched` -- CREATE TABLE `#prefix#_snatched` ( `id` int(10) unsigned NOT NULL auto_increment, `torrent` int(10) unsigned NOT NULL default '0', `torrentid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `ip` bigint(20) unsigned NOT NULL default '0', `torrent_name` varchar(255) NOT NULL default '', `torrent_category` int(10) unsigned NOT NULL default '0', `port` smallint(5) unsigned NOT NULL default '0', `uploaded` bigint(20) unsigned NOT NULL default '0', `downloaded` bigint(20) unsigned NOT NULL default '0', `to_go` bigint(20) unsigned NOT NULL default '0', `speedup` bigint(20) unsigned NOT NULL default '0', `speeddown` bigint(20) unsigned NOT NULL default '0', `seeder` enum('yes','no') NOT NULL default 'no', `last_action` datetime NOT NULL default '0000-00-00 00:00:00', `startdat` datetime NOT NULL default '0000-00-00 00:00:00', `completedat` datetime NOT NULL default '0000-00-00 00:00:00', `connectable` enum('yes','no') NOT NULL default 'yes', `agent` varchar(60) NOT NULL default '', `finished` enum('yes','no') NOT NULL default 'no', PRIMARY KEY (`id`), UNIQUE KEY `torrentid_3` (`torrentid`,`userid`), KEY `finished` (`finished`,`torrentid`), KEY `torrentid` (`userid`), KEY `torrentid_2` (`torrentid`), KEY `userid` (`userid`,`torrentid`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_thanks` -- CREATE TABLE `#prefix#_thanks` ( `tid` bigint(10) NOT NULL auto_increment, `uid` bigint(10) NOT NULL default '0', `torid` bigint(10) NOT NULL default '0', `thank_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`tid`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_tickets` -- CREATE TABLE `#prefix#_tickets` ( `id` int(4) NOT NULL auto_increment, `user` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_torrents` -- CREATE TABLE `#prefix#_time_offset` ( `id` smallint(4) NOT NULL auto_increment, `name` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=721 ; CREATE TABLE `#prefix#_torrents` ( `id` int(15) unsigned NOT NULL auto_increment, `info_hash` varchar(20) character set latin1 collate latin1_bin default NULL, `md5sum` varchar(32) default NULL, `name` varchar(255) NOT NULL default '', `filename` varchar(255) NOT NULL default '', `save_as` varchar(255) NOT NULL default '', `search_text` text NOT NULL, `descr` text NOT NULL, `torrent_descr` text NOT NULL, `plen` bigint(6) unsigned NOT NULL default '0', `size` bigint(20) unsigned NOT NULL default '0', `category` int(10) unsigned NOT NULL default '0', `type` enum('single','multi','link') NOT NULL default 'single', `numfiles` int(10) unsigned NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', `exeem` varchar(250) default NULL, `dht` enum('yes','no') NOT NULL default 'no', `backup_tracker` enum('true','false') NOT NULL default 'false', `views` int(10) unsigned NOT NULL default '0', `downloaded` int(10) unsigned NOT NULL default '0', `completed` int(10) unsigned NOT NULL default '0', `banned` enum('yes','no') NOT NULL default 'no', `password` varchar(255) default NULL, `private` enum('true','false') NOT NULL default 'false', `min_ratio` float unsigned NOT NULL default '0', `visible` enum('yes','no') NOT NULL default 'yes', `evidence` tinyint(1) NOT NULL default '0', `owner` int(10) unsigned NOT NULL default '0', `ownertype` tinyint(1) unsigned NOT NULL default '0', `uploader_host` varchar(100) NOT NULL default '', `numratings` int(10) unsigned NOT NULL default '0', `ratingsum` int(10) unsigned NOT NULL default '0', `seeders` int(10) unsigned NOT NULL default '0', `leechers` int(10) unsigned NOT NULL default '0', `tot_peer` int(11) unsigned NOT NULL default '0', `speed` int(10) unsigned NOT NULL default '0', `comments` int(10) unsigned NOT NULL default '0', `complaints` char(3) NOT NULL default '0,0', `tracker` varchar(250) default NULL, `tracker_list` text, `tracker_update` datetime NOT NULL default '0000-00-00 00:00:00', `last_action` datetime NOT NULL default '0000-00-00 00:00:00', `nuked` enum('yes','no','unnuked') NOT NULL default 'no', `ratiobuild` enum('yes','no') NOT NULL default 'no', `nukereason` varchar(225) NOT NULL default '', `thanks` int(10) NOT NULL default '0', `imdb` varchar(225) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `info_hash` (`info_hash`), KEY `owner` (`owner`), KEY `visible` (`visible`), KEY `added` (`added`), KEY `seeders` (`seeders`), KEY `leechers` (`leechers`), KEY `tot_peer` (`tot_peer`), KEY `banned` (`banned`), KEY `password` (`password`), KEY `tracker` (`tracker`), KEY `evidence` (`evidence`), KEY `rating` (`numratings`,`ratingsum`), KEY `numfiles` (`numfiles`), KEY `downloaded` (`downloaded`), KEY `category` (`category`), KEY `type` (`type`), FULLTEXT KEY `ft_search` (`search_text`), FULLTEXT KEY `filename` (`filename`), FULLTEXT KEY `torrent_descr` (`torrent_descr`) ) TYPE=MyISAM PACK_KEYS=1 CHECKSUM=1; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_trackers` -- CREATE TABLE `#prefix#_trackers` ( `id` tinyint(5) unsigned NOT NULL auto_increment, `url` varchar(120) NOT NULL default '', `support` enum('selective','global','single') NOT NULL default 'selective', `status` enum('active','dead','blacklisted') NOT NULL default 'active', `updated` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `url` (`url`), KEY `update` (`updated`) ) TYPE=MyISAM ; -- -------------------------------------------------------- -- -- Table structure for table `#prefix#_users` -- CREATE TABLE `#prefix#_users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '', `clean_username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '', `name` varchar(50) default NULL, `email` varchar(255) character set utf8 collate utf8_bin NOT NULL default '', `regdate` datetime NOT NULL default '0000-00-00 00:00:00', `password` varchar(40) NOT NULL default '', `theme` varchar(255) default NULL, `language` varchar(15) default NULL, `avatar` varchar(255) NOT NULL default 'blank.gif', `accept_mail` enum('yes','no') NOT NULL default 'no', `aim` varchar(255) default NULL, `icq` varchar(10) default NULL, `jabber` varchar(255) default NULL, `msn` varchar(255) default NULL, `skype` varchar(255) default NULL, `yahoo` varchar(255) default NULL, `level` enum('user','premium','moderator','admin') NOT NULL default 'user', `uploaded` bigint(32) unsigned NOT NULL default '0', `downloaded` bigint(32) unsigned NOT NULL default '0', `active` tinyint(1) default '0', `ban` int(1) unsigned NOT NULL default '0', `act_key` varchar(32) default NULL, `passkey` varchar(32) default NULL, `newpasswd` varchar(40) default NULL, `banreason` varchar(255) default NULL, `lastip` int(10) unsigned NOT NULL default '0', `lasthost` varchar(255) NOT NULL default '', `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `rem` enum('yes','no') NOT NULL default 'no', `modcomment` varchar(225) NOT NULL default '', `warned` int(1) unsigned NOT NULL default '0', `warn_kapta` int(11) NOT NULL default '0', `warn_hossz` int(11) NOT NULL default '0', `invited_by` int(10) NOT NULL default '0', `invitees` varchar(100) NOT NULL default '', `country` int(10) NOT NULL default '0', `seedbox` int(10) unsigned NOT NULL default '0', `tzoffset` smallint(4) NOT NULL default '0', `can_shout` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true', `Show_online` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true', `invites` smallint(5) NOT NULL default '0', `invitedate` datetime NOT NULL default '0000-00-00 00:00:00', `seedbonus` decimal(10,1) NOT NULL default '0.0', `donated` int(5) unsigned NOT NULL default '0', `dondate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`), UNIQUE KEY `passkey` (`passkey`), KEY `lastip` (`lastip`), KEY `lasthost` (`lasthost`), KEY `date` (`regdate`) ) TYPE=MyISAM ;
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#54
|
||||
|
||||
Damn man, do you even sleep?
__________________
CLICK HERE FOR IMPORTANT NEWS FROM BVLIST!! "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." Ernest Hemingway. "A positive attitude will not solve all your problems, but it will annoy enough people to make it worth the effort." Herm Albright. |
#55
|
||||
|
||||
I am asleep
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#56
|
||||
|
||||
I see... lol :sleep::sleep: Me too, at work, as usual. lmao
__________________
CLICK HERE FOR IMPORTANT NEWS FROM BVLIST!! "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." Ernest Hemingway. "A positive attitude will not solve all your problems, but it will annoy enough people to make it worth the effort." Herm Albright. |
#57
|
|||
|
|||
cool i'll test it thx man
|
#58
|
||||
|
||||
phpMyBitTorrent going gold
do you think That phpMyBitTorrent is ready to go gold
I have made alot of updates and all the bug reports have stoped so I am taking it that there are no more bug's that can be found in testing mode?? Please let Me know what you think.....
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#59
|
||||
|
||||
i think so m8
|
#60
|
|||
|
|||
my english is very bad... who have russian translate?
|
Tags |
phpmybittorrent , v20 |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is phpMyBitTorrent | joeroberts | BT.Manager (phpMyBitTorrent) | 0 | 14th October 2009 15:43 |
phpMyBitTorrent 2.0.3 | joeroberts | BT.Manager (phpMyBitTorrent) | 54 | 21st September 2009 13:10 |
req phpmybittorrent | TheArcadeMaster | BT.Manager (phpMyBitTorrent) | 1 | 9th May 2009 06:33 |
What I Think Of phpMyBittorrent | dark_dragon | BT.Manager (phpMyBitTorrent) | 1 | 10th November 2008 07:43 |
phpMyBitTorrent v1.0 | zenja7777 | BT.Manager (phpMyBitTorrent) | 8 | 27th October 2008 17:58 |