[CLUB]
USE SRO_VT_SHARD
GO
Update _RefSkill Set Param10 = 65 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_DIVIDE_A_04'
Update _RefSkill Set Param10 = 65 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_DIVIDE_A_05'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_08'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_09'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_10'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_11'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_12'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_06'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_07'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_08'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_09'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_10'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_11'
Update _RefSkill Set Param3 = 30000 Where Basic_Code like'SKILL_EU_WARRIOR_GUARDA_INTERCEPT_A%'
Update _RefSkill Set Param3 = 30000 Where Basic_Code like'SKILL_EU_WARRIOR_GUARDA_MAGIC_BLOCK_A%'
Update _RefSkill Set Param3 = 30000 Where Basic_Code like'SKILL_EU_WARRIOR_GUARDA_ALL_BLOCK_A%'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_01'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_02'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_03'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_04'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_05'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_06'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_07'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_04'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_05'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_06'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_07'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_04'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_05'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_06'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_07'
Update _RefSkill Set Param10 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_01'
Update _RefSkill Set Param10 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_02'
Update _RefSkill Set Param10 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_03'
Update _RefSkill Set Param13 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_01'
Update _RefSkill Set Param13 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_02'
Update _RefSkill Set Param13 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_03'
Update _RefSkill Set Param14 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_01'
Update _RefSkill Set Param14 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_02'
Update _RefSkill Set Param14 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_03'
Update _RefSkill Set Param13 = 15 Where Basic_Code like'SKILL_EU_WARLOCK_SOULA_STUNLINK_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_PHYSICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_MAGICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_STR_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_INT_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_PHYSICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_MAGICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_STR_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_INT_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_PHYSICAL_B%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_MAGICAL_B%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_STR_B%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_INT_B%'
update _RefSkill Set Param3 = 10000 Where Basic_Code='SKILL_EU_CLERIC_REBIRTHA_SPECIAL_B_BUFF_02'
update _RefSkill Set Param3 = 10000 Where Basic_Code ='SKILL_EU_CLERIC_REBIRTHA_SPECIAL_B_BUFF_01'
[/CLUB]
USE SRO_VT_SHARD
GO
Update _RefSkill Set Param10 = 65 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_DIVIDE_A_04'
Update _RefSkill Set Param10 = 65 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_DIVIDE_A_05'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_08'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_09'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_10'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_11'
Update _RefSkill Set Param11 = 54 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_PHYSICAL_A_12'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_06'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_07'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_08'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_09'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_10'
Update _RefSkill Set Param11 = 51 Where Basic_Code='SKILL_EU_WARRIOR_GUARDA_MAGIC_A_11'
Update _RefSkill Set Param3 = 30000 Where Basic_Code like'SKILL_EU_WARRIOR_GUARDA_INTERCEPT_A%'
Update _RefSkill Set Param3 = 30000 Where Basic_Code like'SKILL_EU_WARRIOR_GUARDA_MAGIC_BLOCK_A%'
Update _RefSkill Set Param3 = 30000 Where Basic_Code like'SKILL_EU_WARRIOR_GUARDA_ALL_BLOCK_A%'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_01'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_02'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_03'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_04'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_05'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_06'
Update _RefSkill Set Param3 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_07'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_04'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_05'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_06'
Update _RefSkill Set Param6 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_07'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_04'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_05'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_06'
Update _RefSkill Set Param7 = 75 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_A_07'
Update _RefSkill Set Param10 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_01'
Update _RefSkill Set Param10 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_02'
Update _RefSkill Set Param10 = 30000 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_03'
Update _RefSkill Set Param13 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_01'
Update _RefSkill Set Param13 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_02'
Update _RefSkill Set Param13 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_03'
Update _RefSkill Set Param14 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_01'
Update _RefSkill Set Param14 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_02'
Update _RefSkill Set Param14 = 90 Where Basic_Code='SKILL_EU_WARLOCK_SOULA_RETURN_B_03'
Update _RefSkill Set Param13 = 15 Where Basic_Code like'SKILL_EU_WARLOCK_SOULA_STUNLINK_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_PHYSICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_MAGICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_STR_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_INT_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_PHYSICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_MAGICAL_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_STR_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_INT_A%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_PHYSICAL_B%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_MAGICAL_B%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_STR_B%'
update _RefSkill Set Param4 = 50 Where Basic_Code like'SKILL_EU_WARLOCK_RAZEA_INT_B%'
update _RefSkill Set Param3 = 10000 Where Basic_Code='SKILL_EU_CLERIC_REBIRTHA_SPECIAL_B_BUFF_02'
update _RefSkill Set Param3 = 10000 Where Basic_Code ='SKILL_EU_CLERIC_REBIRTHA_SPECIAL_B_BUFF_01'
[/CLUB]
