Update on Rent Period

[7-Eleven]

Hello all! I've been adding rent period into some items after they're bought from the shop but their rent period doesn't appear until you relogin/reselect your character.

This is the following:-

IF (@ItemID = 8) OR (@ItemID = 18) OR (@ItemID = 35) OR (@ItemID = 4021) OR (@ItemID = 4022) OR (@ItemID = 4515) OR (@ItemID = 4516) OR (@ItemID = 5019) OR (@ItemID = 5020) OR (@ItemID = 6008) OR (@ItemID = 7009) OR (@ItemID = 8004) OR (@ItemID = 9007)
UPDATE CharacterItem SET RentHourPeriod = 168 WHERE CID=@CID AND ItemID=@ItemID
IF 0 <> @@ERROR
BEGIN
ROLLBACK TRAN
RETURN (-1)
END

Ahy help regarding on how to make it so that it updates as soon as it is bought is greatly appreciated.

[MentaL]

[maxteam]

Rent period actually works
i forgot wat to edit :P

i ll hab to install SQl again :((

[7-Eleven]

Ya, rent period is working. This is just some extra I tried to put in similar to what MAIET tried before adding in lucky boxes for the new high level items.

I just don't know how to get it to update instantly on the rent period (Other than the item id above, no rent period) after the item is bought.