From d361de0c271a40287d79a60a0928bcd3e6718c44 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 22 Aug 2017 17:48:07 +0200
Subject: DB/Creature: Fix Risen Archmage positions on Valithria 25 modes

(cherry picked from commit e56c4f40d402651a05e3df1337e143b610758c1d)
---
 .../world/master/2020_08_23_06_world_2017_08_22_00_world.sql        | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/updates/world/master/2020_08_23_06_world_2017_08_22_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2020_08_23_06_world_2017_08_22_00_world.sql b/sql/updates/world/master/2020_08_23_06_world_2017_08_22_00_world.sql
new file mode 100644
index 00000000000..50d131c1427
--- /dev/null
+++ b/sql/updates/world/master/2020_08_23_06_world_2017_08_22_00_world.sql
@@ -0,0 +1,6 @@
+-- 
+UPDATE `creature` SET `spawnDifficulties`='3,5' WHERE `guid` IN (137751, 137750);
+DELETE FROM `creature` WHERE `guid` IN (48306,48307);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(48306, 37868, 631, 0, 0, '4,6', 0, 0, 0, 0, 0, 4185.2851, 2464.014, 364.8696, 0.798137, 604800, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(48307, 37868, 631, 0, 0, '4,6', 0, 0, 0, 0, 0, 4183.7006, 2503.9326, 364.879, 5.508426, 604800, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- 
cgit v1.2.3