34 lines
918 B
SQL
34 lines
918 B
SQL
------------------------------------
|
|
-- Seekers of Adoulin Weaponskill SQL Adjustments
|
|
-- This module reverts relevant SQL tables for weaponskills to their pre-SoA values
|
|
-- Source: https://www.bg-wiki.com/ffxi/Version_Update_(05/15/2012)
|
|
------------------------------------
|
|
|
|
-- Archery Weaponskills: Revert range from 20 to 15 yalms
|
|
UPDATE weapon_skills SET `range` = 15 WHERE `name` IN (
|
|
'flaming_arrow',
|
|
'piercing_arrow',
|
|
'dulling_arrow',
|
|
'sidewinder',
|
|
'arching_arrow',
|
|
'empyreal_arrow',
|
|
'namas_arrow',
|
|
'refulgent_arrow',
|
|
'jishnus_radiance',
|
|
'apex_arrow'
|
|
);
|
|
|
|
-- Marksmanship Weaponskills: Revert range from 20 to 15 yalms
|
|
UPDATE weapon_skills SET `range` = 15 WHERE `name` IN (
|
|
'hot_shot',
|
|
'split_shot',
|
|
'sniper_shot',
|
|
'slug_shot',
|
|
'heavy_shot',
|
|
'detonator',
|
|
'coronach',
|
|
'trueflight',
|
|
'leaden_salute',
|
|
'wildfire',
|
|
'last_stand'
|
|
);
|