vSRO Paylaşım vSRO Skill Bağlama ve Genel Query

****************************************************************************************************************************

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 (BUZ)
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (ELEKTRİK)
update _RefSkill set Action_ReuseDelay = 15000 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (ATEŞ)

update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (BUZ)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (ELEKTRİK)
update _RefSkill set Param3 = 15000 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (ATEŞ)

-- El Yakmaları Birbirine Bağla
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_COLD_GIGONGTA_%_%' -- El Yakma (BUZ)
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_%_%' -- El Yakma (ELEKTRİK)
update _RefSkill set Action_Overlap = 973078654 where Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_%_%' -- El Yakma (ATEŞ)

-- 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_%_%'

******************************************************************************************************************************

USE SRO_VT_SHARD
GO

-- 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
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

******************************************************************************************************************************

USE SRO_VT_SHARD
GO

-- Tüm Buffları 1 saniyede Basmak

--Cold
update _RefSkill set Action_PreparingTime = 0 where Basic_Code like 'SKILL_CH_COLD_GANGGI_%_%' -- Guard of Ice Bufları
update _RefSkill set Action_CastingTime = 0 where Basic_Code like 'SKILL_CH_COLD_GANGGI_%_%' -- Guard of Ice Bufları
update _RefSkill set Action_ActionDuration = 0 where Basic_Code like 'SKILL_CH_COLD_GANGGI_%_%' -- Guard of Ice Bufları
--Lighting
update _RefSkill set Action_PreparingTime = 0 where Basic_Code like 'SKILL_CH_LIGHTNING_GWANTONG_%_%' -- Piercing Force Bufları
update _RefSkill set Action_CastingTime = 0 where Basic_Code like 'SKILL_CH_LIGHTNING_GWANTONG_%_%' -- Piercing Force Bufları
update _RefSkill set Action_ActionDuration = 0 where Basic_Code like 'SKILL_CH_LIGHTNING_GWANTONG_%_%%' -- Piercing Force Bufları

update _RefSkill set Action_PreparingTime = 0 where Basic_Code like 'SKILL_CH_LIGHTNING_JIPJUNG_%_%' -- Concentrion Bufları
update _RefSkill set Action_CastingTime = 0 where Basic_Code like 'SKILL_CH_LIGHTNING_JIPJUNG_%_%' -- Concentrion Bufları
update _RefSkill set Action_ActionDuration = 0 where Basic_Code like 'SKILL_CH_LIGHTNING_JIPJUNG_%_%' -- Concentrion Bufları
--Fire
update _RefSkill set Action_PreparingTime = 0 where Basic_Code like 'SKILL_CH_FIRE_SHIELD_%_%' -- Fire Shield Bufu
update _RefSkill set Action_CastingTime = 0 where Basic_Code like 'SKILL_CH_FIRE_SHIELD_%_%' -- Fire Shield Bufu
update _RefSkill set Action_ActionDuration = 0 where Basic_Code like 'SKILL_CH_FIRE_SHIELD_%_%' -- Fire Shield Bufu

update _RefSkill set Action_PreparingTime = 0 where Basic_Code like 'SKILL_CH_FIRE_GONGUP_%_%' -- Flame Body Buffları
update _RefSkill set Action_CastingTime = 0 where Basic_Code like 'SKILL_CH_FIRE_GONGUP_%_%' -- Flame Body Buffları
update _RefSkill set Action_ActionDuration = 0 where Basic_Code like 'SKILL_CH_FIRE_GONGUP_%_%' -- Flame Body Buffları

update _RefSkill set Action_PreparingTime = 0 where Basic_Code like 'SKILL_CH_FIRE_GANGGI_%_%' -- Protection Buffları
update _RefSkill set Action_CastingTime = 0 where Basic_Code like 'SKILL_CH_FIRE_GANGGI_%_%' -- Protection Buffları
update _RefSkill set Action_ActionDuration = 0 where Basic_Code like 'SKILL_CH_FIRE_GANGGI_%_%' -- Protection Buffları
******************************************************************************************************************************
USE SRO_VT_SHARD
GO
-- Tüm Buffların kullanım süresini 1 gün Yapmak

--Cold
update _RefSkill set Param3 = 86400000 where Basic_Code like 'SKILL_CH_COLD_GANGGI_%_%' -- Guard of Ice Bufları
--Lighting
update _RefSkill set Param3 = 86400000 where Basic_Code like 'SKILL_CH_LIGHTNING_GWANTONG_%_%' -- Piercing Force Bufları
update _RefSkill set Param3 = 86400000 where Basic_Code like 'SKILL_CH_LIGHTNING_JIPJUNG_%_%' -- Concentrion Bufları
--Fire
update _RefSkill set Param3 = 86400000 where Basic_Code like 'SKILL_CH_FIRE_SHIELD_%_%' -- Fire Shield Bufu
update _RefSkill set Param3 = 86400000 where Basic_Code like 'SKILL_CH_FIRE_GONGUP_%_%' -- Flame Body Buffları
update _RefSkill set Param3 = 86400000 where Basic_Code like 'SKILL_CH_FIRE_GANGGI_%_%' -- Protection Buffları
******************************************************************************************************************************

USE SRO_VT_SHARD
GO
-- 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

/* Mediada düzenlenmesi gerekenler */

--skill data: 5000 - skill data: 10000
--skill data: 5000 enc - skill data: 10000 enc
******************************************************************************************************************************

USE SRO_VT_SHARD
GO

-------------------------------------------------------------------------------------------------------------------------------
--Skill: FORCE
--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
-------------------------------------------------------------------------------------------------------------------------------

/* Mediada düzenlenmesi gerekenler */

--skill data: 5000 - skill data: 10000
--skill data: 5000 enc - skill data: 10000 enc


/*
Skill'e ait tüm levellerde boşta kalan son param hücresine bu değeri girerseniz skill üstten kapatılamaz.
1851946342

Param değerleri için patch atmanıza gerek yoktur.
*/