diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-05-31 06:21:10 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-05-31 06:21:10 +0200 |
| commit | a351d9d4c524d400c26a4e52bfa02901fec4d540 (patch) | |
| tree | 0281c9e44719ed8192fbd80bf13c000797acbb3b | |
| parent | 45c579eb9d1c4c328a2556e22cc01ae9adbf2757 (diff) | |
DB/Creature: Correct spells order for Broken-down Shredder
closes #30010 by CraftedRO
| -rw-r--r-- | sql/updates/world/3.3.5/2024_05_31_00_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_05_31_00_world.sql b/sql/updates/world/3.3.5/2024_05_31_00_world.sql new file mode 100644 index 00000000000..db55621a779 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_05_31_00_world.sql @@ -0,0 +1,7 @@ +-- Correct spells order for Broken-down Shredder +DELETE FROM `creature_template_spell` WHERE `CreatureID` = 27354 AND `Index` IN (0,1,2); +INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES +(27354, 0, 48548, 54847), +(27354, 1, 48558, 54847), +(27354, 2, 48604, 54847); +UPDATE `creature_template_spell` SET `VerifiedBuild`=54847 WHERE `CreatureID`=27354 AND `Spell`=48610 AND `Index`=4; |