phpMyBitTorrent v2.0

[joeroberts]

Beta 4 is now ready for down load at https://sourceforge.net/project/show...ease_id=632334

[piku2008]

There is the error on the sql part here is it

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'

tell me how to solve this :the3:

[joeroberts]

replace steup/sql/install-MySQL with this

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 ;

[Dragan3591]

Damn man, do you even sleep?

[joeroberts]

I am asleep

[Dragan3591]

I see... lol :sleep::sleep: Me too, at work, as usual. lmao

[movizdb]

cool i'll test it thx man

[joeroberts]

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.....

[Subzero]

i think so m8

[UnFeeLing]

my english is very bad... who have russian translate?