From f4b202e49486ac3c87eac5d50650662c011816e2 Mon Sep 17 00:00:00 2001 From: mrquickfx Date: Mon, 21 Mar 2011 22:16:58 +0100 Subject: DB/Creature: Rotting Frost Giant spawn for 25 man instances fixes #797 --- sql/updates/world/2011_03_21_6_world_creature.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2011_03_21_6_world_creature.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_03_21_6_world_creature.sql b/sql/updates/world/2011_03_21_6_world_creature.sql new file mode 100644 index 00000000000..22de14493b3 --- /dev/null +++ b/sql/updates/world/2011_03_21_6_world_creature.sql @@ -0,0 +1,16 @@ +SET @GUID := 95035 ; -- set guid by TDB + +-- Spawn for Rotting Frost Giant in 25 man instances +DELETE FROM `creature` WHERE `id`=38494; +INSERT INTO `creature` +(`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) +VALUES +(@GUID,38494,631,10,1,0,0,-452.366,2354.51,191.242,0.778178,86400,0,0,1,0,0,2,0,0,0); + +-- Correct spawn mask for Rotting Frost Giant in 10 man instances (10/10 Heroic) +UPDATE `creature` SET `spawnmask`=5 WHERE `id`=38490; + +-- add a path to the creature +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@GUID,2087860,0,0,0,0, ''); -- cgit v1.2.3