From 40c6e7bcdbff46f355af5b43bbf5ca0fd86e6777 Mon Sep 17 00:00:00 2001
From: Manuel Carrasco <manue.l@live.com.ar>
Date: Mon, 23 Jan 2012 20:03:06 -0300
Subject: Scripts/UK: Re-written Prince Keleseth script.

* Corrected spawns amount, only 4 Skeletons must be spawned not 5.
* Adjusted timers, now they are blizzlike.
    * This also includes skeleton resurrection timer.
* Removed hacky code that was replacing spells (they are casted now).
* Implemented "On The Rocks" achievement.

Thanks to Subv for help.
---
 sql/updates/world/2012_01_23_01_world_creature_script_names.sql  | 2 ++
 sql/updates/world/2012_01_23_02_world_disables.sql               | 1 +
 .../world/2012_01_23_03_world_achievement_criteria_data.sql      | 3 +++
 sql/updates/world/2012_01_23_04_world_creature_text.sql          | 9 +++++++++
 sql/updates/world/2012_01_23_05_world_spell_script_names.sql     | 3 +++
 5 files changed, 18 insertions(+)
 create mode 100644 sql/updates/world/2012_01_23_01_world_creature_script_names.sql
 create mode 100644 sql/updates/world/2012_01_23_02_world_disables.sql
 create mode 100644 sql/updates/world/2012_01_23_03_world_achievement_criteria_data.sql
 create mode 100644 sql/updates/world/2012_01_23_04_world_creature_text.sql
 create mode 100644 sql/updates/world/2012_01_23_05_world_spell_script_names.sql

(limited to 'sql')

diff --git a/sql/updates/world/2012_01_23_01_world_creature_script_names.sql b/sql/updates/world/2012_01_23_01_world_creature_script_names.sql
new file mode 100644
index 00000000000..d7c2b22725e
--- /dev/null
+++ b/sql/updates/world/2012_01_23_01_world_creature_script_names.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `ScriptName`='npc_frost_tomb' WHERE `entry`=23965;
+UPDATE `creature_template` SET `ScriptName`='npc_vrykul_skeleton' WHERE `entry`=23970;
diff --git a/sql/updates/world/2012_01_23_02_world_disables.sql b/sql/updates/world/2012_01_23_02_world_disables.sql
new file mode 100644
index 00000000000..0a1be704dac
--- /dev/null
+++ b/sql/updates/world/2012_01_23_02_world_disables.sql
@@ -0,0 +1 @@
+DELETE FROM `disables` WHERE `entry`=7231 AND `sourceType`=4;
diff --git a/sql/updates/world/2012_01_23_03_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_23_03_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..4d1f4536455
--- /dev/null
+++ b/sql/updates/world/2012_01_23_03_world_achievement_criteria_data.sql
@@ -0,0 +1,3 @@
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7231;
+INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `ScriptName`) VALUES 
+(7231,11,'achievement_on_the_rocks');
diff --git a/sql/updates/world/2012_01_23_04_world_creature_text.sql b/sql/updates/world/2012_01_23_04_world_creature_text.sql
new file mode 100644
index 00000000000..f505a86b16c
--- /dev/null
+++ b/sql/updates/world/2012_01_23_04_world_creature_text.sql
@@ -0,0 +1,9 @@
+DELETE FROM `script_texts` WHERE `entry` IN (-1574000,-1574001,-1574002,-1574003,-1574004);
+
+DELETE FROM `creature_text` WHERE `entry`=23953;
+INSERT INTO `creature_text` (`entry`, `groupid`, `text`, `sound`, `emote`, `type`) VALUES 
+(23953,1,'Your blood is mine!',13221,7,14),
+(23953,2,'Aranal, ledel! Their fate shall be yours!',13224,0,14),
+(23953,3,'Not so fast.',13222,0,14),
+(23953,4,'%s casts Frost Tomb on $n.',0,0,41),
+(23953,5,'I join... the night.',13225,0,14);
diff --git a/sql/updates/world/2012_01_23_05_world_spell_script_names.sql b/sql/updates/world/2012_01_23_05_world_spell_script_names.sql
new file mode 100644
index 00000000000..6f3b4907e5b
--- /dev/null
+++ b/sql/updates/world/2012_01_23_05_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=48400;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(48400,'spell_frost_tomb');
-- 
cgit v1.2.3