aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-03-31 02:41:42 -0300
committerariel- <ariel-@users.noreply.github.com>2017-03-31 02:41:42 -0300
commitb9d456fad1e39943502218b3fe065be36810e139 (patch)
treef5bbd27b3f3a067759e12da1d5a4c82b8c31fd09
parent006e90339ec27b7d487c9a58dc8a212058a8174c (diff)
DB/Creature: fix regenerating health for vehicles in Wintergrasp and BGs
Closes #950
-rw-r--r--sql/updates/world/3.3.5/2017_03_31_00_world.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_03_31_00_world.sql b/sql/updates/world/3.3.5/2017_03_31_00_world.sql
new file mode 100644
index 00000000000..52ae3f95909
--- /dev/null
+++ b/sql/updates/world/3.3.5/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
+);