aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-03-31 02:41:42 -0300
committerfunjoker <funjoker109@gmail.com>2020-04-24 17:18:51 +0200
commit04b94544ecb6ba43db0ff3ab9178c52e9ddd9f10 (patch)
treedf6a8bb62aea967271ec11f1895fb47f00db5b97
parent3d79b5bdeae1aae75c74de10ad5126f8f4eede8c (diff)
DB/Creature: fix regenerating health for vehicles in Wintergrasp and BGs
Closes #950 (cherry picked from commit b9d456fad1e39943502218b3fe065be36810e139)
-rw-r--r--sql/updates/world/master/2020_04_17_02_world_2017_03_31_00_world.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_04_17_02_world_2017_03_31_00_world.sql b/sql/updates/world/master/2020_04_17_02_world_2017_03_31_00_world.sql
new file mode 100644
index 00000000000..52ae3f95909
--- /dev/null
+++ b/sql/updates/world/master/2020_04_17_02_world_2017_03_31_00_world.sql
@@ -0,0 +1,23 @@
+UPDATE `creature_template` SET `RegenHealth`=0 WHERE `entry` IN (
+/* Wintergrasp */
+27881, -- Wintergrasp Catapult
+28094, -- Wintergrasp Demolisher
+28312, -- Wintergrasp Siege Engine
+28366, -- Wintergrasp Tower Cannon
+32627, -- Wintergrasp Siege Engine
+
+/* Strand of the Ancients */
+27894, 32795, -- Antipersonnel Cannon
+28781, 32796, -- Battleground Demolisher
+
+/* Isle of Conquest*/
+34775, 35415, -- Demolisher
+34776, 35431, -- Siege Engine
+34793, 35413, -- Catapult
+34802, 35419, -- Glaive Thrower
+34929, 35410, -- Alliance Gunship Cannon
+34935, 35427, -- Horde Gunship Cannon
+34944, 35429, -- Keep Cannon
+35069, 35433, -- Siege Engine
+35273, 35421 -- Glaive Thrower
+);