From 75b4b0594f34fb29318ae78725178c54486cf135 Mon Sep 17 00:00:00 2001
From: snakeice <snakeice@gmail.com>
Date: Tue, 6 Aug 2013 19:05:47 +0100
Subject: Scripts/HoR: Major changes:

- Fixed Intro timers
- Fixed mobs aggro
- Fixed General's shield trow
- Added Jaina / Sylvannas / Lich King escape event

Closes #10303
Closes #2505
Closes #9865
---
 sql/updates/world/2013_08_16_01_world_hor.sql | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 sql/updates/world/2013_08_16_01_world_hor.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2013_08_16_01_world_hor.sql b/sql/updates/world/2013_08_16_01_world_hor.sql
new file mode 100644
index 00000000000..c9b8ccf8266
--- /dev/null
+++ b/sql/updates/world/2013_08_16_01_world_hor.sql
@@ -0,0 +1,24 @@
+-- areatrigger for the shadow throne
+DELETE FROM `areatrigger_scripts` WHERE `entry` = 5605;
+INSERT INTO `areatrigger_scripts` (`entry`,`scriptname`) VALUES
+(5605, 'at_shadow_throne');
+
+-- jaina's equipment
+DELETE FROM `creature_equip_template` WHERE `entry` = 36955 AND `id` = 1;
+INSERT INTO `creature_equip_template` (`entry`, `id`, `itementry1`, `itementry2`,`itementry3`) VALUES
+(36955, 1, 2177, 12869, 0);
+
+-- jaina's gossip menu (the same one FROM sylvanas)
+UPDATE `creature_template` SET `gossip_menu_id` = 10909 WHERE `entry` = 36955;
+
+-- jaina's scriptai part 2
+UPDATE `creature_template` SET `ScriptName` = 'npc_jaina_or_sylvanas_escape_hor' WHERE `entry` in (36955, 37554);
+
+-- Raging Ghoul scriptai
+UPDATE `creature_template` SET `ScriptName` = 'npc_raging_ghoul' WHERE `entry` = 36940;
+
+-- Risen Witch Doctor scriptai
+UPDATE `creature_template` SET `ScriptName` = 'npc_risen_witch_doctor' WHERE `entry` = 36941;
+
+-- LumberINg Abomination scriptai
+UPDATE `creature_template` SET `ScriptName` = 'npc_lumbering_abomination' WHERE `entry` = 37069;
-- 
cgit v1.2.3