summaryrefslogtreecommitdiff
path: root/data
diff options
context:
space:
mode:
authorJelle Meeus <sogladev@gmail.com>2024-11-14 10:06:42 +0100
committerGitHub <noreply@github.com>2024-11-14 06:06:42 -0300
commit980b9246c8f207135feeed45e6a2a92ccea2a5e9 (patch)
treeb6ac95bbb7e35d39af30f1f82a9d6c2185f0745b /data
parent87fbdb7967094f19a00a3e5623115588c689cae6 (diff)
fix(Scripts/TheEye): Kael'thas advisors, refactor and RP (#20188)
refactor to use base advisor class refactor doaction extract phase enchanted weapons sql delete script kael_phase_two
Diffstat (limited to 'data')
-rw-r--r--data/sql/updates/pending_db_world/rev_1726878416572918109.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1726878416572918109.sql b/data/sql/updates/pending_db_world/rev_1726878416572918109.sql
new file mode 100644
index 0000000000..db88fba2de
--- /dev/null
+++ b/data/sql/updates/pending_db_world/rev_1726878416572918109.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `spell_script_names` WHERE `spell_id`=36450 AND `ScriptName`='spell_kaelthas_resurrection';
+DELETE FROM `spell_script_names` WHERE `spell_id`=36709 AND `ScriptName`='spell_kaelthas_kael_phase_two';
+-- fix entry from 19871 to Kael'thas for ID - 36709 Kael Phase Two
+UPDATE `conditions` SET `ConditionValue2` = 19622 WHERE (`SourceTypeOrReferenceId` = 13) AND (`SourceGroup` = 1) AND (`SourceEntry` = 36709) AND (`SourceId` = 0) AND (`ConditionTypeOrReference` = 31);