diff options
| author | Aokromes <jipr@hotmail.com> | 2013-07-07 20:14:52 +0200 |
|---|---|---|
| committer | Aokromes <jipr@hotmail.com> | 2013-07-07 20:14:52 +0200 |
| commit | dc5936a296456e74d0589cd6a935eb9f94ee989c (patch) | |
| tree | 3a71671b4a819d00f26ba74cd67739812d45fc4f | |
| parent | 3561ab98bae1dc111530223aaf25f58bb3267677 (diff) | |
DB/Misc: Fix some runtime errors
Also spawns 2 missing doors on Old Hyjal, this doors needs to be scripted.
| -rw-r--r-- | sql/updates/world/2013_07_07_00_world_misc.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2013_07_07_00_world_misc.sql b/sql/updates/world/2013_07_07_00_world_misc.sql new file mode 100644 index 00000000000..3ad7dc08da1 --- /dev/null +++ b/sql/updates/world/2013_07_07_00_world_misc.sql @@ -0,0 +1,8 @@ +-- Fix some runtime errors +UPDATE `creature` SET `MovementType`=0 WHERE `guid`=142347,142368,142371,142376,142378,142379; +UPDATE `creature` SET `modelid`=0 WHERE `id` = 30169; +-- Add missing doors on old Hyjal +DELETE FROM `gameobject` WHERE `guid` IN (4658,4695); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(4658, 182060, 534, 1, 1, 4270.964, -4143.027, 870.7232, 6.020715, 0, 0, 0.8829476, -0.4694716, 7200, 255, 1), +(4695, 182061, 534, 1, 1, 4204.479, -4112.277, 877.9128, 4.985382, 0, 0, 0.8829476, -0.4694716, 7200, 255, 1); |