See, I have a simple logic to understand here. Currently I have a system that allows users to post a classified ad listing. This listing expiry date varies, depending how many days the user chooses. 1,3,5,7,10 days. It works just closely similar to eBay.
Ok, once a listing is posted, there will be an expiry date recorded in the database. For example 2006-11-02 04:27:26. This is the date time that the listing will expired. For now, I want to allow them to pause their own listing. How to I enable this feature? Do i have to create another field in the table and record when the user pause their listing? And how do i calculate that to offset the duration?
do I need to track the pause end time? because everytime a user unpause a listing, the expiry time will be calculated (to the extend) immediately and the pause time will be deleted. Am i right to say that?
you could also keep the pause times if you need to keep records of them, as well as keep the origional expiry time if you need that info, and just calculate the expiry or have an 'adjusted expiry' field.