From 0341fb7c8dcd8183d688aacee5037a0c2916249b Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Mon, 29 Jul 2019 01:34:51 +0200
Subject: DB/Creature: Hellfire Training Dummy

(cherry picked from commit a50450265a54e51a6a41753423f4150bed903def)
---
 .../world/master/2021_12_17_24_world_2019_07_28_05_world.sql   | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 sql/updates/world/master/2021_12_17_24_world_2019_07_28_05_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2021_12_17_24_world_2019_07_28_05_world.sql b/sql/updates/world/master/2021_12_17_24_world_2019_07_28_05_world.sql
new file mode 100644
index 00000000000..cc942d8327e
--- /dev/null
+++ b/sql/updates/world/master/2021_12_17_24_world_2019_07_28_05_world.sql
@@ -0,0 +1,10 @@
+-- 
+UPDATE `creature_template` SET `unit_flags`=131328  WHERE `entry` = 17578;
+DELETE FROM `creature` WHERE `id`=17578 AND `guid` IN (86753, 113595, 113605, 113607, 113609, 113635);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+( 86753, 17578, 540, 3714, 0, '1,2', 0, 0, 0, 512.1739, 205.3514, 2.007787, 0.6981317, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17578 (Area: 0 - Difficulty: 0) (Auras: )
+(113595, 17578, 540, 3714, 0, '1,2', 0, 0, 0, 512.9296, 186.9605, 2.00013, 0.7679449, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17578 (Area: 0 - Difficulty: 0) (Auras: )
+(113605, 17578, 540, 3714, 0, '1,2', 0, 0, 0, 525.0672, 176.6558, 2.016024, 2.356194, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17578 (Area: 0 - Difficulty: 0) (Auras: )
+(113607, 17578, 540, 3714, 0, '1,2', 0, 0, 0, 508.1696, 131.2284, 2.018857, 1.22173, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17578 (Area: 0 - Difficulty: 0) (Auras: )
+(113609, 17578, 540, 3714, 0, '1,2', 0, 0, 0, 512.5972, 119.7658, 1.994586, 0.6632251, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17578 (Area: 0 - Difficulty: 0) (Auras: )
+(113635, 17578, 540, 3714, 0, '1,2', 0, 0, 0, 523.4672, 119.2777, 1.946144, 2.042035, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545); -- 17578 (Area: 0 - Difficulty: 0) (Auras: )
-- 
cgit v1.2.3