From 04b94544ecb6ba43db0ff3ab9178c52e9ddd9f10 Mon Sep 17 00:00:00 2001 From: ariel- Date: Fri, 31 Mar 2017 02:41:42 -0300 Subject: DB/Creature: fix regenerating health for vehicles in Wintergrasp and BGs Closes #950 (cherry picked from commit b9d456fad1e39943502218b3fe065be36810e139) --- .../2020_04_17_02_world_2017_03_31_00_world.sql | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sql/updates/world/master/2020_04_17_02_world_2017_03_31_00_world.sql (limited to 'sql/updates') 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 +); -- cgit v1.2.3