Plus Scroll

M

M.Moamen

المستوي:


نا عاملها تدي +3 على اي أيتم يتحط في Slot 13 اللي هي Slot 1 في الانفيتوري لما يكون الايتم دا اصغر من +15


دا الـ Procedure و ظبت اللينز من اي اسكرول انا نزلتها انا ابل كده و لو صادفك اي مشكله انا معاك


PHP:
IF(@JobID = '339370')    -- Plus Scroll (+3) coded by [iLegend] 
 Begin 
  Declare @OptLvl int 
  Declare @NewOptLvl int 
  Select @OptLvl = OptLevel From dbo._Items Where ID64 = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '13' and ItemID>0) 
  Set @NewOptLvl = (@OptLvl+3) 
  Select ItemID=@ItemID1 From _Inventory Where CharID = @CharID 
  Update dbo._Items Set OptLevel = @NewOptLvl Where ID64 = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '13' and ItemID>0) and OptLevel < 15 
 End
 




M

M.Moamen

المستوي:

رد: Plus Scroll

معلش انا عاوز + 7 عشان اخليها للدونات



اتفضل




PHP:
IF(@JobID = '339370')    -- Plus Scroll (+3) coded by [iLegend]  
 Begin  
  Declare @OptLvl int  
  Declare @NewOptLvl int  
  Select @OptLvl = OptLevel From dbo._Items Where ID64 = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '13' and ItemID>0)  
  Set @NewOptLvl = (@OptLvl+7)  
  Select ItemID=@ItemID1 From _Inventory Where CharID = @CharID  
  Update dbo._Items Set OptLevel = @NewOptLvl Where ID64 = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '13' and ItemID>0) and OptLevel < 15  
 End