diff options
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/updates/db_world/2025_09_27_03.sql (renamed from data/sql/updates/pending_db_world/rev_1758974081429490375.sql) | 1 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2025_09_28_00.sql | 10 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2025_09_28_01.sql | 6 |
3 files changed, 17 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1758974081429490375.sql b/data/sql/updates/db_world/2025_09_27_03.sql index 3eb168f55b..8e2166becc 100644 --- a/data/sql/updates/pending_db_world/rev_1758974081429490375.sql +++ b/data/sql/updates/db_world/2025_09_27_03.sql @@ -1,3 +1,4 @@ +-- DB update 2025_09_27_02 -> 2025_09_27_03 -- -- Fjorlin Frostbrow SAI DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 29732); diff --git a/data/sql/updates/db_world/2025_09_28_00.sql b/data/sql/updates/db_world/2025_09_28_00.sql new file mode 100644 index 0000000000..14d13d7b91 --- /dev/null +++ b/data/sql/updates/db_world/2025_09_28_00.sql @@ -0,0 +1,10 @@ +-- DB update 2025_09_27_03 -> 2025_09_28_00 +-- +DELETE FROM `areatrigger_scripts` WHERE `entry` = 4991; +INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES (4991, 'SmartTrigger'); + +DELETE FROM `smart_scripts` WHERE (`entryorguid` = 4991) AND (`source_type` = 2) AND (`id` IN (0)); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param6`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(4991, 2, 0, 0, 46, 0, 100, 0, 4991, 0, 0, 0, 0, 0, 223, 1, 0, 0, 0, 0, 0, 205, 2, 1, 0, 0, 0, 0, 0, 0, 'Areatrigger - On Trigger - Do Action ID 1'); + +UPDATE `creature_template` SET `unit_flags` = `unit_flags`|64|256, `flags_extra` = `flags_extra`|2147483648 WHERE `entry` IN (26693, 30807); diff --git a/data/sql/updates/db_world/2025_09_28_01.sql b/data/sql/updates/db_world/2025_09_28_01.sql new file mode 100644 index 0000000000..13f7b906f1 --- /dev/null +++ b/data/sql/updates/db_world/2025_09_28_01.sql @@ -0,0 +1,6 @@ +-- DB update 2025_09_28_00 -> 2025_09_28_01 +-- +DELETE FROM `spell_cooldown_overrides` WHERE `Id` IN (56570, 56585); +INSERT INTO `spell_cooldown_overrides` (`Id`, `RecoveryTime`, `CategoryRecoveryTime`, `StartRecoveryTime`, `StartRecoveryCategory`, `Comment`) VALUES +(56570, 200, 200, 0, 0, 'Jotunheim Rapid-Fire Harpoon: Rapid-Fire Harpoon'), +(56585, 30000, 30000, 0, 0, 'Jotunheim Rapid-Fire Harpoon: Energy Reserve'); |