vSRO AddLogItem Prosedürleri Paylaşım (Event, Scroll, Reset, Fix Sistemleri Full Pack 2026)

if (@ItemRefID = '78646' and @Operation = 41)
begin 
 update SRO_VT_SHARD.dbo._Char set HwanLevel = 1 where CharID = @charID 
end

if(@Operation = 41 and @ItemRefID= '78343')
begin
Update SRO_VT_SHARD.._Items
Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL,
MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL,
MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL
where ID64 in (
select ItemID from SRO_VT_SHARD.._Inventory 
where CharID = @CharID and Slot =13 and ItemID Between 1 AND 999999999
)
end

IF (@Operation = 41)
Begin
 IF (@ItemRefID = 78342)
 Begin
  Declare @InvID INT = (Select ItemID From _Inventory Where CharID = @CharID and Slot = 13)
  Declare @RefItemID INT = (Select RefItemID From _Items Where ID64 = @InvID)

  IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,24412)
  Begin
   Update _Items Set RefItemID='24413' Where ID64=@InvID
  End
  ELSE
  Begin
   Update _Items Set RefItemID='24414' Where ID64=@InvID
  End
 End
End

IF @operation = 144
BEGIN
 DECLARE @JobType tinyint , @IsBattleField bit

 SELECT @JobType = CTJ.JobType, @IsBattleField = R.IsBattleField
 FROM _Char C
 INNER JOIN _CharTriJob CTJ ON C.CharID = CTJ.CharID
 INNER JOIN _RefRegion R ON C.LatestRegion = R.wRegionID
 WHERE C.CharID = @CharID

 IF @JobType = 2 AND @IsBattleField = 0
 BEGIN
  DELETE FROM _InvCOS WHERE CharID = @CharID
 END
END

IF (@Operation = 41 AND (@ItemRefID between '78001' and '78012'))
Begin
 EXEC SRO_VT_LOG.dbo._MODEL_SWITCHER_MOON @CharID,@ItemRefID
End

IF (@Operation = 41 AND @ItemRefID='78013')
Begin
 EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
End

IF (@Operation = 41 AND @ItemRefID='78014')
Begin
 EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
End

IF (@Operation=41 AND @ItemRefID='70002')
Begin
 EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
End

IF (@Operation=41 AND @ItemRefID='70004')
Begin
 EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
End

IF (@Operation=41 AND @ItemRefID='78015')
Begin
 EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
End

if(@Operation = 41 and @ItemRefID = 78016)
begin
 DELETE FROM _TimedJob WHERE CharID=@CharID
end

IF (@Operation=41 AND @ItemRefID='78036')
Begin
 EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
End

IF (@Operation = 90 AND @strDesc like '%Opt: +13%')
BEGIN
 UPDATE _Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END