Viernes, 31 Octubre 2014 13:39
beggarly

Virtuemart Product Timeout

Suggest/Comment/Post new extensions for Xmap!

Virtuemart Product Timeout

Postby hhackwell » Thu Feb 04, 2010 11:03 am

Hi,

I have a timeout date for all products on my site which is 150 days. When they timeout they no longer appear on the site, but are still published in case I want to reuse them.

Could you tell me how to put this piece of code into the extension file to stop the sitemap from displaying timed-out products:

$database->setQuery ("SELECT * FROM jos_vm_product WHERE product_id = " . $db_browse->f("product_id") . " AND DATEDIFF(now(),`cdate`) > 150");

Thanks

Helen
hhackwell
Fresh Boarder
Fresh Boarder
 
Posts: 1
Joined: Thu Feb 04, 2010 11:01 am

Return to Plugins



Who is online

Users browsing this forum: No registered users and 2 guests