Scripts/Spells: Get rid of some database spell scripts (#30925)

1 files changed, 33 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2025_06_10_05_world.sql b/sql/updates/world/3.3.5/2025_06_10_05_world.sql
new file mode 100644
index 00000000000..4ca2e6d0e3c
--- /dev/null
+++ b/sql/updates/world/3.3.5/2025_06_10_05_world.sql
@@ -0,0 +1,33 @@
+--
+DELETE FROM `spell_scripts` WHERE `id` IN (55770,36153);
+DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_cast_caster_to_target';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(55770, 'spell_gen_cast_caster_to_target'),
+(36153, 'spell_gen_cast_caster_to_target');
+
+DELETE FROM `spell_scripts` WHERE `id` IN (44876,48724,48726,48728,48730,54640);
+DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_cast_target_to_target';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(44876, 'spell_gen_cast_target_to_target'),
+(48724, 'spell_gen_cast_target_to_target'),
+(48726, 'spell_gen_cast_target_to_target'),
+(48728, 'spell_gen_cast_target_to_target'),
+(48730, 'spell_gen_cast_target_to_target'),
+(54640, 'spell_gen_cast_target_to_target');
+UPDATE `smart_scripts` SET `action_type` = 11, `action_param2` = 2 WHERE `entryorguid` IN (27234,27235,27236,27237) AND `id` = 1;
+UPDATE `conditions` SET `ConditionTypeOrReference`=32,`ConditionValue1`=144,`ConditionValue2`=0 WHERE `SourceEntry` IN (48724,48726,48728,48730) AND `SourceTypeOrReferenceId` = 13;
+
+DELETE FROM `spell_scripts` WHERE `id` IN (28698);
+DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_dreaming_glory';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(28698, 'spell_gen_dreaming_glory');
+
+DELETE FROM `spell_scripts` WHERE `id` = 55048;
+DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_storm_peaks_free_brunnhildar_prisoner';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(55048, 'spell_storm_peaks_free_brunnhildar_prisoner');
+
+DELETE FROM `spell_scripts` WHERE `id` = 32580;
+DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_bem_wicked_strong_fetish';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(32580, 'spell_bem_wicked_strong_fetish');