diff options
| -rw-r--r-- | sql/updates/world/2011_04_23_05_world_gossips.sql | 164 |
1 files changed, 164 insertions, 0 deletions
diff --git a/sql/updates/world/2011_04_23_05_world_gossips.sql b/sql/updates/world/2011_04_23_05_world_gossips.sql new file mode 100644 index 00000000000..db86ec8942e --- /dev/null +++ b/sql/updates/world/2011_04_23_05_world_gossips.sql @@ -0,0 +1,164 @@ +-- Gossip Menu insert +DELETE FROM `gossip_menu` WHERE `entry`=7303 AND `text_id`=8662; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7303,8662); +DELETE FROM `gossip_menu` WHERE `entry`=7380 AND `text_id`=8835; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7380,8835); +DELETE FROM `gossip_menu` WHERE `entry`=7424 AND `text_id`=8973; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7424,8973); +DELETE FROM `gossip_menu` WHERE `entry`=7423 AND `text_id`=8972; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7423,8972); +DELETE FROM `gossip_menu` WHERE `entry`=7425 AND `text_id`=8974; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7425,8974); +DELETE FROM `gossip_menu` WHERE `entry`=11910 AND `text_id`=16726; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11910,16726); +DELETE FROM `gossip_menu` WHERE `entry`=5729 AND `text_id`=6896; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5729,6896); +DELETE FROM `gossip_menu` WHERE `entry`=5728 AND `text_id`=6897; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5728,6897); +DELETE FROM `gossip_menu` WHERE `entry`=5727 AND `text_id`=6898; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5727,6898); +DELETE FROM `gossip_menu` WHERE `entry`=5726 AND `text_id`=6899; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5726,6899); +DELETE FROM `gossip_menu` WHERE `entry`=5725 AND `text_id`=6900; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5725,6900); +DELETE FROM `gossip_menu` WHERE `entry`=5724 AND `text_id`=6901; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5724,6901); +DELETE FROM `gossip_menu` WHERE `entry`=5723 AND `text_id`=6902; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5723,6902); +DELETE FROM `gossip_menu` WHERE `entry`=5737 AND `text_id`=6911; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5737,6911); +DELETE FROM `gossip_menu` WHERE `entry`=7084 AND `text_id`=8336; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7084,8336); +DELETE FROM `gossip_menu` WHERE `entry`=5748 AND `text_id`=6927; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5748,6927); +DELETE FROM `gossip_menu` WHERE `entry`=5756 AND `text_id`=6940; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5756,6940); +DELETE FROM `gossip_menu` WHERE `entry`=5743 AND `text_id`=6919; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5743,6919); +DELETE FROM `gossip_menu` WHERE `entry`=5747 AND `text_id`=6925; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5747,6925); +DELETE FROM `gossip_menu` WHERE `entry`=5755 AND `text_id`=6939; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5755,6939); +DELETE FROM `gossip_menu` WHERE `entry`=10026 AND `text_id`=13902; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10026,13902); +DELETE FROM `gossip_menu` WHERE `entry`=9750 AND `text_id`=13375; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9750,13375); +DELETE FROM `gossip_menu` WHERE `entry`=7522 AND `text_id`=9122; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7522,9122); +DELETE FROM `gossip_menu` WHERE `entry`=9162 AND `text_id`=12756; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9162,12756); +DELETE FROM `gossip_menu` WHERE `entry`=9162 AND `text_id`=12417; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9162,12417); +DELETE FROM `gossip_menu` WHERE `entry`=9164 AND `text_id`=12422; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9164,12422); +DELETE FROM `gossip_menu` WHERE `entry`=9166 AND `text_id`=12424; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9166,12424); +DELETE FROM `gossip_menu` WHERE `entry`=9167 AND `text_id`=12426; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9167,12426); +DELETE FROM `gossip_menu` WHERE `entry`=9144 AND `text_id`=12373; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9144,12373); +DELETE FROM `gossip_menu` WHERE `entry`=9164 AND `text_id`=12422; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9164,12422); +DELETE FROM `gossip_menu` WHERE `entry`=9166 AND `text_id`=12424; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9166,12424); +DELETE FROM `gossip_menu` WHERE `entry`=21230 AND `text_id`=1237; +DELETE FROM `gossip_menu` WHERE `entry`=687 AND `text_id`=1237; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (687,1237); +DELETE FROM `gossip_menu` WHERE `entry`=689 AND `text_id`=1239; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (689,1239); +DELETE FROM `gossip_menu` WHERE `entry`=690 AND `text_id`=1240; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (690,1240); +DELETE FROM `gossip_menu` WHERE `entry`=701 AND `text_id`=1253; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (701,1253); +DELETE FROM `gossip_menu` WHERE `entry`=703 AND `text_id`=1255; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (703,1255); +DELETE FROM `gossip_menu` WHERE `entry`=10990 AND `text_id`=15282; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10990,15282); +DELETE FROM `gossip_menu` WHERE `entry`=10929 AND `text_id`=15188; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10929,15188); +DELETE FROM `gossip_menu` WHERE `entry`=10945 AND `text_id`=15209; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10945,15209); +DELETE FROM `gossip_menu` WHERE `entry`=10946 AND `text_id`=15210; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10946,15210); +DELETE FROM `gossip_menu` WHERE `entry`=10947 AND `text_id`=15211; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10947,15211); +DELETE FROM `gossip_menu` WHERE `entry`=9554 AND `text_id`=12869; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9554,12869); +DELETE FROM `gossip_menu` WHERE `entry`=10400 AND `text_id`=14455; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10400,14455); +DELETE FROM `gossip_menu` WHERE `entry`=10340 AND `text_id`=14408; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10340,14408); +DELETE FROM `gossip_menu` WHERE `entry`=10440 AND `text_id`=14476; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10440,14476); +DELETE FROM `gossip_menu` WHERE `entry`=9550 AND `text_id`=12865; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9550,12865); +DELETE FROM `gossip_menu` WHERE `entry`=9555 AND `text_id`=12868; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9555,12868); +DELETE FROM `gossip_menu` WHERE `entry`=9557 AND `text_id`=12871; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9557,12871); + +-- Creature Gossip_menu_id Update +UPDATE `creature_template` SET `gossip_menu_id`=7303 WHERE `entry`=16554; +UPDATE `creature_template` SET `gossip_menu_id`=5729 WHERE `entry`=14358; +UPDATE `creature_template` SET `gossip_menu_id`=5737 WHERE `entry`=14369; +UPDATE `creature_template` SET `gossip_menu_id`=7084 WHERE `entry`=16032; +UPDATE `creature_template` SET `gossip_menu_id`=5748 WHERE `entry`=14383; +UPDATE `creature_template` SET `gossip_menu_id`=5756 WHERE `entry`=14382; +UPDATE `creature_template` SET `gossip_menu_id`=5747 WHERE `entry`=14368; +UPDATE `creature_template` SET `gossip_menu_id`=5755 WHERE `entry`=14381; +UPDATE `creature_template` SET `gossip_menu_id`=10026 WHERE `entry`=31085; +UPDATE `creature_template` SET `gossip_menu_id`=9740 WHERE `entry`=28082; +UPDATE `creature_template` SET `gossip_menu_id`=9741 WHERE `entry`=28138; +UPDATE `creature_template` SET `gossip_menu_id`=9162 WHERE `entry`=25459; +UPDATE `creature_template` SET `gossip_menu_id`=9164 WHERE `entry`=25475; +UPDATE `creature_template` SET `gossip_menu_id`=9166 WHERE `entry`=25476; +UPDATE `creature_template` SET `gossip_menu_id`=9167 WHERE `entry`=25503; +UPDATE `creature_template` SET `gossip_menu_id`=9144 WHERE `entry`=25237; +UPDATE `creature_template` SET `gossip_menu_id`=9164 WHERE `entry`=25475; +UPDATE `creature_template` SET `gossip_menu_id`=9166 WHERE `entry`=25476; +UPDATE `creature_template` SET `gossip_menu_id`=10990 WHERE `entry`=37671; +UPDATE `creature_template` SET `gossip_menu_id`=10929 WHERE `entry`=37715; +UPDATE `creature_template` SET `gossip_menu_id`=9549 WHERE `entry`=27810; +UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=37887; +UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38041; +UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38040; +UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38039; +UPDATE `creature_template` SET `gossip_menu_id`=10470 WHERE `entry`=33382; +UPDATE `creature_template` SET `gossip_menu_id`=10400 WHERE `entry`=33972; +UPDATE `creature_template` SET `gossip_menu_id`=10340 WHERE `entry`=33447; +UPDATE `creature_template` SET `gossip_menu_id`=9550 WHERE `entry`=27495; + +UPDATE `creature_template` SET `gossip_menu_id`=687 WHERE `gossip_menu_id`=21230; + +-- Creature Gossip_menu_option Update +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7368) AND `id` IN (1,2); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7370,5729,5728,5727,5726,5725,5724,5723,7522,9162) AND `id` IN (0); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (9550,9555) AND `id` IN (0); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10340) AND `id` IN (1); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10976,10929,10945,10946) AND `id` IN (0); +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`) VALUES +(7368,1,0, 'Acteon, where is the best area to hunt for moongraze stags?',1,1,7423,0,0,0,0, ''), +(7368,2,0, 'Acteon, where is the best place to hunt moongraze bucks?',1,1,7424,0,0,0,0, ''), +(7370,0,0, 'Where can I find more infected nightstalker runts, Exarch?',1,1,7425,0,0,0,0, ''), +(5729,0,0, 'What happened here, spirit?',1,1,5728,0,0,0,0, ''), +(5728,0,0, 'I know very little of the Highborne and nothing of the Shen''dralar.',1,1,5727,0,0,0,0, ''), +(5727,0,0, 'Continue, please.',1,1,5726,0,0,0,0, ''), +(5726,0,0, 'Fascinating. Continue, please.',1,1,5725,0,0,0,0, ''), +(5725,0,0, 'I''m going to have to kill something, aren''t I?',1,1,5724,0,0,0,0, ''), +(5724,0,0, 'We live in a world of endless tragedy.',1,1,5723,0,0,0,0, ''), +(5723,0,0, 'A very sad tale. Thank you, spirit.',1,1,0,0,0,0,0, ''), +(7522,0,3, 'Teach me the ways of the spirits.',5,16,0,0,0,0,0, ''), +(9162,0,0, 'Send me to Garrosh''s Landing, Yanni.',1,1,0,0,0,0,0, ''), +(10976,0,0, 'I need another disguise.',1,1,0,0,0,0,0, ''), +(10929,0,0, 'I have a rocket here with your mark on it, Snivel.',1,1,10945,0,0,0,0, ''), +(10945,0,0, 'There''s a chemical inside the rocket. What is it?',1,1,10946,0,0,0,0, ''), +(10946,0,0, 'Where were they delivered?',1,1,10947,0,0,0,0, ''), +(9550,0,0, 'Why would I want to ride a shredder?',1,1,9555,0,0,0,0, ''), +(9555,0,0, 'Where can I get a Refurbished Shredder Key?',1,1,9557,0,0,0,0, ''), +(10340,1,0, 'How do the Argent Crusade riders fight?',1,1,10440,0,0,0,0, ''); + +DELETE FROM `npc_text` WHERE `ID` IN (16540,8336,16726) AND `WDBVerified`=-1; +INSERT INTO `npc_text` (`ID`,`text0_0`,`WDBVerified`) VALUES +(16540, '[PH]', -1), +(8336, '[PH]', -1), +(16726, '[PH]', -1); |