Вобщем хочу удалить мод трекера и прошу помочь, бэкап файлов форума до модификации у меня есть а вот как мне отменить эти запросы (мода трекера):
Код: Выделить всё
ALTER TABLE phpbb_forums ADD allow_reg_tracker TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_forums ADD allow_dl_topic TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_forums ADD dl_type_default TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_forums ADD self_moderated TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_forums ADD last_dl_topics_synch int(11) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_forums ADD show_dl_buttons TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_topics ADD topic_dl_type TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_topics ADD topic_dl_status TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_topics MODIFY topic_title char(120);
ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title);
ALTER TABLE phpbb_users ADD user_allow_passkey TINYINT(1) NOT NULL DEFAULT '1';
ALTER TABLE phpbb_users ADD bt_tor_browse_set text NOT NULL;
ALTER TABLE phpbb_posts_text MODIFY post_subject varchar(120);
ALTER TABLE phpbb_attachments_desc ADD tracker_status TINYINT(1) NOT NULL DEFAULT '0';
CREATE TABLE phpbb_bt_config ( config_name VARCHAR(255) NOT NULL DEFAULT '', config_value VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (config_name) );
CREATE TABLE phpbb_bt_search_results ( session_id VARCHAR(32) NOT NULL DEFAULT '', search_id INT(10) UNSIGNED NOT NULL DEFAULT '0', added INT(11) NOT NULL DEFAULT '0', search_array TEXT NOT NULL, search_settings TEXT NOT NULL, PRIMARY KEY (session_id) );
CREATE TABLE phpbb_bt_tor_dl_stat ( torrent_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', user_id MEDIUMINT(8) NOT NULL DEFAULT '0', attach_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', t_up_total BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', t_down_total BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (torrent_id,user_id) );
CREATE TABLE phpbb_bt_torrents ( torrent_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT, info_hash BINARY(20) NOT NULL DEFAULT '', post_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', poster_id MEDIUMINT(8) NOT NULL DEFAULT '0', topic_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', attach_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', size BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', piece_length MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', reg_time INT(11) NOT NULL DEFAULT '0', complete_count MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', complete_count_guest MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', seeder_last_seen INT(11) NOT NULL DEFAULT '0', last_seeder_uid MEDIUMINT(8) NOT NULL DEFAULT '0', PRIMARY KEY (torrent_id), UNIQUE info_hash (info_hash), UNIQUE post_id (post_id), UNIQUE topic_id (topic_id), UNIQUE attach_id (attach_id), KEY reg_time (reg_time) );
CREATE TABLE phpbb_bt_tracker ( torrent_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', peer_id char(20) binary NOT NULL DEFAULT '', user_id MEDIUMINT(8) NOT NULL DEFAULT '0', ip char(8) binary 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', complete_percent BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', seeder TINYINT(1) NOT NULL DEFAULT '0', last_stored_up BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', last_stored_down BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', stat_last_updated int(11) NOT NULL DEFAULT '0', speed_up MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', speed_down MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', update_time int(11) NOT NULL DEFAULT '0', expire_time int(11) NOT NULL DEFAULT '0', KEY torrent_id (torrent_id), KEY user_id (user_id) );
CREATE TABLE phpbb_bt_users ( user_id MEDIUMINT(8) NOT NULL DEFAULT '0', ip char(8) binary NOT NULL DEFAULT '0', u_up_total BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', u_down_total BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (user_id) );
CREATE TABLE phpbb_bt_users_dl_status ( topic_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', user_id MEDIUMINT(8) NOT NULL DEFAULT '0', user_status TINYINT(1) NOT NULL DEFAULT '0', compl_count TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', update_time int(11) NOT NULL DEFAULT '0', PRIMARY KEY (topic_id,user_id), KEY user_id (user_id) );
INSERT INTO phpbb_config VALUES ('bt_show_peers', '1');
INSERT INTO phpbb_config VALUES ('bt_show_peers_mode', '1');
INSERT INTO phpbb_config VALUES ('bt_allow_spmode_change', '1');
INSERT INTO phpbb_config VALUES ('bt_show_dl_list', '1');
INSERT INTO phpbb_config VALUES ('bt_dl_list_only_1st_page', '1');
INSERT INTO phpbb_config VALUES ('bt_dl_list_only_count', '1');
INSERT INTO phpbb_config VALUES ('bt_dl_list_expire', '30');
INSERT INTO phpbb_config VALUES ('bt_announce_url', 'http://yourdomain.com/bt/announce.php');
INSERT INTO phpbb_config VALUES ('bt_replace_ann_url', '1');
INSERT INTO phpbb_config VALUES ('bt_show_ip_only_moder', '1');
INSERT INTO phpbb_config VALUES ('bt_show_port_only_moder', '1');
INSERT INTO phpbb_config VALUES ('bt_check_announce_url', '0');
INSERT INTO phpbb_config VALUES ('bt_show_dl_list_buttons', '1');
INSERT INTO phpbb_config VALUES ('bt_show_dl_but_will', '1');
INSERT INTO phpbb_config VALUES ('bt_show_dl_but_down', '0');
INSERT INTO phpbb_config VALUES ('bt_show_dl_but_compl', '0');
INSERT INTO phpbb_config VALUES ('bt_show_dl_but_cancel', '1');
INSERT INTO phpbb_config VALUES ('bt_show_dl_stat_on_index', '1');
INSERT INTO phpbb_config VALUES ('bt_newtopic_auto_reg', '1');
INSERT INTO phpbb_config VALUES ('bt_tor_browse_only_reg', '0');
INSERT INTO phpbb_config VALUES ('bt_search_tbl_last_clean', '0');
INSERT INTO phpbb_config VALUES ('bt_search_bool_mode', '0');
INSERT INTO phpbb_config VALUES ('bt_del_addit_ann_urls', '1');
INSERT INTO phpbb_config VALUES ('bt_set_dltype_on_tor_reg', '1');
INSERT INTO phpbb_config VALUES ('bt_unset_dltype_on_tor_unreg', '0');
INSERT INTO phpbb_config VALUES ('bt_add_comment', '');
INSERT INTO phpbb_config VALUES ('bt_add_publisher', 'YourSiteName');
INSERT INTO phpbb_bt_config VALUES ('last_clean_time', '0');
INSERT INTO phpbb_bt_config VALUES ('autoclean', '1');
INSERT INTO phpbb_bt_config VALUES ('off', '0');
INSERT INTO phpbb_bt_config VALUES ('off_show_reason', '1');
INSERT INTO phpbb_bt_config VALUES ('off_reason', 'Tracker is disabled');
INSERT INTO phpbb_bt_config VALUES ('bt_debug', '0');
INSERT INTO phpbb_bt_config VALUES ('silent_mode', '0');
INSERT INTO phpbb_bt_config VALUES ('do_gzip', '0');
INSERT INTO phpbb_bt_config VALUES ('force_gzip', '0');
INSERT INTO phpbb_bt_config VALUES ('client_compat_gzip', '1');
INSERT INTO phpbb_bt_config VALUES ('ignor_given_ip', '1');
INSERT INTO phpbb_bt_config VALUES ('allow_host_ip', '0');
INSERT INTO phpbb_bt_config VALUES ('ignor_numwant', '1');
INSERT INTO phpbb_bt_config VALUES ('numwant', '50');
INSERT INTO phpbb_bt_config VALUES ('numwant_max', '100');
INSERT INTO phpbb_bt_config VALUES ('autoclean_interval', '120');
INSERT INTO phpbb_bt_config VALUES ('min_ann_intv', '1200');
INSERT INTO phpbb_bt_config VALUES ('expire_factor', '3');
INSERT INTO phpbb_bt_config VALUES ('compact_mode', '0');
INSERT INTO phpbb_bt_config VALUES ('update_users_dl_status', '1');
INSERT INTO phpbb_bt_config VALUES ('update_users_compl_status', '1');
INSERT INTO phpbb_bt_config VALUES ('allow_guest_dl', '0');
INSERT INTO phpbb_bt_config VALUES ('upd_user_up_down_stat', '1');
INSERT INTO phpbb_bt_config VALUES ('seed_last_seen_upd_interval', '300');
INSERT INTO phpbb_bt_config VALUES ('user_statistic_upd_interval', '25');
INSERT INTO phpbb_bt_config VALUES ('browser_redirect_url', 'http://yourdomain.com/');
INSERT INTO phpbb_bt_config VALUES ('limit_active_tor', '0');
INSERT INTO phpbb_bt_config VALUES ('limit_seed_count', '20');
INSERT INTO phpbb_bt_config VALUES ('limit_leech_count', '4');
INSERT INTO phpbb_bt_config VALUES ('leech_expire_factor', '60');
INSERT INTO phpbb_bt_config VALUES ('limit_concurrent_ips', '0');
INSERT INTO phpbb_bt_config VALUES ('limit_seed_ips', '0');
INSERT INTO phpbb_bt_config VALUES ('limit_leech_ips', '2');
INSERT INTO phpbb_bt_torrents VALUES (1, 0xf51a6d93f8d475fd7f816f463f20c5734f15a87f, 4, 4, 3, 1, 16748964, 4194304, 1117378225, 0, 0, 0, 0);
INSERT INTO phpbb_bt_users VALUES (-1, '', 0, 0);
INSERT INTO phpbb_bt_users_dl_status VALUES (3, 5, 1, 0, 1117378308);
