Script/Emerald Dragons: Fixed a couple of issues with emerald dragon world bosses and some cleanup.

Renamed one sql from yesterday

2 files changed, 16 insertions, 0 deletions

diff --git a/sql/updates/world/2012_11_13_00_world_trinity_string.sql b/sql/updates/world/2012_11_13_06_world_trinity_string.sql
index 2834a8f900b..2834a8f900b 100644
--- a/sql/updates/world/2012_11_13_00_world_trinity_string.sql
+++ b/sql/updates/world/2012_11_13_06_world_trinity_string.sql
diff --git a/sql/updates/world/2012_11_14_00_world_sai.sql b/sql/updates/world/2012_11_14_00_world_sai.sql
new file mode 100644
index 00000000000..98467fe4f3a
--- /dev/null
+++ b/sql/updates/world/2012_11_14_00_world_sai.sql
@@ -0,0 +1,16 @@
+SET @ENTRY_SPIRIT_SHADE := 15261;
+SET @ENTRY_LETHON := 14888;
+SET @SPELL_DARK_OFFERING := 24804;
+
+DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY_SPIRIT_SHADE;
+UPDATE `creature_template` SET `AIName`= '',`ScriptName`= 'npc_spirit_shade' WHERE `entry`=@ENTRY_SPIRIT_SHADE;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY_SPIRIT_SHADE AND `source_type`=0;
+
+DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY_SPIRIT_SHADE;
+INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`auras`) VALUES
+(@ENTRY_SPIRIT_SHADE,0,0,0, '24809');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@SPELL_DARK_OFFERING;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,1,@SPELL_DARK_OFFERING,0,0,31,0,3,@ENTRY_LETHON,0,0,0, '', 'Dark offering can only target Lethon');