function _ed_classified_get_aged_ads in Classified Ads 6.2
Same name and namespace in other branches
- 5.2 ed_classified_utils.inc \_ed_classified_get_aged_ads()
- 5 ed_classified_utils.inc \_ed_classified_get_aged_ads()
- 7.2 ed_classified_utils.inc \_ed_classified_get_aged_ads()
Get a query result with any ads that have expired prior to a given date, and having a specific publish status
2 calls to _ed_classified_get_aged_ads()
- _ed_classified_expire_ads in ./
ed_classified_utils.inc - expire old ads
- _ed_classified_purge_ads in ./
ed_classified_delete.inc - Purge old ads (must have been expired - IOW, unpublished - first.)
File
- ./
ed_classified_utils.inc, line 241 - Simple text-based classified ads module.
Code
function _ed_classified_get_aged_ads($expire_time_start, $expire_time_end, $status = 1) {
return db_query("SELECT * FROM {node} n, {edi_classified_nodes} ec WHERE n.type='ed_classified' AND n.vid = ec.vid AND n.status = %d AND (ec.expires_on >= %d AND ec.expires_on <= %d)", $status, $expire_time_start, $expire_time_end);
}