Scripts/DrakTharonKeep: update Tharon'Ja

- update Tharon Ja to BossAI
- update one creature - cosmetic npc

Closes #10524

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/world/2013_08_16_00_world_drak_tharon_keep.sql b/sql/updates/world/2013_08_16_00_world_drak_tharon_keep.sql
new file mode 100644
index 00000000000..f05e14c1ca3
--- /dev/null
+++ b/sql/updates/world/2013_08_16_00_world_drak_tharon_keep.sql
@@ -0,0 +1,14 @@
+DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (49527, 49518, 49528, 49544, 49537, 49548);
+INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`) VALUES
+(49527, 49527, 59972),
+(49518, 49518, 59971),
+(49528, 49528, 59973),
+(49544, 49544, 59965),
+(49537, 49537, 59963),
+(49548, 49548, 59969);
+
+UPDATE `creature_template` SET `AIName` = 'NullAI' WHERE `entry` = 30413;
+
+DELETE FROM `spell_script_names` WHERE `spell_id` = 53242;
+INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES
+(53242, 'spell_tharon_ja_clear_gift_of_tharon_ja');