4Xx Gossip "badlands Quest"

[CODE]-- Gossip for Badlands Quest 4XX

– Gossip Menu insert from sniff
DELETE FROM gossip_menu WHERE entry=12225 AND text_id=17168;
INSERT INTO gossip_menu (entry,text_id) VALUES (12225,17168);
DELETE FROM gossip_menu WHERE entry=12202 AND text_id=17140;
INSERT INTO gossip_menu (entry,text_id) VALUES (12202,17140);
DELETE FROM gossip_menu WHERE entry=12209 AND text_id=17151;
INSERT INTO gossip_menu (entry,text_id) VALUES (12209,17151);
DELETE FROM gossip_menu WHERE entry=12205 AND text_id=17143;
INSERT INTO gossip_menu (entry,text_id) VALUES (12205,17143);
DELETE FROM gossip_menu WHERE entry=12148 AND text_id=17078;
INSERT INTO gossip_menu (entry,text_id) VALUES (12148,17078);
DELETE FROM gossip_menu WHERE entry=12149 AND text_id=17080;
INSERT INTO gossip_menu (entry,text_id) VALUES (12149,17080);
DELETE FROM gossip_menu WHERE entry=12147 AND text_id=17073;
INSERT INTO gossip_menu (entry,text_id) VALUES (12147,17073);
DELETE FROM gossip_menu WHERE entry=12146 AND text_id=17072;
INSERT INTO gossip_menu (entry,text_id) VALUES (12146,17072);
DELETE FROM gossip_menu WHERE entry=12171 AND text_id=17115;
INSERT INTO gossip_menu (entry,text_id) VALUES (12171,17115);
DELETE FROM gossip_menu WHERE entry=12172 AND text_id=17116;
INSERT INTO gossip_menu (entry,text_id) VALUES (12172,17116);
DELETE FROM gossip_menu WHERE entry=12146 AND text_id=17074;
INSERT INTO gossip_menu (entry,text_id) VALUES (12146,17074);
DELETE FROM gossip_menu WHERE entry=12147 AND text_id=17075;
INSERT INTO gossip_menu (entry,text_id) VALUES (12147,17075);

– Creature Gossip_menu_id Update from sniff
UPDATE creature_template SET gossip_menu_id=12225 WHERE entry=46930;
UPDATE creature_template SET gossip_menu_id=12202 WHERE entry=2920;
UPDATE creature_template SET gossip_menu_id=12209 WHERE entry=4618;
UPDATE creature_template SET gossip_menu_id=12205 WHERE entry=47123;
UPDATE creature_template SET gossip_menu_id=12148 WHERE entry=46654;
UPDATE creature_template SET gossip_menu_id=12149 WHERE entry=46760;
UPDATE creature_template SET gossip_menu_id=10181 WHERE entry=46659;
UPDATE creature_template SET gossip_menu_id=12147 WHERE entry=46769;
UPDATE creature_template SET gossip_menu_id=12146 WHERE entry=46768;
UPDATE creature_template SET gossip_menu_id=12171 WHERE entry=9728;
UPDATE creature_template SET gossip_menu_id=12172 WHERE entry=9727;

– Creature Gossip_menu_option Update from sniff
DELETE FROM gossip_menu_option WHERE menu_id IN (12205,10181,12146,12147) AND id IN (0);
INSERT INTO gossip_menu_option (menu_id,id,option_icon,option_text,option_id,npc_option_npcflag,action_menu_id,action_poi_id,box_coded,box_money,box_text) VALUES
(12205,0,0, ‘Hop in, baby.’,1,1,0,0,0,0, ‘’),
(10181,0,1, ‘I want to browse your goods.’,3,128,0,0,0,0, ‘’),
(12146,0,0, ‘’,1,1,0,0,0,0, ‘’),
(12147,0,0, ‘’,1,1,0,0,0,0, ‘’);

– Insert npc_text from sniff
DELETE FROM npc_text WHERE ID IN (17168,17140,17151,17143,17078,17080,17073,17072,17115,17116,17074,17075);
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
(17168,1,‘’,‘Dragon’‘s Mouth was established to give the Alliance their first real foothold here in the Badlands. Despite its position between Stormwind and Dun Morogh, the Badlands have traditionally been Horde territory.$b$bIf that’‘s ever to change, we need to start asserting ourselves. Of course, the dragon attacks on New Kargath don’‘t hurt our cause either.’,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),
(17140,1,‘You’‘ve got to try some of this beer.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17151,1,‘What brings you to a bunch of old, washed-up desert dogs like 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),
(17143,1,‘Hey there, good lookin’‘.’,‘Hey there, good lookin’‘.’,0,0,0,0,0,0,0,1,‘You got room for one more, sugar?’,‘You got room for one more, sugar?’,0,0,0,0,0,0,0,1,‘Going my way?’,‘Going my way?’,0,0,0,0,0,0,0,1,‘Can a lady get a ride?’,‘Can a lady get a ride?’,0,0,0,0,0,0,0,1,‘You’‘re looking very handsome today, Martek.’,‘You’‘re looking very handsome today, Martek.’,0,0,0,0,0,0,0,1,‘Ooh, Martek, can I ride with you?’,‘Ooh, Martek, can I ride with you?’,0,0,0,0,0,0,0,1,‘Martek, you are the bravest orc I know.’,‘Martek, you are the bravest orc I know.’,0,0,0,0,0,0,0,1,‘Save me, Martek! I need you!’,‘Save me, Martek! I need you!’,0,0,0,0,0,0,0,1),
(17078,1,‘’,‘Greetings.’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17080,1,‘Hope you brought your mining pick, pilgrim. No place better than here for digging up ancient treasure.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17073,1,‘While it is clearly quite old, this statue does not appear to have crumbled at all over the centuries.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17072,1,‘The hulking statue stands inert, untouched for centuries.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17115,1,‘An inconspicuous marble slab.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17116,1,‘An inconspicuous stone slab.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17074,1,‘Judging by its color, this must be The Warden.$b$bYou see a small indentation where your pawn might fit.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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),
(17075,1,‘This red statue looks a lot like the Sentinel’‘s pawn that you hold.$b$bThe statue has a small indentation that matches the size of your pawn.’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,0,‘’,‘’,0,0,0,0,0,0,0,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]

thx boy.