NeatElves
23.03.2013, 20:37
Под мангос:
1. Юра, эта часть уже есть в моей теме.)) Остальным залить, чтобы ошибок в логе не было:
UPDATE `creature_loot_template` SET `condition_id`='185' WHERE `item`=12840;
DELETE FROM `conditions` WHERE `condition_entry` = 144;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24823;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24825;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24826;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24827;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24828;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24830;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24832;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=24834;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=25239;
UPDATE `quest_template` SET `NextQuestInChain`='0' WHERE `entry`=25240;
2. Сама правка
REPLACE INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`) VALUES ('144', '8', '24815', '0'),
('1991', '24', '50375', '1'),('1992', '24', '50376', '1'),('1993', '24', '50377', '1'),('1994', '24', '50378', '1'),('1995', '24', '52569', '1'),
('1996', '24', '50388', '1'),('1997', '24', '50387', '1'),('1998', '24', '50384', '1'),('1999', '24', '50386', '1'),('2000', '24', '52570', '1'),
('2001', '24', '50403', '1'),('2002', '24', '50401', '1'),('2003', '24', '50397', '1'),('2004', '24', '50399', '1'),('2005', '24', '52571', '1'),
('2006', '24', '50404', '1'),('2007', '24', '50402', '1'),('2008', '24', '50398', '1'),('2009', '24', '50400', '1'),('2010', '24', '52572', '1'),
('2011', '8', '24827', '0'),('2012', '8', '24826', '0'),('2013', '8', '24828', '0'),('2014', '8', '24825', '0'),('2015', '8', '25239', '0'),
('2016', '8', '24834', '0'),('2017', '8', '24832', '0'),('2018', '8', '24823', '0'),('2019', '8', '24830', '0'),('2020', '8', '25240', '0'),
('2021', '8', '24835', '0'),('2022', '8', '24833', '0'),('2023', '8', '24829', '0'),('2024', '8', '24831', '0'),('2025', '8', '25242', '0'),
('2026', '-2', '2011', '2012'),('2027', '-2', '2013', '2014'),('2028', '-2', '2026', '2027'),('2029', '-2', '2015', '2028'),('2030', '-3', '2029', '0'),
('2031', '-2', '2016', '2017'),('2032', '-2', '2018', '2019'),('2033', '-2', '2031', '2032'),('2034', '-2', '2020', '2033'),('2035', '-3', '2034', '0'),
('2036', '-2', '2021', '2022'),('2037', '-2', '2023', '2024'),('2038', '-2', '2036', '2037'),('2039', '-2', '2025', '2038'),('2040', '-3', '2039', '0'),
('2041', '-1', '2030', '2035'),('2042', '-1', '2040', '2041'),
('2043', '-1', '1991', '1992'),('2044', '-1', '1993', '1994'),('2045', '-1', '2043', '2044'),('2046', '-1', '1995', '2045'),
('2047', '-1', '1996', '1997'),('2048', '-1', '1998', '1999'),('2049', '-1', '2047', '2048'),('2050', '-1', '2000', '2049'),
('2051', '-1', '2001', '2002'),('2052', '-1', '2003', '2004'),('2053', '-1', '2051', '2052'),('2054', '-1', '2005', '2053'),
('2055', '-1', '2006', '2007'),('2056', '-1', '2008', '2009'),('2057', '-1', '2055', '2056'),('2058', '-1', '2010', '2057'),
('2059', '-1', '144', '2042'),('2060', '-1', '2046', '2059'),
('2061', '-1', '2035', '2040'),
('2062', '-1', '144', '2029'),('2063', '-1', '2061', '2062'),('2064', '-1', '2050', '2063'),
('2065', '-1', '2029', '2040'),
('2066', '-1', '144', '2034'),('2067', '-1', '2065', '2066'),('2068', '-1', '2054', '2067'),
('2069', '-1', '2029', '2034'),
('2070', '-1', '144', '2039'),('2071', '-1', '2069', '2070'),('2072', '-1', '2058', '2071');
#
UPDATE `gossip_menu_option` SET `condition_id`='2060' WHERE `menu_id`=10996 AND `id`=2;
UPDATE `gossip_menu_option` SET `condition_id`='2064' WHERE `menu_id`=10996 AND `id`=3;
UPDATE `gossip_menu_option` SET `condition_id`='2068' WHERE `menu_id`=10996 AND `id`=4;
UPDATE `gossip_menu_option` SET `condition_id`='2072' WHERE `menu_id`=10996 AND `id`=5;
#
DELETE FROM `gossip_menu_option` WHERE `menu_id`=10996 AND `id`=6;
DELETE FROM `locales_gossip_menu_option` WHERE `menu_id`=10996 AND`id`=6;
DELETE FROM `gossip_menu_option` WHERE `menu_id`=11002;
DELETE FROM `locales_gossip_menu_option` WHERE `menu_id`=11002;
DELETE FROM `gossip_menu` WHERE `entry`=11002;
#
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='80', `condition_id`='958' WHERE `menu_id`=10998 AND `id`=0;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='81', `condition_id`='959' WHERE `menu_id`=10998 AND `id`=1;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='82', `condition_id`='960' WHERE `menu_id`=10998 AND `id`=2;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='83', `condition_id`='957' WHERE `menu_id`=10998 AND `id`=3;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='84', `condition_id`='961' WHERE `menu_id`=10998 AND `id`=4;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='86', `condition_id`='958' WHERE `menu_id`=10999 AND `id`=0;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='87', `condition_id`='959' WHERE `menu_id`=10999 AND `id`=1;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='88', `condition_id`='960' WHERE `menu_id`=10999 AND `id`=2;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='89', `condition_id`='957' WHERE `menu_id`=10999 AND `id`=3;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='90', `condition_id`='961' WHERE `menu_id`=10999 AND `id`=4;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='91', `condition_id`='958' WHERE `menu_id`=11000 AND `id`=0;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='92', `condition_id`='959' WHERE `menu_id`=11000 AND `id`=1;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='93', `condition_id`='960' WHERE `menu_id`=11000 AND `id`=2;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='94', `condition_id`='957' WHERE `menu_id`=11000 AND `id`=3;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='95', `condition_id`='961' WHERE `menu_id`=11000 AND `id`=4;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='96', `condition_id`='958' WHERE `menu_id`=11001 AND `id`=0;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='97', `condition_id`='959' WHERE `menu_id`=11001 AND `id`=1;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='98', `condition_id`='960' WHERE `menu_id`=11001 AND `id`=2;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='99', `condition_id`='957' WHERE `menu_id`=11001 AND `id`=3;
UPDATE `gossip_menu_option` SET `option_text`='This does not happen again.', `action_menu_id`='-1', `action_script_id`='100', `condition_id`='961' WHERE `menu_id`=11001 AND `id`=4;
#
DELETE FROM `dbscripts_on_gossip` WHERE `id` in (80,81,82,83,84,86,87,88,89,90,91,92,93,94,95,96,9 7,98,99,100);
INSERT INTO `dbscripts_on_gossip` (`id`, `delay`, `command`, `datalong`, `datalong2`, `buddy_entry`, `search_radius`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
('80', '0', '17', '50375', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Courage'),
('81', '0', '17', '50376', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Vengeance'),
('82', '0', '17', '50377', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Destruction'),
('83', '0', '17', '50378', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Wisdom'),
('84', '0', '17', '52569', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Might'),
('86', '0', '17', '50388', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Greater Courage'),
('87', '0', '17', '50387', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Greater Vengeance'),
('88', '0', '17', '50384', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Greater Destruction'),
('89', '0', '17', '50386', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Greater Wisdom'),
('90', '0', '17', '52570', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Greater Might'),
('91', '0', '17', '50403', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Unmatched Courage'),
('92', '0', '17', '50401', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Unmatched Vengeance'),
('93', '0', '17', '50397', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Unmatched Destruction'),
('94', '0', '17', '50399', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Unmatched Wisdom'),
('95', '0', '17', '52571', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Unmatched Might'),
('96', '0', '17', '50404', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Endless Courage'),
('97', '0', '17', '50402', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Endless Vengeance'),
('98', '0', '17', '50398', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Endless Destruction'),
('99', '0', '17', '50400', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Endless Wisdom'),
('100', '0', '17', '52572', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'create item Ashen Band of Endless Might');
vBulletin® v3.8.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd. Перевод: zCarot