Prosudur bilgim yok Nasil yapacagim bilemiyorum SRO_VT_LOG ve Prosudur Kisminda _AddLogItem
IF (@Operation = 41 AND @ItemRefID='67445') -- ADV SİLİCİ
Begin
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
End
IF (@Operation=41 AND @ItemRefID='67442') --STAT RECALL
BEGIN
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
END
IF (@Operation=41 AND @ItemRefID='67439') --SKILL RECALL
BEGIN
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
END
IF (@Operation=41 AND @ItemRefID='67443') -- FGW Time Remove added by KaRa
BEGIN
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
END
IF (@Operation=41 AND @ItemRefID='67441') -- Premium Delete Scroll
BEGIN
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
END
IF (@Operation=41 AND @ItemRefID='67444') -- Job Penalty Delete
BEGIN
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
END
IF (@Operation=41 AND @ItemRefID='67466') -- Job Penalty Delete
BEGIN
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
END
IF(@Operation=16 AND @ItemRefID ='67490')
BEGIN
EXEC SRO_VT_LOG.dbo.MeloScroll @CharID,@ItemRefID
END
if(@Operation = 90)
begin
declare @itempls VARCHAR(5)
select @itempls = OptLevel from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
if(@itempls='13' or @itempls='14' or @itempls='15' or @itempls='16' or @itempls='17' )
begin
update SRO_VT_SHARD.._Items set OptLevel=12 where Serial64 = @ItemSerial
BU SEKILDEDIR