diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-06-25 21:37:48 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-06-25 21:37:48 +0200 |
| commit | cb100d64d55c7af65d79c15131e2ebe0bf1cda86 (patch) | |
| tree | 58bb23d2ee938b6fc1a19f708fd05bca312cd6aa | |
| parent | ca6228067507f19db230d415a1d088e5c0b5b808 (diff) | |
DB/Creature: use lower GUIDs for some creatures in Culling of Stratholme
| -rw-r--r-- | sql/updates/world/3.3.5/2019_06_25_02_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_25_02_world.sql b/sql/updates/world/3.3.5/2019_06_25_02_world.sql new file mode 100644 index 00000000000..7f25e5c32b7 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_25_02_world.sql @@ -0,0 +1,10 @@ +-- +SET @DAY = 86400; +SET @CGUID = 111214; -- creature GUIDs (4 creature); +DELETE FROM `creature` WHERE `guid` BETWEEN 700300 AND 700303; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+00 AND @CGUID+03; +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`movementtype`) VALUES +(@CGUID+00, 27915, 595, 3, 1, 1813.298, 1283.578, 142.3258, 3.878161, @DAY, 0, 0), +(@CGUID+01, 28340, 595, 3, 1, 2398.715, 1207.334, 134.1223, 5.270895, @DAY, 0, 0), +(@CGUID+02, 28340, 595, 3, 1, 2401.265, 1202.789, 134.1039, 1.466077, @DAY, 0, 0), +(@CGUID+03, 28341, 595, 3, 1, 2402.654, 1205.786, 134.1223, 2.897247, @DAY, 0, 0); |