From f7f64edbbe03f0ee30c00e78cbef59222acfb066 Mon Sep 17 00:00:00 2001 From: offl <11556157+offl@users.noreply.github.com> Date: Sat, 17 May 2025 13:57:22 +0300 Subject: Scripts/SteamVault: Modernize scripts (#30948) --- sql/updates/world/3.3.5/2025_05_17_00_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/3.3.5/2025_05_17_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2025_05_17_00_world.sql b/sql/updates/world/3.3.5/2025_05_17_00_world.sql new file mode 100644 index 00000000000..e2287bb182d --- /dev/null +++ b/sql/updates/world/3.3.5/2025_05_17_00_world.sql @@ -0,0 +1,12 @@ +-- +DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_mekgineer_steamrigger_summon_gnomes'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(31531, 'spell_mekgineer_steamrigger_summon_gnomes'); + +DELETE FROM `spell_target_position` WHERE `ID` IN (31528,31529,31530); +INSERT INTO `spell_target_position` (`ID`,`EffectIndex`,`MapID`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`VerifiedBuild`) VALUES +(31528,0,545,-315.56015,-164.80557,-7.7555575,1.251415848731994628,0), +(31529,0,545,-347.00745,-160.84607,-7.7555575,0.530080020427703857,0), +(31530,0,545,-329.94170,-113.43509,-7.7555575,5.497043132781982421,0); + +UPDATE `creature_text` SET `Text` = "Tune 'em up good, boys!", `BroadcastTextId` = 14602 WHERE `CreatureID` = 17796 AND `GroupID` = 0 AND `ID` = 0; -- cgit v1.2.3