DELETE From `game_event_gameobject` where `guid` = '255216'; DELETE FROM `gossip_menu_option` WHERE (`menu_id`='10830') AND (`id`='0'); DELETE FROM `gossip_menu_option` WHERE (`menu_id`='10830') AND (`id`='1'); DELETE FROM `gameobject` WHERE (`guid`='10042120'); DELETE FROM `gameobject` WHERE (`guid`='17'); DELETE FROM `gameobject` WHERE (`guid`='1272'); DELETE FROM `gameobject` WHERE (`guid`='1273'); DELETE FROM `creature_template_addon` WHERE (`entry`='1182'); DELETE FROM `creature` WHERE (`guid`='9992815'); DELETE FROM `creature` WHERE (`guid`='9992816'); DELETE FROM `npc_text` WHERE (`ID`='15017'); DELETE FROM `npc_text` WHERE (`ID`='50783'); DELETE FROM `npc_text` WHERE (`ID`='50784'); DELETE FROM `npc_text` WHERE (`ID`='50785'); DELETE FROM `npc_text` WHERE (`ID`='50786'); DELETE FROM `npc_text` WHERE (`ID`='50787'); DELETE FROM `npc_text` WHERE (`ID`='50788'); DELETE FROM `gossip_menu` WHERE (`entry`='50783'); DELETE FROM `gossip_menu` WHERE (`entry`='50784'); DELETE FROM `gossip_menu` WHERE (`entry`='50785'); DELETE FROM `gossip_menu` WHERE (`entry`='50786'); DELETE FROM `gossip_menu` WHERE (`entry`='50787'); DELETE FROM `gossip_menu` WHERE (`entry`='50788'); DELETE FROM `creature` WHERE (`guid`='174084'); DELETE FROM `creature` WHERE (`guid`='73382'); UPDATE `creature_template` SET `gossip_menu_id`='0' WHERE (`entry`='38517'); UPDATE `creature_text` SET `text`='I''m on fire. Note that in the logs!' WHERE (`entry`='36061') AND (`groupid`='0') AND (`id`='5'); UPDATE `npc_text` SET `text0_0`='Welcome, ally. We have much to discuss$B$BThe beasts you call the \"Horde\" ravage these woods. Their terrible stone ribbon slices through our land, frightens the animals we hunt, and fills the air with noise and ash.$B$BTell me, friend. How can we Blackmaw join this \"Alliance\" of yours?' WHERE (`ID`='15015'); INSERT INTO `npc_text` (`ID`,`text0_0`,`text0_1`) VALUES ('15017','Your tone enrages me, outsider. If this is what we can expect from your so-called \"Alliance,\" we will have no part in it!','Your tone enrages me, outsider. If this is what we can expect from your so-called \"Alliance,\" we will have no part in it!'); UPDATE `npc_text` SET `text0_0`='What tactic is this that you come into my home and start barking demands of my people?' WHERE (`ID`='15016'); UPDATE `gossip_menu_option` SET `action_menu_id`='10829' WHERE (`menu_id`='10828') AND (`id`='1'); UPDATE `gossip_menu_option` SET `action_menu_id`='10829' WHERE (`menu_id`='10828') AND (`id`='2'); UPDATE `gossip_menu_option` SET `id`='2' WHERE (`menu_id`='10830') AND (`id`='0'); INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES ('10830','0','You will have no choice once your people are enslaved by the jackbooted Alliance death squads!','1','1'); INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES ('10830','1','You keep talking, but all i hear is \"Blah blah my people bathe in our own filth\"','1','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('17','200298','1','16','1221','1','1','3539.45','-5130.52','84.9613','1.90135','0','0','0.813807','0.581135','1','0','1'); INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`,`emote`,`VisibilityDistanceType`) VALUES ('1182','7','0','65','0'); UPDATE `creature_text` SET `text`='Master Taerar no longer dwells here, fool. He has bestowed me with enough power to stop you!' WHERE (`entry`='39394') AND (`groupid`='0') AND (`id`='0'); UPDATE `npc_text` SET `text0_0`='Welcome to Stonemaul Hold, brave $c. How may I assist you this day?' WHERE (`ID`='2638'); DELETE FROM `gossip_menu` WHERE (`entry`='1964') AND (`text_id`='2368'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('1272','49486','1','405','4925','1','1','-524.833','1065.46','89.8322','2.84845','0','0','0.989277','0.146048','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('1273','194438','1','357','5002','1','1','-3079.46','2570.71','50.1783','4.08399','0','0','0.891024','-0.453956','300','0','1'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('9992815','44969','429','2557','2557','1','1','0','0','36.9811','-197.504','-4.14222','0.0966024','300','0','0','5836','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('9992816','44991','429','2557','2557','1','1','0','0','43.003','177.109','-3.47746','4.70275','300','0','0','1336','11420','0','0','0','0','0','0'); UPDATE `creature_text` SET `text`='Any Ladies and Gentlemen present should LEAVE NOW..for only REAL MEN AND WOMEN will be able to handle the gory spectacle about to unfold! Introducing the first fighter, the warrior of the Wastewander, the Ayatollah of Kaja-Cola....THE GINORMUS!' WHERE (`entry`='39034') AND (`groupid`='0') AND (`id`='0'); UPDATE `creature_text` SET `text`='The Ginormus has fallen! $N looks like $g he : she;''s ready for more!' WHERE (`entry`='39034') AND (`groupid`='1') AND (`id`='0'); UPDATE `creature_text` SET `text`='Into the Thunderdrome, $N! There''s no getting out until someone''s hit the sand. Let''s start the show!' WHERE (`entry`='39034') AND (`groupid`='2') AND (`id`='0'); UPDATE `creature_text` SET `text`="The Trade Prince''s yacht is about to set sail. Everyone, get to the dock! Hand over the keys, boss. I''m driving. Just let me know when you''re ready to go." WHERE (`entry`='34668') AND (`groupid`='7') AND (`id`='0'); UPDATE `creature_text` SET `text`='And that''s that, folks! This conflict''s been settled the proper way, with VIOLENCE! Let''s hear it for our contestants!' WHERE (`entry`='39034') AND (`groupid`='7') AND (`id`='0'); UPDATE `quest_template` SET `Details`='If you''re looking for more work, I''ve got a line for you.$B$BI know an elf by the name of Trenton Lighthammer who''s been obsessed with the sand trolls near here for years. He''s dead-set on finding some kind of mythical sword made by them, and just a while ago he finally got a crew together to go to Sandsorrow Watch and look for it.$B$BLast I heard, they kicked the trolls out of one of their camps and set up shop there. Look for it to the west, near Zul''Farrak.' WHERE (`Id`='25091'); UPDATE `creature_text` SET `text`='Emergency power activated! Initializing ambulatory motor! CLUCK!' WHERE (`entry`='7784') AND (`groupid`='0') AND (`id`='0'); UPDATE `creature_text` SET `text`='Threat analyzed! Activating combat plan beta! CLUCK!' WHERE (`entry`='7784') AND (`groupid`='1') AND (`id`='1'); UPDATE `quest_template` SET `PrevQuestId`='24723' WHERE (`Id`='24694'); UPDATE `quest_template` SET `PrevQuestId`='4321' WHERE (`Id`='24726'); UPDATE `quest_template` SET `PrevQuestId`='4321' WHERE (`Id`='24727'); UPDATE `quest_template` SET `PrevQuestId`='4321' WHERE (`Id`='24728'); UPDATE `quest_template` SET `PrevQuestId`='4321' WHERE (`Id`='24729'); UPDATE `quest_template` SET `PrevQuestId`='24734' WHERE (`Id`='24735'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('50785','50785'); INSERT INTO `npc_text` (`ID`,`text0_1`) VALUES ('50785','$n, is that you?'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('50786','50786'); INSERT INTO `npc_text` (`ID`,`text0_1`) VALUES ('50786','Individual strength is important, but tribal strength is more so. Our tribe is only as strong as its weakest member.'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('50787','50787'); INSERT INTO `npc_text` (`ID`,`text0_1`) VALUES ('50787','Welcome, outsider, to our home'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('50788','50788'); INSERT INTO `npc_text` (`ID`,`text0_1`) VALUES ('50788','A few of our tribe have harnessed the power of thunder. We use it to defend ourselves against invaders, whether human, orc, or dinosaur.$B$BOur thunder stuns all dinosaurs, you know.'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('50783','50783'); INSERT INTO `npc_text` (`ID`,`text0_1`) VALUES ('50783','Who are you? What do you want with our tribe?'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('50784','50784'); INSERT INTO `npc_text` (`ID`,`text0_1`) VALUES ('50784','The lashers to the south will eat small creatures, like frogs and parrots. We, the gorillas, will eat the lashers. And dinosaurs eat gorillas. All this is honorable and natural.$B$BThe humans and orcs also hunt the gorilla, but they take the skin and leave the body to rot. This is why we attack the humans and the orcs'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172024'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172025'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172026'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172027'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172028'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172029'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172030'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172031'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172032'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172033'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172034'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172035'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172036'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172049'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172050'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172051'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172052'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172057'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172058'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172059'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172060'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172061'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172062'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172063'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172064'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172065'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172066'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172067'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172068'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172069'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172070'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172071'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172072'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172073'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172074'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172075'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172076'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172077'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172078'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172079'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172080'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172081'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172082'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='172083'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174125'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174126'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174127'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174128'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174135'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174136'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174137'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174138'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174139'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174140'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174153'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174154'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174155'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174156'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174157'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174158'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174159'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174160'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174161'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174179'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174180'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174181'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174182'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174183'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174184'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174185'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174186'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174187'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174188'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174189'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174190'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174191'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174192'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174193'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='174194'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177441'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177452'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177654'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177671'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177677'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177682'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177686'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177687'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177690'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177701'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177706'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177712'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177713'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177716'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177719'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177720'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177723'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177730'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177737'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177739'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177741'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177745'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177746'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177749'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177750'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177753'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177763'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177764'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177766'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177768'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177770'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177771'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177774'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177775'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177781'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177782'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177784'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177785'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177789'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177794'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177795'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177796'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177797'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177799'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177800'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177801'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177802'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177807'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177809'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177814'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177815'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177816'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177819'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177823'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177825'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177828'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177829'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177832'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177834'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177836'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177837'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177842'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177844'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177845'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177847'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177848'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177849'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177851'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177853'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177855'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177856'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177859'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177861'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177863'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177864'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177867'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177868'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177871'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177872'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177874'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177878'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177879'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177880'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177881'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177882'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177886'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177892'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177893'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177906'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177907'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177908'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='177927'); INSERT INTO `game_event_gameobject` (`eventEntry`,`guid`) VALUES ('2','255216'); UPDATE `smart_scripts` SET `action_param1`='0' WHERE (`entryorguid`='5997') AND (`source_type`='0') AND (`id`='2') AND (`link`='0'); DELETE FROM `creature_addon` WHERE (`guid`='16576'); DELETE FROM `creature_addon` WHERE (`guid`='17652'); DELETE FROM `creature_addon` WHERE (`guid`='17664'); DELETE FROM `creature_addon` WHERE (`guid`='16485'); DELETE FROM `creature_addon` WHERE (`guid`='16352'); DELETE FROM `creature_addon` WHERE (`guid`='16336'); UPDATE `creature_model_info` SET `modelid_other_gender`='16292' WHERE (`modelid`='16292'); UPDATE `creature_model_info` SET `modelid_other_gender`='7228' WHERE (`modelid`='7228'); UPDATE `quest_template` SET `Details`='With the Legion to one side and the fel orcs to the other, Thrallmar is going to be overrun if we don''t do something about it.$B$BHead west to the Hellfire Ramparts and speak with Stone Guard Stok''ton. He''s in charge of a covert operation to start a Horde invasion on the entire citadel.' WHERE (`Id`='29542'); DELETE FROM `creature_loot_template` WHERE (`entry`='20324') AND (`item`='24484'); UPDATE `creature_text` SET `text`='Let''s see now... where could they be...' WHERE (`entry`='49141') AND (`groupid`='3') AND (`id`='0'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('20324','24484','0.01','1'); UPDATE `creature_loot_template` SET `ChanceOrQuestChance`='75' WHERE (`item`='30561'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21819'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='20093'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='22447'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='20023'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='20093'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='20024'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='20003'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='21814'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='21025'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='21819'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='22447'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='22021'); UPDATE `creature_template_addon` SET `auras`='16380' WHERE (`entry`='20736'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='20736'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='22422'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='22471'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='22502'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='20476'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21436'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21437'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21438'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21440'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='20769'); UPDATE `creature` SET `MovementType`='0' WHERE (`guid`='127557'); UPDATE `creature_template` SET `movementId`='0' WHERE (`entry`='20904'); UPDATE `creature_model_info` SET `modelid_other_gender`='4249' WHERE (`modelid`='4249'); UPDATE `creature_equip_template` SET `itemEntry1`='13033' WHERE (`entry`='21519') AND (`id`='1'); UPDATE `creature_text` SET `text`='I prefer to be hands-on...' WHERE (`entry`='19220') AND (`groupid`='3') AND (`id`='0'); UPDATE `creature_template` SET `dynamicflags`='0' WHERE (`entry`='20869'); UPDATE `npc_text` SET `text0_0`='There are only 3 kinds of people in this world: competitors, customers, and employees. Competitors are to be crushed ruthlessly, customers indulged, and employees strictly supervised.$B$BIndependent contractors are a myth. They want to be paid better than employees, but treated like customers. Never trust one who calls himself by that title.' WHERE (`ID`='9971'); UPDATE `creature_template` SET `MovementType`='0',`InhabitType`='5' WHERE (`entry`='19568'); UPDATE `quest_template` SET `RequiredRaces`='0' WHERE (`Id`='10413'); UPDATE `quest_template` SET `Details`='I have no idea what killed all of the druids here. I''ve been away for a couple of days on a survey of the Bone Wastes to the south.$B$BPlease, you must help me to uncover what''s behind this horrible tragedy. Go into the thicket and look for a clue that might reveal something to us. When I was in there briefly, I could have sworn I saw a dead Broken and a strange object next to him.$B$BAnd don''t worry about Treelos - he might have been driven insane by what happened, but I think he''s mostly harmless.' WHERE (`Id`='9971'); UPDATE `creature_addon` SET `emote`='0' WHERE (`guid`='123598'); UPDATE `creature` SET `position_x`='-2000.06',`position_y`='5350.01',`position_z`='-9.34982',`orientation`='3.51371' WHERE (`guid`='123730'); DELETE From `creature` where `guid` = '111593'; UPDATE `creature_text` SET `text`='Well hand it over and let''s see what you got!' WHERE (`entry`='19612') AND (`groupid`='0') AND (`id`='0'); UPDATE `quest_template` SET `RequiredRaces`='0' WHERE (`Id`='11098'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113875'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113876'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113877'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113878'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113879'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113880'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113881'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113882'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113883'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113884'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113885'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113886'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113887'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113888'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113889'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113890'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113891'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113892'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113893'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113894'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113895'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113896'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113897'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113898'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113899'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113900'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113901'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113902'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113903'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113904'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113905'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113906'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113907'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113908'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113909'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113910'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113911'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113930'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113931'); UPDATE `creature` SET `id`='23219' WHERE (`guid`='113932'); DELETE FROM `creature` WHERE (`guid`='117686'); DELETE FROM `creature` WHERE (`guid`='506007'); DELETE FROM `creature` WHERE (`guid`='81823'); DELETE FROM `creature` WHERE (`guid`='81824'); DELETE FROM `creature` WHERE (`guid`='81825'); DELETE FROM `creature` WHERE (`guid`='81826'); DELETE FROM `creature` WHERE (`guid`='81827'); DELETE FROM `creature` WHERE (`guid`='81828'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21792'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21793'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21794'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='21957'); UPDATE `gossip_menu_option` SET `box_text`='' WHERE (`menu_id`='8687') AND (`id`='0'); UPDATE `creature_loot_template` SET `ChanceOrQuestChance`='100' WHERE (`entry`='18554') AND (`item`='29912'); UPDATE `creature_addon` SET `mount`='0' WHERE (`guid`='120899'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('81823','22314','530','3519','3677','1','1','0','0','-2526.39','5383.57','28.0073','1.86696','300','0','0','42','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('81824','22314','530','3519','3677','1','1','0','0','-2525.76','5384.84','28.0054','2.85264','300','0','0','42','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('81825','22314','530','3519','3677','1','1','0','0','-2579.78','5430.94','27.9615','5.49315','300','0','0','42','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('81826','22314','530','3519','3677','1','1','0','0','-2579.42','5429.94','27.9564','2.12772','300','0','0','42','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('81827','22314','530','3519','3677','1','1','0','0','-2463.38','5402.33','2.00083','4.35497','300','0','0','42','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('81828','22314','530','3519','3677','1','1','0','0','-2545.34','5485.08','8.26826','5.11759','300','0','0','42','0','0','0','0','0','0','0'); UPDATE `gameobject_template` SET `questItem1`='31708' WHERE (`entry`='185224'); UPDATE `gameobject_template` SET `questItem1`='31709' WHERE (`entry`='185226'); UPDATE `quest_template` SET `OfferRewardText`='You have done well. Any advantage we can take away from Kael''thas'' forces is to our benefit.',`CompletedText`='' WHERE (`Id`='29659'); UPDATE `creature_model_info` SET `modelid_other_gender`='20450' WHERE (`modelid`='20449'); UPDATE `creature_template` SET `difficulty_entry_1`='0' WHERE (`entry`='21419'); DELETE FROM `creature` WHERE (`guid`='125107'); DELETE FROM `creature` WHERE (`guid`='125108'); UPDATE `gameobject` SET `id`='203188' WHERE (`id`='1610'); UPDATE `gameobject` SET `id`='203188' WHERE (`id`='1667'); DELETE FROM `creature` WHERE (`id`='1039'); UPDATE `creature_template` SET `minlevel`='20',`maxlevel`='21',`faction_a`='91',`faction_h`='91' WHERE (`entry`='41147'); DELETE FROM `creature` WHERE (`guid`='8398'); DELETE FROM `creature` WHERE (`guid`='8399'); DELETE FROM `creature` WHERE (`guid`='8449'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('8398','1445','0','11','150','1','1','0','0','-3734.51','-881.336','0.653606','2.18332','300','0','0','55','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('8399','1446','0','11','150','1','1','0','0','-3733.1','-880.352','0.590916','2.29327','300','0','0','55','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('8449','1447','0','11','150','1','1','0','0','-3735.36','-878.521','0.645148','5.41523','300','0','0','55','0','0','0','0','0','0','0'); UPDATE `creature_template` SET `equipment_id`='0' WHERE (`entry`='1445'); UPDATE `creature_template` SET `equipment_id`='0' WHERE (`entry`='1447'); DELETE FROM `gossip_menu` WHERE (`entry`='21295') AND (`text_id`='9361'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('21295','9361'); UPDATE `gossip_menu_option` SET `option_text`='We will fight you until the end, then, Lantresor. We will not stand idly by as you pillage our towns and kill our people.' WHERE (`menu_id`='21301') AND (`id`='6'); DELETE FROM `creature` WHERE (`guid`='153648'); DELETE FROM `creature` WHERE (`guid`='153649'); DELETE FROM `creature` WHERE (`guid`='153650'); DELETE FROM `creature` WHERE (`guid`='153651'); DELETE FROM `creature` WHERE (`guid`='153652'); DELETE FROM `creature` WHERE (`guid`='153653'); DELETE FROM `creature` WHERE (`guid`='153654'); DELETE FROM `creature` WHERE (`guid`='153655'); DELETE FROM `creature` WHERE (`guid`='153656'); DELETE FROM `creature` WHERE (`guid`='153657'); DELETE FROM `creature` WHERE (`guid`='153658'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153648','25361','571','3537','4020','1','1','0','0','2800.87','6063.89','75.6811','5.51746','300','0','0','7984','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153649','25361','571','3537','4129','1','1','0','0','2806.38','6069.58','75.6811','5.04231','300','0','0','9291','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153650','25361','571','3537','4020','1','1','0','0','2828.46','6065.14','75.6811','2.11593','300','0','0','6116','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153651','25361','571','3537','4020','1','1','0','0','2823.8','6065.53','75.6811','0.864001','300','0','0','7984','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153652','25361','571','3537','4129','1','1','0','0','2831.02','6068.51','75.6811','2.43872','300','0','0','6326','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153653','25361','571','3537','4129','1','1','0','0','2821.08','6069.95','75.6811','1.04857','300','0','0','6326','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153654','25361','571','3537','4129','1','1','0','0','2824.19','6073.54','75.6811','1.08784','300','0','0','6986','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153655','25361','571','3537','4020','1','1','0','0','2818.64','6062.26','75.6811','4.98341','300','0','0','6326','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153656','25361','571','3537','4129','1','1','0','0','2813.37','6068.74','75.6811','2.09315','300','0','0','9610','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153657','25361','571','3537','4020','1','1','0','0','2808.6','6062.46','75.6811','4.48861','300','0','0','6116','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153658','25361','571','3537','4129','1','1','0','0','2800.47','6070.22','75.6811','5.16405','300','0','0','6326','0','0','0','0','0','0','0'); DELETE FROM `creature_addon` WHERE (`guid`='153648'); DELETE FROM `creature_addon` WHERE (`guid`='153649'); DELETE FROM `creature_addon` WHERE (`guid`='153652'); DELETE FROM `creature_addon` WHERE (`guid`='153653'); DELETE FROM `creature_addon` WHERE (`guid`='153654'); DELETE FROM `creature_addon` WHERE (`guid`='153658'); INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`,`VisibilityDistanceType`) VALUES ('153648','0','0','3','0','0','','-1'); INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`,`VisibilityDistanceType`) VALUES ('153649','0','0','8','0','0','','-1'); INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`,`VisibilityDistanceType`) VALUES ('153652','0','0','8','0','0','','-1'); INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`,`VisibilityDistanceType`) VALUES ('153653','0','0','8','0','0','','-1'); INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`,`VisibilityDistanceType`) VALUES ('153654','0','0','8','0','0','','-1'); INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`,`VisibilityDistanceType`) VALUES ('153658','0','0','8','0','0','','-1'); DELETE FROM `creature` WHERE (`guid`='153659'); DELETE FROM `creature` WHERE (`guid`='153660'); DELETE FROM `creature` WHERE (`guid`='153661'); DELETE FROM `creature` WHERE (`guid`='153662'); DELETE FROM `creature` WHERE (`guid`='153663'); DELETE FROM `creature` WHERE (`guid`='153664'); DELETE FROM `creature` WHERE (`guid`='153665'); DELETE FROM `creature` WHERE (`guid`='153666'); DELETE FROM `creature` WHERE (`guid`='153667'); DELETE FROM `creature` WHERE (`guid`='153668'); DELETE FROM `creature` WHERE (`guid`='153669'); DELETE FROM `creature` WHERE (`guid`='153670'); DELETE FROM `creature` WHERE (`guid`='153671'); DELETE FROM `gameobject` WHERE (`guid`='55825'); DELETE FROM `gameobject` WHERE (`guid`='54575'); DELETE FROM `gameobject` WHERE (`guid`='54576'); DELETE FROM `gameobject` WHERE (`guid`='54577'); DELETE FROM `gameobject` WHERE (`guid`='54578'); DELETE FROM `gameobject` WHERE (`guid`='54579'); DELETE FROM `gameobject` WHERE (`guid`='54580'); DELETE FROM `gameobject` WHERE (`guid`='54582'); DELETE FROM `gameobject` WHERE (`guid`='54583'); DELETE FROM `gameobject` WHERE (`guid`='54584'); DELETE FROM `creature` WHERE (`guid`='153669'); DELETE FROM `conditions` WHERE (`SourceGroup`='8894'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153659','25284','571','3537','4020','1','1','0','0','2661.19','6056.51','53.9905','2.59737','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153660','25284','571','3537','4020','1','1','0','0','2677','6149.66','40.1588','3.58697','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153661','25284','571','3537','4020','1','1','0','0','2686.31','6131.78','39.9643','2.41673','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153662','25284','571','3537','4020','1','1','0','0','2678.75','6198.51','39.7312','2.4128','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153663','25284','571','3537','4020','1','1','0','0','2626.09','6097.11','53.9331','1.40592','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153664','25284','571','3537','4020','1','1','0','0','2688.58','6110','39.7678','2.38374','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153665','25284','571','3537','4020','1','1','0','0','2654.29','6116.14','38.2066','1.5473','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153666','25284','571','3537','4020','1','1','0','0','2632.66','6120.6','38.2056','1.30696','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153667','25284','571','3537','4020','1','1','0','0','2665.92','6180.09','39.1406','3.73385','300','0','0','449','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153668','25284','571','3537','4020','1','1','0','0','2670.77','6170.41','39.1849','3.59248','300','0','0','449','0','0','0','0','0','0','0'); UPDATE `quest_template` SET `Type`='2',`Flags`='136' WHERE (`Id`='11636'); UPDATE `conditions` SET `ConditionTypeOrReference`='28' WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='9162') AND (`SourceEntry`='0') AND (`SourceId`='0') AND (`ElseGroup`='0') AND (`ConditionTypeOrReference`='8') AND (`ConditionTarget`='0') AND (`ConditionValue1`='11636') AND (`ConditionValue2`='0') AND (`ConditionValue3`='0'); UPDATE `creature_addon` SET `bytes1`='7' WHERE (`guid`='140728'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('55825','187866','571','3537','4141','1','1','2904.11','6484.44','79.1325','1.48105','0','0','0.674674','0.738116','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54575','187866','571','3537','3537','1','1','2994.46','6405.95','90.1982','0.644019','0','0','0.316473','0.948601','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54576','187866','571','3537','3537','1','1','3042.44','6518.98','82.6338','2.40855','0','0','0.93358','0.35837','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54577','187866','571','3537','3537','1','1','3094.01','6384.92','87.0756','5.22054','0','0','0.506675','-0.862137','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54578','187866','571','3537','3537','1','1','3072.66','6427.15','85.4332','4.92052','0','0','0.62983','-0.776733','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54579','187866','571','3537','3537','1','1','3044.69','6447.79','82.6706','0.569406','0','0','0.280873','0.959745','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54580','187866','571','3537','3537','1','1','3014.81','6431','83.8453','2.63108','0','0','0.967598','0.252495','300','0','1'); UPDATE `quest_template` SET `RequiredRaces`='946' WHERE (`Id`='11627'); UPDATE `quest_template` SET `PrevQuestId`='11562' WHERE (`Id`='11564'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54582','187373','571','3537','4097','1','1','3998.04','6282.13','8.08343','1.02694','0','0','0.491205','0.871044','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54583','187373','571','3537','4097','1','1','3956.71','6367.23','11.3986','2.48509','0','0','0.946608','0.322387','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54584','194438','571','3537','4122','1','1','4512.56','5708.66','81.6496','4.44544','0','0','0.794917','-0.606718','300','0','1'); UPDATE `creature_text` SET `text`='Aargh! Do your worst, $C! I''ll tell you NOTHING!' WHERE (`entry`='25478') AND (`groupid`='1') AND (`id`='0'); UPDATE `creature_text` SET `text`='I''ve given you the information, $C! You''re wasting your time....' WHERE (`entry`='25478') AND (`groupid`='5') AND (`id`='0'); UPDATE `broadcast_text` SET `MaleText`='Stay close to me, $n. I could not bear for any harm to come to you.' WHERE (`ID`='25474'); UPDATE `broadcast_text` SET `MaleText`='MALYGOS!!' WHERE (`ID`='25475'); UPDATE `creature_text` SET `BroadcastTextId`='25475' WHERE (`entry`='26237') AND (`groupid`='1') AND (`id`='0'); UPDATE `broadcast_text` SET `MaleText`='Come, Lord of Magic, and recover your precious consort....' WHERE (`ID`='25477'); UPDATE `broadcast_text` SET `MaleText`='...what remains of her!' WHERE (`ID`='25478'); UPDATE `broadcast_text` SET `MaleText`='Come, $n. Let us see the fruits of our efforts.' WHERE (`ID`='25479'); UPDATE `broadcast_text` SET `MaleText`='Hurry, $n! Flee! Live to finish what we''ve begun here....' WHERE (`ID`='25491'); UPDATE `broadcast_text` SET `MaleText`='Never!' WHERE (`ID`='25489'); UPDATE `creature_text` SET `text`='The flesh is weak. We will make you better, stronger... faster.' WHERE (`entry`='25814') AND (`groupid`='1') AND (`id`='2'); UPDATE `creature_text` SET `text`='We are Mechagnome... resistance is futile.' WHERE (`entry`='25814') AND (`groupid`='1') AND (`id`='1'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153669','25654','571','3537','4124','1','1','0','0','4205.41','4057.7','91.7338','5.92436','300','0','0','42','0','0','0','33554432','0','0','0'); UPDATE `gameobject` SET `position_x`='3747.49',`position_y`='3516.68',`position_z`='69.5826',`orientation`='1.78024' WHERE (`guid`='45970'); UPDATE `creature_text` SET `text`='The zeppelin to Undercity has just arrived! All aboard for Tirisfal Glades!' WHERE (`entry`='26540') AND (`groupid`='0') AND (`id`='0'); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES ('15','8894','0','0','0','28','0','11229','0','0','Show Gossip Option on Quest The Windrunner Fleet'); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES ('15','8894','1','0','0','9','0','11170','0','0','Show Gossip Option on Quest Test at Sea'); DELETE FROM `creature` WHERE (`guid`='145860'); DELETE FROM `creature` WHERE (`guid`='145992'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('145860','24035','571','495','4006','1','1','0','0','2504.83','-3514.95','185.588','1.58454','300','0','0','6761','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('145992','24035','571','495','4006','1','1','0','0','2499.9','-3515.75','184.881','1.98349','300','0','0','5914','0','0','0','0','0','0','0'); UPDATE `creature` SET `spawndist`='0',`MovementType`='0' WHERE (`guid`='142136'); DELETE FROM `creature` WHERE (`guid`='142136'); UPDATE `creature_template` SET `gossip_menu_id`='9780' WHERE (`entry`='29159'); UPDATE `creature_template` SET `gossip_menu_id`='9780',`AIName`='SmartAI' WHERE (`entry`='29155'); UPDATE `creature_template` SET `gossip_menu_id`='9780' WHERE (`entry`='29160'); UPDATE `creature_template` SET `gossip_menu_id`='9780' WHERE (`entry`='29162'); UPDATE `creature_template` SET `gossip_menu_id`='9780' WHERE (`entry`='29160'); UPDATE `creature_template` SET `gossip_menu_id`='9780',`AIName`='SmartAI',`ScriptName`='npc_kingdom_of_dalaran_quests' WHERE (`entry`='27158'); UPDATE `creature_template` SET `AIName`='SmartAI' WHERE (`entry`='29161'); UPDATE `creature_template` SET `gossip_menu_id`='9780',`AIName`='SmartAI',`ScriptName`='npc_kingdom_of_dalaran_quests' WHERE (`entry`='29158'); DELETE FROM `game_tele` WHERE (`id`='1731'); DELETE FROM `game_tele` WHERE (`id`='1736'); DELETE FROM `game_tele` WHERE (`id`='1769'); DELETE FROM `game_tele` WHERE (`id`='1738'); UPDATE `game_tele` SET `name`='DronosharBlockade' WHERE (`id`='1739'); DELETE FROM `game_tele` WHERE (`id`='1743'); UPDATE `game_tele` SET `name`='UnderKarazhan' WHERE (`id`='1747'); DELETE FROM `game_tele` WHERE (`id`='1749'); DELETE FROM `game_tele` WHERE (`id`='2319'); DELETE FROM `game_tele` WHERE (`id`='2320'); INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES ('1731','3509.72','2004.22','65.2506','3.52754','571','StarsRest'); INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES ('1736','3262.35','-2215.77','117.372','1.09912','571','ConquestHold'); INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES ('1769','3237.53','-691.094','166.875','5.98681','571','Venomspite'); DELETE FROM `gameobject` WHERE (`guid`='54585'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54585','181481','571','65','4152','1','1','2776.38','931.606','22.2502','2.00401','0','0','0.842554','0.538612','300','0','1'); UPDATE `creature_template` SET `flags_extra`='130' WHERE (`entry`='26656'); DELETE FROM `gameobject` WHERE (`guid`='54586'); DELETE FROM `gameobject` WHERE (`guid`='54587'); DELETE FROM `gameobject` WHERE (`guid`='54588'); DELETE FROM `gameobject` WHERE (`guid`='54589'); DELETE FROM `gameobject` WHERE (`guid`='54590'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54586','188633','571','65','4165','1','1','3854.65','1563.22','89.7386','2.61703','0','0','0.965801','0.259283','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54587','188633','571','65','4165','1','1','3859.76','1584.38','89.7921','3.61056','0','0','0.972634','-0.232342','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54588','188633','571','65','4165','1','1','3829.61','1611.77','89.8255','4.70384','0','0','0.710124','-0.704077','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54589','188633','571','65','4165','1','1','3804.51','1598.4','89.7538','5.66595','0','0','0.303741','-0.952755','300','0','1'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54590','188633','571','65','4165','1','1','3824.48','1550.51','89.8168','3.60428','0','0','0.973359','-0.229288','300','0','1'); DELETE FROM `creature_text` WHERE `entry` IN (27234,27235,27236,27237,27209); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`comment`) VALUES ('27209','1','0','Ow! I''ll tell you NOTHING, filthy $r!','12','100','26480','Branding 1'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`comment`) VALUES ('27209','2','0','Wait... WAIT! What is it that you want to know?! I know you''re the $c named $n.','12','100','26481','Branding 2'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`comment`) VALUES ('27209','3','0','OW...NO! We know that you''ve been stealing our armor and weapons and horses!','12','100','26482','Branding 3'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`comment`) VALUES ('27209','4','0','We know... that you don''t... know why we''re immune... to your so-called blight. Grand Admiral Westwind somehow gave the high abbot that prayer. I beg you... no more... please?!','12','100','26483','Branding 4'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`comment`) VALUES ('27209','5','0','AHHHHHHHHH! Please... we know... that you... have a spy... disguised as... one of us! There... that''s all that I know. Please... mercy... STOP!','12','100','26484','Branding 5'); UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (27234,27235,27236,27237); DELETE FROM `spell_scripts` WHERE `id` IN (48724,48726,48728,48730); INSERT INTO `spell_scripts`(`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES (48724,0,15,48723,1,0,0,0,0,0), (48726,0,15,48725,1,0,0,0,0,0), (48728,0,15,48727,1,0,0,0,0,0), (48730,0,15,48729,1,0,0,0,0,0); DELETE FROM `conditions` where `SourceEntry` IN (48724,48726,48728,48730) AND `SourceTypeOrReferenceId`=13; DELETE FROM `conditions` where `SourceEntry`=37438 AND `SourceTypeOrReferenceId`=18; INSERT INTO `conditions`(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`Comment`) VALUES (13,0,48724,0,18,1,27237,0,0, 'The Denouncement: Jordan target'), (13,0,48726,0,18,1,27235,0,0, 'The Denouncement: Zierhut target'), (13,0,48728,0,18,1,0,0,0, 'The Denouncement: Goodman target'), (13,0,48730,0,18,1,27236,0,0, 'The Denouncement: Mercer'), (18,0,37438,0,24,1,27234,0,0, 'The Denouncement: Rod - Goodman target'), (18,0,37438,0,24,1,27235,0,0, 'The Denouncement: Rod - Zierhut target'), (18,0,37438,0,24,1,27236,0,0, 'The Denouncement: Rod - Mercer target'), (18,0,37438,0,24,1,27237,0,0, 'The Denouncement: Rod - Jordan target'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES (27234,0,0, 'You are being misled! The Onslaught is all lies! The Scourge and the Forsaken are not our enemies! Wake up!',1,0,100,5,0,0, 'Blacksmith Goodman'), (27237,0,0, 'High general Abbendis personally told me that it was a mistake to come north and that we''re doomed! I urge you all to lay down your weapons and leave before it''s too late!',1,0,100,5,0,0, 'Commander Jordan'), (27235,0,0, 'Renounce the Scarlet Onslaught! Don''t listen to the lies of the high general and the grand admiral any longer!',1,0,100,5,0,0, 'Lead Cannoneer Zierhut'), (27236,0,0, 'Abbendis is nothing but a harlot and Grand Admiral Westwind is selling her cheap like he sold us out!',1,0,100,5,0,0, 'Stable Master Mercer'); DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (27234,27235,27236,27237); INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (27234,0,0,0,8,0,100,0,48714,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On spellhit set phase 2'), (27234,0,1,0,6,2,100,0,0,0,0,0,85,48728,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On death in phase 2 cast spell'), (27234,0,2,0,25,0,100,0,0,0,0,0,28,48714,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On reset remove Compelled aura'), (27234,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On reset set phase 0'), (27234,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On death in phase 2 yell'), (27236,0,0,0,8,0,100,0,48714,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On spellhit set phase 2'), (27236,0,1,0,6,2,100,0,0,0,0,0,85,48730,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On death in phase 2 cast spell'), (27236,0,2,0,25,0,100,0,0,0,0,0,28,48714,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On reset remove Compelled aura'), (27236,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On reset set phase 0'), (27236,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On death in phase 2 yell'), (27235,0,0,0,8,0,100,0,48714,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On spellhit set phase 2'), (27235,0,1,0,6,2,100,0,0,0,0,0,85,48726,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On death in phase 2 cast spell'), (27235,0,2,0,25,0,100,0,0,0,0,0,28,48714,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On reset remove Compelled aura'), (27235,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On reset set phase 0'), (27235,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On death in phase 2 yell'), (27237,0,0,0,8,0,100,0,48714,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On spellhit set phase 2'), (27237,0,1,0,6,2,100,0,0,0,0,0,85,48724,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On death in phase 2 cast spell'), (27237,0,2,0,25,0,100,0,0,0,0,0,28,48714,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On reset remove Compelled aura'), (27237,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On reset set phase 0'), (27237,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On death in phase 2 yell'); DELETE FROM `creature_template_addon` WHERE (`entry`='27559'); INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`,`VisibilityDistanceType`) VALUES ('27559','0','17722','50331648','1','0','','-1'); UPDATE `quest_template` SET `PrevQuestId`='12050' WHERE (`Id`='12112'); UPDATE `quest_template` SET `Details`='$C, did you see that? That''s the harpy that''s been leading the attack on our shipments to the gate! I''ve seen her in the back of Coldwind Heights before.$B$BThose harpies have slowed our profits long enough! Kill them all.' WHERE (`Id`='12052'); DELETE FROM `gameobject` WHERE (`guid`='54591'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54591','188633','571','65','4165','1','65535','3854.36','1531.87','89.9536','1.39232','0','0','0.641276','0.76731','300','0','1'); UPDATE `creature_template` SET `unit_flags`='33685504' WHERE (`entry`='27490'); DELETE FROM `creature` WHERE `id`=27715; UPDATE `creature_template` SET `faction_a`=14, `faction_h`=14, `AIName`='SmartAI' WHERE `entry` IN (27715, 27716, 27717, 27718); UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (27727, 27726); DELETE FROM `creature_text` WHERE `entry` IN (27719, 27727, 27726); INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (27719,0,0,"Ladies and gentlemen! Well... let's just say you don't want to miss this one!",14,0,100,0,0,0,'Grennix Shivwiggle - Quest Accepted'), (27719,1,0,"Ladies and gentlemen, gather round the Conquest Pit! Witness the battle of $r versus bear and place your bets with confidence!",14,0,100,0,0,0,'Grennix Shivwiggle - Bear Quest Accepted'), (27719,2,0,"Just when you think you've seen it all! $n will square off with an authentic Grizzly Hills crazed furbolg in front of your very eyes here at the Conquest Pit! Place your bets folks!",14,0,100,0,0,0,'Grennix Shivwiggle - Furbolg Quest Accepted'), (27719,3,0,"Gather round, folks! Grab a warm drink and find a good seat for you're about to witness a showdown between $r and machine!",14,0,100,0,0,0,'Grennix Shivwiggle - Blood Metal Quest Accepted'), (27719,4,0,"Ladies and gentlemen... gather round the pit!",14,0,100,0,0,0,'Grennix Shivwiggle - Death Likely Quest Accepted'), (27719,5,0,"In one corner we have... $n, truly a world class $c. Slayer of reptiles, mammals, mechanical constructs and the odd dragon...kin. You've never seen another $r like him.",14,0,100,0,0,0,'Grennix Shivwiggle - Death Likely Quest Accepted'), (27719,6,0,"In the other corner, a serial killer, mass defenestrator, sentenced to death multiple times by noose and by blunt instrument! Horgrenn... Hellcleave! Ladies and gentlemen... place your bets!",14,0,100,0,0,0,'Grennix Shivwiggle - Death Likely Quest Accepted'), (27727,0,0,"You went behind my back. You neglected my orders. You will pay the price.",12,0,100,0,0,0,'Conqueror Krenna - Say 0'), (27727,1,1,"Enough talk. By the time I'm though with you, not even the worgs will go near your corpse.",12,0,100,0,0,0,'Conqueror Krenna - Say 1'), (27726,0,0,"I used good judgment when you showed none. I don't want to see you lead us into ruin, Krenna!",12,0,100,0,0,0,'Gorgonna - Say 0'), (27726,1,1,"It doesn't have to end this way, you know?",12,0,100,0,0,0,'Gorgonna - Say 1'), (27726,2,2,"We'll see about that",12,0,100,0,0,0,'Gorgonna - Say 2'), (27726,3,3,"Why... why sister? Why did it have to come to this?",12,0,100,0,0,0,'Gorgonna - Say 3'); UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (27715,27716,27717,27718,27727,27719,27726); DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (27715,27716,27717,27718,27727,27719,27726); DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27715,27716,27717,27718,27727,27719,27726); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES (27715,0,0,0,9,0,100,0,8,25,17000,24000,11,32323,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Ironhide - Cast Charge'), (27715,0,1,0,0,0,100,0,5000,7000,7000,9000,11,34298,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Ironhide - Cast Maul'), (27715,0,2,0,9,0,100,0,0,5,7000,11000,11,31279,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Ironhide - Cast Swipe'), (27715,0,3,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ironhide - Evade - Unseen'), (27715,0,4,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ironhide - Evade - Despawn'), (27715,0,5,0,6,0,100,0,0,0,0,0,15,12427,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Ironhide - Death - Credit'), (27715,0,6,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ironhide - Death - Unseen'), (27715,0,7,0,7,0,100,0,0,0,0,0,6,12427,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Ironhide - Evade - Quest Fail'), (27716,0,0,0,0,0,100,0,1000,3000,6000,8000,11,16033,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Chain Lightning'), (27716,0,1,0,0,0,100,0,10000,20000,5000,15000,11,15982,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Healing Wave'), (27716,0,2,0,0,0,100,0,0,0,21000,21000,11,31991,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Corrupted Nova Totem'), (27716,0,3,0,0,0,100,0,4000,4000,12000,12000,11,15501,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Cast Earth Shock'), (27716,0,4,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Evade - Unseen'), (27716,0,5,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Evade - Despawn'), (27716,0,6,0,6,0,100,0,0,0,0,0,15,12428,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Torgg Thundertotem - Credit'), (27716,0,7,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Torgg Thundertotem - Death - Unseen'), (27716,0,8,0,7,0,100,0,0,0,0,0,6,12428,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Torgg Thundertotem - Evade - Quest Fail'), (27717,0,0,0,0,0,100,0,5000,7000,5000,7000,11,42746,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Cleave'), (27717,0,1,0,9,0,100,0,0,5,22000,30000,11,49398,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Knockback'), (27717,0,2,0,0,0,100,0,12000,15000,18000,21000,11,14102,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Head Smash'), (27717,0,3,0,0,0,100,0,0,3000,12000,12000,11,61893,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Rustblood - Cast Lightning Bolt'), (27717,0,4,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rustblood - Evade - Unseen'), (27717,0,5,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rustblood - Evade - Despawn'), (27717,0,6,0,6,0,100,0,0,0,0,0,15,12429,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Rustblood - Death - Credit'), (27717,0,7,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rustblood - Death - Unseen'), (27717,0,8,0,7,0,100,0,0,0,0,0,6,12429,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Rustblood - Evade - Quest Fail'), (27718,0,0,0,9,0,100,0,0,10,21000,29000,11,16508,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Intimidating Roar'), (27718,0,1,0,0,0,100,0,3000,6000,8000,12000,11,15572,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Sunder Armor'), (27718,0,2,0,0,0,100,0,9000,12000,12000,16000,11,39171,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Mortal Strike'), (27718,0,3,0,0,0,100,0,13000,15000,13000,18000,11,38618,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Cast Whirlwind'), (27718,0,4,0,7,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Evade - Unseen'), (27718,0,5,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Evade - Despawn'), (27718,0,6,0,6,0,100,0,0,0,0,0,15,12430,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Death - Credit'), (27718,0,7,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Death - Unseen'), (27718,0,8,0,7,0,100,0,0,0,0,0,6,12430,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Horgrenn Hellcleave - Evade - Quest Fail'), (27727,0,0,0,9,0,100,0,0,5,7000,9000,11,15284,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Cleave'), (27727,0,1,0,0,0,100,0,9000,12000,12000,17000,11,11430,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Slam'), (27727,0,2,0,13,0,100,0,14000,17000,14000,17000,11,12555,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Pummel'), (27727,0,3,0,13,0,100,0,3000,6000,6000,11000,11,34719,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Conqueror Krenna - Cast Fixate'), (27727,0,4,0,54,0,100,0,0,0,0,0,12,27726,3,75000,0,0,0,8,0,0,0,3244.50,-2340.56,92.14,6.27, 'Conqueror Krenna - Summon Gorgonna'), (27727,0,5,0,54,0,100,0,0,0,0,0,1,0,18000,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - Summoned - Say 0'), (27727,0,6,0,52,0,100,0,0,27727,0,0,1,1,6000,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - Say 0 - Say 1'), (27727,0,7,0,1,0,100,1,35000,35000,1,1,2,14,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - OOC 35 Sec - Enemy'), (27727,0,8,0,6,0,100,0,0,0,0,0,15,12431,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Conqueror Krenna - Death - Credit'), (27727,0,9,0,6,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Conqueror Krenna - Death - Unseen'), (27727,0,10,0,7,0,100,0,0,0,0,0,6,12431,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Conqueror Krenna - Evade - Quest Fail'), (27726,0,0,0,1,0,100,1,6000,6000,1,1,1,0,6000,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - OOC 6 Sec - Say 0'), (27726,0,1,0,52,0,100,0,0,27726,0,0,1,1,18000,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - Say 0 - Say 1'), (27726,0,2,0,52,0,100,0,1,27726,0,0,1,2,15000,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - Say 1 - Say 2'), (27726,0,3,0,52,0,100,0,2,27726,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Gorgonna - Say 2 - Say 3'), (27719, 0, 0, 0, 19, 0, 100, 0, 12427, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grennix Shivwiggle - Accepted Quest - Say 1'), (27719, 0, 1, 0, 19, 0, 100, 0, 12427, 0, 0, 0, 12, 27715, 7, 0, 0, 0, 0, 8, 0, 0, 0, 3242.77, -2340.98, 92.34, 0.98, 'Grennix Shivwiggle - Accepted Quest - Summon 27715'), (27719, 0, 2, 0, 19, 0, 100, 0, 12428, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grennix Shivwiggle - Accepted Quest - Say 2'), (27719, 0, 3, 0, 19, 0, 100, 0, 12428, 0, 0, 0, 12, 27716, 7, 0, 0, 0, 0, 8, 0, 0, 0, 3242.77, -2340.98, 92.34, 0.98, 'Grennix Shivwiggle - Accepted Quest - Summon 27716'), (27719, 0, 4, 0, 19, 0, 100, 0, 12429, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grennix Shivwiggle - Accepted Quest - Say 3'), (27719, 0, 5, 0, 19, 0, 100, 0, 12429, 0, 0, 0, 12, 27717, 7, 0, 0, 0, 0, 8, 0, 0, 0, 3242.77, -2340.98, 92.34, 0.98, 'Grennix Shivwiggle - Accepted Quest - Summon 27717'), (27719, 0, 6, 0, 19, 0, 100, 0, 12430, 0, 0, 0, 1, 4, 5, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grennix Shivwiggle - Accepted Quest - Say 4'), (27719, 0, 7, 0, 19, 0, 100, 0, 12430, 0, 0, 0, 1, 5, 10, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grennix Shivwiggle - Accepted Quest - Say 5'), (27719, 0, 8, 0, 19, 0, 100, 0, 12430, 0, 0, 0, 1, 6, 10, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grennix Shivwiggle - Accepted Quest - Say 6'), (27719, 0, 9, 0, 19, 0, 100, 0, 12430, 0, 0, 0, 12, 27718, 7, 0, 0, 0, 0, 8, 0, 0, 0, 3242.77, -2340.98, 92.34, 0.98, 'Grennix Shivwiggle - Accepted Quest - Summon 27718'), (27719, 0, 10, 0, 19, 0, 100, 0, 12431, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grennix Shivwiggle - Accepted Quest - Say 0'), (27719, 0, 11, 0, 19, 0, 100, 0, 12431, 0, 0, 0, 12, 27727, 7, 0, 0, 0, 0, 8, 0, 0, 0, 3251.91, -2340.61, 91.86, 3.1, 'Grennix Shivwiggle - Accepted Quest - Summon 27727'); DELETE FROM `gameobject` WHERE (`guid`='54592'); INSERT INTO `gameobject` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES ('54592','1864','571','394','4208','1','1','3841.19','-1959.29','208.596','5.41817','0','0','0.419148','-0.907918','300','0','1'); UPDATE `creature_template` SET `unit_flags2`='32769' WHERE (`entry`='26335'); DELETE FROM `creature` WHERE (`guid`='153670'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153670','55677','600','4196','4196','1','1','0','0','-527.273','-527.276','11.0112','5.78525','300','0','0','4524','0','0','0','0','0','0','0'); UPDATE `quest_template` SET `RequestItemsText`='Do you have the cloth?' WHERE (`Id`='13129'); DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='1') AND (`SourceGroup`='28519') AND (`SourceEntry`='38673') AND (`SourceId`='0') AND (`ElseGroup`='0') AND (`ConditionTypeOrReference`='9') AND (`ConditionTarget`='0') AND (`ConditionValue1`='12633') AND (`ConditionValue2`='0') AND (`ConditionValue3`='0'); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES ('1','28519','38673','0','0','9','0','12633','0','0','Writhing Choker - Stop drop when quest accepted'); DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='9709') AND (`SourceEntry`='0') AND (`SourceId`='0') AND (`ElseGroup`='0') AND (`ConditionTypeOrReference`='9') AND (`ConditionTarget`='0') AND (`ConditionValue1`='12630') AND (`ConditionValue2`='0') AND (`ConditionValue3`='0'); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES ('15','9709','0','0','0','9','0','12630','0','0','Stefan Vadu - option only if player has taken quest 12630'); UPDATE `creature_text` SET `text`='Soon, the master will grant them the dark gift, making them fit to serve the Lich King for eternity!' WHERE (`entry`='28948') AND (`groupid`='12') AND (`id`='0'); UPDATE `creature_text` SET `BroadcastTextId`='29128' WHERE (`entry`='28948') AND (`groupid`='1') AND (`id`='0'); UPDATE `creature_text` SET `BroadcastTextId`='29433' WHERE (`entry`='28948') AND (`groupid`='8') AND (`id`='0'); UPDATE `creature_text` SET `BroadcastTextId`='29437' WHERE (`entry`='28948') AND (`groupid`='12') AND (`id`='0'); UPDATE `creature_text` SET `BroadcastTextId`='29438' WHERE (`entry`='28948') AND (`groupid`='13') AND (`id`='0'); UPDATE `creature_template` SET `unit_flags2`='32769' WHERE (`entry`='28133'); UPDATE `creature_template` SET `unit_flags2`='32769' WHERE (`entry`='28141'); UPDATE `creature_template` SET `unit_flags2`='32769' WHERE (`entry`='28143'); UPDATE `creature_template` SET `unit_flags`=unit_flags+512 WHERE (`entry`='28260'); DELETE FROM `gameobject_loot_template` WHERE `entry`=24320 AND `item` IN (38340,38341,38397); DELETE FROM `gameobject_loot_template` WHERE `entry`=24326 AND `item`=38397; DELETE FROM `gameobject_loot_template` WHERE `entry`=24330 AND `item`=38335; DELETE FROM `gameobject_loot_template` WHERE `entry`=25028 AND `item`=38337; UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=100 WHERE `entry` BETWEEN 24319 AND 24340; UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=100 WHERE `entry` IN (25026,25027,25028); DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (51060,51068,51088,51094); INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES (51060,51226,1,'On spellhit Have Withered Batwing - Spellcast Withered Batwing Kill Credit'), (51068,51227,1,'On spellhit Have Muddy Mire Maggot - Spellcast Muddy Mire Maggot Kill Credit'), (51088,51228,1,'On spellhit Have Amberseed - Spellcast Amberseed Kill Credit'), (51094,51229,1,'On spellhit Have Chilled Serpent Mucus - Spellcast Chilled Serpent Mucus Kill Credit'); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9668 AND `SourceEntry` IN (13098,13119); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9668 AND `SourceEntry`=0; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (14,9668,13098,0,9,12587,0,0,0,'','Alchemist Finklestein - Show different gossip if player has taken quest Troll Patrol'), (14,9668,13119,0,9,12541,0,0,0,'','Alchemist Finklestein - Show different gossip if player has taken quest Troll Patrol: The Alchemist''s Apprentice'), (15,9668,0,0,9,12541,0,0,0,'','Alchemist Finklestein - Show gossip option only if player has taken quest Troll Patrol: The Alchemist''s Apprentice'); UPDATE `creature_template` SET `npcflag`='0' WHERE (`entry`='28800'); UPDATE `creature_text` SET `BroadcastTextId`='27513' WHERE (`entry`='28068') AND (`groupid`='2') AND (`id`='0'); DELETE FROM `creature_text` WHERE (`entry`='28151'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`comment`) VALUES ('28151','1','0','NOOOOOOOOooooooo.........!','14','100','27532','Muddled Prophet of Sseratus Death'); UPDATE `page_text` SET `text`='\n\n

The Diary of High General Abbendis

\n
\n\n\n',`next_page`='3093' WHERE (`entry`='3079'); DELETE FROM `page_text` WHERE (`entry`='3092'); UPDATE `creature_equip_template` SET `itemEntry1`='3198',`itemEntry2`='0' WHERE (`entry`='28636') AND (`id`='1'); DELETE FROM `creature` WHERE (`guid`='145627'); DELETE FROM `creature` WHERE (`guid`='150213'); DELETE FROM `creature` WHERE (`guid`='150342'); DELETE FROM `creature` WHERE (`guid`='153671'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153671','55737','604','4416','4416','1','1','0','0','1856.22','833.407','176.682','1.18789','300','0','0','3462','8313','0','0','0','0','0','0'); UPDATE `gameobject_template` SET `data9`='1' WHERE (`entry`='190857'); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=52090 AND `ElseGroup`=1; INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 52090, 0, 1, 31, 1, 3, 28465, 0, 0, 173, 0, '', 'Item 38731 "Ahunae\'s Knife" targets 28465 "Heb\'Drakkar Striker'), (17, 0, 52090, 0, 1, 36, 1, 0, 0, 0, 1, 173, 0, '', 'Item 38731 "Ahunae\'s Knife" targets 28465 "Heb\'Drakkar Striker'); UPDATE `creature_template` SET `npcflag`='0' WHERE (`entry`='30572'); UPDATE `conditions` SET `ConditionTypeOrReference`='28' WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='9045') AND (`SourceEntry`='0') AND (`SourceId`='0') AND (`ElseGroup`='0') AND (`ConditionTypeOrReference`='9') AND (`ConditionTarget`='0') AND (`ConditionValue1`='11509') AND (`ConditionValue2`='0') AND (`ConditionValue3`='0'); DELETE FROM `gossip_menu` WHERE (`entry`='9019') AND (`text_id`='12186'); DELETE FROM `conditions` WHERE (`SourceGroup`='9019'); INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES ('9019','12186'); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES ('14','9019','12187','0','0','8','0','11471','0','0','0','0','0','','Only show gossip text 12186 if player has completed quest 11471'); DELETE FROM `gossip_menu_option` WHERE (`menu_id`='10024') AND (`id`='1'); UPDATE `conditions` SET `ConditionTypeOrReference`='28' WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='10024') AND (`SourceEntry`='0') AND (`SourceId`='0') AND (`ElseGroup`='0') AND (`ConditionTypeOrReference`='9') AND (`ConditionTarget`='0') AND (`ConditionValue1`='12521') AND (`ConditionValue2`='0') AND (`ConditionValue3`='0'); UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=28160; UPDATE `creature_template` SET `npcflag`= 16777216, `InhabitType`=4, `AIName`='SmartAI', `VehicleId`=220 WHERE `entry`=28192; UPDATE `creature_template` SET `InhabitType`=4, `AIName`='SmartAI' WHERE `entry`=28229; UPDATE creature_template SET InhabitType=4, `AIName`='SmartAI' WHERE entry=27987; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=28160; DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=28160*100; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=28192; DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=28192*100; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=28192; DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=28192*100+1; DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=28192*100+2; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=28229; DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=28229*100; DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=27987*100; DELETE FROM `smart_scripts` WHERE `entryorguid` = 27987 AND `source_type` = 0; INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (28160,0,0,0,62,0,100,0,10024,0,0,0,80,28160*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Archmage Pentarus - On gossip option select - run script'), (28160*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Archmage Pentarus - Actionlist - Close gossip'), (28160*100,9,1,0,0,0,100,0,0,0,0,0,85,50860,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Archmage Pentarus - Script - Cast Flight to Sholazar on player'), (28160*100,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Archmage Pentarus - Script - say 0'), (28160*100,9,3,0,0,0,100,0,0,0,0,0,50,190488,19,0,0,0,0,8,0,0,0,5832.702637, 436.761108, 669.141174, 1.612513, 'Archmage Pentarus - Script - spawn portal'), (28192, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, 28192*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Machine - On summon - Action List'), (28192*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Machine - Action List - Set Fly ON'), (28192*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 46598, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Machine - Action List - CrossCast'), (28192*100, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5832.702637, 436.761108, 669.141174, 0.612513, 'Machine - Action List - InvokerCast'), (28192*100, 9, 3, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 11, 50987, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Machine - Action List - cast teleportation'), (28192*100, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 53, 1, 28192, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Machine - Action List - Start wp'), (28192, 0, 1, 0, 40, 0, 100, 0, 1, 0, 0, 0, 80, 28192*100+1, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Machine - on wp end - ActionList'), (28192*100+1, 9, 0, 0, 0, 0, 100, 0, 11000, 11000, 0, 0, 11, 508602, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Machine - Action List - cast spell to invok AirPatrol'), (28229, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, 28229*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '28229 - On spawn - Action List'), (28229*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '28229 - Action List - Set Fly ON'), (28229*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '28229 - Action List - Set react passif'), (28229*100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 29, 5, 45, 0, 0, 0, 0, 19, 28192, 60, 0, 0, 0, 0, 0, '28229 - Action List - follow target'), (28229*100, 9, 3, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '28229 - Action List - Talk'), (28229*100, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Talk'), (28229*100, 9, 5, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 11, 50878, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 6, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50878, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 7, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50878, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 8, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50878, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 9, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50878, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 10, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50878, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 11, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50892, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 12, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50892, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 13, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50892, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 14, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50892, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28229*100, 9, 15, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 50892, 0, 0, 0, 0, 0, 19, 28192, 30, 0, 0, 0, 0, 0, '28229 - Action List - Cast'), (28192, 0, 2, 0, 40, 0, 100, 0, 2, 0, 0, 0, 80, 27987*100, 2, 0, 0, 0, 0, 10, 103289, 27987, 0, 0, 0, 0, 0, '28192 - On WP2 - Actionlist'), (27987*100, 9, 0, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 21, 40, 0, 0, 0, 0, 0, 0, '27987 - Action List - talk'), (28192, 0, 3, 0, 40, 0, 100, 0, 3, 0, 0, 0, 80, 28192*100+2, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '28192 - On spellHit - Actionlist'), (28192*100+2, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 75, 61360, 0, 0, 0, 0, 0, 21, 10, 0, 0, 0, 0, 0, 0, '28192 - Actionlist - Add parachute'), (28192*100+2, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '28192 - Actionlist - Eject passenger'), (27987, 0, 0, 1, 25, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' 27987 - On spawn - set fly on'); DELETE FROM `waypoints` WHERE `entry` IN(28192); INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (28192, 1, 5478.141113, 4971.844238, -22.431667, 'Archimage Pentarus Flying Machine'), (28192, 2, 5593.686035, 5187.787109, -72.69004, 'Archimage Pentarus Flying Machine'), (28192, 3, 5647.750488, 5229.604004, -72.69004, 'Archimage Pentarus Flying Machine'); DELETE FROM `creature_text` WHERE `entry`in (28229, 27987, 28192, 28160); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextID`) VALUES (28160,0,0, 'I''ll send you on my flying machine. Keep your eyes peeled for clues about what might''ve happened to Hemet!',12,0,100,25,0,0, 'Archmage Pentarus',27620), (28229,0,0, 'More intruders? You''ll soon learn, no one messes with the Venture Company!',14,0,100,0,0,0, 'Venture Co. Air Patrol',27611), (27987,0,0, 'Over here, to the southeast. I see they got you too...',14,0,100,0,0,0, 'Monte Muzzleshot',27610), (28192,0,0, 'WARNING: Missile lock detected. Engaging evasive maneuvers.',12,0,100,0,0,0, 'Archimage Pentarus Flying Machine',27621); DELETE FROM `spell_target_position` WHERE `id` in (50987, 50859); INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES (50987, 571, 5071.35, 4642.54, 72.164, 0.878587), (50859,571, 5832.892, 482.8708, 658.2753, 0.9121326); DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=28192; INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`,`user_type`) VALUES (28192,46598,1,0); DELETE FROM `creature_addon` WHERE `guid`=103289; INSERT INTO `creature_addon` (`guid`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`)VALUES (103289,0,0,1,0, '50544'); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10024; Delete from `conditions` where `SourceTypeOrReferenceId`=13 AND `SourceEntry`in (50878, 50892); INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (13, 1, 50892, 0, 31, 3, 28192, 0, 0, '', 'Only petrus flying machine is the target for the rockets'), (13, 1, 50878, 0, 31, 3, 28192, 0, 0, '', 'Only petrus flying machine is the target for the rockets'); UPDATE `creature_template` SET `dmg_multiplier`=5 WHERE `entry`=28468; UPDATE `quest_template` SET `Details`='So, where did you come from? I don''t suppose that fool of an archmage sent you, too?$B$BYou''re lucky to be in one piece, $g laddie:lass;! They nearly blew you up!$B$BThe jungle here''s a darned dangerous place, ''specially with the Venture Company about.$B$BGit you! Go see the boss... he''ll sort you out. The camp''s at the end of that path to the northwest.$B$BNow, git!' WHERE (`Id`='12489'); DELETE FROM `creature` WHERE (`guid`='153672'); DELETE FROM `creature` WHERE (`guid`='153673'); DELETE FROM `creature` WHERE (`guid`='142136'); DELETE FROM `creature` WHERE (`guid`='145627'); DELETE FROM `creature` WHERE (`guid`='150213'); DELETE FROM `creature` WHERE (`guid`='150342'); DELETE FROM `creature` WHERE (`guid`='150059'); DELETE FROM `creature` WHERE (`guid`='150063'); DELETE FROM `creature` WHERE (`guid`='150207'); DELETE FROM `creature` WHERE (`guid`='150223'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153672','28127','571','3711','4303','1','1','0','0','5130.31','3979.45','-61.5883','3.07353','300','0','0','86','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('153673','28127','571','3711','4303','1','1','0','0','5132.87','3979.49','-61.6483','0.788018','300','0','0','55','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('142136','28127','571','3711','4303','1','1','0','0','5130.56','3977.36','-61.2746','5.66534','300','0','0','55','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('145627','28127','571','3711','4303','1','1','0','0','5121.05','3983.86','-61.8943','2.45306','300','0','0','55','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('150213','28127','571','3711','4303','1','1','0','0','5119.04','3983.98','-61.8759','4.83675','300','0','0','71','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('150342','28127','571','3711','4303','1','1','0','0','5119.93','3986.42','-61.9229','3.6076','300','0','0','71','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('150059','29056','571','3711','4307','1','1','0','0','6208.12','4765.22','223.447','4.62857','300','0','0','6722','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('150063','29057','571','3711','4400','1','1','0','0','5101.57','5341.06','216.552','1.53263','300','0','0','6722','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('150207','29069','571','3711','4302','1','1','0','0','4983.28','4588.94','150.673','1.97481','300','0','0','6722','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('150223','29057','571','3711','4400','1','1','0','0','5102.56','5336.32','212.018','1.41254','300','0','0','6722','0','0','0','0','0','0','0'); UPDATE `quest_template` SET `OfferRewardText`='So much energy in you... you full of the power of the Great Ones!$b$bI not lie, I little bit jealous.' WHERE (`Id`='12762'); UPDATE `creature` SET `spawndist`='0',`MovementType`='0' WHERE (`id`='29483'); UPDATE `creature` SET `position_x`='6236.35',`position_y`='-1236.11',`position_z`='432.593' WHERE (`guid`='132528'); DELETE FROM `creature` WHERE (`guid`='135980'); DELETE FROM `creature_loot_template` WHERE (`entry`='30291'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','44756','71','4'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','43010','50','4'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','44757','19','3'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','43013','14','3'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','44766','7','4'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','44767','2','2'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','39551','0.2','3'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','33384','0.2','1'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','36428','0.2','1'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','33424','0.2','1'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','33383','0.2','1'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','36254','0.2','1'); INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`maxcount`) VALUES ('30291','36392','0.2','1'); UPDATE `quest_template` SET `CompletedText`='Return to Thorim at the Temple of Storms in the Storm Peaks.' WHERE (`Id`='12886'); UPDATE `creature_text` SET `text`='This "Loken" sounds like a nasty character. Glad we don''t have to worry about the likes o'' him anymore. So... if I''m understandin'' ye right, the original earthen eventually woke up from this stasis, and by that time the destabili-whatever had turned ''em into proper dwarves. Or at least... dwarf ancestors.' WHERE (`entry`='28070') AND (`groupid`='28') AND (`id`='0'); UPDATE `creature` SET `spawndist`='0',`MovementType`='0' WHERE (`id`='28965'); UPDATE `creature` SET `spawndist`='0',`MovementType`='0' WHERE (`id`='28961'); DELETE FROM `creature` WHERE (`guid`='150208'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('150208','30433','571','210','4501','1','1','0','30433','6163.27','-61.6693','388.18','0.376226','300','0','0','232470','0','0','0','0','0','0','0'); DELETE FROM `creature` WHERE (`guid`='508557'); DELETE FROM `creature` WHERE (`guid`='508556'); DELETE FROM `creature` WHERE (`guid`='149523'); DELETE FROM `creature` WHERE (`guid`='149273'); DELETE FROM `creature` WHERE (`guid`='149242'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES ('149523','30831','571','210','4506','128','6869.48','423.288','471.784','1.06624'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('149273','30829','571','210','4506','1','128','0','0','6839.02','594.445','427.23','4.5','120','0','0','1','0','0','0','0','0','0','0'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('149242','30830','571','210','4593','1','128','0','0','7169.8','664.115','492.376','1.12953','120','0','0','1','0','2','0','0','0','0','0'); UPDATE `creature_addon` SET `bytes1`='3' WHERE (`guid`='148411'); DELETE FROM `creature_queststarter` WHERE (`id`='30824') AND (`quest`='14447'); DELETE FROM `creature_queststarter` WHERE (`id`='30824') AND (`quest`='14447'); DELETE FROM `creature` WHERE (`guid`='149274'); INSERT INTO `creature` (`guid`,`id`,`map`,`zone`,`area`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`walkmode`,`saiscriptflag`) VALUES ('149274','30630','571','210','4501','1','1','0','0','6203.86','-11.1894','410.159','0.864655','300','0','0','63000','7988','0','0','0','0','0','0'); DELETE FROM `smart_scripts` WHERE `entryorguid`=30630; INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES ('30630','0','0','1','62','0','100','0','9991','0','0','0','11','57536','0','0','0','0','0','7','0','0','0','0','0','0','0',"Arch Druid Lilliandra - On Gossip Option 0 Selected - Cast 'Forcecast Portal: Moonglade'"); INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES ('30630','0','1','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','1','0','0','0','0','0','0','0',"Arch Druid Lilliandra - On Gossip Option 0 Selected - Close gossip"); UPDATE `creature` SET `modelid`='27548' WHERE (`guid`='150584'); DELETE FROM `creature` WHERE (`guid`='897139'); UPDATE `creature_text` SET `text`='We made it! I''ll find my way back on my own. Do me a favor and go tell Royce Duskwhisper where he can stick his stupid Eye of Twilight.' WHERE (`entry`='39797') AND (`groupid`='1') AND (`id`='0'); UPDATE `smart_scripts` SET `event_type`='54',`event_param1`='0' WHERE (`entryorguid`='39797') AND (`source_type`='0') AND (`id`='0') AND (`link`='0'); UPDATE `npc_text` SET `text0_1`='$N, the Twilight slaves you and others have been rescuing from Wolf''s Run are wandering into camp, but they can''t tell me who they are and they speak in riddles and gibberish.$B$BI thought Twilight''s Hammer kept the slaves in line the old fashioned way - you know, whips and chains - but it''s clear that there''s some brainwashing at work...' WHERE (`ID`='15712'); UPDATE `npc_text` SET `text0_1`='Any luck out there? Just trying to hold a conversation with the freed slaves makes my head hurt.$B$BThey straddle the line in discord and rhyme.' WHERE (`ID`='15714'); UPDATE `npc_text` SET `text0_1`='Thanks for your help, $N.' WHERE (`ID`='15715'); DELETE FROM `conditions` WHERE (`SourceGroup`='11316') AND (`SourceEntry`='15784'); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES ('14','11316','15784','0','0','8','0','25404','0','0','Tyrus Blackthorn - Change gossip on quest finish'); UPDATE `gossip_menu` SET `text_id`='15782' WHERE (`entry`='11323') AND (`text_id`='15779'); UPDATE `creature_text` SET `text`='But your time will come soon enough. Yes, mortal. Soon enough...',`sound`='20778' WHERE (`entry`='40172') AND (`groupid`='5') AND (`id`='0'); UPDATE `creature_text` SET `sound`='20773' WHERE (`entry`='40172') AND (`groupid`='0') AND (`id`='0'); UPDATE `creature_text` SET `sound`='20774' WHERE (`entry`='40172') AND (`groupid`='1') AND (`id`='0'); UPDATE `creature_text` SET `sound`='20776' WHERE (`entry`='40172') AND (`groupid`='3') AND (`id`='0'); UPDATE `creature_text` SET `sound`='20777' WHERE (`entry`='40172') AND (`groupid`='4') AND (`id`='0'); DELETE FROM `creature_text` WHERE (`entry`='41068'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`comment`) VALUES ('41068','0','0','A Mysterious Winged Spirit appears above the circle, hazy and indistinct.','16','100','Quest: An Offering to Aviana - Text 1'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`comment`) VALUES ('41068','1','0','Come ... closer ... $C. They are ... pulling me away ...','12','100','Quest: An Offering to Aviana - Text 2'); INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`comment`) VALUES ('41068','2','0','Hurry... ','12','100','Quest: A Plea from Beyond - Accept quest text'); UPDATE `smart_scripts` SET `event_param1`='25665' WHERE (`entryorguid`='41068') AND (`source_type`='0') AND (`id`='1') AND (`link`='0'); UPDATE `gameobject` SET `spawntimesecs`='120' WHERE (`id`='203143'); DELETE FROM `creature_queststarter` WHERE (`id`='41308') AND (`quest`='25810'); UPDATE `gossip_menu_option` SET `option_text`='On Your feet, soldier. The ancients are with us, and the mountain is healed!' WHERE (`menu_id`='41499') AND (`id`='0');