aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAqua Deus <95978183+aquadeus@users.noreply.github.com>2022-11-09 00:14:05 +0100
committerNaddley <NaddleyTC@gmail.com>2022-11-09 00:14:09 +0100
commitb0b5b0d397b53209b1e778225efc5db933f88d81 (patch)
tree6a6c3c0c64f2c0299b634fd69a120c358a721963
parentc705b4e8f2e4187c9505f2e7a98c2642051081ac (diff)
DB/Azsuna: Added missing Demon Ward
Closes #28472
-rw-r--r--sql/updates/world/master/2022_11_09_03_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_09_03_world.sql b/sql/updates/world/master/2022_11_09_03_world.sql
new file mode 100644
index 00000000000..2822e6190d5
--- /dev/null
+++ b/sql/updates/world/master/2022_11_09_03_world.sql
@@ -0,0 +1,5 @@
+SET @OGUID := 400420;
+
+DELETE FROM `gameobject` WHERE `guid` = @OGUID+0;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 240291, 1220, 7334, 7364, '0', 0, 0, -137.583328247070312, 6983.27978515625, 8.014510154724121093, 1.862035393714904785, 0, 0, 0.802227973937988281, 0.597017824649810791, 120, 255, 0, 46455); -- Demon Ward