diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-07-12 17:27:08 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-07-12 17:27:08 +0200 |
| commit | a0c43da18865e065d011c6323e094f87db586c78 (patch) | |
| tree | 768ba51645b38d93d98f21d9b1bb879e3a5e0d11 | |
| parent | 1ecb8695d8bf2e69db869f49400f1be732a914c9 (diff) | |
DB/Creature: Fixing some spawns on The Frozen Halls entrance
By Killyana, closes #15014
| -rw-r--r-- | sql/updates/world/2015_07_12_07_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_12_07_world.sql b/sql/updates/world/2015_07_12_07_world.sql new file mode 100644 index 00000000000..0a74a4c018d --- /dev/null +++ b/sql/updates/world/2015_07_12_07_world.sql @@ -0,0 +1,14 @@ +-- +UPDATE `creature` SET `phaseMask`=1 WHERE `guid` IN (88806, 88792, 88802, 88788, 88777, 88778, 88804, 88790, 88800, 88786, 88803, 88789, 88797, 88783, 88796, 88782, 88799, 88785, 88784, 88798); +DELETE FROM `creature` WHERE `guid` IN (129856, 129855, 129857, 129858, 129864); + +SET @GUID := 6341; -- 3 free gob guid set by TC +DELETE FROM `gameobject` WHERE `guid`IN (@GUID, @GUID+1, @GUID+2); +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID+0,196871,571,1,1,8121.33,794.503,481.288,-1.797,0,0,-0.782608,0.622515,180,100,1), +(@GUID+1,196871,571,1,1,5644.50,2107.415,798.054,4.5902,0,0,-0.782608,0.622515,180,100,1), +(@GUID+2,196871,571,1,1,5660.98,2106.137,798.054,4.5902,0,0,-0.782608,0.622515,180,100,1); + +DELETE FROM `gameobject_addon` WHERE `guid` IN (164446,164447, 6135, 6134); +INSERT INTO `gameobject_addon` (`guid`, `invisibilityType`, `invisibilityValue`) VALUES +(@GUID+1,8,1000), (@GUID+2,8,1000), (6135,9,1000), (6134,9,1000); |