Miércoles, 28 Enero 2015 06:37

Virtuemart Product Timeout

Suggest/Comment/Post new extensions for Xmap!

Virtuemart Product Timeout

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


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");


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 1 guest