diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-02-09 04:11:20 +0100 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-02-09 04:11:20 +0100 |
| commit | 93718e5b3d504c2a64acf5b04cd0cdc9aac74624 (patch) | |
| tree | 8731b1cfb7bd7aaa2f87c8b0b5ed4418b89c688b | |
| parent | 9b796ddf0b82f81425a5b843695c47d1d9a47e6e (diff) | |
DB/Creature: Add CREATURE_FLAGS_EXTRA_NO_PLAYER_DAMAGE_REQ to Garhal (30147), adjust respawn time to 60 seconds. Fixes & closes #16084.
| -rw-r--r-- | sql/updates/world/2016_02_09_00_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_09_00_world.sql b/sql/updates/world/2016_02_09_00_world.sql new file mode 100644 index 00000000000..c93a1d8fed1 --- /dev/null +++ b/sql/updates/world/2016_02_09_00_world.sql @@ -0,0 +1,3 @@ +-- Garhal (Examples To Be Made quest target): Add CREATURE_FLAG_EXTRA_NO_PLAYER_DAMAGE_REQ, spawn time = 60 seconds; closes #16084 +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|2097152 WHERE `entry`=30147; +UPDATE `creature` SET `spawntimesecs`=60 WHERE `guid`=114369; |