diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-05-08 23:33:53 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-05-08 23:36:21 +0200 |
| commit | 2c48938c6daf9c45a32ee325aab17eef8cb4bb53 (patch) | |
| tree | 290fe67fd8d5ca88142118b5640b2fef0330a8be | |
| parent | 70dd848785f5a0251f8b544addcc5cd85c0f99c2 (diff) | |
DB/Instance: Fix Ahn''Kahet exit (portal/areatrigger)
| -rw-r--r-- | sql/updates/world/2014_05_07_00_world_misc.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2014_05_07_00_world_misc.sql b/sql/updates/world/2014_05_07_00_world_misc.sql new file mode 100644 index 00000000000..8f4971f771f --- /dev/null +++ b/sql/updates/world/2014_05_07_00_world_misc.sql @@ -0,0 +1,11 @@ +SET @OGUID := 6100; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+1; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 191849, 619, 3, 1, 523.5123, -301.1218, 68.84955, -1.570796, -0.004628658, 0.003181458, -0.7086, 0.705588, 7200, 255, 1), -- 191849 (Area: 4627) +(@OGUID+1, 191848, 619, 3, 1, 523.4318, -300.7111, 68.82808, -1.575045, 0, 0, -0.7071066, 0.7071069, 7200, 255, 1); -- 191848 (Area: 4627) + + +DELETE FROM `areatrigger_teleport` WHERE `id`=5235; +INSERT INTO `areatrigger_teleport` (`id`, `name`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES +(5235, 'Ahn''Kahet (exit)', 571, 3817.4,2032.82, 11.0133, 3.612832); |