Scripts/Spells: removed broken Steady Shot energize spell_linked_spell fix and properly fix it via spell script

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_11_29_00_world.sql b/sql/updates/world/cata_classic/2024_11_29_00_world.sql
new file mode 100644
index 00000000000..3e5e0c06a8d
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_11_29_00_world.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`= 'spell_hun_steady_shot';
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 56641;
+
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(56641, 'spell_hun_steady_shot');