Advertisement
Guest User

proc

a guest
Aug 18th, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.73 KB | None | 0 0
  1. IF(@Operation = 41 AND @ItemRefID = 62745) -- Plus Scroll (+1) coded by [Crap_iLegend]
  2. BEGIN
  3. DECLARE @OptLvl INT , @Item INT,
  4.         @CharName VARCHAR(64),
  5.         @Namescroll VARCHAR(64)
  6. SELECT @CharName = CharName16 FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID
  7. SELECT @Namescroll = CodeName128 FROM SRO_VT_SHARD.._RefObjCommon WHERE ID = @ItemRefID
  8. SET @Item = (SELECT ItemID FROM SRO_VT_SHARD.._Inventory WHERE CharID = @CharID AND Slot = '13')
  9. SET @OptLvl = (SELECT OptLevel FROM SRO_VT_SHARD.._Items WHERE ID64 = @Item) + 1 -- Plus (+1)
  10. IF ((@Item IS NOT NULL) AND @Item > 0) BEGIN
  11. UPDATE SRO_VT_SHARD.._Items SET OptLevel = @OptLvl WHERE ID64 = @Item
  12. END
  13. ELSE
  14. EXEC SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@Namescroll,1,0
  15. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement