Adding items to a new characters inventory

[CoreAI]

Hi all,

I want an item sent to a characters inventory upon character creation, but I want the item to expire after 3 days. I know what procedure to edit and successfully done it without an expiry date, but trying to make the item expire puzzles me, so does anyone know how to do this?

Thanks.

[MentaL]

[Dave]

You have to set the RentHourPeriod. 72 hours, 3 days.

In spInsertChar you can do something like:

INSERT INTO dbo.CharacterItem (CID, ItemID, RegDate, RentDate, RentHourPeriod, Cnt) 
        VALUES (@CharIdent, youritemid, @NowDate, @NowDate, 72, 1) 

[CoreAI]

Can't believe it was something that simple lol, thanks Dave :)