47 lines
1.8 KiB
SQL
47 lines
1.8 KiB
SQL
------------------------------------
|
|
-- Rhapsodies of Vana'diel Spell SQL Adjustments
|
|
-- This module reverts relevant spells to their pre-RoV values
|
|
------------------------------------
|
|
|
|
------------------------------------
|
|
-- Enhancing Magic
|
|
-- Source: https://forum.square-enix.com/ffxi/threads/46531
|
|
------------------------------------
|
|
|
|
-- Protectra: Revert cast time from 1 to 3 seconds
|
|
UPDATE spell_list SET castTime = 3000 WHERE name = 'protectra';
|
|
|
|
-- Protectra II: Revert cast time from 1.25 to 3.75 seconds
|
|
UPDATE spell_list SET castTime = 3750 WHERE name = 'protectra_ii';
|
|
|
|
-- Protectra III: Revert cast time from 1.5 to 4.5 seconds
|
|
UPDATE spell_list SET castTime = 4500 WHERE name = 'protectra_iii';
|
|
|
|
-- Protectra IV: Revert cast time from 1.75 to 5.25 seconds
|
|
UPDATE spell_list SET castTime = 5250 WHERE name = 'protectra_iv';
|
|
|
|
-- Protectra V: Revert cast time from 2 to 7 seconds
|
|
UPDATE spell_list SET castTime = 7000 WHERE name = 'protectra_v';
|
|
|
|
-- Shellra: Revert cast time from 1 to 3 seconds
|
|
UPDATE spell_list SET castTime = 3000 WHERE name = 'shellra';
|
|
|
|
-- Shellra II: Revert cast time from 1.25 to 3.75 seconds
|
|
UPDATE spell_list SET castTime = 3750 WHERE name = 'shellra_ii';
|
|
|
|
-- Shellra III: Revert cast time from 1.5 to 4.5 seconds
|
|
UPDATE spell_list SET castTime = 4500 WHERE name = 'shellra_iii';
|
|
|
|
-- Shellra IV: Revert cast time from 1.75 to 5.25 seconds
|
|
UPDATE spell_list SET castTime = 5250 WHERE name = 'shellra_iv';
|
|
|
|
-- Shellra V: Revert cast time from 2 to 6 seconds
|
|
UPDATE spell_list SET castTime = 6000 WHERE name = 'shellra_v';
|
|
|
|
------------------------------------
|
|
-- Divine Magic
|
|
------------------------------------
|
|
|
|
-- Remove PLD from Banishga
|
|
-- Source: https://forum.square-enix.com/ffxi/threads/56243
|
|
UPDATE spell_list SET jobs = 0x00000F00000000000000000000000000000000000000 WHERE name = 'banishga';
|