diff options
-rw-r--r-- | sql/custom/Ulduar/HallsOfLightning/01_boss_general_bjarngrim.sql | 30 | ||||
-rw-r--r-- | sql/updates/world/2012_01_08_18_world_achievement_criteria_data.sql | 5 | ||||
-rw-r--r-- | sql/updates/world/2012_01_08_18_world_creature_addon.sql | 3 | ||||
-rw-r--r-- | sql/updates/world/2012_01_08_18_world_spell_linked_spell.sql | 4 | ||||
-rw-r--r-- | sql/updates/world/2012_01_08_18_world_waypoint_data.sql | 8 | ||||
-rw-r--r-- | sql/updates/world/2012_01_08_18_world_waypoint_scripts.sql | 10 | ||||
-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 |