DELETE FROM `creature_questrelation` WHERE `quest` IN(12932, 12933, 12934, 12935, 12936, 12954, 12948);DELETE FROM `gameobject_questrelation` WHERE `quest` IN(12932, 12933, 12934, 12935, 12936, 12954, 12948);UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` IN(12932, 12933, 12934, 12935, 12936, 12954, 12948);DELETE FROM `creature_involvedrelation` WHERE `quest` IN(12932, 12933, 12934, 12935, 12936, 12954, 12948);DELETE FROM `gameobject_involvedrelation` WHERE `quest` IN(12932, 12933, 12934, 12935, 12936, 12954, 12948);UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` IN (30007, 30009);INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES(30009, 12932),(30009, 12933),(30009, 12934),(30009, 12935),(30009, 12936),(30009, 12954),(30009, 12948);INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES(30007, 12932),(30007, 12933),(30007, 12934),(30007, 12935),(30007, 12936),(30007, 12954),(30007, 12948);-- (INVIS:Updated kill criteria for elemental quest from air to water (the one with correct stats)REPLACE INTO`quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorableKills`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES('12932','2','66','0','75','77','1','0','0','0','0','0','0','0','0','5','0','130','0','0','0','0','12974','0','0','0','0','0','0','The Amphitheater of Anguish: Yggdras!','I\'ll tell you what, buddy, this place is a far cry from the rolling plains of Nagrand. These trolls are dirtier than ogres; but hey, I go where the gold\'s at! So welcome to Zul\'Drak, pal.$B$BYou\'re new to this racket, so let me set you straight. I\'m the fight promoter and this feisty troll next to me is Wodin, my bodyguard. You\'re the entertainment. When you wanna fight, let me know and I\'ll set up the match.$B$BIf you\'re ready and got a group of friends with you, we can start! What do you say?$B','Get in the arena at the Amphitheater of Anguish and defeat Yggdras! Return to Wodin the Troll-Servant to redeem your reward.','Not bad, friend. You might make some gold out here - if you manage to stay alive.','','Yggdras Defeated','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','30014','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','195000','192600','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12932','0'),('12933','2','66','0','75','77','1','0','0','0','0','0','0','0','0','5','0','130','0','0','0','0','12932','0','0','0','0','0','0','The Amphitheater of Anguish: Magnataur!','This next match is a doozy, buddy! Apparently some magnataur from the Dragonblight wants a piece of the action. You ever fought one of those before? All I can tell you is to aim high!$B$BWe\'ll get this party started when you give me the word.','Get in the arena at the Amphitheater of Anguish and defeat Stinkbeard! Return to Wodin the Troll-Servant to redeem your reward.','Wow! When I first saw Stinkbeard, I thought you were done for! Nice work!','','Stinkbeard Defeated','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','30017','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','195000','192600','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12933','0'),('12934','2','66','0','75','77','1','0','0','0','0','0','0','0','0','5','0','130','0','0','0','0','12933','0','0','0','0','0','0','The Amphitheater of Anguish: From Beyond!','I\'m not gonna lie to you, pal. You might be overmatched here. This next one is a being from the elemental planes! I don\'t even know what\'s gonna show up in that arena!$B$BIf you think you\'re up to it, get in there and give \'em hell!','Get in the arena at the Amphitheater of Anguish and defeat one of the elemental lords! Return to Wodin the Troll-Servant to redeem your reward.','Unbelievable! I thought this whole place was going to explode when it first appeared! You really dominated that round!','','Elemental Lord Defeated','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','30024','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','195000','192600','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12934','0'),('12935','2','66','0','75','77','1','0','0','0','0','0','0','0','0','5','0','130','0','0','0','0','12934','0','0','0','0','0','0','The Amphitheater of Anguish: Tuskarrmageddon!','This next one\'s fightin\' from a dark place, kid. The kind of dark that can only happen when you\'ve been on the flip-side. He\'s hungry and willing to do whatever it takes to win. Watch yourself! I\'ve heard he wrestles yetis for exercise!$B$BWe\'ll start when you\'re ready.','Get in the arena at the Amphitheater of Anguish and defeat Orinoko Tuskbreaker! Return to Wodin the Troll-Servant to redeem your reward.','I was worried for a while there, $n. When he busted out the seals and penguins... Well, I didn\'t know what to think to be honest. It looked pretty damn ridiculous.','','Orinoko Tuskbreaker Defeated','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','30020','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','33447','33448','34722','0','5','5','20','0','0','0','0','0','0','0','0','0','0','0','0','195000','192600','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12935','0'),('12936','2','66','0','75','77','1','0','0','0','0','0','0','0','0','5','0','130','0','0','0','0','12935','0','0','0','0','0','0','The Amphitheater of Anguish: Korrak the Bloodrager!','You\'re not gonna believe this, pal. Your next fight is against Korrak the Bloodrager! Looks like the Drakkari trolls are pulling a power play! And let me tell you, buddy, he\'s been sippin\' the animal god juice. He\'s good and ready to pound you into the ground.$B$BAre you ready?','Get in the arena at the Amphitheater of Anguish and defeat Korrak the Bloodrager! Return to Wodin the Troll-Servant to redeem your reward.','Damn, I remember Korrak from way back in my younger days when I used to work for the Frostwolf Clan. He would never shut up! I think you just did the world a great service, $n.','','Korrak the Bloodrager Defeated','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','30023','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','195000','192600','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12936','0'),('12954','2','66','0','74','77','1','0','0','0','0','0','0','0','0','5','0','130','0','0','0','0','12974','0','0','0','0','0','0','The Amphitheater of Anguish: Yggdras!','I was wondering when you\'d show up, $N! Having a past champion of the Ring of Blood here will be a huge draw! We\'re gonna be rich, buddy! RICH!$B$BAnyway, this dump is Zul\'Drak. All the ice trolls seem to use it as a toilet. I dunno, the whole place is off its rocker if you ask me! Who cares, though, right? We\'re here to make some gold!$B$BYou know the drill, $N. When you\'re ready let me know and we\'ll get this show on the road!$B','Get in the arena at the Amphitheater of Anguish and defeat Yggdras! Return to Wodin the Troll-Servant to redeem your reward.','Hey! I know you. Your victory at the Ring of Blood was talked about for months! Too bad you forfeited the championship when you failed to show up to defend your title! Easy come, easy go, eh? At least you\'re still alive.','No payout until the fight\'s over, $gman:woman;.','Yggdras Defeated','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','30014','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','195000','192600','0','0','0','0','0','0','0','0','4','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12954','0'),('12948','2','66','0','75','78','1','0','0','0','0','0','0','0','0','0','0','8','0','0','0','0','12936','0','0','0','0','0','0','The Champion of Anguish','This is the end, my friend! Your last opponent is going to be your greatest challenge. He\'s a vrykul champion from the steppes of Icecrown and he\'s out for blood! Defeat him and you\'ll be crowned the champion of the Amphitheater of Anguish! This fight is going to make us both rich!$B$BLet me know when you\'re ready and we\'ll start.','Get in the arena at the Amphitheater of Anguish and defeat Vladof the Butcher! Return to Wodin the Troll-Servant to redeem your reward.','You did it, $N! That was the most exciting fight yet! What are you going to do with your winnings? Me? I\'m going to Dalaran and blowing it all in the Underbelly. Lot of hot action going on down there!',NULL,'Vladof the Butcher Defeated','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','30022','0','0','0','1','0','0','0','0','0','0','0','41815','41821','41825','41816','41822','41824','1','1','1','1','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','204000','194400','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12948','0');-- "proper" creatures (INVIS: Added: Wodin 'troll servant', Yggdras Minions, Whisker, and hungry penguins FTW, !added elite multipliers!)REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES('30020','0','0','0','26695','0','26695','0','Orinoko Tuskbreaker',NULL,NULL,'76','76','198018','198018','0','0','8534','14','14','0','1','1','1','452','546','0','428','3.5','2000','1500','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','32064','55937','55929','55946','0','0','0','','0','3','18','1','0','0','0','0','0','164','1','1646','0','0','generic_creature'),('30014','0','0','0','24892','0','24892','0','Yggdras',NULL,NULL,'75','75','106350','106350','0','0','8235','14','14','0','1','1','1','428','521','0','407','3.5','2000','1500','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','40504','57076','55859','0','0','0','0','','0','3','10','1','0','0','0','0','0','199','1','0','0','0','generic_creature'),('30017','0','0','0','24954','0','24954','0','Stinkbeard',NULL,NULL,'75','75','138255','138255','0','0','8235','14','14','0','1','1','1','428','521','0','407','3.5','2000','1500','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','31389','55867','55866','50420','0','0','0','','0','3','13','1','0','0','0','0','0','169','1','0','0','0','generic_creature'),('30023','0','12159','0','7873','0','7873','0','Korrak the Bloodrager','Champion of the Winterax',NULL,'77','77','227580','227580','0','0','8833','14','14','0','1','1','1','484','577','0','455','3.5','2000','1500','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','24193','42745','55948','30471','0','0','0','','0','3','20','1','0','0','0','0','0','164','1','0','0','0','generic_creature'),('30024','0','0','0','26692','0','26692','0','Gargoral the Water Lord',NULL,NULL,'76','76','165015','165015','54645','54645','8534','14','14','0','1','1','1','452','546','0','428','3.5','2000','1500','0','0','0','0','0','0','0','0','0','0','0','4','0','0','0','0','0','0','0','0','0','0','55909','0','0','0','0','0','0','','0','3','15','15','0','0','0','0','0','0','1','0','0','0','generic_creature'),('30022','0','0','0','26696','0','26696','0','Vladof the Butcher',NULL,NULL,'77','77','250338','250338','0','0','8833','14','14','0','1','1','1','484','577','0','455','3.5','2000','1500','0','0','0','0','0','0','0','0','0','0','0','7','8','0','0','0','0','0','0','0','0','0','55974','55973','50689','55975','0','0','0','','0','3','22','1','0','0','0','0','0','180','1','1647','0','0','generic_creature'),(30007, 0, 0, 0, 17836, 0, 17836, 0, 'Gurgthock', 'Fight Promoter', '', 75, 75, 10635, 10635, 0, 0, 0, 35, 35, 2, 1, 1, 0, 200, 200, 0, 400, 1, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''),(30009, 0, 0, 0, 12829, 0, 12829, 0, 'Wodin the Troll-Servant', '', '', 74, 74, 10282, 10282, 0, 0, 0, 35, 35, 2, 1, 1, 0, 200, 200, 0, 400, 1, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''),('30093','0','0','0','26758','0','26758','0','Yggdras Worm',NULL,NULL,'72','73','4805','4970','0','0','7618','14','14','0','1','1','0','428','521','0','320','1','2000','1500','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','0.5','1','0','0','0','0','0','80','1','0','0','0',''),('30110','0','0','0','25390','25390','25391','25391','Hungry Penguin',NULL,NULL,'74','74','1028','1028','0','0','7618','7','7','0','1','1','0','328','467','0','354','1','2000','1500','0','0','0','0','0','0','0','0','0','0','0','8','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','0.5','1','0','0','0','0','0','80','1','0','0','0',''),('30113','0','0','0','26768','0','26768','0','Whisker',NULL,NULL,'76','76','154014','154014','0','0','8520','14','14','0','1','1','1','356','503','0','432','3.5','2000','1500','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','50169','0','0','0','0','0','0','','0','3','14','1','0','0','0','0','0','199','1','0','0','0','generic_creature');-- Quest_start_scripts to spawn NPCs for the above quests, (INVIS: Changed AirLord to WaterLord whos stats were provided)DELETE FROM `quest_start_scripts` WHERE `id` IN(12932, 12933, 12934, 12936, 12936, 12954, 12935, 12948);INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES('12932','5','10','30014','1200000','0','5773.31','-2981.64','272.98','5.24'),('12933','5','10','30017','1200000','0','5773.31','-2981.64','272.98','5.24'),('12934','5','10','30024','1200000','0','5773.31','-2981.64','272.98','5.24'),('12935','5','10','30020','1200000','0','5773.31','-2981.64','272.98','5.24'),('12936','5','10','30023','1200000','0','5773.31','-2981.64','272.98','5.24'),('12954','5','10','30014','1200000','0','5773.31','-2981.64','272.98','5.24'),('12948','5','10','30022','1200000','0','5773.31','-2981.64','272.98','5.24');UPDATE `quest_template` SET `StartScript` = `entry` WHERE `entry` IN(12932, 12933, 12934, 12936, 12936, 12954, 12935, 12948);-- More correct spawns for quest giver and quest turn-in guys by Invis. The quest giver is spawned in the arena, and should be above it on a platform.DELETE FROM creature WHERE `id` IN(30009, 30007);INSERT INTO creature (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES(30007, 571, 1, 1, 0, 0, 5792.99, -3019.04, 286.301, 1.9762, 25, 0, 0, 10635, 0, 0, 0),(30009, 571, 1, 1, 0, 0, 5788.32, -3024.51, 286.295, 1.955, 25, 0, 0, 10282, 0, 0, 0);