I get add procedures from _AddLogItem but not working :(
Code:
IF (@Operation = 16 and [MENTION=1134588]item[/MENTION]RefID = '67427')
Begin
Declare @ID64 Int , [MENTION=6278456]refit[/MENTION]emID Int
Select Top 1 @ID64 = Inv.ItemID , [MENTION=6278456]refit[/MENTION]emID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = [MENTION=395373]Chari[/MENTION]D and Inv.ItemID > 0 and Inv.Slot = 6
Begin
Update [SRO_VT_SHARD].[dbo].[_RentItemInfo] Set PeriodBeginTime = [MENTION=3299839]reNTT[/MENTION]ime, PeriodEndTime = [MENTION=3299839]reNTT[/MENTION]imenew, MeterRateTime = [MENTION=3299839]reNTT[/MENTION]imemenew Where nItemDBID = @ID64
End
End