diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-01-13 20:03:17 +0100 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-01-23 16:41:25 +0100 |
| commit | d240ccb38c05e394b181a09d42f5e55d3222603a (patch) | |
| tree | 551d9cd70d51bf20b91388548cd7858392158b24 /sql | |
| parent | f5bd7b903ccd97a322af962400c0d5edd57edd16 (diff) | |
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.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2016_01_13_playerdamagereq.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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); |