DB/Misc:

- Quest Nessa Shadowsong and following steps are only available to Night Elves.
- Fix offer reward text for quest Elanaria.
- NPC Webwood Spider should be neutral.
- Small cosmetic fix for quest Force Commander Danath's end event.
- Prevent NPCs Gnarlpine Shaman and Elder Timberling from spamming healing spells.
(cherry picked from commit 04618be4279560fd05c8f7ce48895560f2ff39de)

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_09_05_12_world_2016_10_10_02_world_335.sql b/sql/updates/world/master/2017_09_05_12_world_2016_10_10_02_world_335.sql
new file mode 100644
index 00000000000..2e2f80a2607
--- /dev/null
+++ b/sql/updates/world/master/2017_09_05_12_world_2016_10_10_02_world_335.sql
@@ -0,0 +1,11 @@
+--
+-- UPDATE `quest_template` SET `AllowableRaces`=8 WHERE `ID` IN (6344, 6341, 6342, 6343);
+
+UPDATE `quest_offer_reward` SET `RewardText`="I bid you greetings, $N. Your name rings loudly in Darnassus, for you show promise. But we shall soon see if you possess the strength of will to follow the path of the $C." WHERE `ID`=1684;
+
+UPDATE `creature_template` SET `faction`=189 WHERE `entry`=1986;
+
+UPDATE `smart_scripts` SET `action_param2`=2 WHERE `entryorguid`=16819 AND `id`=1;
+
+UPDATE `smart_scripts` SET `event_param2`=30000, `event_param4`=30000 WHERE `entryorguid`=2030 AND `id`=2;
+UPDATE `smart_scripts` SET `event_param2`=30000, `event_param4`=30000 WHERE `entryorguid`=2009 AND `id`=0;