Показать сообщение отдельно
Старый 23.03.2013, 20:37   #35
NeatElves
YTDB dev
 
Аватар для NeatElves
 
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
NeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспорима
По умолчанию

Под мангос:
1. Юра, эта часть уже есть в моей теме.)) Остальным залить, чтобы ошибок в логе не было:

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,97,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');
NeatElves вне форума