-- fix quest Crumbling Defenses

UPDATE `quest_template` SET `QuestFlags` = 0 WHERE `entry` = 26312;

UPDATE `creature_template` SET `minlevel` = 83, `maxlevel` = 83, `exp` = 3 WHERE `entry` = 44131;
UPDATE `creature_template` SET `ScriptName` = "npc_crumbling_defenses" WHERE `entry` IN (44353,44352,42788);

SET @GUID:= 810000;

DELETE FROM `creature` WHERE `id` IN (44353,44352,42788);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@GUID+0,'42788','646','1','1','0','0','1332.31','638.2','-66.513','0.519875','300','0','0','297777','51582','0','0','0','0'),
(@GUID+1,'44352','646','1','1','0','0','1379.17','794.633','-57.0729','4.43332','300','0','0','153395','0','0','0','0','0'),
(@GUID+3,'44353','646','1','1','0','0','1330.97','837.571','-57.3255','6.26357','600','0','0','252','0','0','0','0','0');