From 870a76ad10af5a881a25d2d2cfa6ead9a3d56c5a Mon Sep 17 00:00:00 2001 From: treeston Date: Wed, 13 Jan 2016 20:03:17 +0100 Subject: DB/Creature: Add a new extra_flag CREATURE_FLAG_EXTRA_NO_PLAYER_DAMAGE_REQ (0x00200000) that awards players credit for killing the creature even if less than 50% of damage was dealt by players. This can be used to fix quests such as "Heated Battle" or "If Valgarde Falls..." that are currently very hard to complete at the appropriate level due to "friendly" NPCs killing off the required targets too quickly for players to get 50% of damage in. (cherry picked from commit d240ccb38c05e394b181a09d42f5e55d3222603a) --- sql/updates/world/2016_01_13_playerdamagereq.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2016_01_13_playerdamagereq.sql (limited to 'sql') diff --git a/sql/updates/world/2016_01_13_playerdamagereq.sql b/sql/updates/world/2016_01_13_playerdamagereq.sql new file mode 100644 index 00000000000..ce561af3a61 --- /dev/null +++ b/sql/updates/world/2016_01_13_playerdamagereq.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); -- cgit v1.2.3