diff options
| author | mrquickfx <none@none> | 2011-03-21 22:16:58 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-03-21 22:16:58 +0100 |
| commit | f4b202e49486ac3c87eac5d50650662c011816e2 (patch) | |
| tree | 7c0f7694622199b4b95a8c6e24e2e21ba5707fc3 /sql/updates | |
| parent | 1d62d30b0b62bbc2404aafa4020e8e0ab5505ece (diff) | |
DB/Creature: Rotting Frost Giant spawn for 25 man instances
fixes #797
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_03_21_6_world_creature.sql | 16 |
1 files changed, 16 insertions, 0 deletions
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, ''); |