diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2025-07-08 20:59:53 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-07-08 19:59:53 +0200 |
| commit | 3744d6bb2942db779613f5b3fb8320288fbb2e81 (patch) | |
| tree | 2c5ed9238a70688217c809f6ec5dae90a765de5d /sql | |
| parent | 5bace54513cebcb0d7f5e84a3c94a9e8654c195d (diff) | |
Scripts/Mechanar: Update scripts (#31127)
* Gyro-Kill - missing emote, timers, targets
* Iron-Hand - missing emote, timers, targets, one missing spell, update the way texts are handled
* Sepethrea - unique enum names, comments for scriptnames, update the way one text is handled
* Pathaleon - reorder spells, reorder hooks, implement one missing spell, change the way one spell is used
* Instance - remove unneeded placeholder
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2025_07_08_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_07_08_00_world.sql b/sql/updates/world/3.3.5/2025_07_08_00_world.sql new file mode 100644 index 00000000000..f664f6795d3 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_07_08_00_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `creature_text` WHERE `CreatureID` = 19218 AND `GroupID` = 4; +DELETE FROM `creature_text` WHERE `CreatureID` = 19710 AND `GroupID` = 5; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(19218,4,0,"You hear a faint unlocking sound...",16,0,100,0,0,0,19055,0,"Gatewatcher Gyro-Kill - On Death"), +(19710,5,0,"You hear a faint unlocking sound...",16,0,100,0,0,0,19055,0,"Gatewatcher Iron-Hand - On Death"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 35301; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,35301,0,0,31,0,3,21062,0,0,0,0,"","Group 0: Spell 'Suicide' (Effect 0) targets creature 'Nether Wraith'"); |