aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSerpaa <Serpaa@users.noreply.github.com>2019-02-23 01:34:10 +0100
committerKillyana <morphone1@gmail.com>2019-02-23 01:34:10 +0100
commitf86d4536516d43acee3bcb01a5ad59aa0e2cad36 (patch)
treeae9d0b2d6f069f9e686058e5d55ea116ed202760
parentc8dfab7761339152cc5ff380fbc7939d1128fddb (diff)
DB/Creature: Dying Blood Elf
Closes #23063
-rw-r--r--sql/updates/world/3.3.5/2019_02_23_00_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_02_23_00_world.sql b/sql/updates/world/3.3.5/2019_02_23_00_world.sql
new file mode 100644
index 00000000000..170b729dbc5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_02_23_00_world.sql
@@ -0,0 +1,3 @@
+-- Update Dying Blood Elf to 1 HP
+UPDATE `creature` SET `curhealth`=1 WHERE `id`=16601;
+UPDATE `creature_template` SET `RegenHealth`=0 WHERE `entry`=16601;