From 61ba1351e0da10219877ad9761ab161e3de51c74 Mon Sep 17 00:00:00 2001 From: Wyrserth Date: Mon, 1 Jul 2019 00:46:55 +0200 Subject: 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! --- sql/updates/world/3.3.5/2019_07_01_01_world.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/updates') 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), -- cgit v1.2.3