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

Please, write a message in your native language or english
 • Просмотры: 414280
He
HerzeleidMeister
Сообщения: 3
Зарегистрирован: 19 окт 2014, 06:04
Сообщение

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

19 окт 2014, 07:04

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
Администратор
Благодарил (а): 82 раза
Поблагодарили: 1619 раз
Сообщения: 10275
Зарегистрирован: 21 мар 2009, 17:13
Сообщение

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

20 окт 2014, 10:24

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
He
HerzeleidMeister
Сообщения: 3
Зарегистрирован: 19 окт 2014, 06:04
Сообщение

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

22 окт 2014, 04:45

PPK писал(а):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
Администратор
Благодарил (а): 82 раза
Поблагодарили: 1619 раз
Сообщения: 10275
Зарегистрирован: 21 мар 2009, 17:13
Сообщение

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

23 окт 2014, 13:23

позже напишу ..
I will write later ..
Аватара пользователя
PPK
Администратор
Благодарил (а): 82 раза
Поблагодарили: 1619 раз
Сообщения: 10275
Зарегистрирован: 21 мар 2009, 17:13
Сообщение

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

24 окт 2014, 16:51

для 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
У вас нет необходимых прав для просмотра вложений в этом сообщении.
He
HerzeleidMeister
Сообщения: 3
Зарегистрирован: 19 окт 2014, 06:04
Сообщение

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

01 ноя 2014, 12:22

Awesome, thanks I'll post if I have issues.
Перенесено из форума Вопросы, ответы и примеры решений в форум Non-russian speakers forum 02 окт 2016, 14:09 модератором PPK

Вернуться в «Non-russian speakers forum»