[ppkBB3cker] Help with installation of tracker on modded phpBB3 site

[HerzeleidMeister]

Hello, I need help on installing the tracker on a modded phpBB3 site. Obviously I do not speak Russian so this causes a slight problem in finding information here on the site for me. My site already has many mods installed on it and I do not want to over write any files of my current phpBB3 forum because it may break my other mods that are in place. I'm good with code, I do it for a living so if I have to put in a little bit of work to get it to work that is fine, but I need to know how to install it first. I have downloaded what I think is a copy of the tracker mod, but it looks like there are some phpBB3 files integrated into it. I need to know what file edits to do so I do not have to overwrite any files. What I downloaded did not include a install.xml file, I cannot find it, so I either got the wrong thing or I'm missing something. I downloaded it from here: Re: ppkBB3cker v.2 - текущие версии. If that is wrong please point me to the clean install download. Any help would be great, thanks.

[PPK]

1. трекера в виде мода или инструкции по установке не существует
2. для трекера есть только русская локализация
Если вам нужно установить этот мод на форум с уже установленными модами можно:
1. установить его "вручную", т.е. сравнивать файлы и вручную вносить правки, потом выполнить для базы данных недостающие sql запросы
2. подождать выхода phpbb 3.1, обновиться до него и после выхода мода для трекера для этой версии - установить мод

1. tracker as a mod or installation instructions does not exist
2. tracker has only russian localization
If you need to install this mod on the forum with already installed mods, you can:
1. to install it "manually", ie compare files and manually make changes, and then perform a database missing sql queries
2. wait for the phpbb 3.1, upgrade to it and after the creation of mod for the tracker for this version - to install a mod

[HerzeleidMeister]

1. install it "manually", ie compare files and manually make changes, and then perform a database sql queries missing

What are the database queries I need to perform?

The other stuff I can handle.

[PPK]

позже напишу ..

I will write later ..

[PPK]

для phpBB 3.0.12, ppkBB3cker free v.2 обновление 47, mysql не ниже 4.1, sql запросы структуры базы данных (sql запросы для внесения данных сделаю позже):

Код: Выделить всё

ALTER TABLE `phpbb_attachments` 
 ADD `i_width` smallint(4) unsigned NOT NULL DEFAULT '0',
 ADD `i_height` smallint(4) unsigned NOT NULL DEFAULT '0',
 ADD `i_poster` tinyint(1) unsigned NOT NULL DEFAULT '0',
 ADD `i_external` tinyint(3) unsigned NOT NULL DEFAULT '0',
 ADD KEY `i_poster` (`i_poster`);

