From 90dcb2a4480ed9aa52a29d7b5e693738bff324d7 Mon Sep 17 00:00:00 2001
From: MitchesD <majklprofik@seznam.cz>
Date: Fri, 16 Aug 2013 14:34:42 +0200
Subject: Scripts/DrakTharonKeep: update Tharon'Ja - update Tharon Ja to BossAI
 - update one creature - cosmetic npc

Closes #10524
---
 sql/updates/world/2013_08_16_00_world_drak_tharon_keep.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql/updates/world/2013_08_16_00_world_drak_tharon_keep.sql

(limited to 'sql/updates')

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