From a74d233cccbefe7bee6fe8547ebba6808a2eeb31 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 9 May 2017 23:01:33 +0200
Subject: DB/Creature: Fallen Earthen Warrior

Closes #16559

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

(limited to 'sql')

diff --git a/sql/updates/world/master/2020_06_14_03_world_2017_05_09_00_world.sql b/sql/updates/world/master/2020_06_14_03_world_2017_05_09_00_world.sql
new file mode 100644
index 00000000000..6134763d355
--- /dev/null
+++ b/sql/updates/world/master/2020_06_14_03_world_2017_05_09_00_world.sql
@@ -0,0 +1,5 @@
+-- 
+UPDATE `creature_template` SET `unit_flags`=768, `RegenHealth`=0 WHERE `entry`=26335;
+DELETE FROM `creature_template_addon` WHERE `entry`=26335;
+INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`) VALUES (26335, 7, 1);
+UPDATE `creature` SET `curhealth`=1 WHERE `id`=26335;
-- 
cgit v1.2.3