aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/custom/Ulduar/HallsOfLightning/01_boss_general_bjarngrim.sql30
-rw-r--r--sql/updates/world/2012_01_08_18_world_achievement_criteria_data.sql5
-rw-r--r--sql/updates/world/2012_01_08_18_world_creature_addon.sql3
-rw-r--r--sql/updates/world/2012_01_08_18_world_spell_linked_spell.sql4
-rw-r--r--sql/updates/world/2012_01_08_18_world_waypoint_data.sql8
-rw-r--r--sql/updates/world/2012_01_08_18_world_waypoint_scripts.sql10
-rw-r--r--sql/updates/world/2012_01_08_19_world_achievement_criteria_data.sql (renamed from sql/custom/Ulduar/HallsOfLightning/02_boss_general_bjarngrim.sql)0
7 files changed, 30 insertions, 30 deletions
diff --git a/sql/custom/Ulduar/HallsOfLightning/01_boss_general_bjarngrim.sql b/sql/custom/Ulduar/HallsOfLightning/01_boss_general_bjarngrim.sql
deleted file mode 100644
index b4a77999612..00000000000
--- a/sql/custom/Ulduar/HallsOfLightning/01_boss_general_bjarngrim.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- HoL General Bjarngrim event Temporary Electrical Charge
--- Clear wrong aura
-UPDATE `creature_addon` SET `auras`='' WHERE `guid` = 126981;
-
--- add spell link for Temporary Electrical Charge
-DELETE FROM `spell_linked_spell` WHERE `spell_trigger`='-52098' AND `spell_effect`='52092';
-INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
-('-52098', '52092', '0', 'Charge Up - Temporary Electrical Charge');
-
--- Set 10 sec delay on platforms where boss gets Temporary Electrical Charge
-UPDATE `waypoint_data` SET `delay`=10000 WHERE `id`=1269810 AND `point` IN (2, 5, 11, 14);
-
--- Cast self Charge Up to get Temporary Electrical Charge
-DELETE FROM `waypoint_scripts` WHERE `id`=12698101;
-INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
-(12698101, 0, 14, 52092, 1, 0, 0, 0, 0, 0, 855),
-(12698101, 2, 15, 52098, 1, 0, 0, 0, 0, 0, 856);
-UPDATE `waypoint_data` SET `action`=12698101 WHERE `id`=1269810 AND `point` IN (5, 14);
-
--- Remove aura Temporary Electrical Charge
-DELETE FROM `waypoint_scripts` WHERE `id`=12698102;
-INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
-(12698102, 0, 14, 52092, 1, 0, 0, 0, 0, 0, 857);
-UPDATE `waypoint_data` SET `action`=12698102 WHERE `id`=1269810 AND `point` IN (2, 3, 4, 11, 12, 13);
-
--- Lightning Struck achievement
-DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=6835;
-DELETE FROM `achievement_criteria_data` WHERE `type`=11 AND `criteria_id`=6835;
-INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
-(6835, 11, 0, 0, 'achievement_lightning_struck');
diff --git a/sql/updates/world/2012_01_08_18_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_08_18_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..e20fd1c55bb
--- /dev/null
+++ b/sql/updates/world/2012_01_08_18_world_achievement_criteria_data.sql
@@ -0,0 +1,5 @@
+-- Lightning Struck achievement
+DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=6835;
+DELETE FROM `achievement_criteria_data` WHERE `type`=11 AND `criteria_id`=6835;
+INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
+(6835, 11, 0, 0, 'achievement_lightning_struck');
diff --git a/sql/updates/world/2012_01_08_18_world_creature_addon.sql b/sql/updates/world/2012_01_08_18_world_creature_addon.sql
new file mode 100644
index 00000000000..7570cc14afe
--- /dev/null
+++ b/sql/updates/world/2012_01_08_18_world_creature_addon.sql
@@ -0,0 +1,3 @@
+-- HoL General Bjarngrim event Temporary Electrical Charge
+-- Clear wrong aura
+UPDATE `creature_addon` SET `auras`='' WHERE `guid` = 126981;
diff --git a/sql/updates/world/2012_01_08_18_world_spell_linked_spell.sql b/sql/updates/world/2012_01_08_18_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..927c6c0c663
--- /dev/null
+++ b/sql/updates/world/2012_01_08_18_world_spell_linked_spell.sql
@@ -0,0 +1,4 @@
+-- add spell link for Temporary Electrical Charge
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`='-52098' AND `spell_effect`='52092';
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+('-52098', '52092', '0', 'Charge Up - Temporary Electrical Charge');
diff --git a/sql/updates/world/2012_01_08_18_world_waypoint_data.sql b/sql/updates/world/2012_01_08_18_world_waypoint_data.sql
new file mode 100644
index 00000000000..e443f7c055a
--- /dev/null
+++ b/sql/updates/world/2012_01_08_18_world_waypoint_data.sql
@@ -0,0 +1,8 @@
+-- Set 10 sec delay on platforms where boss gets Temporary Electrical Charge
+UPDATE `waypoint_data` SET `delay`=10000 WHERE `id`=1269810 AND `point` IN (2, 5, 11, 14);
+
+-- Cast self Charge Up to get Temporary Electrical Charge
+UPDATE `waypoint_data` SET `action`=12698101 WHERE `id`=1269810 AND `point` IN (5, 14);
+
+-- Remove aura Temporary Electrical Charge
+UPDATE `waypoint_data` SET `action`=12698102 WHERE `id`=1269810 AND `point` IN (2, 3, 4, 11, 12, 13);
diff --git a/sql/updates/world/2012_01_08_18_world_waypoint_scripts.sql b/sql/updates/world/2012_01_08_18_world_waypoint_scripts.sql
new file mode 100644
index 00000000000..f6c147155ea
--- /dev/null
+++ b/sql/updates/world/2012_01_08_18_world_waypoint_scripts.sql
@@ -0,0 +1,10 @@
+-- Cast self Charge Up to get Temporary Electrical Charge
+DELETE FROM `waypoint_scripts` WHERE `id`=12698101;
+INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
+(12698101, 0, 14, 52092, 1, 0, 0, 0, 0, 0, 855),
+(12698101, 2, 15, 52098, 1, 0, 0, 0, 0, 0, 856);
+
+-- Remove aura Temporary Electrical Charge
+DELETE FROM `waypoint_scripts` WHERE `id`=12698102;
+INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
+(12698102, 0, 14, 52092, 1, 0, 0, 0, 0, 0, 857);
diff --git a/sql/custom/Ulduar/HallsOfLightning/02_boss_general_bjarngrim.sql b/sql/updates/world/2012_01_08_19_world_achievement_criteria_data.sql
index 6cd1a367e81..6cd1a367e81 100644
--- a/sql/custom/Ulduar/HallsOfLightning/02_boss_general_bjarngrim.sql
+++ b/sql/updates/world/2012_01_08_19_world_achievement_criteria_data.sql