aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorWyrserth <wyrserth@protonmail.com>2019-07-01 00:46:55 +0200
committerWyrserth <wyrserth@protonmail.com>2019-07-01 00:46:55 +0200
commit61ba1351e0da10219877ad9761ab161e3de51c74 (patch)
tree29d20b8545ab2e9a66fc517535e43ae1192581d7 /sql/updates
parentce3820031d4185d4124fa062baa99619e483a84c (diff)
Core/Quest: if a quest rewards a title, show it in the offer reward screen too.
Also fix delete query in fa0fc13fd06e1af3dc6cb2ea611c4012660bfbdb, thanks Aokromes for noticing!
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2019_07_01_01_world.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_01_01_world.sql b/sql/updates/world/3.3.5/2019_07_01_01_world.sql
index d7c4ea151e9..661f1820194 100644
--- a/sql/updates/world/3.3.5/2019_07_01_01_world.sql
+++ b/sql/updates/world/3.3.5/2019_07_01_01_world.sql
@@ -1,7 +1,7 @@
--
SET @GUID := 111225;
-DELETE FROM `creature` WHERE `guid` IN (@GUID, @GUID+1, @GUID+2);
+DELETE FROM `creature` WHERE `guid` IN (@GUID, @GUID+1, @GUID+2, @GUID+3);
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
(@GUID , 15655, 530, 0, 0, 1, 1, 0, 0, 9301.48, -6958.67, 8.01523, 6.19155, 60, 0, 0, 120, 0, 0, 0, 0, 0, "", 0),
(@GUID+1, 15655, 530, 0, 0, 1, 1, 0, 0, 9298.69, -6960.92, 7.68314, 6.19155, 60, 0, 0, 120, 0, 0, 0, 0, 0, "", 0),