almost able to mass delete expired articles! SOLVED

[rescamilla]

I am not a my mysql expert, so can somebody help me complete this myphpadmin query?

Code: Select all

SELECT *
FROM `phpwcms_article`
WHERE `article_cid` =316
AND `article_end` < '2011-02-24 23:59:59'

The above query shows me all the articles in the 316 category that have an end date less than 02/24/11. I want to be able to add to this query and change the "article_deleted" value from "0" to "9". This will then remove the hundreds of articles in that category that are expired (from view in the backend).

This is a very large site, and my expired articles are out of control. Clicking the little red x in the backend to delete every article would take forever.

-Ray

PS I am using phpwcms v 1.3.3

[rescamilla]

I figured it out. Run this query in phpmyadmin to delete expired articles:

Code: Select all

UPDATE phpwcms_article SET article_deleted = '9' WHERE `article_cid` = '316' AND `article_end` < '2011-02-24 23:59:59';

Note: You need to replace 316 with the catergory id # that you want to delete from (I only wanted to delete expired articles from my news category). Also modify the date to suit your needs.

-Ray

[update]

If you've set the articles "visible after expire" google will not be happy at all, I think...