From 1d843364e6cc8ef92ab9dec31e48a7595a10b7ca Mon Sep 17 00:00:00 2001
From: treeston <treeston.mmoc@gmail.com>
Date: Tue, 9 Feb 2016 04:11:20 +0100
Subject: 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)
---
 sql/updates/world/2016_04_02_47_world_2016_02_09_00_world.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/2016_04_02_47_world_2016_02_09_00_world.sql

(limited to 'sql')

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;
-- 
cgit v1.2.3