phpMyBitTorrent v2.0
PMBT v2
You must creat an account there to see the full system. If you would like a look at the admin panel you must pm a admin there and let them know so that they can change you permission. this is the change log .::phpMyBitTorrent Change log::. you may now down load for beta testing PMBT2.0 beta from sourceforge At This link phpMyBitTorrent-V2.0 Please test and let me know of any error's only We well work on changes at a later time and New Themes well come shortly. Welcome to phpMyBitTorrent! phpMyBitTorrent is the brand new Open Source solution for BitTorrent communities! phpMyBitTorrent is not just a simple tracker like the ones you see around. It has so many amazing features that it cannot be called simply a "Tracker". In fact, it is a BMS (Bittorrent Management System), something like a BitTorrent-oriented Content Management System. Some points to convince you of phpMyBitTorrent's supremacy: phpMyBitTorrent is Free Software! phpMyBitTorrent is Open Source Software, distributed under the GNU/GPL license. This means that the code is open for scrutiny by anyone, and anybody can join in the development effort. phpMyBitTorrent is easy! phpMyBitTorrent is provided with full documentation to help you install it step by step in no time, even if you've never heard of PHP/MySQL. When you start phpMyBitTorrent, you'll discover help system based on OverLib and image-popups. Just point the mouse over the "Info" icon and read what the item in question is about, and how to use it. phpMyBitTorrent is up-to-date! phpMyBitTorrent supports all the latest BitTorrent Protocol Extensions, including Compact Announce, MultiScrape, DHT, Peer Count, Tracker ID, Unique Peer ID, Backup Tracker, etc. phpMyBitTorrent is not only BitTorrent! There are many ways other than BitTorrent to share your files. GNutella, Direct Connect, eDonkey are some of them. ed2k and Magnet URIs are automatically generated for all files in a torrent, and are presented as alternate Links. You can also allow users to submit Magnet and ed2k links without a torrent. phpMyBitTorrent has low requirements! All you need is some webspace with PHP and a MySQL database to start building your File-Sharing Community. phpMyBitTorrent is secure! Stop leechers from downloading more than their share! Choose who can download your files and who can't. See who is downloading your Torrent and who is helping you share it. Define rules to avoid annoyance by Download Requests. Choose friends and foes. Keep your anonymity. And that's just the tip of the iceberg.... phpMyBitTorrent is easy on the eye! You can choose your personal theme that reflects your style, choose your avatar displayed next to comments you make phpMyBitTorrent is fast! phpMyBitTorrent uses the minimum number of code lines required to do all the amazing things it does. Memory usage is low because every single variable is deleted when not needed any more. phpMyBitTorrent is easy to m0d! If you know some PHP, you will find incredibly easy to add new features to phpMyBitTorrent. Just include the header and footer pages at the beginning and end of your script, and you'll be able to access all phpMyBitTorrent incredible code layer with basic functions for theming, database access and Torrent encoding. |
great news joe, the new tracker theme looks great ;-)
|
Quote:
|
Don`t forget this is still BETA, joe is working hard to release the final version as soon as posible
Please report if you find any problems ! |
Quote:
Starting with the sql queries during the intial setup of the torrent database i faced with query issues in Step 5 (like torrent_global_galaxy - column not found issues) I removed them(those lines) from the setup sql 5.php file and continued with the installation but i couldnt proceed anymore after 5.php..But i guess after After that i installed phpbb3 which dint have any issues...except for the issue that i couldnt merge it with the same database prefix as the system didnt except an installation with the same database prefix..But i inserted the phpbb3 into the same database table but with different table prefix ( i think i might have login issues using the same username with the torrent page and the forum) Then i took /admin.php where i could see the torrent page but i cant seem to find/login with the admin username and password(Need help here). So i registered like a user and i seem to login properly after the email verification. Well the torrent site is sort of setup but i feelthe integration isnt still complete as i believe everyone at phpBB would want a tracker MOD(like a add-on) rather than a complete tracker+phpbb installation to be done. But the start is a good one :friend: Demo: www.aikyam.org |
Quote:
Quote:
Quote:
|
Quote:
After reading your comments i just tried reloading the setup files and folder back through my ftp and rerun the setup...this time around...i could finish all the steps...last time around i was stuck in step 5 and couldnt add the administrator username and password...This time around i succeeded...But i dint do anything different :blink: Okay i shall try to delete the entire mysql tables later today and i shall rerun from the beginning...I have a strange feeling it has run properly maybe because the phpbb3 is installed...Because the only different thing that has happened now is the installation of phpbb3 whereas in the first trial i had installed the bittorrent setup and then run the phpbb3 installation.. But i shall confirfm the same and report :hi: N.B. : Also I am able to login into the admin now... But can you tell me even after entering the phpBB integration options and i click on forums it goes to phpMyBitTorrent and not http://aikyam.org/tforum/html/phpBB3/index.php Any reasons or where i can update the settings? Hey Joe, -------------------------------------------------------------------- EDITED : I tried to delete the tables from phpmyadmin and started the installer setup again and these are the errors that followed ( the same ones that i got during my first initial tracker setup... Code:
Notice: Undefined variable: sub_rewrite_engine in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 343 ----------------------------------------------------------------------- Code:
Error executing SQL Query This was the error i was speaking about...Now what i did in my first setup was that i removed the lines from thes step5 of whatever contained the torrent_complains field so that i could go ahead with the rest of the installation... BUt then the next error came torrent_global_privacy which again i tried to edit but couldnt let me forward to the next step...so i stopped my installation there and continued to my phpBB3 setup (as it mentions that i could setup these within my admin tracker options) Maybe if Joe can start helping in the bugging from here itself i could hold on with the installation... :drink: |
what language are you using? need you to try these new files please 5.php Code:
/* |
"._basicsettings." | ||
| ||
| ||
| ||
| ||
"._advancedsettings." | ||
| ||
|
"._step5."
\n";\n";
";
echo "";
echo _btsqlerror1."\n";
echo "" ;
echo _btsqlerror2.$err["code"];
echo "";
echo _btsqlerror3.$err["message"];
echo "
"._step5explain."
\n";\n";
"._step5complete."
";"._step5."
\n";\n";
"._step5explain."
\n";\n";
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_casino_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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',
`#prefix#_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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 `#prefix#_2` (`torrent`,`filename`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_lottery_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_offres_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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) character set latin1 collate latin1_bin 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 `#prefix#_peer_id` (`torrent`,`peer_id`),
UNIQUE KEY `#prefix#_3` (`torrent`,`unique_id`),
KEY `torrent` (`torrent`),
KEY `last_action` (`last_action`),
KEY `#prefix#_2` (`torrent`,`seeder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_ratiowarn_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_requist_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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',
`#prefix#_name` varchar(255) NOT NULL default '',
`#prefix#_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_tickets` (
`id` int(4) NOT NULL auto_increment,
`user` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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;
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,
`#prefix#_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 `#prefix#_descr` (`#prefix#_descr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_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',
`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;
I have changed both the files and now i get at step 5 the following errors,
Code:
Notice: Undefined variable: sub_rewrite_engine in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 343 Code:
Error executing SQL Query Quote:
Checking PHP Version - 5.2.6 - OK Checking Zlib - OK Checking MySQL - OK - 5.0.51a Checking installed DOM XML - OK Testing outgoing connections - OK Checking Operating System - Linux I use Mysql database and have used the setting Mysql >= 4.1 in Step 3 |
ok lets try this first make tracker prefix (leave it torrent) if it is not set or is something else do not add underscore here (_) and the forum well be phpbb
second is my fault replase step 5.php (I posted wrong one) with PHP Code:
|
All times are GMT +2. The time now is 23:51. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.