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:
|
The installation just went perfectly.... :ok:
I am just checking the integration options from the tracker control panel Starter issues seen: 1) Header logo is not seen on the main screen. 2) when i click on forums i get Code:
Warning: include(./tforum/html/index.php) [function.include]: failed to open stream: No such file or directory in /home/aikyam0/public_html/tforum/html/phpBB.php on line 289 and thus the main page to the forum should be linked to aikyam.org • Index page Also Joe please clarify why the does the forum point to /phpbb.php instead of index.php ? :s |
can you post content of tracker admin/forum settings??
you need to use the included phpBB3 folder for intergration as it is very much modded to work |
The admin/forum settings are as follows,
Forum Data Base Prefix phpbb Cookie Name phpbb3_k27c3 Forum Domain Aikyam - Where our family unites Forum Cookie Path / Cookie Time 3 Base Folder Your Forum Is in tforum/html Turn on Forum Share Ticked Turn on Auto Posting Ticked Post New Toppic In 2 Quote:
I will delete everything and try from start again if i am unable to link the forum from the torrent page..Is it not possible to do any edit on the header file for the links? |
Quote:
Forum Data Base Prefix phpbb this is right Cookie Name phpbb3_k27c3 this is ok Forum Domain Aikyam - Where our family unites Forum Cookie Path / Cookie Time 3 Base Folder Your Forum Is in tforum/html this is wayyy wrong it you want to do away with tracker index you can just leave blank Turn on Forum Share Ticked Turn on Auto Posting Ticked |
Looking good Joe :D
Managed to get it all installed, uploaded a torrent but I cannot seem to download it in order to Seed I just get a blank page! The torrent is in the DB and the torrents Dir and seems to be linking to the correct torrent id which being the first upload in 1. This is the only part I've found an issue with so far. Edit just noticed that I don't need to re-download the torrent, I presume the Passkey is not installed as yet? As in the setting I tick to use the Passkey but the setting does not save. Issues:- Font on Polls unreadable too small Torrent Search if no input string is entered receive this error Quote:
Viewing Forum Posts - Receive this error Quote:
|
give me a few let me clean and find errors
Quote:
SourceForge.net: Files Made some fixes fixed Ajax for being in sub folder fixed phpBB3 viewtopic for missplaced modd fixed web install for many errors fixed ajax pm notice fixed minor lay out problems fixed minor sql error |
Testing now.
One issue is that until you change your 'Complete Name' in your Profile the Who's Online always shows you as your email address. |
Quote:
|
I could have sworn I entered my username in the username field? Will check it out further.
Upon logging out and then logging in I get redirected to a blank page http://xxxxxxxxxxx/user.php?returnto=/index.php Download still returns a blank page http://xxxxxxxxxxxx/download.php?id=1 Edit Torrent still does not load the complete page http://img258.imageshack.us/img258/4717/86093338at7.png BBCodes do not show on torrent details page it appears as :thankyou: instead of the graphical representation. |
Quote:
|
thz a lot for this great script :).i love it
|
This is what I have:-
Site Name: Test Site Site URL: http://www.xxxxx.com Cookie Domain: http://www.xxxxx.com Cookie Path: Administrator E-Mail: myemailaddress Cookie Path is empty as am testing the code in the root dir. |
cookie Domain is with out http://
|
i fund some bugs
when using imdb mod to add data Code:
IMDB INFO Code:
Error executing SQL Query INSERT INTO torrent_torrents (info_hash, name, filename, save_as, md5sum, search_text, descr, size, plen, category, type, numfiles, added, exeem, dht, backup_tracker, views, downloaded, completed, banned, password, visible, evidence, owner, ownertype, uploader_host, numratings, ratingsum, seeders, leechers, tot_peer, speed, comments, complaints, tracker, tracker_list, tracker_update, last_action, imdb) VALUES ('?`,?jC???????', 'XXX 2 The Next Level KLAXXON [mininova]', 'XXX 2 The Next Level KLAXXON', 'XXX 2 The Next Level KLAXXON [mininova]', '17dc4ee747f8d388ecaed3342d26e963', 'XXX 2 The Next Level KLAXXON [mininova] XXX 2 The Next Level KLAXXON xxx 2 KLAXXON.nfo 271 XXX 2 The Next Level KLAXXON.avi 1079214080 ', 'xxx 2', '1079214351', '65536', '1', 'multi', '2', NOW(), '', 'no', 'false', '0', '0', '1350', 'no', NULL, 'no', '0', '2', '0', '59.92.36.85', '0', '0', '117', '187', '304', '0', '0', '0,0', 'http://vip.tracker.thepiratebay.org:80/announce', 'http://vip.tracker.thepiratebay.org:80/announce http://tracker4.finalgear.com:80/announce http://vtv.tracker.prq.to:80/announce http://tracker.prq.to:80/announce', NOW(), NOW(), ''); Code:
Warning: require_once(admin/files/offres_config.php) [function.require-once]: failed to open stream: No such file or directory in /home/public_html/admin.php on line 129 plz help :) sorry if the above detail is confusing iam using v2beta2 |
Quote:
|
Quote:
Quote:
Quote:
Quote:
|
Quote:
STill unable to use the download torrent or edit torrent options, plus once I log out I cannot log back in again! I have to remove this part fropm the URL to be able to login user.php?returnto=/index.php EDIT: I can edit torrents if I Disable 'Use HTML Editor' in the Site Settings No Option available to UnSticky a Torrent. |
where are you trying to login from that well not log you In and that you have to remove
Code:
user.php?returnto=/index.php Quote:
Quote:
Quote:
Quote:
|
Quote:
|
can you open
user.php and find Code:
header("Refresh: 0; url=".$siteurl."/user.php?op=loginconfirm&returnto=".$returnto); and replace it with Code:
header("Location: ".$siteurl."/user.php?op=loginconfirm&returnto=".$returnto); Code:
header("Refresh: 3; url=" . $returnto); replace with Code:
echo ""; |
Thanks Joe, but still the same I'm afraid.
|
Quote:
|
Private Tracker Mode is Enabled.
|
phpMyBitTorrentV2.0 Beta3
we are now moving in to beta3 testing with any luck we have got all the errors straight that have been posted here and look forward to finding more and getting them fixed!!
you can get your copy now here https://sourceforge.net/project/show...kage_id=203349 |
Reinstalled with latest version and when I log in I get logged straight back out again!
|
Quote:
|
looking into this now dose any one have a link I can fallow to test this? please pm it to me
|
Quote:
|
Quote:
|
Quote:
|
All times are GMT +2. The time now is 22:42. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.