Newbie Spellweaver
- Joined
- Feb 5, 2018
- Messages
- 9
- Reaction score
- 3
IF EXISTS (SELECT * FROM tCharacter WHERE dLastLoginDate < DATEADD(month, -1, GETDATE()) and nCharNo = @nCharNo)
INSERT INTO tItem (nItemKey,nStorageType,nOwner,nStorage,nItemID,nFlags,dDate)
VALUES (ABS(CHECKSUM(NewId())) % 99999999999,2,@nCharNo,0,5,0,GETDATE());
Gamigo uses it from a long time ago.This is pretty cool. Reminds me of that Returning Mercenaries feature in vindictus