Support Forums - Classified Ads Script Osclass - Query to renew all expired listings - Support Forums

katalin2k · « **on:** February 05, 2025, 09:52:57 PM »

Hi guys,
Can anyone provide a mysql query that renews all expired listings?

Thanks!

MB Themes · « **Reply #1 on:** February 07, 2025, 04:39:27 PM »

Start with something like this.

SELECT * FROM oc_t_item WHERE dt_expiration >= now();

katalin2k · « **Reply #2 on:** February 07, 2025, 08:40:29 PM »

Thanks! I used this query, hopefully it's ok

UPDATE oc_t_item SET dt_expiration = DATE_ADD(dt_pub_date, INTERVAL 90 DAY) WHERE b_enabled = 1 AND dt_expiration < NOW();

Query to renew all expired listings