Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF(@Operation = 41 AND @ItemRefID = 62745) -- Plus Scroll (+1) coded by [Crap_iLegend]
- BEGIN
- DECLARE @OptLvl INT , @Item INT,
- @CharName VARCHAR(64),
- @Namescroll VARCHAR(64)
- SELECT @CharName = CharName16 FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID
- SELECT @Namescroll = CodeName128 FROM SRO_VT_SHARD.._RefObjCommon WHERE ID = @ItemRefID
- SET @Item = (SELECT ItemID FROM SRO_VT_SHARD.._Inventory WHERE CharID = @CharID AND Slot = '13')
- SET @OptLvl = (SELECT OptLevel FROM SRO_VT_SHARD.._Items WHERE ID64 = @Item) + 1 -- Plus (+1)
- IF ((@Item IS NOT NULL) AND @Item > 0) BEGIN
- UPDATE SRO_VT_SHARD.._Items SET OptLevel = @OptLvl WHERE ID64 = @Item
- END
- ELSE
- EXEC SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@Namescroll,1,0
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement