Код: Выделить всё
Ok: SELECT VERSION() AS version
Ok: SET NAMES 'utf8'
Ok: ALTER TABLE `phpbb_forums` CHANGE `forum_addfields` `forum_addfields2` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''
Ok: SELECT COUNT(*) ut, id, user_id, torrent_id FROM `phpbb_tracker_thanks` GROUP BY user_id, torrent_id HAVING(ut) > 1
Ok: SELECT SUM(s.uploaded), s.userid FROM phpbb_tracker_snatched s, phpbb_tracker_torrents t WHERE s.userid=t.poster_id AND s.torrent=t.id GROUP BY s.userid
Ok: ALTER TABLE `phpbb_tracker_thanks` DROP INDEX `user_id`
[color=#FF0000]Error: ALTER TABLE `phpbb_tracker_thanks` DROP INDEX `torrent_id`[/color]
[1091] (Can't DROP 'torrent_id'; check that column/key exists)
Ok: ALTER TABLE `phpbb_tracker_thanks` ADD UNIQUE (`user_id`, `torrent_id`)
Ok: ALTER TABLE `phpbb_topics` ADD `topic_first_post_show` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL
Ok: ALTER TABLE `phpbb_forums` ADD `forum_first_post_show` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 'u_canusefpep', '1', '0', '0')
Ok: INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 'f_canusefpep', '0', '1', '0')
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_fpep_enable', '0')
Ok: ALTER TABLE `phpbb_users` ADD `user_uploaded_self` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_tciptype', '0')
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_gtciptype', '0')
Ok: ALTER TABLE `phpbb_tracker_peers` ADD `seeder_new` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: SELECT id FROM `phpbb_tracker_peers` WHERE seeder='yes'
Update PEERS SEEDER
Ok: ALTER TABLE `phpbb_tracker_peers` DROP `seeder`
Ok: ALTER TABLE `phpbb_tracker_peers` CHANGE `seeder_new` `seeder` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: ALTER TABLE `phpbb_tracker_peers` ADD `connectable_new` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: SELECT id FROM `phpbb_tracker_peers` WHERE connectable='yes'
Update PEERS CONNECTABLE
Ok: ALTER TABLE `phpbb_tracker_peers` DROP `connectable`
Ok: ALTER TABLE `phpbb_tracker_peers` CHANGE `connectable_new` `connectable` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD INDEX (`post_msg_id`)
Ok: DELETE FROM `phpbb_tracker_config` WHERE config_name='ppkbb_gtcignore_connectable'
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_trclear_cronjobs', '0')
Ok: ALTER TABLE `phpbb_tracker_snatched` DROP `seeder`
Ok: ALTER TABLE `phpbb_tracker_peers` ADD INDEX (`seeder`)
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_tcallow_unregtorr', '0'), ('ppkbb_gtcallow_unregtorr', '0')
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD `unreg` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_gtcunregtorr_sessid', '')
Ok: ALTER TABLE `phpbb_tracker_guests` ADD `unreg` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: ALTER TABLE `phpbb_tracker_guests` ADD INDEX ( `unreg` )
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_trclear_unregtorr', '0')
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD INDEX ( `forb` )
Ok: ALTER TABLE `phpbb_attachments` ADD `i_poster` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', ADD INDEX ( `i_poster` )
Ok: UPDATE `phpbb_attachments` SET i_poster='1' WHERE extension IN('gif', 'jpeg', 'jpg', 'png', 'tga', 'tif', 'tiff') AND real_filename LIKE '%poster%'
Ok: DELETE FROM `phpbb_tracker_config` WHERE `phpbb_tracker_config`.`config_name` = 'ppkbb_num_torrents' LIMIT 1
Ok: DELETE FROM `phpbb_tracker_config` WHERE `phpbb_tracker_config`.`config_name` = 'ppkbb_num_comments' LIMIT 1
Ok: INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('num_torrents', '0', '1')
Ok: INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('num_comments', '0', '1')
Ok: ALTER TABLE `phpbb_tracker_rannounces` ADD INDEX ( `torrent` )
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD `lastseed` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0', ADD `lastleech` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD `forum_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0', ADD INDEX ( `forum_id` )
Ok: SELECT t.forum_id, tr.id FROM `phpbb_tracker_torrents` tr, `phpbb_topics` t WHERE t.topic_id=tr.topic_id
Ok: UPDATE `phpbb_attachments` SET i_poster='2' WHERE extension IN('gif', 'jpeg', 'jpg', 'png', 'tga', 'tif', 'tiff') AND real_filename NOT LIKE '%poster%'
Ok: ALTER TABLE `phpbb_attachments` DROP INDEX `extension`
Ok: DELETE FROM `phpbb_tracker_config` WHERE `config_name` IN ('ppkbb_chat_last_cleanup', 'ppkbb_tracker_last_cleanup', 'ppkbb_gtracker_last_cleanup', 'ppkbb_cron_last_cleanup', 'ppkbb_newversion_lastcheck')
[color=#FF0000]Error: INSERT INTO `phpbb_config`(config_name, config_value, is_dynamic) VALUES ('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)[/color]
[1062] (Duplicate entry 'ppkbb_newversion_lastcheck' for key 1)
Ok: INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('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)
Ok: INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('ppkbb_last_stattime', '0', '1')
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD `lastcleanup` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD `rem_seeders` int(10) unsigned NOT NULL DEFAULT '0', ADD `rem_leechers` int(10) unsigned NOT NULL DEFAULT '0', ADD `rem_times_completed` int(10) unsigned NOT NULL DEFAULT '0'
Ok: ALTER TABLE `phpbb_tracker_torrents` ADD `lastremote` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'
Ok: ALTER TABLE `phpbb_tracker_rannounces` DROP `peers`
Ok: ALTER TABLE `phpbb_attachments` ADD `i_external` TINYINT UNSIGNED NOT NULL DEFAULT '0'
Ok: DELETE FROM `phpbb_tracker_config` WHERE `phpbb_tracker_config`.`config_name` = 'ppkbb_postscr_src'
Ok: DELETE FROM `phpbb_tracker_config` WHERE `phpbb_tracker_config`.`config_name` = 'ppkbb_postscr_fields'
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_max_extposters', ''), ('ppkbb_max_extscreenshots', '')
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_topdown_torrents_exclude', ''), ('ppkbb_topdown_torrents_trueexclude', '')
Ok: INSERT INTO `phpbb_tracker_config` (`config_name`, `config_value`) VALUES ('ppkbb_tstatus_notify', '')
на портале не отображаются обвел красным или надо включить где то раздачи мультитрэкерные
