Scripts/Spells: Migrate Some Scripted Spells to Scripts (#23185)

* Migrate spells to scripts

* Simplify code

* I need to sleep

* Update chapter1.cpp

* Use actual damage

* No need in null check here

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/9999_99_99_99_world.sql b/sql/updates/world/3.3.5/9999_99_99_99_world.sql
new file mode 100644
index 00000000000..6056582868d
--- /dev/null
+++ b/sql/updates/world/3.3.5/9999_99_99_99_world.sql
@@ -0,0 +1,20 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_death_knight_initiate_visual', 'spell_dk_glyph_of_scourge_strike_script', 'spell_item_mirrens_drinking_hat', 'spell_item_goblin_weather_machine', 'spell_gen_5000_gold', 'spell_sha_stoneclaw_totem', 'spell_gen_remove_impairing_auras', 'spell_q1846_bending_shinbone');
+INSERT INTO `spell_script_names` VALUES
+(51519, 'spell_death_knight_initiate_visual'),
+(69961, 'spell_dk_glyph_of_scourge_strike_script'),
+(29830, 'spell_item_mirrens_drinking_hat'),
+(46203, 'spell_item_goblin_weather_machine'),
+(46642, 'spell_gen_5000_gold'),
+(55328, 'spell_sha_stoneclaw_totem'),
+(55329, 'spell_sha_stoneclaw_totem'),
+(55330, 'spell_sha_stoneclaw_totem'),
+(55332, 'spell_sha_stoneclaw_totem'),
+(55333, 'spell_sha_stoneclaw_totem'),
+(55335, 'spell_sha_stoneclaw_totem'),
+(55278, 'spell_sha_stoneclaw_totem'),
+(58589, 'spell_sha_stoneclaw_totem'),
+(58590, 'spell_sha_stoneclaw_totem'),
+(58591, 'spell_sha_stoneclaw_totem'),
+(20589, 'spell_gen_remove_impairing_auras'),
+(30918, 'spell_gen_remove_impairing_auras'),
+(8856, 'spell_q1846_bending_shinbone');