diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2025-05-17 13:57:22 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-05-17 12:57:22 +0200 |
| commit | f7f64edbbe03f0ee30c00e78cbef59222acfb066 (patch) | |
| tree | 4f3fa87a5314d861b8a0e38c0873fffe734150aa /sql/updates | |
| parent | 2f331b2fe2699296030312cbba218499daef9ecc (diff) | |
Scripts/SteamVault: Modernize scripts (#30948)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/3.3.5/2025_05_17_00_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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; |