SRO_VT_LOG içerisinde Stored Procedures kısmında _AddLogItem'i bul AS kısmının altında
IF(@ItemRefID= 'Scroll Kodu')
BEGIN
declare @TotalSP int
declare @TotalSPMastery int
UPDATE SRO_VT_SHARD.dbo._Char SET RemainSkillPoint=RemainSkillPoint+5000000 WHERE CharID=@CharID
DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET Level='0' WHERE CharID=@CharID
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_SHIELD_%')
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GONGUP_%')
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GANGGI_%')
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_GWANTONG_%')
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_JIPJUNG_%')
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_COLD_GANGGI_%')
BU KISMA MasteryScroll Prosedürünü
HEMEN ALTINADA Kullanan Chara filter veya bot üzerinden dc verdirecek sorguyu yaz.
END