-- Prosedürü kullanmadan önce mutlaka yedeğinizi alınız
USE SRO_VT_SHARD
GO
-- El Yakmalar 15 saniye
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (Cold)
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (Light)
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (Fire)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (Cold)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (Light)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (Fire)
-- El Yakmaları Birbirine Bağla
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (Cold)
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (Light)
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (Fire)
-- Snowları Birbirine Bağla ve 250 Int sınırı koy
update _RefSkill set Action_Overlap = 1919120754 where Basic_Code like 'SKILL_CH_COLD_SHIELD_%_%'
update _RefSkill set ReqCommon_Int = 250 where Basic_Code like 'SKILL_CH_COLD_SHIELD_%_%'
-- Speed bugunu kapat
update _RefSkill set Action_ReuseDelay = 25000 where Basic_Code like 'SKILL_CH_LIGHTNING_GYEONGGONG_A_%' -- Grass walk Flow
update _RefSkill set Action_ReuseDelay = 25000 where Basic_Code like 'SKILL_CH_LIGHTNING_GYEONGGONG_C_%' -- Grass walk Speed
update _RefSkill set Action_ReuseDelay = 25000 where Basic_Code like 'SKILL_CH_LIGHTNING_GYEONGGONG_E_%' -- Grass walk God
-- Force / Vital Spot değeleri %(45 olan değeri kaç yaparsanız o skill için bu değer atanır)
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_C_%' -- Vital Spot-Body
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_D_%' -- Vital Spot-Mind
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_E_%' -- Vital Spot-Zero
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_F_%' -- Vital Spot-Brain
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_G_%' -- Vital Spot-Faint
-- Force Theraphy Kapat
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_WATER_HARMONY_%_%' -- Tüm Therapy Skilleri
-- Heuksal ilk Skill
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_A_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_B_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_C_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_D_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_E_%' -- Spear mızrak vuruşu
-- Bow - Arrow Comboları Birbirine bağlama--
update _RefSkill set Action_ReuseDelay = 6000 where Basic_Code like 'SKILL_CH_BOW_CHAIN_%_%' -- Yeniden kullanım 6 saniye
update _RefSkill set Action_Overlap = 603979776 where Basic_Code like 'SKILL_CH_BOW_CHAIN_%_%' -- Hepsini birbirine bağlama
--Seri: Self Breathe Heal
update _RefSkill set Action_ReuseDelay = 10000 where Basic_Code like 'SKILL_CH_WATER_SELFHEAL_%_%' -- Yeniden kullanım 10 saniye
update _RefSkill set Action_Overlap = 1224736788 where Basic_Code like 'SKILL_CH_WATER_SELFHEAL_%_%' -- Hepsini birbirine bağlama
--Skill: FORCE
--Seri: Force Cure - Poison
update _RefSkill set Action_ReuseDelay = 16000 where Basic_Code like 'SKILL_CH_WATER_CURE_%_%' -- Yeniden kullanım 16 saniye
update _RefSkill set Action_Overlap = 637534208 where Basic_Code like 'SKILL_CH_WATER_CURE_%_%' -- Hepsini birbirine bağlama
--Skill: FORCE
--Seri: Cure Terapy
update _RefSkill set Action_ReuseDelay = 16000 where Basic_Code like 'SKILL_CH_WATER_CUREAREA_%_%' -- Yeniden kullanım 16 saniye
update _RefSkill set Action_Overlap = 1358954531 where Basic_Code like 'SKILL_CH_WATER_CUREAREA_%_%' -- Hepsini birbirine bağlama
--Skill: FORCE
--Seri: Heal Serisi
update _RefSkill set Action_ReuseDelay = 10000 where Basic_Code like 'SKILL_CH_WATER_HEAL_%_%' -- Yeniden kullanım 10 saniye
update _RefSkill set Action_Overlap = 251658240 where Basic_Code like 'SKILL_CH_WATER_HEAL_%_%' -- Hepsini birbirine bağlama
USE SRO_VT_SHARD
GO
-- El Yakmalar 15 saniye
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (Cold)
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (Light)
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (Fire)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (Cold)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (Light)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (Fire)
-- El Yakmaları Birbirine Bağla
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (Cold)
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (Light)
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (Fire)
-- Snowları Birbirine Bağla ve 250 Int sınırı koy
update _RefSkill set Action_Overlap = 1919120754 where Basic_Code like 'SKILL_CH_COLD_SHIELD_%_%'
update _RefSkill set ReqCommon_Int = 250 where Basic_Code like 'SKILL_CH_COLD_SHIELD_%_%'
-- Speed bugunu kapat
update _RefSkill set Action_ReuseDelay = 25000 where Basic_Code like 'SKILL_CH_LIGHTNING_GYEONGGONG_A_%' -- Grass walk Flow
update _RefSkill set Action_ReuseDelay = 25000 where Basic_Code like 'SKILL_CH_LIGHTNING_GYEONGGONG_C_%' -- Grass walk Speed
update _RefSkill set Action_ReuseDelay = 25000 where Basic_Code like 'SKILL_CH_LIGHTNING_GYEONGGONG_E_%' -- Grass walk God
-- Force / Vital Spot değeleri %(45 olan değeri kaç yaparsanız o skill için bu değer atanır)
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_C_%' -- Vital Spot-Body
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_D_%' -- Vital Spot-Mind
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_E_%' -- Vital Spot-Zero
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_F_%' -- Vital Spot-Brain
update _RefSkill set Param4 = 45 where Basic_Code like 'SKILL_CH_WATER_CANCEL_G_%' -- Vital Spot-Faint
-- Force Theraphy Kapat
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_WATER_HARMONY_%_%' -- Tüm Therapy Skilleri
-- Heuksal ilk Skill
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_A_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_B_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_C_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_D_%' -- Spear mızrak vuruşu
update _RefSkill set Service = 0 where Basic_Code like 'SKILL_CH_SPEAR_PIERCE_E_%' -- Spear mızrak vuruşu
-- Bow - Arrow Comboları Birbirine bağlama--
update _RefSkill set Action_ReuseDelay = 6000 where Basic_Code like 'SKILL_CH_BOW_CHAIN_%_%' -- Yeniden kullanım 6 saniye
update _RefSkill set Action_Overlap = 603979776 where Basic_Code like 'SKILL_CH_BOW_CHAIN_%_%' -- Hepsini birbirine bağlama
--Seri: Self Breathe Heal
update _RefSkill set Action_ReuseDelay = 10000 where Basic_Code like 'SKILL_CH_WATER_SELFHEAL_%_%' -- Yeniden kullanım 10 saniye
update _RefSkill set Action_Overlap = 1224736788 where Basic_Code like 'SKILL_CH_WATER_SELFHEAL_%_%' -- Hepsini birbirine bağlama
--Skill: FORCE
--Seri: Force Cure - Poison
update _RefSkill set Action_ReuseDelay = 16000 where Basic_Code like 'SKILL_CH_WATER_CURE_%_%' -- Yeniden kullanım 16 saniye
update _RefSkill set Action_Overlap = 637534208 where Basic_Code like 'SKILL_CH_WATER_CURE_%_%' -- Hepsini birbirine bağlama
--Skill: FORCE
--Seri: Cure Terapy
update _RefSkill set Action_ReuseDelay = 16000 where Basic_Code like 'SKILL_CH_WATER_CUREAREA_%_%' -- Yeniden kullanım 16 saniye
update _RefSkill set Action_Overlap = 1358954531 where Basic_Code like 'SKILL_CH_WATER_CUREAREA_%_%' -- Hepsini birbirine bağlama
--Skill: FORCE
--Seri: Heal Serisi
update _RefSkill set Action_ReuseDelay = 10000 where Basic_Code like 'SKILL_CH_WATER_HEAL_%_%' -- Yeniden kullanım 10 saniye
update _RefSkill set Action_Overlap = 251658240 where Basic_Code like 'SKILL_CH_WATER_HEAL_%_%' -- Hepsini birbirine bağlama