Textpattern CMS

#1 2014-03-23 13:54:40

towndock

Member

From: Oriental, NC USA

Registered: 2007-04-06

Posts: 329

Website

Put all Live articles in Draft mode

I’m working on a complex site, where a decision has been made to change content in a manner that will cause every article to be tweaked before going live. The tweaks cannot be automated – each requires human intervention.

There are over 3,000 articles.

A really clean solution would be to put all 3,000 articles in draft mode, and then go through them all with the needed tweaks, making them live as that is accomplished.

Is there a way to send all articles to draft mode?

#2 2014-03-23 17:06:53

Gocom

Developer Emeritus

From: Helsinki, Finland

Registered: 2006-07-14

Posts: 4,533

Website

Re: Put all Live articles in Draft mode

You can do it by running a simple query trough MySQL CLI or management tools such as phpMyAdmin:

update textpattern set Status = 1 where Status = 4;

---

Rah | GitHub

#3 2014-03-23 17:30:41

towndock

Member

From: Oriental, NC USA

Registered: 2007-04-06

Posts: 329

Website

Re: Put all Live articles in Draft mode

Bingo. Thank you!