diff options
| author | Rushor <PBienati@web.de> | 2015-07-24 14:30:12 +0200 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2015-07-24 14:30:12 +0200 |
| commit | 5a0bf31cb6e274590ad2bd086b52b79991582b34 (patch) | |
| tree | ef23f7c6092ec8ac04be872e8283325a8e7f72de /sql | |
| parent | 7c9095592914efe5a10509325270ca9723694781 (diff) | |
DB/Misc: Fixup Import
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_07_24_04_world_2015_07_19_05.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2015_07_24_06_world.sql | 3 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/updates/world/2015_07_24_04_world_2015_07_19_05.sql b/sql/updates/world/2015_07_24_04_world_2015_07_19_05.sql index 2d174d02b4d..6ee261342b9 100644 --- a/sql/updates/world/2015_07_24_04_world_2015_07_19_05.sql +++ b/sql/updates/world/2015_07_24_04_world_2015_07_19_05.sql @@ -3,7 +3,7 @@ -- Spawn Borderzone to Zul'Drak SET @CGUID := 52283; DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+39; -INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES (@CGUID+0, 26965, 571, 1, 1, 4851.188, -1375.803, 168.173, 2.495821, 120, 0, 0), -- 26965 (Area: 65) (@CGUID+1, 26965, 571, 1, 1, 4857.981, -1376.318, 168.6309, 2.670354, 120, 0, 0), -- 26965 (Area: 65) (@CGUID+2, 26942, 571, 1, 1, 4835.941, -1356.574, 168.1345, 3.508112, 120, 0, 0), -- 26942 (Area: 65) diff --git a/sql/updates/world/2015_07_24_06_world.sql b/sql/updates/world/2015_07_24_06_world.sql new file mode 100644 index 00000000000..cb2f69e7dfa --- /dev/null +++ b/sql/updates/world/2015_07_24_06_world.sql @@ -0,0 +1,3 @@ +-- +SET @CGUID := 52283; +UPDATE `creature` SET `PhaseId`=0 WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+39; |