ALTER TABLE `phpbb_forums` 
 ADD `forumas` tinyint(1) unsigned NOT NULL DEFAULT '0',
 ADD `forum_torrents` mediumint(8) unsigned NOT NULL DEFAULT '0',
 ADD `forum_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
 ADD `forum_subforumslist_type` tinyint(4) DEFAULT '0',
 ADD `forum_first_post_show` tinyint(1) unsigned NOT NULL DEFAULT '0',
 ADD `similar_topic_forums` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 ADD `forum_addfields` smallint(5) unsigned NOT NULL DEFAULT '0';

CREATE TABLE IF NOT EXISTS `phpbb_portal_config` (
  `config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `config_value` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_portal_modules` (
  `module_id` int(3) unsigned NOT NULL AUTO_INCREMENT,
  `module_classname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `module_column` tinyint(3) NOT NULL DEFAULT '0',
  `module_order` tinyint(3) NOT NULL DEFAULT '0',
  `module_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `module_image_src` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `module_image_width` int(3) NOT NULL DEFAULT '0',
  `module_image_height` int(3) NOT NULL DEFAULT '0',
  `module_group_ids` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `module_status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`module_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_ppkchat_messages` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `message` varchar(255) COLLATE utf8_bin NOT NULL,
  `user_id` bigint(10) NOT NULL DEFAULT '0',
  `to_user` bigint(10) NOT NULL DEFAULT '0',
  `date` int(11) unsigned NOT NULL DEFAULT '0',
  `rights` varchar(255) COLLATE utf8_bin NOT NULL,
  `room` smallint(5) unsigned NOT NULL DEFAULT '0',
  `username` varchar(255) COLLATE utf8_bin NOT NULL,
  `user_color` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_ip` int(11) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `room` (`room`),
  KEY `to_user` (`to_user`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_ppkchat_users` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_bin NOT NULL,
  `rights` varchar(255) COLLATE utf8_bin NOT NULL,
  `lastpost` int(11) unsigned NOT NULL DEFAULT '0',
  `room` smallint(5) unsigned NOT NULL DEFAULT '0',
  `lastaccess` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(10) NOT NULL DEFAULT '0',
  `chatkey` varchar(32) COLLATE utf8_bin NOT NULL,
  `user_color` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_hidden` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `user_ip` int(11) unsigned NOT NULL DEFAULT '0',
  `user_lang` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_timezone` decimal(5,2) NOT NULL DEFAULT '0.00',
  `user_dst` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `user_dateformat` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
  `session_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `room` (`room`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE `phpbb_topics` 
 ADD `topic_first_post_show` tinyint(1) unsigned NOT NULL DEFAULT '0',
 ADD KEY `topic_first_post_id` (`topic_first_post_id`),
 ADD KEY `topic_last_post_id` (`topic_last_post_id`),
 ADD FULLTEXT KEY `topic_title` (`topic_title`);

CREATE TABLE IF NOT EXISTS `phpbb_tracker_afftpl` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `addfields` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_hlp` mediumtext COLLATE utf8_bin NOT NULL,
  `addfields_br` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_br2` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_inall` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `addfields_ta` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `addfields_multi` tinyint(1) NOT NULL DEFAULT '0',
  `addfields_bbcode` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_bbcodes` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_descr` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_enable` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `addfields_split` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `af_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `addfields_def` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_checkas` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addfields_alias` mediumtext COLLATE utf8_bin NOT NULL,
  `addfields_skip` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `addfields_exists` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `addfields` (`addfields`),
  KEY `addfields_enable` (`addfields_enable`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_afsets` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `af_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `af_name` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `af_count` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `af_order` smallint(3) unsigned NOT NULL DEFAULT '0',
  `af_required` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `af_id` (`af_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_aftpl` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `af_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `af_descr` text COLLATE utf8_bin NOT NULL,
  `af_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `af_data` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_config` (
  `config_name` varchar(255) COLLATE utf8_bin NOT NULL,
  `config_value` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_cron` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `data` text COLLATE utf8_bin NOT NULL,
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `added` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_downloads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `downloader_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `dl_time` int(11) unsigned NOT NULL DEFAULT '0',
  `dl_ip` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `attach_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `post_msg_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `guests` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `downloader_attach_id` (`downloader_id`,`attach_id`),
  KEY `post_msg_id` (`post_msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_files` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `filename` text COLLATE utf8_bin NOT NULL,
  `size` bigint(20) unsigned NOT NULL DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_guests` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_passkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_ip` int(11) unsigned NOT NULL DEFAULT '0',
  `user_time` int(11) unsigned NOT NULL DEFAULT '0',
  `user_last_time` int(11) unsigned NOT NULL DEFAULT '0',
  `session_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `unreg` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`),
  KEY `user_passkey` (`user_passkey`),
  KEY `session_id` (`session_id`),
  KEY `unreg` (`unreg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_peers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `torrent` int(10) unsigned NOT NULL DEFAULT '0',
  `peer_id` binary(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `ip` int(11) 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',
  `startdat` int(11) unsigned NOT NULL DEFAULT '0',
  `last_action` int(11) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `rights` varchar(64) COLLATE utf8_bin NOT NULL,
  `guests` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `seeder` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `connectable` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `agent` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `torrent` (`torrent`),
  KEY `userid` (`userid`),
  KEY `ip` (`ip`),
  KEY `seeder` (`seeder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_rannounces` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `torrent` int(10) unsigned NOT NULL DEFAULT '0',
  `tracker` int(11) unsigned NOT NULL DEFAULT '0',
  `next_announce` int(11) unsigned NOT NULL DEFAULT '0',
  `next_scrape` int(11) unsigned NOT NULL DEFAULT '0',
  `a_message` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `s_message` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `err_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `a_interval` mediumint(6) unsigned NOT NULL DEFAULT '0',
  `seeders` int(10) unsigned NOT NULL DEFAULT '0',
  `leechers` int(10) unsigned NOT NULL DEFAULT '0',
  `times_completed` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `tracker` (`tracker`,`torrent`),
  KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_rtrack` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `zone_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rtrack_url` text COLLATE utf8_bin NOT NULL,
  `rtrack_user` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `rtrack_remote` tinyint(1) NOT NULL DEFAULT '0',
  `torrent` int(10) unsigned NOT NULL DEFAULT '0',
  `rtrack_forb` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `rtrack_enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `forb_type` enum('r','s','i') COLLATE utf8_bin NOT NULL DEFAULT 's',
  PRIMARY KEY (`id`),
  KEY `zone_id` (`zone_id`),
  KEY `rtrack_user` (`rtrack_user`),
  KEY `torrent` (`torrent`),
  KEY `rtrack_enabled` (`rtrack_enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_snatched` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `torrent` int(10) 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',
  `last_action` int(11) unsigned NOT NULL DEFAULT '0',
  `startdat` int(11) unsigned NOT NULL DEFAULT '0',
  `completedat` int(11) unsigned NOT NULL DEFAULT '0',
  `finished` smallint(5) unsigned NOT NULL DEFAULT '0',
  `bonus_count` bigint(20) unsigned NOT NULL DEFAULT '0',
  `guests` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `uploadoffset` bigint(20) unsigned NOT NULL DEFAULT '0',
  `downloadoffset` bigint(20) unsigned NOT NULL DEFAULT '0',
  `prev_action` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `torrent` (`torrent`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_statuses` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `status_id` tinyint(2) NOT NULL,
  `status_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `status_mark` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `def_forb` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `def_notforb` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `author_candown` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `status_enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `newtorrents_freeze` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`status_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_thanks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `torrent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `to_user` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `tadded` int(11) unsigned NOT NULL DEFAULT '0',
  `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`torrent_id`),
  KEY `to_user` (`to_user`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_tracker_torrents` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `post_msg_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `info_hash` binary(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `numfiles` int(10) unsigned NOT NULL DEFAULT '0',
  `times_completed` int(10) unsigned NOT NULL DEFAULT '0',
  `leechers` int(10) unsigned NOT NULL DEFAULT '0',
  `seeders` int(10) unsigned NOT NULL DEFAULT '0',
  `size` bigint(20) unsigned NOT NULL DEFAULT '0',
  `free` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `upload` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `forb` tinyint(2) NOT NULL DEFAULT '0',
  `forb_user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forb_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forb_date` int(11) unsigned NOT NULL DEFAULT '0',
  `added` int(11) unsigned NOT NULL DEFAULT '0',
  `req_upload` bigint(20) unsigned NOT NULL DEFAULT '0',
  `req_ratio` decimal(6,3) unsigned NOT NULL DEFAULT '0.000',
  `private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `tsl_speed` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ip` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
  `unreg` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `lastseed` int(11) unsigned NOT NULL DEFAULT '0',
  `lastleech` int(11) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `lastcleanup` int(11) unsigned NOT NULL DEFAULT '0',
  `rem_seeders` int(11) unsigned NOT NULL DEFAULT '0',
  `rem_leechers` int(11) unsigned NOT NULL DEFAULT '0',
  `rem_times_completed` int(11) unsigned NOT NULL DEFAULT '0',
  `lastremote` int(11) unsigned NOT NULL DEFAULT '0',
  `thanks` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `info_hash` (`info_hash`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_msg_id` (`post_msg_id`),
  KEY `forb` (`forb`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE  `phpbb_users` 
 ADD `user_passkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
 ADD `user_uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
 ADD `user_downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
 ADD `user_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
 ADD `user_torrents` mediumint(8) unsigned NOT NULL DEFAULT '0',
 ADD `user_bonus` decimal(6,3) unsigned NOT NULL DEFAULT '0.000',
 ADD `user_shadow_downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
 ADD `user_chatkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
 ADD  `user_tracker_data` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
 ADD `user_tracker_options` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
 ADD `user_fromthanks_count` smallint(5) unsigned NOT NULL DEFAULT '0',
 ADD `user_tothanks_count` smallint(5) unsigned NOT NULL DEFAULT '0',
 ADD `user_uploaded_self` bigint(20) unsigned NOT NULL DEFAULT '0',
 ADD KEY `user_passkey` (`user_passkey`),
 ADD KEY `user_chatkey` (`user_chatkey`);

for phpBB 3.0.12, ppkBB3cker free v.2 update 47, mysql not lower than 4.1, sql queries of the database structure (sql queries for data entry will do later)

Добавлено спустя 19 часов 29 минут 16 секунд:
для phpBB 3.0.12, ppkBB3cker free v.2 обновление 47, mysql не ниже 4.1, sql запросы данных:

for phpBB 3.0.12, ppkBB3cker free v.2 update 47, mysql is not below 4.1, sql data requests

Код: Выделить всё

INSERT INTO phpbb_config (`config_name`, `config_value`, `is_dynamic`) VALUES
('cgp_cache_gc', '7200', 0),
('cgp_cache_last_gc', '0', 1),
('cgp_enabled', '0', 0),
('cgp_force_fcache', '1', 0),
('cgp_multi_styles', '0', 0),
('cgp_remove_sid', '1', 0),
('cgp_ttl', '720', 0),
('cgp_version', '1.1.2', 0),
('similar_topics_limit', '5', 0),
('similar_topics', '0', 0),
('similar_topics_hide', '', 0),
('similar_topics_ignore', '', 0),
('similar_topics_type', 'y', 0),
('similar_topics_time', '31536000', 0),
('similar_topics_cache', '3600', 0),
('similar_topics_words', '', 0),
('similar_topics_version', '1.1.6', 0),
('allow_quick_reply_bbcode', '1', 0),
('allow_quick_reply_smilies', '1', 0),
('num_torrents', '0', 1),
('num_comments', '0', 1),
('ppkbb_last_dtad', '0', 1),
('ppkbb_chat_last_cleanup', 0, 1),
('ppkbb_tracker_last_cleanup', 0, 1),
('ppkbb_gtracker_last_cleanup', 0, 1),
('ppkbb_cron_last_cleanup', 0, 1),
('ppkbb_newversion_lastcheck', 0, 1),
('ppkbb_total_peers_size', '', 1),
('ppkbb_total_up_down', '', 1),
('ppkbb_total_sup_sdown', '', 1),
('ppkbb_total_seed_leech', '', 1),
('ppkbb_total_tdown_tup', '', 1),
('ppkbb_total_udown_uup', '', 1),
('ppkbb_total_speedup_speeddown', '', 1),
('ppkbb_last_stattime', '0', 1),
('ppkbb_total_thanks_seedreq', '', 1),
('cgp_places', '', 0);

INSERT INTO phpbb_config (`config_name`, `config_value`, `is_dynamic`) VALUES
('board3_portal_version', '2.0.2', 0),
('board3_enable', '1', 0),
('board3_left_column', '1', 0),
('board3_right_column', '1', 0),
('board3_version_check', '0', 0),
('board3_forum_index', '1', 0),
('board3_left_column_width', '180px', 0),
('board3_right_column_width', '180px', 0),
('board3_phpbb_menu', '1', 0),
('board3_display_jumpbox', '1', 0),
('board3_menu_1', '', 0),
('board3_menu_url_new_window_1', '0', 0),
('board3_birthdays_ahead_3', 'portal_birthdays_ahead', 0),
('board3_clock_src_4', 'board3clock.swf', 0),
('board3_attachments_number_6', '8', 0),
('board3_attach_max_length_6', '15', 0),
('board3_attachments_forum_ids_6', '', 0),
('board3_attachments_forum_exclude_6', '0', 0),
('board3_attachments_filetype_6', '', 0),
('board3_attachments_exclude_6', '0', 0),
('board3_topposters_7', '8', 0),
('board3_max_last_member_8', '8', 0),
('board3_welcome_message_10', '', 0),
('board3_welcome_message_uid_10', '', 0),
('board3_welcome_message_bitfield_10', '', 0),
('board3_max_topics_11', '10', 0),
('board3_recent_title_limit_11', '100', 0),
('board3_recent_forum_11', '', 0),
('board3_recent_exclude_forums_11', '1', 0),
('board3_announcements_style_12', '1', 0),
('board3_number_of_announcements_12', '1', 0),
('board3_announcements_day_12', '0', 0),
('board3_announcements_length_12', '200', 0),
('board3_global_announcements_forum_12', '', 0),
('board3_announcements_forum_exclude_12', '0', 0),
('board3_announcements_archive_12', '1', 0),
('board3_announcements_permissions_12', '1', 0),
('board3_show_announcements_replies_views_12', '1', 0),
('board3_news_length_13', '250', 0),
('board3_news_forum_13', '', 0),
('board3_news_permissions_13', '1', 0),
('board3_number_of_news_13', '5', 0),
('board3_show_all_news_13', '1', 0),
('board3_news_exclude_13', '0', 0),
('board3_news_archive_13', '1', 0),
('board3_news_show_last_13', '0', 0),
('board3_show_news_replies_views_13', '1', 0),
('board3_news_style_13', '1', 0),
('board3_poll_allow_vote_14', '1', 0),
('board3_poll_topic_id_14', '', 0),
('board3_poll_exclude_id_14', '0', 0),
('board3_poll_hide_14', '0', 0),
('board3_poll_limit_14', '3', 0),
('board3_user_menu_register_16', '1', 0),
('board3_sunday_first_18', '0', 0),
('board3_calendar_today_color_18', '#000000', 0),
('board3_calendar_sunday_color_18', '#FF0000', 0),
('board3_long_month_18', '1', 0),
('board3_display_events_18', '0', 0),
('board3_events_18', '', 0),
('board3_events_url_new_window_18', '0', 0),
('board3_leaders_ext_19', '1', 0),
('board3_last_visited_bots_number_20', '1', 0),
('board3_links_21', '', 0),
('board3_links_url_new_window_21', '0', 0),
('board3_ppk_chat_number_22', '1', 0),
('board3_ppk_ltorrents_number_23', '1', 0),
('board3_ppk_trstats_number_24', '1', 0),
('board3_ppk_topdown_torrents_number_25', '1', 0);

INSERT INTO phpbb_portal_modules (`module_id`, `module_classname`, `module_column`, `module_order`, `module_name`, `module_image_src`, `module_image_width`, `module_image_height`, `module_group_ids`, `module_status`) VALUES
(1, 'main_menu', 1, 1, 'M_MENU', 'portal_menu.png', 16, 16, '', 1),
(2, 'stylechanger', 1, 2, 'BOARD_STYLE', 'portal_style.png', 16, 16, '', 1),
(3, 'birthday_list', 1, 3, 'BIRTHDAYS', 'portal_birthday.png', 16, 16, '', 1),
(4, 'clock', 1, 4, 'CLOCK', 'portal_clock.png', 16, 16, '', 1),
(5, 'search', 1, 5, 'PORTAL_SEARCH', 'portal_search.png', 16, 16, '', 1),
(6, 'attachments', 1, 7, 'PORTAL_ATTACHMENTS', 'portal_attach.png', 16, 16, '', 1),
(7, 'topposters', 1, 8, 'TOPPOSTERS', 'portal_top_poster.png', 16, 16, '', 1),
(8, 'latest_members', 1, 9, 'LATEST_MEMBERS', 'portal_members.png', 16, 16, '', 1),
(9, 'link_us', 1, 10, 'LINK_US', 'portal_link_us.png', 16, 16, '', 1),
(10, 'welcome', 2, 1, 'PORTAL_WELCOME', '', 16, 16, '', 1),
(11, 'recent', 2, 2, 'PORTAL_RECENT', '', 16, 16, '', 1),
(12, 'announcements', 2, 3, 'GLOBAL_ANNOUNCEMENTS', '', 16, 16, '', 1),
(13, 'news', 2, 4, 'LATEST_NEWS', '', 16, 16, '', 1),
(14, 'poll', 2, 6, 'PORTAL_POLL', 'portal_poll.png', 16, 16, '', 1),
(15, 'whois_online', 2, 7, 'PORTAL_WHOIS_ONLINE', '', 16, 16, '', 1),
(16, 'user_menu', 3, 1, 'USER_MENU', 'portal_user.png', 16, 16, '', 1),
(17, 'statistics', 3, 2, 'STATISTICS', 'portal_statistics.png', 16, 16, '', 1),
(18, 'calendar', 3, 3, 'PORTAL_CALENDAR', 'portal_calendar.png', 16, 16, '', 1),
(19, 'leaders', 3, 4, 'THE_TEAM', 'portal_team.png', 16, 16, '', 1),
(20, 'latest_bots', 3, 5, 'LATEST_BOTS', 'portal_bots.png', 16, 16, '', 1),
(21, 'links', 3, 6, 'PORTAL_LINKS', 'portal_links.png', 16, 16, '', 1),
(22, 'ppkbb3cker_chat', 4, 1, 'PPKBB3CKER_CHAT', '', 0, 0, '', 1),
(23, 'ppkbb3cker_ltorrents', 2, 5, 'PPKBB3CKER_LTORRENTS', '', 0, 0, '', 1),
(24, 'ppkbb3cker_trstats', 3, 7, 'PPKBB3CKER_TRSTATS', 'portal_statistics.png', 16, 16, '', 1),
(25, 'ppkbb3cker_topdown_torrents', 2, 8, 'PPKBB3CKER_TOPDOWN_TORRENTS', 'portal_link_us.png', 16, 16, '', 1);

INSERT INTO phpbb_tracker_config (`config_name`, `config_value`) VALUES
('ppkbb_forb_extpostscr', ''),
('ppkbb_forb_extpostscr_trueexclude', '1'),
('ppkbb_index_chat2', '0'),
('ppkbb_topdown_torrents_options', ''),
('ppkbb_addfields_type', '0 1'),
('ppkbb_deadtorrents_autodelete', '0'),
('ppkbb_chat_enable_magicurl', '0'),
('ppkbb_tcignored_upload', '0'),
('ppkbb_tccheck_fext', '0'),
('ppkbb_tcannounce_interval', '1800'),
('ppkbb_tcbonus_fsize', '700'),
('ppkbb_tcminannounce_interval', '1800'),
('ppkbb_tccleanup_interval', '3600'),
('ppkbb_tcdead_time', '1900'),
('ppkbb_tcbonus_value', '-1'),
('ppkbb_tcwait_time', ''),
('ppkbb_tcrights_tcache', '3600'),
('ppkbb_tcmax_seed', '0'),
('ppkbb_tcmax_leech', '0'),
('ppkbb_tcmaxpeers_limit', '50'),
('ppkbb_tcignore_connectable', '1'),
('ppkbb_tctracker_disabled', '0'),
('ppkbb_tcclean_place', '1 2 3 4'),
('ppkbb_tccheck_ban', '1'),
('ppkbb_tcmaxpeers_rewrite', '0'),
('ppkbb_tcratio_start', '0'),
('ppkbb_tcmaxleech_restr', ''),
('ppkbb_tcwait_time2', ''),
('ppkbb_tcmaxip_pertorr', '0'),
('ppkbb_tcmaxip_pertr', '0'),
('ppkbb_tcgz_rewrite', '0'),
('ppkbb_tczones_enable', '0'),
('ppkbb_tcclients_restricts', '0 0 0'),
('ppkbb_tcguests_enabled', '1 1'),
('ppkbb_tcenable_rannounces', '1 1 1 1 1'),
('ppkbb_tcrannounces_options', '30 30 50 75 1 1 0.1 1'),
('ppkbb_tcdef_statuses', '-2 5'),
('ppkbb_tcauthor_candown', '5'),
('ppkbb_tciptype', '0'),
('ppkbb_tcallow_unregtorr', '0'),
('ppkbb_gtcgz_rewrite', '0'),
('ppkbb_gtcmax_leech', '0'),
('ppkbb_gtcmax_seed', '0'),
('ppkbb_gtcmaxip_pertr', '0'),
('ppkbb_gtcmaxip_pertorr', '0'),
('ppkbb_gtcmaxpeers_limit', '50'),
('ppkbb_gtcmaxpeers_rewrite', '0'),
('ppkbb_gtcrights_tcache', '86400'),
('ppkbb_gtcmax_sessions', '0'),
('ppkbb_gtcsession_expire', '0 24'),
('ppkbb_gtccleanup_interval', '48'),
('ppkbb_gtcclients_restricts', '0 0 0'),
('ppkbb_gtciptype', '0'),
('ppkbb_gtcallow_unregtorr', '0'),
('ppkbb_gtcunregtorr_sessid', ''),
('ppkbb_chat_inactive_time', '300'),
('ppkbb_chat_messlength', '255'),
('ppkbb_chat_userrefresh', '30'),
('ppkbb_chat_murefresh', '10'),
('ppkbb_chat_messdisplay', '20'),
('ppkbb_chat_waittime', '5'),
('ppkbb_chat_cleanup_interval', '3600'),
('ppkbb_chat_killtime', '1800'),
('ppkbb_chat_maxsmiles', '3'),
('ppkbb_chat_marchive', '100'),
('ppkbb_chat_umclean', '0 0 0 0'),
('ppkbb_chat_autokill_onpost', '1'),
('ppkbb_chat_autokill_onrefresh', '1'),
('ppkbb_chat_enable', '2'),
('ppkbb_announce_url', '/tracker/announce.php'),
('ppkbb_max_screenshots', '0 3'),
('ppkbb_max_posters', '0 1'),
('ppkbb_unset_tcache', '0'),
('ppkbb_tmax_thumbwidth', '140'),
('ppkbb_tmin_thumbsize', '12000'),
('ppkbb_tmax_imgwidth', '1280'),
('ppkbb_tmax_imgheight', '1024'),
('ppkbb_tprivate_flag', '0'),
('ppkbb_torrent_statvt', '1 2 3 4 5 6 7 8 9'),
('ppkbb_forums_qr', '0'),
('ppkbb_clean_snatch', '0'),
('ppkbb_clear_peers', 'no'),
('ppkbb_subject_textlength', '250'),
('ppkbb_reset_ratio', '0'),
('ppkbb_reset_bonus', '0'),
('ppkbb_append_tfile', '1'),
('ppkbb_tctstat_ctime', '10'),
('ppkbb_maxspoiler_depth', '3'),
('ppkbb_rtrack_enable', '3 3 0'),
('ppkbb_torrblock_width', '20 80 35 0 0'),
('ppkbb_poll_options', '1 1'),
('ppkbb_recount_finished', '0'),
('ppkbb_trclear_files', '0'),
('ppkbb_trclear_thanks', '0'),
('ppkbb_trclear_snatched', '0'),
('ppkbb_trclear_torrents', '0'),
('ppkbb_trclean_sticky', '0'),
('ppkbb_trclean_polls', '0'),
('ppkbb_minscrape_interval', '1800'),
('ppkbb_scrape_enabled', '1'),
('ppkbb_trclear_pollres', '0'),
('ppkbb_ppkbb3cker_version', 'ppkBB3cker free v.2_20140828_47'),
('ppkbb_ipreg_countrestrict', '0 0'),
('ppkbb_hicons_fields', ''),
('ppkbb_torrent_magnetlink', '1'),
('ppkbb_trclear_guestsess', '0'),
('ppkbb_feed_torrents', '0'),
('ppkbb_feed_comments', '0'),
('ppkbb_feed_ftorrents', '0'),
('ppkbb_feed_fcomments', '0'),
('ppkbb_feed_tcomments', '0'),
('ppkbb_feed_trueenblist', '0'),
('ppkbb_feed_enblist', ''),
('ppkbb_feed_torrents_limit', '30'),
('ppkbb_feed_comments_limit', '15'),
('ppkbb_feed_torrents_sort', '0'),
('ppkbb_tracker_top', '10'),
('ppkbb_index_chat', '0'),
('ppkbb_tfile_annreplace', '1 5'),
('ppkbb_subforumslist', ''),
('ppkbb_cron_options', '1 1 1 60 10'),
('ppkbb_tccron_jobs', '1 1'),
('ppkbb_max_mfu', '3'),
('ppkbb_fix_statuses', '0'),
('ppkbb_feed_torrtime', '99'),
('ppkbb_feed_commtime', '99'),
('ppkbb_recount_thanks', '0'),
('ppkbb_topdown_torrents', '0 0 0 10 100% 100 1 0 3 1 0'),
('ppkbb_torr_blocks', '1 2 3 4 5 6 7 8 9'),
('ppkbb_trclear_rannounces', '0'),
('ppkbb_trclear_trtrack', '0'),
('ppkbb_trclear_urtrack', '0'),
('ppkbb_spoiler_options', '200 0 0'),
('ppkbb_spoiler_banned_imghosts', '/imagebanana|hidebehind/i'),
('ppkbb_torrent_statml', '1 2 3 4 5 6 7 8'),
('ppkbb_search_astracker', '1'),
('ppkbb_noticedisclaimer_blocks', '1 1 1 1 1 2'),
('ppkbb_disable_fpquote', '1'),
('ppkbb_peerstable_memory', '0'),
('ppkbb_fpep_enable', '0'),
('ppkbb_trclear_cronjobs', '0'),
('ppkbb_trclear_unregtorr', '0'),
('ppkbb_max_extposters', ''),
('ppkbb_max_extscreenshots', ''),
('ppkbb_topdown_torrents_exclude', ''),
('ppkbb_topdown_torrents_trueexclude', ''),
('ppkbb_tstatus_notify', ''),
('ppkbb_extposters_exclude', ''),
('ppkbb_extposters_trueexclude', '1'),
('ppkbb_extscreenshots_exclude', ''),
('ppkbb_extscreenshots_trueexclude', '1'),
('ppkbb_ppkbb3cker_new', ''),
('ppkbb_thanks_enable', '1'),
('ppkbb_portal_torrents_posttime', '-1 1 0'),
('ppkbb_addfields_pos', '0'),
('ppkbb_cssjs_cache', '1'),
('ppkbb_torrent_gmagnetlink', ''),
('ppkbb_cgp_places', ''),
('ppkbb_addit_options', '0 0 0'),
('ppkbb_mua_countlist', '5 10 25 50 75 100 250 500 750 1000 5000 10000'),
('ppkbb_chat_display', '');

INSERT INTO phpbb_tracker_config (`config_name`, `config_value`) VALUES
('board3_ppkbb3cker_chat_22', '0'),
('board3_ppkbb3cker_portal_last_torrents_23', '1 0 0 1'),
('board3_ppkbb3cker_portal_torrents_perpage_23', '10'),
('board3_ppkbb3cker_portal_torrents_textlength_23', '3000'),
('board3_ppkbb3cker_portal_torrents_posttime_23', '-1 1 0'),
('board3_ppkbb3cker_portal_exclude_forums_23', ''),
('board3_ppkbb3cker_portal_trueexclude_forums_23', '1'),
('board3_ppkbb3cker_portal_lttorrents_display_23', '1 2 3 4');

INSERT INTO phpbb_portal_config (`config_name`, `config_value`) VALUES
('acp_parent_module', '219'),
('board3_menu_array_1', 'a:11:{i:0;a:4:{s:5:"title";s:9:"M_CONTENT";s:3:"url";s:0:"";s:4:"type";i:0;s:10:"permission";s:0:"";}i:1;a:4:{s:5:"title";s:5:"INDEX";s:3:"url";s:9:"index.php";s:4:"type";i:1;s:10:"permission";s:0:"";}i:2;a:4:{s:5:"title";s:6:"SEARCH";s:3:"url";s:10:"search.php";s:4:"type";i:1;s:10:"permission";s:0:"";}i:3;a:4:{s:5:"title";s:8:"REGISTER";s:3:"url";s:21:"ucp.php?mode=register";s:4:"type";i:1;s:10:"permission";s:1:"1";}i:4;a:4:{s:5:"title";s:10:"MEMBERLIST";s:3:"url";s:14:"memberlist.php";s:4:"type";i:1;s:10:"permission";s:3:"2,3";}i:5;a:4:{s:5:"title";s:8:"THE_TEAM";s:3:"url";s:27:"memberlist.php?mode=leaders";s:4:"type";i:1;s:10:"permission";s:3:"2,3";}i:6;a:4:{s:5:"title";s:6:"M_HELP";s:3:"url";s:0:"";s:4:"type";i:0;s:10:"permission";s:0:"";}i:7;a:4:{s:5:"title";s:3:"FAQ";s:3:"url";s:7:"faq.php";s:4:"type";i:1;s:10:"permission";s:0:"";}i:8;a:4:{s:5:"title";s:8:"M_BBCODE";s:3:"url";s:19:"faq.php?mode=bbcode";s:4:"type";i:1;s:10:"permission";s:0:"";}i:9;a:4:{s:5:"title";s:7:"M_TERMS";s:3:"url";s:18:"ucp.php?mode=terms";s:4:"type";i:1;s:10:"permission";s:0:"";}i:10;a:4:{s:5:"title";s:5:"M_PRV";s:3:"url";s:20:"ucp.php?mode=privacy";s:4:"type";i:1;s:10:"permission";s:0:"";}}'),
('board3_welcome_message_10', 'Welcome to my community!'),
('board3_calendar_events_18', ''),
('board3_links_array_21', 'a:4:{i:0;a:4:{s:5:"title";s:9:"Board3.de";s:3:"url";s:21:"http://www.board3.de/";s:4:"type";i:2;s:10:"permission";s:0:"";}i:1;a:4:{s:5:"title";s:10:"ppkBB3cker";s:3:"url";s:25:"http://www.ppkbb3cker.ru/";s:4:"type";i:2;s:10:"permission";s:0:"";}i:2;a:4:{s:5:"title";s:9:"phpBB.com";s:3:"url";s:21:"http://www.phpbb.com/";s:4:"type";i:2;s:10:"permission";s:0:"";}i:3;a:4:{s:5:"title";s:9:"phpBBGuRu";s:3:"url";s:25:"http://www.phpbbguru.net/";s:4:"type";i:2;s:10:"permission";s:0:"";}}');

INSERT INTO phpbb_reports_reasons (`reason_title`, `reason_description`, `reason_order`) VALUES
('TORRENT_ABUSE_DESCR', '{L_RREASON_TORRENT_ABUSE_DESCR}', 5),
('TORRENT_ABUSE_CAT', '{L_RREASON_TORRENT_ABUSE_CAT}', 4);

INSERT INTO phpbb_tracker_afftpl (`id`, `addfields`, `addfields_hlp`, `addfields_br`, `addfields_br2`, `addfields_inall`, `addfields_ta`, `addfields_multi`, `addfields_bbcode`, `addfields_bbcodes`, `addfields_descr`, `addfields_enable`, `af_id`, `addfields_alias`) VALUES
(1, 'version', '', '', '', 0, 0, 0, '', '', 'Версия', 1, 0, ''),
(2, 'year', '', '', '', 0, 0, 0, '', '', 'Дата выхода', 1, 0, ''),
(3, 'status', 'бесплатная\r\nусловно-бесплатная\r\nтриал\r\nдемо\r\nплатная', '', '', 0, 0, 0, '', '', 'Статус', 1, 0, ''),
(4, 'type', '', '', '', 0, 0, 0, '', '', 'Тип', 1, 0, ''),
(5, 'orig', '', '', '', 0, 0, 0, '', '', 'Оригинальное название', 1, 0, ''),
(6, 'style', '', '', '', 0, 0, 0, '', '', 'Жанр', 1, 0, ''),
(7, 'producer', '', '', '', 0, 0, 0, '', '', 'Режиссёр', 1, 0, ''),
(8, 'acters', '', '', '', 0, 0, 0, '', '', 'В ролях', 1, 0, ''),
(9, 'afilm', '', '', '', 0, 1, 0, '', '', 'О фильме', 1, 0, ''),
(10, 'imdb', 'http://imdb.com/title/tt041827 8.0/10 (41,610 голосов)', '', '', 0, 0, 0, '', '', 'IMDB', 1, 0, ''),
(11, 'company', '', '', '', 0, 0, 0, '', '', 'Кинокомпания', 1, 0, ''),
(12, 'land', '', '', '', 0, 0, 0, '', '', 'Страна', 1, 0, ''),
(13, 'time', '01:34:23', '', '', 0, 0, 0, '', '', 'Продолжительность', 1, 0, ''),
(14, 'translate', 'Оригинал\r\nЛюбительский (один голос)\r\nЛюбительский (многоголосный)\r\nПрофессиональный (многоголосный)\r\nГоблин\r\nДублированный', '', '', 0, 0, 0, '', '', 'Перевод', 1, 0, ''),
(15, 'aformat', 'MP3\r\nAC3\r\nWMA\r\nOGG\r\nMP2\r\nFLAC\r\nAPE', '', '', 0, 0, 0, '', '', 'Формат аудио', 1, 0, ''),
(16, 'vformat', 'DivX\r\nXviD\r\nWMV\r\nAVI\r\nSVCD\r\nVCD', '', '', 0, 0, 0, '', '', 'Формат видео', 1, 0, ''),
(17, 'quality', 'DVDRip\r\nDVD9Rip\r\nDVDScr\r\nTVRip\r\nTS\r\nTC\r\nCAMRip\r\nTVRip\r\nSATRip\r\nHDTVRip\r\nHD-DVDRip\r\nVHSRip', '', '', 0, 0, 0, '', '', 'Качество', 1, 0, ''),
(18, 'video', '560x304, 985 кб/с', '', '', 0, 0, 0, '', '', 'Видео', 1, 0, ''),
(19, 'audio', 'MP3, 192 кб/с', '', '', 0, 0, 0, '', '', 'Аудио', 1, 0, ''),
(20, 'sample', '', '', '', 0, 0, 0, '', '', 'Сэмпл', 1, 0, ''),
(21, 'execut', '', '', '', 0, 0, 0, '', '', 'Исполнитель', 1, 0, ''),
(22, 'author', '', '', '', 0, 0, 0, '', '', 'Автор', 1, 0, ''),
(23, 'album', '', '', '', 0, 0, 0, '', '', 'Альбом', 1, 0, ''),
(24, 'bitrate', '', '', '', 0, 0, 0, '', '', 'Битрэйт', 1, 0, ''),
(25, 'tracklist', '', '', '', 0, 1, 0, '', '', 'Трэклист', 1, 0, ''),
(26, 'developer', '', '', '', 0, 0, 0, '', '', 'Разработчик', 1, 0, ''),
(27, 'publisher', '', '', '', 0, 0, 0, '', '', 'Издатель', 1, 0, ''),
(28, 'agame', '', '', '', 0, 1, 0, '', '', 'Об игре', 1, 0, ''),
(29, 'feature', '', '', '', 0, 1, 0, '', '', 'Особенности игры', 1, 0, ''),
(30, 'protect', '', '', '', 0, 0, 0, '', '', 'Защита', 1, 0, ''),
(31, 'sysreq', '', '', '', 0, 1, 0, '', '', 'Системные требования', 1, 0, ''),
(32, 'launch', '', '', '', 0, 1, 0, '', '', 'Запуск', 1, 0, ''),
(33, 'language', 'русский\r\nанглийский', '', '', 0, 0, 0, '', '', 'Язык', 1, 0, ''),
(34, 'addit', '', '', '', 0, 1, 0, '', '', 'Дополнительно', 1, 0, ''),
(35, 'poster', '', '', '', 0, 0, 0, '[spoiler="Постер"]%s[/spoiler]', '[img]%s[/img]', 'Постер', 1, 0, ''),
(36, 'screenshots', '', '', '', 0, 0, 0, '[spoiler="Скриншоты"]%s[/spoiler]', '[img]%s[/img]', 'Скриншоты', 1, 0, '');

INSERT INTO phpbb_tracker_afsets (`id`, `af_id`, `af_name`, `af_count`, `af_order`) VALUES
(9, 2, 'version', 1, 0),
(10, 2, 'year', 1, 0),
(11, 2, 'status', 1, 0),
(12, 2, 'developer', 1, 0),
(13, 2, 'sysreq', 1, 0),
(14, 2, 'launch', 1, 0),
(15, 2, 'language', 1, 0),
(16, 2, 'addit', 1, 0),
(17, 3, 'version', 1, 0),
(18, 3, 'year', 1, 0),
(19, 3, 'status', 1, 0),
(20, 3, 'style', 1, 0),
(21, 3, 'developer', 1, 0),
(22, 3, 'publisher', 1, 0),
(23, 3, 'agame', 1, 0),
(24, 3, 'feature', 1, 0),
(25, 3, 'protect', 1, 0),
(26, 3, 'sysreq', 1, 0),
(27, 3, 'launch', 1, 0),
(28, 3, 'language', 1, 0),
(29, 3, 'addit', 1, 0),
(45, 5, 'year', 1, 0),
(46, 5, 'orig', 1, 0),
(47, 5, 'style', 1, 0),
(48, 5, 'land', 1, 0),
(49, 5, 'author', 1, 0),
(50, 5, 'publisher', 1, 0),
(51, 5, 'language', 1, 0),
(52, 5, 'addit', 1, 0),
(53, 6, 'year', 1, 0),
(54, 6, 'orig', 1, 0),
(55, 6, 'style', 1, 0),
(56, 6, 'producer', 1, 0),
(57, 6, 'acters', 1, 0),
(58, 6, 'afilm', 1, 0),
(59, 6, 'imdb', 1, 0),
(60, 6, 'company', 1, 0),
(61, 6, 'land', 1, 0),
(62, 6, 'time', 1, 0),
(63, 6, 'translate', 1, 0),
(64, 6, 'aformat', 1, 0),
(65, 6, 'vformat', 1, 0),
(66, 6, 'quality', 1, 0),
(67, 6, 'video', 1, 0),
(68, 6, 'audio', 1, 0),
(69, 6, 'language', 1, 0),
(70, 6, 'addit', 1, 0),
(108, 9, 'year', 1, 0),
(109, 9, 'style', 1, 0),
(110, 9, 'time', 1, 0),
(111, 9, 'aformat', 1, 0),
(112, 9, 'audio', 1, 0),
(113, 9, 'album', 1, 0),
(114, 9, 'bitrate', 1, 0),
(115, 9, 'tracklist', 1, 0),
(116, 9, 'language', 1, 0),
(117, 9, 'addit', 1, 0);

INSERT INTO phpbb_tracker_aftpl (`id`, `af_name`, `af_descr`, `af_subject`, `af_data`) VALUES
(2, 'Soft', '', '', ''),
(3, 'Game', '', '', ''),
(5, 'Book', '', '', ''),
(6, 'Films', '', '', ''),
(9, 'Music', '', '', '');

INSERT INTO phpbb_tracker_statuses (`id`, `status_id`, `status_reason`, `status_mark`, `def_forb`, `def_notforb`, `author_candown`, `status_enabled`, `newtorrents_freeze`) VALUES
(1, 0, 'без статуса', '', 0, 0, 0, 1, 0),
(2, 1, 'запрещённый торрент', '<font color="#FF0000">Запрещён</font>', 0, 0, 0, 1, 0),
(3, 2, 'недооформленный торрент', '<font color="#FF3F47">Недооформлен</font>', 0, 0, 0, 1, 0),
(4, 3, 'повторный торрент', '<font color="#FF3F47">Повторный</font>', 0, 0, 0, 1, 0),
(5, 4, 'поглощённый торрент', '<font color="#FF3F47">Поглощён</font>', 0, 0, 0, 1, 0),
(6, 5, 'непроверенный торрент', '<font color="#FF3F47">Непроверен</font>', 0, 1, 1, 1, 0),
(7, -1, 'обновлённый торрент', '<font color="#09AF00">Обновлён</font>', 0, 0, 0, 1, 0),
(8, -2, 'проверенный торрент', 'Проверен', 1, 0, 0, 1, 0);


INSERT INTO phpbb_acl_options (`auth_option`, `is_global`, `is_local`, `founder_only`) VALUES
('f_attachfonly', 0, 1, 0),
('u_attachfonly', 1, 0, 0),
('u_canviewtopdowntorrents', 1, 0, 0),
('u_attach50down', 1, 0, 0),
('u_attach100down', 1, 0, 0),
('u_canfreetorrents', 1, 0, 0),
('u_canusebonus', 1, 0, 0),
('f_attach50down', 0, 1, 0),
('f_attach100down', 0, 1, 0),
('f_canfreetorrents', 0, 1, 0),
('f_canusebonus', 0, 1, 0),
('f_canusefree', 0, 1, 0),
('u_canusefree', 1, 0, 0),
('u_canusethanks', 1, 0, 0),
('f_canusethanks', 0, 1, 0),
('f_canusetracker', 0, 1, 0),
('u_canusetracker', 1, 0, 0),
('u_canskiprcheck', 1, 0, 0),
('f_canskiprcheck', 0, 1, 0),
('u_canviewchatm', 1, 0, 0),
('f_canviewchatm', 0, 1, 0),
('u_canviewchatu', 1, 0, 0),
('f_canviewchatu', 0, 1, 0),
('u_candelchatm', 1, 0, 0),
('f_candelchatm', 0, 1, 0),
('u_canaddchatm', 1, 0, 0),
('f_canaddchatm', 0, 1, 0),
('f_canskipchatktime', 0, 1, 0),
('u_canskipchatktime', 1, 0, 0),
('f_canskipdisbutton', 0, 1, 0),
('u_canskipdisbutton', 1, 0, 0),
('u_canskipmaxseed', 1, 0, 0),
('u_canskipmaxleech', 1, 0, 0),
('f_canusesmilies', 0, 1, 0),
('u_canusesmilies', 1, 0, 0),
('f_canskipreqratio', 0, 1, 0),
('u_canskipreqratio', 1, 0, 0),
('f_canskiprequpload', 0, 1, 0),
('u_canskiprequpload', 1, 0, 0),
('f_cansetrequpratio', 0, 1, 0),
('u_cansetrequpratio', 1, 0, 0),
('f_candowntorr', 0, 1, 0),
('u_candowntorr', 1, 0, 0),
('f_candownpostscr', 0, 1, 0),
('u_candownpostscr', 1, 0, 0),
('u_cansearchtr', 1, 0, 0),
('u_cansetforb', 1, 0, 0),
('f_cansetforb', 0, 1, 0),
('u_canskipiprestr', 1, 0, 0),
('u_canskiptcheck', 1, 0, 0),
('f_canskiptcheck', 0, 1, 0),
('u_view_portal', 1, 0, 0),
('u_canviewtrtop', 1, 0, 0),
('u_candelchatm2', 1, 0, 0),
('f_candelchatm2', 0, 1, 0),
('a_ppktracker', 1, 0, 0),
('a_ppkchat', 1, 0, 0),
('a_manage_portal', 1, 0, 0),
('u_canusefpep', 1, 0, 0),
('f_canusefpep', 0, 1, 0),
('u_similar_topics', 1, 0, 0),
('u_canviewarchive', 1, 0, 0),
('f_canviewarchive', 0, 1, 0),
('u_canviewvtstats', 1, 0, 0),
('f_canviewvtstats', 0, 1, 0),
('u_canviewmuastatr', 1, 0, 0),
('u_canviewmuastatorr', 1, 0, 0);

INSERT INTO phpbb_acl_roles (`role_name`, `role_description`, `role_type`, `role_order`) VALUES
('ROLE_TRACKER_VIPUPLOADER', 'ROLE_TRACKER_VIPUPLOADER_DESCR', 'f_', 10),
('ROLE_TRACKER_SUPERUPLOADER', 'ROLE_TRACKER_SUPERUPLOADER_DESCR', 'f_', 11),
('ROLE_TRACKER_EXPUPLOADER', 'ROLE_TRACKER_EXPUPLOADER_DESCR', 'f_', 12),
('ROLE_TRACKER_UPLOADER', 'ROLE_TRACKER_UPLOADER_DESCR', 'f_', 13),
('ROLE_TRACKER_EXPLEECHER', 'ROLE_TRACKER_EXPLEECHER_DESCR', 'f_', 14),
('ROLE_TRACKER_LEECHER', 'ROLE_TRACKER_LEECHER_DESCR', 'f_', 15),
('ROLE_TRACKER_TRACKERUSER', 'ROLE_TRACKER_TRACKERUSER_DESCR', 'f_', 16),
('ROLE_TRACKER_VIPUPLOADER', 'ROLE_TRACKER_VIPUPLOADER_DESCR', 'u_', 6),
('ROLE_TRACKER_SUPERUPLOADER', 'ROLE_TRACKER_SUPERUPLOADER_DESCR', 'u_', 7),
('ROLE_TRACKER_EXPUPLOADER', 'ROLE_TRACKER_EXPUPLOADER_DESCR', 'u_', 8),
('ROLE_TRACKER_UPLOADER', 'ROLE_TRACKER_UPLOADER_DESCR', 'u_', 9),
('ROLE_TRACKER_EXPLEECHER', 'ROLE_TRACKER_EXPLEECHER_DESCR', 'u_', 10),
('ROLE_TRACKER_LEECHER', 'ROLE_TRACKER_LEECHER_DESCR', 'u_', 11),
('ROLE_TRACKER_TRACKERUSER', 'ROLE_TRACKER_TRACKERUSER_DESCR', 'u_', 12),
('ROLE_TRACKER_BLOCKUSER', 'ROLE_TRACKER_BLOCKUSER_DESCR', 'f_', 17),
('ROLE_TRACKER_BLOCKUSER', 'ROLE_TRACKER_BLOCKUSER_DESCR', 'u_', 13),
('ROLE_TRACKER_PRIVUSER', 'ROLE_TRACKER_PRIVUSER_DESCR', 'f_', 18),
('ROLE_TRACKER_PRIVUSER', 'ROLE_TRACKER_PRIVUSER_DESCR', 'u_', 14),
('ROLE_TRACKER_SUPERMODERATOR', 'ROLE_TRACKER_SUPERMODERATOR_DESCR', 'f_', 21),
('ROLE_TRACKER_SUPERMODERATOR', 'ROLE_TRACKER_SUPERMODERATOR_DESCR', 'u_', 17),
('ROLE_TRACKER_ADMINISTRATOR', 'ROLE_TRACKER_ADMINISTRATOR_DESCR', 'u_', 18),
('ROLE_TRACKER_ADMINISTRATOR', 'ROLE_TRACKER_ADMINISTRATOR_DESCR', 'f_', 22),
('ROLE_CHAT_USER', 'ROLE_CHAT_USER_DESCR', 'u_', 19),
('ROLE_CHAT_USER', 'ROLE_CHAT_USER_DESCR', 'f_', 23),
('ROLE_TRACKER_MODERATOR', 'ROLE_TRACKER_MODERATOR_DESCR', 'u_', 16),
('ROLE_TRACKER_MODERATOR', 'ROLE_TRACKER_MODERATOR_DESCR', 'f_', 20),
('ROLE_TRACKER_JRMODERATOR', 'ROLE_TRACKER_JRMODERATOR_DESCR', 'u_', 15),
('ROLE_TRACKER_JRMODERATOR', 'ROLE_TRACKER_JRMODERATOR_DESCR', 'f_', 19),
('ROLE_TRACKER_TRACKERGUEST', 'ROLE_TRACKER_TRACKERGUEST_DESCR', 'f_', 25),
('ROLE_TRACKER_TRACKERGUEST', 'ROLE_TRACKER_TRACKERGUEST_DESCR', 'u_', 21);

после этого:
1. очистить кэш, обновить стили
2. добавить расширение torrent в адм. разделе и разрешить его в нужных форумах
3. добавить модули в адм. разделе (как они должны выглядеть можно посмотреть установив трекер)
4. назначить права на роли и группы

after that:
1. clear cache, update styles
2. add an extension to the torrent adm. section and solve it in the right forums
3. add modules to adm. section (as they should look, you can see the setting tracker)
4. assign rights to roles and groups

[HerzeleidMeister]

Awesome, thanks I'll post if I have issues.