aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authortreeston <treeston.mmoc@gmail.com>2016-02-02 18:10:18 +0100
committertreeston <treeston.mmoc@gmail.com>2016-02-02 18:10:18 +0100
commitbac463c4815b0d7f7a1433a9409b9d4ba30ffc45 (patch)
tree8c1d8fd410555ef34d4c2ba21c793507fe921d6a /sql
parent60f8751c642282d1aae789ee37f654c452063780 (diff)
parentd240ccb38c05e394b181a09d42f5e55d3222603a (diff)
Merge branch '3.3.5-noplayerdamagereq' into 3.3.5-base (PR #16257)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2016_02_02_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_02_00_world.sql b/sql/updates/world/2016_02_02_00_world.sql
new file mode 100644
index 00000000000..ce561af3a61
--- /dev/null
+++ b/sql/updates/world/2016_02_02_00_world.sql
@@ -0,0 +1,5 @@
+-- Transition some creatures to use new CREATURE_FLAGS_EXTRA_NO_PLAYER_DAMAGE_REQ
+-- 27685/27686/27531: Target creatures for Quest 12416 ("Heated Battle")
+-- 24051/24063: Target creatures for Quest 11243 ("If Valgarde Falls...")
+-- 28034/28035/28036: Targets for Quest 12508 ("Mopping Up")
+UPDATE `creature_template` SET `flags_extra`=(`flags_extra`|2097152) WHERE `entry` IN (27685,27686,27531,24051,24063,28034,28035,28036);