DB/Misc: Cenarion Thicket

* Add strange aura to spell_area for Cenarion Thicket (someone had tried getting the druids to cast this on themselves in sai whoever did obviously did not read this AttributesEx3: 0x00000100 (SPELL_ATTR3_ONLY_TARGET_PLAYERS)
* However even when aura is active it still would not hit druids only the Broken Corpses, found that the druids should not even have this aura (proper auras are permament feign death + blue radiation), also in sniff unit_flags2 is 2049 (we had 2048) and dynamic flags 0 (we had 40)
* Also removing stun from unit flags, this makes no difference in game as npc gets those flags from feign death

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/world/2014_09_10_00_world_misc.sql b/sql/updates/world/2014_09_10_00_world_misc.sql
new file mode 100644
index 00000000000..0aaec188e09
--- /dev/null
+++ b/sql/updates/world/2014_09_10_00_world_misc.sql
@@ -0,0 +1,10 @@
+UPDATE `creature_template` SET `AIName`='' WHERE  `entry`=18490;
+DELETE FROM `smart_scripts` WHERE  `entryorguid`=18490 AND `source_type`=0;
+UPDATE `creature_template` SET `unit_flags`=536871680, `unit_flags2`=2049, `dynamicflags`=0 WHERE  `entry`=18490;
+UPDATE `creature_template_addon` SET `auras`='29266 32423' WHERE  `entry`=18490;
+
+DELETE FROM `spell_area` WHERE `spell`=32407;
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(32407, 3674, 0, 0, 0, 0, 2, 1, 64, 11); 
+
+UPDATE `smart_scripts` SET `action_param3`=1927115 WHERE  `entryorguid`=19271 AND `source_type`=0 AND `id`=13;