aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSerpaa <Serpaa@users.noreply.github.com>2019-02-23 01:34:10 +0100
committerShauren <shauren.trinity@gmail.com>2021-11-23 23:18:40 +0100
commit0f334265c08a8b17202eef706bd175b786ff77c3 (patch)
tree55a8d8a493bd559c16b90deec0e59f7f2e84edac
parent2dda5fb477ab09ac7dc0e32bbd76f58a513347fa (diff)
DB/Creature: Dying Blood Elf
Closes #23063 (cherry picked from commit f86d4536516d43acee3bcb01a5ad59aa0e2cad36)
-rw-r--r--sql/updates/world/master/2021_11_23_21_world_2019_02_23_00_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_23_21_world_2019_02_23_00_world.sql b/sql/updates/world/master/2021_11_23_21_world_2019_02_23_00_world.sql
new file mode 100644
index 00000000000..170b729dbc5
--- /dev/null
+++ b/sql/updates/world/master/2021_11_23_21_world_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;