[Only registered and activated users can see links. Click Here To Register...]
USE w00_Character;
DECLARE @
[Only registered and activated users can see links. Click Here To Register...] nvarchar(40)
set @
[Only registered and activated users can see links. Click Here To Register...] = 'CharName' /** <--- write the name of the Character**/
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]Reward int
set @
[Only registered and activated users can see links. Click Here To Register...]Reward = 'ItemInx' /** <--- write the ID of the ItemInfo.shn**/
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]er int
set @
[Only registered and activated users can see links. Click Here To Register...]er = NULL
set @
[Only registered and activated users can see links. Click Here To Register...]er = (Select nCharNo FROM tCharacter where sID = @
[Only registered and activated users can see links. Click Here To Register...])
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]mkey bigint
set @
[Only registered and activated users can see links. Click Here To Register...]mkey = (convert(numeric(17,0),rand() * 89999999999999999) + 10000000000000000)
INSERT INTO tItem (nItemKey, nStorageType, nOwner, nStorage, nItemID, nFlags, dDate)
VALUES @
[Only registered and activated users can see links. Click Here To Register...]mkey, 2, @
[Only registered and activated users can see links. Click Here To Register...]er, 1, @
[Only registered and activated users can see links. Click Here To Register...]Reward, 0, CURRENT_TIMESTAMP);