diff options
| author | Shauren <shauren.trinity@gmail.com> | 2012-04-07 17:00:05 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2012-04-07 17:00:05 +0200 |
| commit | c2c8b62282efda6f1732ed1aff4e75e273fba635 (patch) | |
| tree | 09b0464bb90d04f5290c15e93c44ee50bf4fb501 | |
| parent | 7dfebf57fc21fb41d0e70a8853d8359a42d90add (diff) | |
DB/Spawns: Added missing gameobject at Majordomo Executus area (damage on pile of coal)
| -rw-r--r-- | sql/updates/world/2012_04_07_00_world_gameobject.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_07_00_world_gameobject.sql b/sql/updates/world/2012_04_07_00_world_gameobject.sql new file mode 100644 index 00000000000..c63fc753d32 --- /dev/null +++ b/sql/updates/world/2012_04_07_00_world_gameobject.sql @@ -0,0 +1,5 @@ +UPDATE `gameobject_template` SET `faction`=54 WHERE `entry`=178164; +SET @GUID := 247; +DELETE FROM `gameobject` WHERE `guid`=@GUID; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID,178164,409,1,1,736.6528,-1176.32,-118.0967,-0.6806787,0,0,0,1,120,255,1); -- Hot Coal, damage |