Re: [mv] Don't Know How To Title This Question

[OTR Comm <otrcomm@isp-systems.com>]

Bill Randle wrote:
> 
> On Feb 4, 11:13am, OTR Comm wrote:

> Sure. Just add a timestamp field to the database. At the time you
> change the item status from AVAILABLE to SALE-PENDING, set the
> "sale_time" (or whatever you call it) to the current time.
> 
> How you handle it can be done in a couple of different ways.
> (1) whenever the item is accessed for display, the timestamp
>     field is compared against the current time. If your hold
>     time has elapsed, change the status to available and display
>     the item as usual.
> 
> (2) have a cron job that runs periodically to check the products
>     database for expired sales (those whose hold time is greater
>     then your pre-determined limit) and reset the status field
>     to AVAILABLE.
> 
> In both cases, whenever the status is changed, you may need to check
> for any existing carts or saved carts containing that item and
> remove it from the cart. In the case of a saved cart (where you have
> a username), you could even send the user email letting them know
> the hold time has expired and has been removed from their saved cart.
> If you go that route, I would suggest option (2) as you probably
> don't want to do all that processing during the display of search results.

Thanks, This (option 2) should work well.

Murrah

> 
>         -Bill
> 
> _______________________________________________
> Minivend-users mailing list
> Minivend-users@minivend.com
> http://www.minivend.com/mailman/listinfo/minivend-users


_______________________________________________
Minivend-users mailing list
Minivend-users@minivend.com
http://www.minivend.com/mailman/listinfo/minivend-users