diff options
| -rw-r--r-- | sql/updates/world/2011_04_16_00_world_gossip_menu.sql | 579 |
1 files changed, 579 insertions, 0 deletions
diff --git a/sql/updates/world/2011_04_16_00_world_gossip_menu.sql b/sql/updates/world/2011_04_16_00_world_gossip_menu.sql new file mode 100644 index 00000000000..6a2a4d951a3 --- /dev/null +++ b/sql/updates/world/2011_04_16_00_world_gossip_menu.sql @@ -0,0 +1,579 @@ +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=6652 AND `text_id`=9190; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6652,9190); +DELETE FROM `gossip_menu` WHERE `entry`=7146 AND `text_id`=8410; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7146,8410); +DELETE FROM `gossip_menu` WHERE `entry`=7153 AND `text_id`=8417; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7153,8417); +DELETE FROM `gossip_menu` WHERE `entry`=7158 AND `text_id`=8423; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7158,8423); +DELETE FROM `gossip_menu` WHERE `entry`=7159 AND `text_id`=8424; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7159,8424); +DELETE FROM `gossip_menu` WHERE `entry`=7160 AND `text_id`=8429; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7160,8429); +DELETE FROM `gossip_menu` WHERE `entry`=7162 AND `text_id`=8431; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7162,8431); +DELETE FROM `gossip_menu` WHERE `entry`=7163 AND `text_id`=8433; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7163,8433); +DELETE FROM `gossip_menu` WHERE `entry`=7171 AND `text_id`=8445; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7171,8445); +DELETE FROM `gossip_menu` WHERE `entry`=7172 AND `text_id`=8447; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7172,8447); +DELETE FROM `gossip_menu` WHERE `entry`=7188 AND `text_id`=8466; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7188,8466); +DELETE FROM `gossip_menu` WHERE `entry`=7192 AND `text_id`=8472; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7192,8472); +DELETE FROM `gossip_menu` WHERE `entry`=7195 AND `text_id`=8476; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7195,8476); +DELETE FROM `gossip_menu` WHERE `entry`=7204 AND `text_id`=8485; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7204,8485); +DELETE FROM `gossip_menu` WHERE `entry`=7205 AND `text_id`=8487; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7205,8487); +DELETE FROM `gossip_menu` WHERE `entry`=7206 AND `text_id`=8488; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7206,8488); +DELETE FROM `gossip_menu` WHERE `entry`=7207 AND `text_id`=8489; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7207,8489); +DELETE FROM `gossip_menu` WHERE `entry`=7211 AND `text_id`=8501; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7211,8501); +DELETE FROM `gossip_menu` WHERE `entry`=7250 AND `text_id`=8564; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7250,8564); +DELETE FROM `gossip_menu` WHERE `entry`=7251 AND `text_id`=8565; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7251,8565); +DELETE FROM `gossip_menu` WHERE `entry`=7253 AND `text_id`=8569; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7253,8569); +DELETE FROM `gossip_menu` WHERE `entry`=7259 AND `text_id`=8580; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7259,8580); +DELETE FROM `gossip_menu` WHERE `entry`=7287 AND `text_id`=8617; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7287,8617); +DELETE FROM `gossip_menu` WHERE `entry`=7289 AND `text_id`=8620; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7289,8620); +DELETE FROM `gossip_menu` WHERE `entry`=7291 AND `text_id`=8638; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7291,8638); +DELETE FROM `gossip_menu` WHERE `entry`=7446 AND `text_id`=9019; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7446,9019); +DELETE FROM `gossip_menu` WHERE `entry`=7447 AND `text_id`=9020; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7447,9020); +DELETE FROM `gossip_menu` WHERE `entry`=7451 AND `text_id`=9024; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7451,9024); +DELETE FROM `gossip_menu` WHERE `entry`=8775 AND `text_id`=11354; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8775,11354); +DELETE FROM `gossip_menu` WHERE `entry`=8789 AND `text_id`=11256; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8789,11256); +DELETE FROM `gossip_menu` WHERE `entry`=8790 AND `text_id`=11257; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8790,11257); +DELETE FROM `gossip_menu` WHERE `entry`=8791 AND `text_id`=11258; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8791,11258); +DELETE FROM `gossip_menu` WHERE `entry`=8792 AND `text_id`=11259; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8792,11259); +DELETE FROM `gossip_menu` WHERE `entry`=8825 AND `text_id`=11372; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8825,11372); + +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=7146 WHERE `entry`=16187; +UPDATE `creature_template` SET `gossip_menu_id`=7153 WHERE `entry`=16197; +UPDATE `creature_template` SET `gossip_menu_id`=7158 WHERE `entry`=16213; +UPDATE `creature_template` SET `gossip_menu_id`=7159 WHERE `entry`=16219; +UPDATE `creature_template` SET `gossip_menu_id`=7160 WHERE `entry`=16220; +UPDATE `creature_template` SET `gossip_menu_id`=7162 WHERE `entry`=16224; +UPDATE `creature_template` SET `gossip_menu_id`=7163 WHERE `entry`=16231; +UPDATE `creature_template` SET `gossip_menu_id`=7171 WHERE `entry`=16253; +UPDATE `creature_template` SET `gossip_menu_id`=7172 WHERE `entry`=16252; +UPDATE `creature_template` SET `gossip_menu_id`=7188 WHERE `entry`=16289; +UPDATE `creature_template` SET `gossip_menu_id`=7192 WHERE `entry`=16293; +UPDATE `creature_template` SET `gossip_menu_id`=7195 WHERE `entry`=16203; +UPDATE `creature_template` SET `gossip_menu_id`=7204 WHERE `entry`=16205; +UPDATE `creature_template` SET `gossip_menu_id`=7205 WHERE `entry`=16202; +UPDATE `creature_template` SET `gossip_menu_id`=7206 WHERE `entry`=16201; +UPDATE `creature_template` SET `gossip_menu_id`=7207 WHERE `entry`=16251; +UPDATE `creature_template` SET `gossip_menu_id`=7250 WHERE `entry`=16462; +UPDATE `creature_template` SET `gossip_menu_id`=7251 WHERE `entry`=16464; +UPDATE `creature_template` SET `gossip_menu_id`=7253 WHERE `entry`=16463; +UPDATE `creature_template` SET `gossip_menu_id`=7259 WHERE `entry`=16480; +UPDATE `creature_template` SET `gossip_menu_id`=7287 WHERE `entry`=16528; +UPDATE `creature_template` SET `gossip_menu_id`=7288 WHERE `entry`=16542; +UPDATE `creature_template` SET `gossip_menu_id`=7289 WHERE `entry`=16217; +UPDATE `creature_template` SET `gossip_menu_id`=7291 WHERE `entry`=16603; +UPDATE `creature_template` SET `gossip_menu_id`=7446 WHERE `entry`=17655; +UPDATE `creature_template` SET `gossip_menu_id`=7447 WHERE `entry`=17656; +UPDATE `creature_template` SET `gossip_menu_id`=7451 WHERE `entry`=16665; +UPDATE `creature_template` SET `gossip_menu_id`=8775 WHERE `entry`=23559; +UPDATE `creature_template` SET `gossip_menu_id`=8789 WHERE `entry`=23718; + +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (6652,7287,7146,7171,7451,7446,7153,7447,8789) AND `id` IN (0); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (6652,7171,8789) AND `id` IN (1); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (8789) AND `id` IN (2); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (8775) AND `id` IN (6); +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 +(6652,0,3, 'I seek training in the ways of the Hunter.',5,16,0,0,0,0,0, ''), +(6652,1,0, 'I wish to unlearn my talents.',16,16,0,0,0,0,0, ''), +(7287,0,1, 'Show me what I have access to, Vredigar.',3,128,0,0,0,0,0, ''), +(7146,0,1, 'Let me browse your goods.',3,128,0,0,0,0,0, ''), +(7171,0,3, 'Master chef, can you train me in the culinary arts?',5,16,0,0,0,0,0, ''), +(7171,1,1, 'Have you any cooking supplies?',3,128,0,0,0,0,0, ''), +(7451,0,12, 'I wish to make use of the stables.',14,4194304,0,0,0,0,0, ''), +(7446,0,1, 'I want to browse your goods.',3,128,0,0,0,0,0, ''), +(7153,0,0, 'Arcanist Vandril, what are the Forsaken doing here?',1,1,7211,0,0,0,0, ''), +(7447,0,1, 'Let me browse your goods.',3,128,0,0,0,0,0, ''), +(8789,0,0, 'Who is this Budd fellow?',1,1,8790,0,0,0,0, ''), +(8789,1,0, 'Interesting crew you''ve got here....',1,1,8791,0,0,0,0, ''), +(8789,2,0, 'Whew! What''s that smell?',1,1,8792,0,0,0,0, ''), +(8775,6,0, 'Are you suggesting I provide you with people for Zul''jin''s sacrifices?',1,1,8825,0,0,0,0, ''); + +-- Insert npc_text from sniff +DELETE FROM `npc_text` WHERE `ID` IN (11354,11372); +INSERT INTO `npc_text` (`ID`,`prob0`,`text0_0`,`text0_1`,`lang0`,`em0_0`,`em0_1`,`em0_2`,`em0_3`,`em0_4`,`em0_5`,`prob1`,`text1_0`,`text1_1`,`lang1`,`em1_0`,`em1_1`,`em1_2`,`em1_3`,`em1_4`,`em1_5`,`prob2`,`text2_0`,`text2_1`,`lang2`,`em2_0`,`em2_1`,`em2_2`,`em2_3`,`em2_4`,`em2_5`,`prob3`,`text3_0`,`text3_1`,`lang3`,`em3_0`,`em3_1`,`em3_2`,`em3_3`,`em3_4`,`em3_5`,`prob4`,`text4_0`,`text4_1`,`lang4`,`em4_0`,`em4_1`,`em4_2`,`em4_3`,`em4_4`,`em4_5`,`prob5`,`text5_0`,`text5_1`,`lang5`,`em5_0`,`em5_1`,`em5_2`,`em5_3`,`em5_4`,`em5_5`,`prob6`,`text6_0`,`text6_1`,`lang6`,`em6_0`,`em6_1`,`em6_2`,`em6_3`,`em6_4`,`em6_5`,`prob7`,`text7_0`,`text7_1`,`lang7`,`em7_0`,`em7_1`,`em7_2`,`em7_3`,`em7_4`,`em7_5`,`WDBVerified`) VALUES +(11354,1,'Listen, $c, it''s clear that you and your friends know your way around Azeroth. Surely you''ve come across certain folks who hunger for fame and fortune. $b$bSend me anyone who might be willing to enter Zul''Aman and I''ll make it worth your while.','',0,0,1,1000,1,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(11372,1,'Perish the thought!$b$bI''m simply trying to rid the world of a horrible menace, and that type of thing rarely comes without a price, as I''m sure you know.$b$bThink of it like this, $n. You''ll be offering ordinary folks the chance to become heroes! A rare opportunity indeed!$b$bYou just send them my way and I''ll handle the rest....','',0,0,1,1000,1,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1); + +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=10921 AND `text_id`=15170; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10921,15170); +DELETE FROM `gossip_menu` WHERE `entry`=10948 AND `text_id`=15212; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10948,15212); +DELETE FROM `gossip_menu` WHERE `entry`=7925 AND `text_id`=9704; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7925,9704); +DELETE FROM `gossip_menu` WHERE `entry`=10976 AND `text_id`=15256; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10976,15256); +DELETE FROM `gossip_menu` WHERE `entry`=12024 AND `text_id`=16850; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12024,16850); +DELETE FROM `gossip_menu` WHERE `entry`=11983 AND `text_id`=16801; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11983,16801); +DELETE FROM `gossip_menu` WHERE `entry`=11979 AND `text_id`=16796; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11979,16796); +DELETE FROM `gossip_menu` WHERE `entry`=11952 AND `text_id`=16779; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11952,16779); +DELETE FROM `gossip_menu` WHERE `entry`=6647 AND `text_id`=7904; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6647,7904); +DELETE FROM `gossip_menu` WHERE `entry`=11793 AND `text_id`=16540; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11793,16540); + +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=10921 WHERE `entry`=37675; +UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38042; +UPDATE `creature_template` SET `gossip_menu_id`=7925 WHERE `entry`=19175; +UPDATE `creature_template` SET `gossip_menu_id`=10976 WHERE `entry`=37172; + +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (6647) AND `id` IN (0,1); +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 +(6647,0,3, 'I would like to train further in the ways of the Light.',5,16,0,0,0,0,0, ''), +(6647,1,0, 'I wish to unlearn my talents.',16,16,0,0,0,0,0, ''); + +-- Insert npc_text from sniff +DELETE FROM `npc_text` WHERE `ID` IN (9704,16850,16801,16796,16779); +INSERT INTO `npc_text` (`ID`,`prob0`,`text0_0`,`text0_1`,`lang0`,`em0_0`,`em0_1`,`em0_2`,`em0_3`,`em0_4`,`em0_5`,`prob1`,`text1_0`,`text1_1`,`lang1`,`em1_0`,`em1_1`,`em1_2`,`em1_3`,`em1_4`,`em1_5`,`prob2`,`text2_0`,`text2_1`,`lang2`,`em2_0`,`em2_1`,`em2_2`,`em2_3`,`em2_4`,`em2_5`,`prob3`,`text3_0`,`text3_1`,`lang3`,`em3_0`,`em3_1`,`em3_2`,`em3_3`,`em3_4`,`em3_5`,`prob4`,`text4_0`,`text4_1`,`lang4`,`em4_0`,`em4_1`,`em4_2`,`em4_3`,`em4_4`,`em4_5`,`prob5`,`text5_0`,`text5_1`,`lang5`,`em5_0`,`em5_1`,`em5_2`,`em5_3`,`em5_4`,`em5_5`,`prob6`,`text6_0`,`text6_1`,`lang6`,`em6_0`,`em6_1`,`em6_2`,`em6_3`,`em6_4`,`em6_5`,`prob7`,`text7_0`,`text7_1`,`lang7`,`em7_0`,`em7_1`,`em7_2`,`em7_3`,`em7_4`,`em7_5`,`WDBVerified`) VALUES +(9704,1,'The largest celebration of the Lunar Festival is taking place in Moonglade. If that''s too far to travel to, there are druids offering transport from the Valley of Wisdom.','The largest celebration of the Lunar Festival is taking place in Moonglade. If that''s too far to travel to, there are druids offering transport from the Valley of Wisdom.',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16850,1,'Never underestimate the power of proper supply management. The warriors may win the battles, but it''s the supplies that win the war. ','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16801,1,'There are no emotions. There are no morals. There are no zealots.$B$BThere is only the Brotherhood.$B$BHere, in the very chapel where Uther the Lightbringer joined the Order of the Silver Hand, I, Korfax, Champion of the Light, will inspire fear into the fearless.$B$BNothing will curb my fury - not the Scarlet Crusade, not the Argent Dawn, not my brothers, not even you.','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16796,1,'The Brotherhood of the Light transcends the ability of any other group to eradicate affronts to the Light. We will take any actions necessary to rid the world of foul beasts like these undead. Nothing will stand in our way.$B$BAre you with us, or against us?','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16779,1,'Weapons...armor...these are the keys to victory. Any warrior, no matter how strong, is essentially defenseless without them.$B$BI have crafted many a legend in my day, $r. You will find nothing like them in all of Azeroth. They are the key to my brethren''s success.','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1); + + +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=141 AND `text_id`=4793; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (141,4793); +DELETE FROM `gossip_menu` WHERE `entry`=523 AND `text_id`=4985; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (523,4985); +DELETE FROM `gossip_menu` WHERE `entry`=1582 AND `text_id`=938; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (1582,938); +DELETE FROM `gossip_menu` WHERE `entry`=2384 AND `text_id`=2193; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (2384,2193); +DELETE FROM `gossip_menu` WHERE `entry`=2782 AND `text_id`=3466; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (2782,3466); +DELETE FROM `gossip_menu` WHERE `entry`=3062 AND `text_id`=3794; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (3062,3794); +DELETE FROM `gossip_menu` WHERE `entry`=3162 AND `text_id`=3896; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (3162,3896); +DELETE FROM `gossip_menu` WHERE `entry`=3187 AND `text_id`=3954; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (3187,3954); +DELETE FROM `gossip_menu` WHERE `entry`=4017 AND `text_id`=4888; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4017,4888); +DELETE FROM `gossip_menu` WHERE `entry`=4104 AND `text_id`=5006; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4104,5006); +DELETE FROM `gossip_menu` WHERE `entry`=4105 AND `text_id`=5008; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4105,5008); +DELETE FROM `gossip_menu` WHERE `entry`=4509 AND `text_id`=4985; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4509,4985); +DELETE FROM `gossip_menu` WHERE `entry`=4511 AND `text_id`=4985; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4511,4985); +DELETE FROM `gossip_menu` WHERE `entry`=4603 AND `text_id`=5715; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4603,5715); +DELETE FROM `gossip_menu` WHERE `entry`=4604 AND `text_id`=5715; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4604,5715); +DELETE FROM `gossip_menu` WHERE `entry`=4643 AND `text_id`=5715; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4643,5715); +DELETE FROM `gossip_menu` WHERE `entry`=4741 AND `text_id`=5793; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4741,5793); +DELETE FROM `gossip_menu` WHERE `entry`=4747 AND `text_id`=5799; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4747,5799); +DELETE FROM `gossip_menu` WHERE `entry`=5848 AND `text_id`=7010; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5848,7010); +DELETE FROM `gossip_menu` WHERE `entry`=6815 AND `text_id`=7935; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6815,7935); +DELETE FROM `gossip_menu` WHERE `entry`=6899 AND `text_id`=7935; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6899,7935); +DELETE FROM `gossip_menu` WHERE `entry`=6918 AND `text_id`=8205; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6918,8205); +DELETE FROM `gossip_menu` WHERE `entry`=7935 AND `text_id`=9716; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7935,9716); +DELETE FROM `gossip_menu` WHERE `entry`=10031 AND `text_id`=13911; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10031,13911); +DELETE FROM `gossip_menu` WHERE `entry`=10181 AND `text_id`=14126; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10181,14126); +DELETE FROM `gossip_menu` WHERE `entry`=10638 AND `text_id`=14736; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10638,14736); +DELETE FROM `gossip_menu` WHERE `entry`=11185 AND `text_id`=5002; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11185,5002); +DELETE FROM `gossip_menu` WHERE `entry`=11189 AND `text_id`=15572; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11189,15572); +DELETE FROM `gossip_menu` WHERE `entry`=11653 AND `text_id`=16283; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11653,16283); +DELETE FROM `gossip_menu` WHERE `entry`=11681 AND `text_id`=16344; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11681,16344); +DELETE FROM `gossip_menu` WHERE `entry`=11726 AND `text_id`=16413; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11726,16413); +DELETE FROM `gossip_menu` WHERE `entry`=11766 AND `text_id`=16489; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11766,16489); +DELETE FROM `gossip_menu` WHERE `entry`=11767 AND `text_id`=16490; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11767,16490); +DELETE FROM `gossip_menu` WHERE `entry`=11790 AND `text_id`=16535; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11790,16535); +DELETE FROM `gossip_menu` WHERE `entry`=11824 AND `text_id`=16578; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11824,16578); +DELETE FROM `gossip_menu` WHERE `entry`=11875 AND `text_id`=4973; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11875,4973); +DELETE FROM `gossip_menu` WHERE `entry`=11877 AND `text_id`=5717; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11877,5717); +DELETE FROM `gossip_menu` WHERE `entry`=11878 AND `text_id`=5006; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11878,5006); +DELETE FROM `gossip_menu` WHERE `entry`=11879 AND `text_id`=4998; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11879,4998); +DELETE FROM `gossip_menu` WHERE `entry`=11906 AND `text_id`=16715; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11906,16715); +DELETE FROM `gossip_menu` WHERE `entry`=11912 AND `text_id`=4986; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11912,4986); +DELETE FROM `gossip_menu` WHERE `entry`=11913 AND `text_id`=5004; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11913,5004); +DELETE FROM `gossip_menu` WHERE `entry`=11919 AND `text_id`=16734; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11919,16734); +DELETE FROM `gossip_menu` WHERE `entry`=11932 AND `text_id`=16749; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11932,16749); +DELETE FROM `gossip_menu` WHERE `entry`=11933 AND `text_id`=565; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11933,565); +DELETE FROM `gossip_menu` WHERE `entry`=11951 AND `text_id`=16778; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11951,16778); +DELETE FROM `gossip_menu` WHERE `entry`=11969 AND `text_id`=16783; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11969,16783); +DELETE FROM `gossip_menu` WHERE `entry`=11971 AND `text_id`=16789; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11971,16789); +DELETE FROM `gossip_menu` WHERE `entry`=12050 AND `text_id`=16882; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12050,16882); +DELETE FROM `gossip_menu` WHERE `entry`=12094 AND `text_id`=16982; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12094,16982); +DELETE FROM `gossip_menu` WHERE `entry`=12095 AND `text_id`=16983; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12095,16983); +DELETE FROM `gossip_menu` WHERE `entry`=12151 AND `text_id`=17085; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12151,17085); +DELETE FROM `gossip_menu` WHERE `entry`=12233 AND `text_id`=17176; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12233,17176); +DELETE FROM `gossip_menu` WHERE `entry`=12235 AND `text_id`=17180; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12235,17180); +DELETE FROM `gossip_menu` WHERE `entry`=12443 AND `text_id`=17499; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12443,17499); +DELETE FROM `gossip_menu` WHERE `entry`=12563 AND `text_id`=17647; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12563,17647); +DELETE FROM `gossip_menu` WHERE `entry`=12670 AND `text_id`=12549; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12670,12549); + +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=64 WHERE `entry`=5880; +UPDATE `creature_template` SET `gossip_menu_id`=141 WHERE `entry`=3170; +UPDATE `creature_template` SET `gossip_menu_id`=141 WHERE `entry`=3155; +UPDATE `creature_template` SET `gossip_menu_id`=523 WHERE `entry`=3169; +UPDATE `creature_template` SET `gossip_menu_id`=2384 WHERE `entry`=3326; +UPDATE `creature_template` SET `gossip_menu_id`=2782 WHERE `entry`=1383; +UPDATE `creature_template` SET `gossip_menu_id`=3062 WHERE `entry`=10578; +UPDATE `creature_template` SET `gossip_menu_id`=3162 WHERE `entry`=7952; +UPDATE `creature_template` SET `gossip_menu_id`=3187 WHERE `entry`=11176; +UPDATE `creature_template` SET `gossip_menu_id`=3644 WHERE `entry`=3706; +UPDATE `creature_template` SET `gossip_menu_id`=4017 WHERE `entry`=3171; +UPDATE `creature_template` SET `gossip_menu_id`=4104 WHERE `entry`=3173; +UPDATE `creature_template` SET `gossip_menu_id`=4509 WHERE `entry`=3353; +UPDATE `creature_template` SET `gossip_menu_id`=4511 WHERE `entry`=3354; +UPDATE `creature_template` SET `gossip_menu_id`=4603 WHERE `entry`=3324; +UPDATE `creature_template` SET `gossip_menu_id`=4604 WHERE `entry`=3325; +UPDATE `creature_template` SET `gossip_menu_id`=4643 WHERE `entry`=3156; +UPDATE `creature_template` SET `gossip_menu_id`=4741 WHERE `entry`=3332; +UPDATE `creature_template` SET `gossip_menu_id`=4747 WHERE `entry`=3399; +UPDATE `creature_template` SET `gossip_menu_id`=5848 WHERE `entry`=14451; +UPDATE `creature_template` SET `gossip_menu_id`=5856 WHERE `entry`=5943; +UPDATE `creature_template` SET `gossip_menu_id`=6565 WHERE `entry`=7951; +UPDATE `creature_template` SET `gossip_menu_id`=6815 WHERE `entry`=15572; +UPDATE `creature_template` SET `gossip_menu_id`=6899 WHERE `entry`=15579; +UPDATE `creature_template` SET `gossip_menu_id`=6918 WHERE `entry`=15895; +UPDATE `creature_template` SET `gossip_menu_id`=7935 WHERE `entry`=19177; +UPDATE `creature_template` SET `gossip_menu_id`=10031 WHERE `entry`=5875; +UPDATE `creature_template` SET `gossip_menu_id`=10181 WHERE `entry`=3881; +UPDATE `creature_template` SET `gossip_menu_id`=10638 WHERE `entry`=35364; +UPDATE `creature_template` SET `gossip_menu_id`=11189 WHERE `entry`=10676; +UPDATE `creature_template` SET `gossip_menu_id`=11790 WHERE `entry`=3139; +UPDATE `creature_template` SET `gossip_menu_id`=11971 WHERE `entry`=9988; +UPDATE `creature_template` SET `gossip_menu_id`=12670 WHERE `entry`=12776; +UPDATE `creature_template` SET `gossip_menu_id`=12670 WHERE `entry`=6027; +UPDATE `creature_template` SET `gossip_menu_id`=12670 WHERE `entry`=5815; + +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (1012,6899,12443,2746,10181,4142,4741,4747,11767,10638,7034,6918) AND `id` IN (0); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (12443,11767,6899,3162,6815) AND `id` IN (1); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (6815,1582,11919) AND `id` IN (2); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (1582,11919,6815,6899) AND `id` IN (3); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (6899) AND `id` IN (4); +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 +(1012,0,3, 'Train me.',5,16,0,0,0,0,0, ''), +(6899,0,0, 'Where is Elder Darkcore?',1,1,0,0,0,0,0, ''), +(12443,0,3, 'Train me.',5,16,0,0,0,0,0, ''), +(2746,0,3, 'Train me.',5,16,0,0,0,0,0, ''), +(10181,0,1, 'I want to browse your goods.',3,128,0,0,0,0,0, ''), +(4142,0,3, 'Train me.',5,16,0,0,0,0,0, ''), +(4741,0,3, 'I require training, Lumak.',5,16,0,0,0,0,0, ''), +(4747,0,3, 'I require training, Zamja.',5,16,0,0,0,0,0, ''), +(11767,0,3, 'I would like to train.',5,16,0,0,0,0,0, ''), +(10638,0,0, 'I no longer wish to gain experience.',1,1,0,0,0,0,0, ''), +(7034,0,0, 'I would like to enter the secret code to receive my Murloc pet.',1,1,0,0,0,0,0, ''), +(6918,0,0, 'I''d like a new invitation to the Lunar Festival.',1,1,0,0,0,0,0, ''), +(12443,1,1, 'Let me browse your goods.',3,128,0,0,0,0,0, ''), +(11767,1,0, 'I wish to unlearn my talents.',16,16,0,0,0,0,0, ''), +(6899,1,0, 'Where is Elder Ironband?',1,1,0,0,0,0,0, ''), +(3162,1,1, 'I would like to buy from you.',3,128,0,0,0,0,0, ''), +(6815,1,0, 'Where is Elder High Mountain?',1,1,0,0,0,0,0, ''), +(6815,2,0, 'Where is Elder Moonwarden?',1,1,0,0,0,0,0, ''), +(1582,2,5, 'Make this inn your home.',8,65536,0,0,0,0,0, ''), +(11919,2,5, 'Make this inn your home.',8,65536,0,0,0,0,0, ''), +(1582,3,1, 'I want to browse your goods.',3,128,0,0,0,0,0, ''), +(11919,3,1, 'Let me browse your goods.',3,128,0,0,0,0,0, ''), +(6815,3,0, 'Where is Elder Windtotem?',1,1,0,0,0,0,0, ''), +(6899,3,0, 'Where is Elder Runetotem?',1,1,0,0,0,0,0, ''), +(6899,4,0, 'Where is Elder Windtotem?',1,1,0,0,0,0,0, ''); + +-- Insert npc_text from sniff +DELETE FROM `npc_text` WHERE `ID` IN (14126,15572,16283,16344,16413,16489,16490,16535,16578,16715,16734,16749,16778,16783,16789,16882,16982,16983,17085,17125,17176,17180,17499,17647); +INSERT INTO `npc_text` (`ID`,`prob0`,`text0_0`,`text0_1`,`lang0`,`em0_0`,`em0_1`,`em0_2`,`em0_3`,`em0_4`,`em0_5`,`prob1`,`text1_0`,`text1_1`,`lang1`,`em1_0`,`em1_1`,`em1_2`,`em1_3`,`em1_4`,`em1_5`,`prob2`,`text2_0`,`text2_1`,`lang2`,`em2_0`,`em2_1`,`em2_2`,`em2_3`,`em2_4`,`em2_5`,`prob3`,`text3_0`,`text3_1`,`lang3`,`em3_0`,`em3_1`,`em3_2`,`em3_3`,`em3_4`,`em3_5`,`prob4`,`text4_0`,`text4_1`,`lang4`,`em4_0`,`em4_1`,`em4_2`,`em4_3`,`em4_4`,`em4_5`,`prob5`,`text5_0`,`text5_1`,`lang5`,`em5_0`,`em5_1`,`em5_2`,`em5_3`,`em5_4`,`em5_5`,`prob6`,`text6_0`,`text6_1`,`lang6`,`em6_0`,`em6_1`,`em6_2`,`em6_3`,`em6_4`,`em6_5`,`prob7`,`text7_0`,`text7_1`,`lang7`,`em7_0`,`em7_1`,`em7_2`,`em7_3`,`em7_4`,`em7_5`,`WDBVerified`) VALUES +(14126,1,'How may I help you?','How may I help you?',0,0,1,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(15572,1,'Need something?','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16283,1,'Leave this old Dragonmaw to his drink, $c.$B$BI''ve fought creatures that would curl your spine and I''ve seen my people all but slaughtered in the swamps of the wetlands and amidst the ruins of Outland.$B$BGet. Lost.','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16344,1,'You ever been to the jungle, $r?$b$bIt''s real nice.','',0,0,0,0,0,0,0,1,'Stranglethorn, $g man: babe;. That''s where it''s AT!','',0,0,0,0,0,0,0,1,'Hi.','',0,0,0,0,0,0,0,1,'Ah, to be back in Stranglethorn. The screeching raptors, the troll wars, jungle creatures as far as the eye see, just ASKING to be killed...$b$b<Bort sighs.>','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16413,1,'Fishing has always come naturally to my family. You look like you could use a little help though. How about running a few errands for a Master Angler?','',0,0,1,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16489,1,'The Light protect you, $c.','The Light protect you, $c.',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16490,1,'The light of the Sun illuminates the path to wisdom. Where shall we walk today, friend?','The light of the Sun illuminates the path to wisdom. Where shall we walk today, friend?',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16535,1,'Keep your eyes open, $c. Even Durotar is not safe from our enemies.','',0,0,1,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16578,1,'Ya''ll need to find a different trainer, $c. I cannot help ya.','',0,0,1,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16715,1,'Dark is de jungle, but fertile is its soil.$B$BMay de spirits of de earth watch over ya, $c.','Dark is de jungle, but fertile is its soil.$B$BMay de spirits of de earth watch over ya, $c.',1,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16734,100,'Come in, mon... forget yer cares for a while!$B$BRest de body, rest de soul.','Come in, mon... forget yer cares for a while!$B$BRest de body, rest de soul.',1,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16749,1,'De secrets I have ta share would blast your soul apart, $c.$B$BTrust me: You be wantin'' ta talk ta someone else about trainin''.','De secrets I have ta share would blast your soul apart, $c.$B$BTrust me: You be wantin'' ta talk ta someone else about trainin''.',1,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16778,1,'I can''t see a thing with this mask on, but I''m not about to tell HER that.','',1,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16783,1,'You take a wrong turn, mon? Heh heh heh.$B$BWhat can I be helpin'' ya find?','You take a wrong turn, mon? Heh heh heh.$B$BWhat can I be helpin'' ya find?',1,0,153,3,396,0,0,1,'Don''t see many a'' your kind ''round here, mon.$B$BWhat can I be helpin'' ya find?','Don''t see many a'' your kind ''round here, mon.$B$BWhat can I be helpin'' ya find?',1,0,396,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16789,1,'Hey der, mon.$B$BDid ya need help recoverin'' a lost companion?','Hey der, mon.$B$BDid ya need help recoverin'' a lost companion?',0,0,1,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16882,1,'Nothin'' ta see here, mon. Be on yer way, why don''cha?','Nothin'' ta see here, mon. Be on yer way, why don''cha?',1,0,274,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16982,1,'The Highborne have returned, and with them spellcraft lost to the world for centuries.$B$BDo you have something for me to examine?','The Highborne have returned, and with them spellcraft lost to the world for centuries.$B$BDo you have something for me to examine?',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16983,1,'Arcane Reforgers can modify the magical effects of a item; this magically complex process is known simply as reforging.$B$BThrough reforging, a secondary attribute of any piece of weaponry, armor, or jewelry may be reduced in order to add an additional secondary attribute. In this manner one may customize their equipment to best match their role and skills.$B$BFor example, if an item afforded you a bonus to strike your enemies but you''d rather it made you attack more quickly, an Arcane Reforger could, for a price, reforge the item to have less Hit Rating but increase your Haste Rating.','Arcane Reforgers can modify the magical effects of a item; this magically complex process is known simply as reforging.$B$BThrough reforging, a secondary attribute of any piece of weaponry, armor, or jewelry may be reduced in order to add an additional secondary attribute. In this manner one may customize their equipment to best match their role and skills.$B$BFor example, if an item afforded you a bonus to strike your enemies but you''d rather it made you attack more quickly, an Arcane Reforger could, for a price, reforge the item to have less Hit Rating but increase your Haste Rating.',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(17085,1,'After the fall of the Burning Blade Clan, we blademasters swore to free ourselves and our people from demonic control.$B$BThis may be done, but my honor remains unsatisfied.$B$BI shall fight for the Horde - and train other warriors to do so - until I die gloriously in battle. This is the only path I may tread.','After the fall of the Burning Blade Clan, we blademasters swore to free ourselves and our people from demonic control.$B$BThis may be done, but my honor remains unsatisfied.$B$BI shall fight for the Horde - and train other warriors to do so - until I die gloriously in battle. This is the only path I may tread.',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(17125,1,'I can teach you the basics of any gathering or production profession, but that''s all.$B$BTo learn more than an apprentice''s skills, you''ll need to visit a specialist dedicated to only one profession.$B$BYou can learn up to two professions: Two gathering, two production, or one of each.$B$BSecondary skills like Archaeology, Cooking, First Aid, and Fishing don''t count towards your two professions; you can learn as many of those as you like.','I can teach you the basics of any gathering or production profession, but that''s all.$B$BTo learn more than an apprentice''s skills, you''ll need to visit a specialist dedicated to only one profession.$B$BYou can learn up to two professions: Two gathering, two production, or one of each.$B$BSecondary skills like Archaeology, Cooking, First Aid, and Fishing don''t count towards your two professions; you can learn as many of those as you like.',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(17176,1,'For too long we have ignored the secrets of the Arcane.$B$BSadly, they will remain a secret to you.','For too long we have ignored the secrets of the Arcane.$B$BSadly, they will remain a secret to you.',1,0,274,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(17180,1,'Sorry, $c. $B$BYour grasp of the arcane isn''t strong enough to understand portal magic.','Sorry, $c. $B$BYour grasp of the arcane isn''t strong enough to understand portal magic.',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(17499,1,'You be here ta learn fishin'', mon? Or maybe ta buy some tings for it?','You be here ta learn fishin'', mon? Or maybe ta buy some tings for it?',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(17647,1,'Hail, $N. We''re in need of your assistance.','',0,0,1,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1); + +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=5854 AND `text_id`=7017; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5854,7017); +DELETE FROM `gossip_menu` WHERE `entry`=6573 AND `text_id`=7821; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6573,7821); +DELETE FROM `gossip_menu` WHERE `entry`=6570 AND `text_id`=7869; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6570,7869); +DELETE FROM `gossip_menu` WHERE `entry`=7437 AND `text_id`=7903; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7437,7903); +DELETE FROM `gossip_menu` WHERE `entry`=6939 AND `text_id`=8228; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6939,8228); +DELETE FROM `gossip_menu` WHERE `entry`=6940 AND `text_id`=8229; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6940,8229); +DELETE FROM `gossip_menu` WHERE `entry`=6942 AND `text_id`=8232; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6942,8232); +DELETE FROM `gossip_menu` WHERE `entry`=7116 AND `text_id`=8374; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7116,8374); +DELETE FROM `gossip_menu` WHERE `entry`=7117 AND `text_id`=8378; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7117,8378); +DELETE FROM `gossip_menu` WHERE `entry`=7141 AND `text_id`=8403; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7141,8403); +DELETE FROM `gossip_menu` WHERE `entry`=7154 AND `text_id`=8418; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7154,8418); +DELETE FROM `gossip_menu` WHERE `entry`=7155 AND `text_id`=8419; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7155,8419); +DELETE FROM `gossip_menu` WHERE `entry`=7156 AND `text_id`=8421; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7156,8421); +DELETE FROM `gossip_menu` WHERE `entry`=7214 AND `text_id`=8504; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7214,8504); +DELETE FROM `gossip_menu` WHERE `entry`=7235 AND `text_id`=8535; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7235,8535); +DELETE FROM `gossip_menu` WHERE `entry`=7244 AND `text_id`=8552; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7244,8552); +DELETE FROM `gossip_menu` WHERE `entry`=7245 AND `text_id`=8556; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7245,8556); +DELETE FROM `gossip_menu` WHERE `entry`=7247 AND `text_id`=8558; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7247,8558); +DELETE FROM `gossip_menu` WHERE `entry`=7255 AND `text_id`=8575; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7255,8575); +DELETE FROM `gossip_menu` WHERE `entry`=7256 AND `text_id`=8576; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7256,8576); +DELETE FROM `gossip_menu` WHERE `entry`=7311 AND `text_id`=8678; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7311,8678); +DELETE FROM `gossip_menu` WHERE `entry`=7313 AND `text_id`=8682; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7313,8682); +DELETE FROM `gossip_menu` WHERE `entry`=7316 AND `text_id`=8684; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7316,8684); +DELETE FROM `gossip_menu` WHERE `entry`=7323 AND `text_id`=8698; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7323,8698); +DELETE FROM `gossip_menu` WHERE `entry`=7324 AND `text_id`=8699; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7324,8699); +DELETE FROM `gossip_menu` WHERE `entry`=7325 AND `text_id`=8700; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7325,8700); +DELETE FROM `gossip_menu` WHERE `entry`=7344 AND `text_id`=8755; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7344,8755); +DELETE FROM `gossip_menu` WHERE `entry`=7864 AND `text_id`=9630; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7864,9630); +DELETE FROM `gossip_menu` WHERE `entry`=7921 AND `text_id`=9700; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7921,9700); +DELETE FROM `gossip_menu` WHERE `entry`=8098 AND `text_id`=10011; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8098,10011); +DELETE FROM `gossip_menu` WHERE `entry`=8376 AND `text_id`=10451; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8376,10451); +DELETE FROM `gossip_menu` WHERE `entry`=8380 AND `text_id`=10456; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8380,10456); +DELETE FROM `gossip_menu` WHERE `entry`=8732 AND `text_id`=11049; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8732,11049); +DELETE FROM `gossip_menu` WHERE `entry`=8733 AND `text_id`=11055; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8733,11055); +DELETE FROM `gossip_menu` WHERE `entry`=9142 AND `text_id`=12370; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9142,12370); +DELETE FROM `gossip_menu` WHERE `entry`=10991 AND `text_id`=15284; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10991,15284); +DELETE FROM `gossip_menu` WHERE `entry`=11902 AND `text_id`=16703; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11902,16703); +DELETE FROM `gossip_menu` WHERE `entry`=9420 AND `text_id`=12666; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9420,12666); + +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=4783 WHERE `entry`=16271; +UPDATE `creature_template` SET `gossip_menu_id`=5854 WHERE `entry`=16676; +UPDATE `creature_template` SET `gossip_menu_id`=6570 WHERE `entry`=15281; +UPDATE `creature_template` SET `gossip_menu_id`=6573 WHERE `entry`=15301; +UPDATE `creature_template` SET `gossip_menu_id`=6647 WHERE `entry`=16275; +UPDATE `creature_template` SET `gossip_menu_id`=6650 WHERE `entry`=16279; +UPDATE `creature_template` SET `gossip_menu_id`=6652 WHERE `entry`=16270; +UPDATE `creature_template` SET `gossip_menu_id`=6939 WHERE `entry`=15924; +UPDATE `creature_template` SET `gossip_menu_id`=6940 WHERE `entry`=15403; +UPDATE `creature_template` SET `gossip_menu_id`=6942 WHERE `entry`=15951; +UPDATE `creature_template` SET `gossip_menu_id`=7116 WHERE `entry`=16144; +UPDATE `creature_template` SET `gossip_menu_id`=7117 WHERE `entry`=16147; +UPDATE `creature_template` SET `gossip_menu_id`=7141 WHERE `entry`=15416; +UPDATE `creature_template` SET `gossip_menu_id`=7154 WHERE `entry`=16196; +UPDATE `creature_template` SET `gossip_menu_id`=7155 WHERE `entry`=16183; +UPDATE `creature_template` SET `gossip_menu_id`=7156 WHERE `entry`=16210; +UPDATE `creature_template` SET `gossip_menu_id`=7214 WHERE `entry`=16362; +UPDATE `creature_template` SET `gossip_menu_id`=7235 WHERE `entry`=16397; +UPDATE `creature_template` SET `gossip_menu_id`=7244 WHERE `entry`=16443; +UPDATE `creature_template` SET `gossip_menu_id`=7245 WHERE `entry`=16444; +UPDATE `creature_template` SET `gossip_menu_id`=7247 WHERE `entry`=15942; +UPDATE `creature_template` SET `gossip_menu_id`=7255 WHERE `entry`=15398; +UPDATE `creature_template` SET `gossip_menu_id`=7256 WHERE `entry`=15400; +UPDATE `creature_template` SET `gossip_menu_id`=7311 WHERE `entry`=16263; +UPDATE `creature_template` SET `gossip_menu_id`=7313 WHERE `entry`=16860; +UPDATE `creature_template` SET `gossip_menu_id`=7316 WHERE `entry`=16862; +UPDATE `creature_template` SET `gossip_menu_id`=7323 WHERE `entry`=16924; +UPDATE `creature_template` SET `gossip_menu_id`=7324 WHERE `entry`=15397; +UPDATE `creature_template` SET `gossip_menu_id`=7325 WHERE `entry`=15401; +UPDATE `creature_template` SET `gossip_menu_id`=7344 WHERE `entry`=15399; +UPDATE `creature_template` SET `gossip_menu_id`=7346 WHERE `entry`=17056; +UPDATE `creature_template` SET `gossip_menu_id`=7437 WHERE `entry`=16647; +UPDATE `creature_template` SET `gossip_menu_id`=7524 WHERE `entry`=16160; +UPDATE `creature_template` SET `gossip_menu_id`=7524 WHERE `entry`=16161; +UPDATE `creature_template` SET `gossip_menu_id`=7524 WHERE `entry`=16366; +UPDATE `creature_template` SET `gossip_menu_id`=7524 WHERE `entry`=16367; +UPDATE `creature_template` SET `gossip_menu_id`=7566 WHERE `entry`=16646; +UPDATE `creature_template` SET `gossip_menu_id`=7566 WHERE `entry`=16648; +UPDATE `creature_template` SET `gossip_menu_id`=7864 WHERE `entry`=18947; +UPDATE `creature_template` SET `gossip_menu_id`=7921 WHERE `entry`=19169; +UPDATE `creature_template` SET `gossip_menu_id`=8098 WHERE `entry`=16264; +UPDATE `creature_template` SET `gossip_menu_id`=8376 WHERE `entry`=15501; +UPDATE `creature_template` SET `gossip_menu_id`=8380 WHERE `entry`=19775; +UPDATE `creature_template` SET `gossip_menu_id`=8732 WHERE `entry`=16688; +UPDATE `creature_template` SET `gossip_menu_id`=8733 WHERE `entry`=16642; +UPDATE `creature_template` SET `gossip_menu_id`=9142 WHERE `entry`=17718; +UPDATE `creature_template` SET `gossip_menu_id`=9821 WHERE `entry`=16185; +UPDATE `creature_template` SET `gossip_menu_id`=10181 WHERE `entry`=16261; +UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38043; +UPDATE `creature_template` SET `gossip_menu_id`=10991 WHERE `entry`=38295; +UPDATE `creature_template` SET `gossip_menu_id`=11902 WHERE `entry`=15278; +UPDATE `creature_template` SET `gossip_menu_id`=12670 WHERE `entry`=16649; +UPDATE `creature_template` SET `gossip_menu_id`=9420 WHERE `entry`=26647; + +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7244,7245,7256,7311,7313,7524,7864,8098,8376,8380,8732,8733) AND `id` IN (0); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7256,7324,7524) AND `id` IN (1); +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7324) AND `id` IN (2); +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 +(7244,0,1, 'Let me browse your goods.',3,128,0,0,0,0,0, ''), +(7245,0,1, 'Let me browse your goods.',3,128,0,0,0,0,0, ''), +(7256,0,3, 'I wish to learn more about blacksmithing.',5,16,0,0,0,0,0, ''), +(7256,1,1, 'May I see your wares?',3,128,0,0,0,0,0, ''), +(7311,0,1, 'May I see your wares?',3,128,0,0,0,0,0, ''), +(7313,0,1, 'Let me see what hatchlings you have for sale.',3,128,0,0,0,0,0, ''), +(7324,2,1, 'Let me browse your goods.',3,128,0,0,0,0,0, ''), +(7324,1,5, 'Make this inn your home.',8,65536,0,0,0,0,0, ''), +(7524,0,1, 'I want to browse your goods.',3,128,0,0,0,0,0, ''), +(7524,1,3, 'Train me.',5,16,0,0,0,0,0, ''), +(7864,0,1, 'I would like to buy from you.',3,128,0,0,0,0,0, ''), +(8098,0,1, 'I wish to purchase one of these creatures.',3,128,0,0,0,0,0, ''), +(8376,0,3, 'Train me.',5,16,0,0,0,0,0, ''), +(8380,0,3, 'Train me.',5,16,0,0,0,0,0, ''), +(8732,0,3, 'I would like to train.',5,16,0,0,0,0,0, ''), +(8733,0,3, 'I would like to train.',5,16,0,0,0,0,0, ''); + +-- Insert npc_text from sniff +DELETE FROM `npc_text` WHERE `ID` IN (7821,16703); +INSERT INTO `npc_text` (`ID`,`prob0`,`text0_0`,`text0_1`,`lang0`,`em0_0`,`em0_1`,`em0_2`,`em0_3`,`em0_4`,`em0_5`,`prob1`,`text1_0`,`text1_1`,`lang1`,`em1_0`,`em1_1`,`em1_2`,`em1_3`,`em1_4`,`em1_5`,`prob2`,`text2_0`,`text2_1`,`lang2`,`em2_0`,`em2_1`,`em2_2`,`em2_3`,`em2_4`,`em2_5`,`prob3`,`text3_0`,`text3_1`,`lang3`,`em3_0`,`em3_1`,`em3_2`,`em3_3`,`em3_4`,`em3_5`,`prob4`,`text4_0`,`text4_1`,`lang4`,`em4_0`,`em4_1`,`em4_2`,`em4_3`,`em4_4`,`em4_5`,`prob5`,`text5_0`,`text5_1`,`lang5`,`em5_0`,`em5_1`,`em5_2`,`em5_3`,`em5_4`,`em5_5`,`prob6`,`text6_0`,`text6_1`,`lang6`,`em6_0`,`em6_1`,`em6_2`,`em6_3`,`em6_4`,`em6_5`,`prob7`,`text7_0`,`text7_1`,`lang7`,`em7_0`,`em7_1`,`em7_2`,`em7_3`,`em7_4`,`em7_5`,`WDBVerified`) VALUES +(7821,1,'','Ah, $N - it is good to see you again. I trust your affairs go well.',0,0,2,0,1,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1), +(16703,1,'','$N! I hope you''re ready to get to work, because there is much for you to do here on Sunstrider Isle.$B$BEver since the destruction of the Sunwell by Arthas and the Scourge, we have been a race adrift on a sea of uncertainty. We teeter on the edge of oblivion. This will change, $c, and you will learn and aid our recovery at the same time.$B$BThe Outland awaits us!',0,0,1,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1); + + +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=7436 AND `text_id`=9005; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7436,9005); +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=7436 WHERE `entry`=16268; +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id`=7436 AND `id`=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 +(7436,0,1, 'May I see your wares?',3,128,0,0,0,0,0, ''); + +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=9985 AND `text_id`=13839; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9985,13839); +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=9985 WHERE `entry`=26905; +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id`=9985 AND `id`=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 +(9985,0,3, 'Train me.',5,16,0,0,0,0,0, ''); + +-- Conversation between Highlord Tirion Fordring & The Ebon Watcher minor text update from sniff +UPDATE `creature_text` SET `text`= 'The Lich King is unlike any foe that you have ever faced, Highlord. Though you bested him upon the holy ground of Light''s Hope Chapel, you tread now upon his domain.$B' WHERE `entry`=30377 AND `groupid`=1; +UPDATE `creature_text` SET `text`= 'You cannot win. Not like this...$B' WHERE `entry`=30377 AND `groupid`=2; +UPDATE `creature_text` SET `text`= 'The Lich King knows your boundaries, Highlord. He knows that you will not fire on your own men. Do you not understand? He has no boundaries. No rules to abide. $B' WHERE `entry`=30377 AND `groupid`=8; +UPDATE `creature_text` SET `text`= 'Then you have lost, Highlord.$B' WHERE `entry`=30377 AND `groupid`=9; + +-- Fix some text for quest 9164 "Captives at Deatholme" now that I can properly parse the sniffs +UPDATE `creature_text` SET `text`= 'Th... thank you. I thought I was going to die.' WHERE `entry`=16206; +UPDATE `gossip_menu_option` SET `option_text`= 'A bit ungrateful, aren''t we? The way out is clear, flee quickly!' WHERE `menu_id`=7179; +UPDATE `gossip_menu_option` SET `option_text`= 'You''re free to go now. The way out is safe.' WHERE `menu_id`=7176; +UPDATE `gossip_menu_option` SET `option_text`= 'You''re free to go now. The way out is safe.' WHERE `menu_id`=7186; |