From 18aca970ce1042535945fca53e13fd7059aa2a50 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Fri, 12 Apr 2019 13:59:38 +0200 Subject: DB/Creature: Heroic Twilight Zealot Cherry pick of https://gitlab.com/trinitycore/TrinityCore_434/commit/70471d0c6c5ef22362d9e052342298a928c6cae1 --- sql/updates/world/master/2019_04_12_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/master/2019_04_12_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2019_04_12_00_world.sql b/sql/updates/world/master/2019_04_12_00_world.sql new file mode 100644 index 00000000000..d330e863a6e --- /dev/null +++ b/sql/updates/world/master/2019_04_12_00_world.sql @@ -0,0 +1,5 @@ +-- Twilight Zealot from Heroic Blackrock Caverns is missing +SET @GUID := 250021; +DELETE FROM `creature` WHERE `guid` = @GUID; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@GUID, 50284,645,"2",169,573.484,978.585,155.4369,1.570796,7200,0,0); -- Twilight Zealot Heroic -- cgit v1.2.3