[Complete] [Merged]Gossip update

[Malcrom]

[CODE]-- 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);
[/sql]
[/CODE]

[Malcrom]

[CODE]-- 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);
[/sql]
[/CODE]

[Malcrom]

[CODE]-- 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’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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);
[/sql]
[/CODE]

[Malcrom]

[CODE]-- 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);
[/sql]
[/CODE]