Welcome back rewards

Results 1 to 3 of 3
  1. #1
    Registered ItsWannabe is offline
    MemberRank
    Feb 2018 Join Date
    9Posts

    thumbs up Welcome back rewards

    Just a small script which gives a Character a Item if he logs in after being inactive for a while.
    It goes into the Login Procedure and will put the respective Item into the Rewards Inventory.

    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());
    Change this to adjust the Script for your needs:
    month: Can be replaced with Day or Year if required.
    -1: Means that the script will be triggered only if the last login was 1 month ago.
    5: The ItemID which you can find in your ItemInfo.shn.

    I felt like this function was missing, for sure its not that much relevant for private servers but maybe you can find a good use for it :)



  2. #2
    Member spectra51 is offline
    MemberRank
    Jun 2015 Join Date
    44Posts

    Re: Welcome back rewards

    This is pretty cool. Reminds me of that Returning Mercenaries feature in vindictus

  3. #3
    Account Upgraded | Title Enabled! Krum is online now
    True MemberRank
    Aug 2012 Join Date
    265Posts

    Re: Welcome back rewards

    Quote Originally Posted by spectra51 View Post
    This is pretty cool. Reminds me of that Returning Mercenaries feature in vindictus
    Gamigo uses it from a long time ago.



Advertisement