aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authortreeston <treeston.mmoc@gmail.com>2016-02-09 04:11:20 +0100
committerShauren <shauren.trinity@gmail.com>2016-04-02 20:47:01 +0200
commit1d843364e6cc8ef92ab9dec31e48a7595a10b7ca (patch)
tree36d827fcdb5806402f277f70729776dd5b876447
parent60ab64c3f9b72f2d5228620e7693a45c9c6d081c (diff)
DB/Creature: Add CREATURE_FLAGS_EXTRA_NO_PLAYER_DAMAGE_REQ to Garhal (30147), adjust respawn time to 60 seconds. Fixes & closes #16084.
(cherry picked from commit 93718e5b3d504c2a64acf5b04cd0cdc9aac74624)
-rw-r--r--sql/updates/world/2016_04_02_47_world_2016_02_09_00_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_02_47_world_2016_02_09_00_world.sql b/sql/updates/world/2016_04_02_47_world_2016_02_09_00_world.sql
new file mode 100644
index 00000000000..c93a1d8fed1
--- /dev/null
+++ b/sql/updates/world/2016_04_02_47_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;