Part of the EllisLab Network
pMachine Pro has been replaced by ExpressionEngine, our full featured web publishing solution. Please consider upgrading.
You can download pMachine Pro here: Download pMachine Pro  |  Download Language Packs
   
 
Changing Open/Clost status of multiple entries…?
Posted: 08 February 2007 02:12 PM   [ Ignore ]  
Grad Student
Avatar
Rank
Total Posts:  78
Joined  2002-06-01

Does anyone know how I could change the status of all entries, from only one weblog, to closed, that are older than 3 months old?  Is there a phpMyadmin query or something that could do this?  Anyone tried this before?

What about simply deleting all entries from one weblog that are over 3 months old?  There are thousands of entries so it would take a long time to this through the control panel.

Thanks in advance for any advice…

Profile
 
 
Posted: 08 February 2007 03:08 PM   [ Ignore ]   [ # 1 ]  
Moderator
Avatar
RankRankRankRankRankRankRank
Total Posts:  12231
Joined  2002-04-29

You’d need to write a sql query that checks the value of t_stamp in the pm_weblog table and updates the value of status to closed.

I don’t have the time or energy to help you with doing this, but this will get you started.

 Signature 

Quick Reference - EE Trial Options - EE Wiki - Docs for updating a build

Profile
 
 
   
 
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 233, on December 18, 2007 12:04 AM
Total Registered Members: 64433 Total Logged-in Users: 0
Total Topics: 80875 Total Anonymous Users: 0
Total Replies: 435349 Total Guests: 20
Total Posts: 516224    
Members ( View Memberlist )
Active Members: