UBB.Developers Forums UBB.threads 7 Development How Do I? Pruning Forum Posts In Chronological Order

Back again taking Joshpet's advice to post this query here as well.

With Classic I could go into my Admin and delete all the old posts very easily in chronological order.

The older threads which hadn't been posted to in some time appeared one after another at the bottom of the list and it was easy as pie to go in and delete.

Threads on the other hand is terrible
The threads started the longest time ago do indeed appear at the bottom of the prunage list regardless of whether they've been posted to recently??

"Help?"

If you have "date slip" enabled then even old threads will rise to the top if they are replied to.

Not sure if that helps or not though.

You can set a chron task - doexpire.php - and it will delete threads over a certain age. I'm not sure if it goes by last replied to or if it goes by creation date. I don't delete threads because they are old. Once its up its up. So I don't know the specifics. My computer with my files is out of town right now so I can't look. You might want to read throught the doexpire.php. Don't change anything without having a back up copy though. The files pretty document what they are doing pretty well so you might read through it and decide that is what you need.

The doexpire goes by last reply date. I use this cron to delete threads in my off-topic forum that haven't been replied to in 7 days. You can access this setting in your admin section under "Edit or Delete a forum."

If you are viewing them from the admin menu - using the "viewexpthreads.php" script they will be ordered by the date posted and not reply.

Backup your script first - and try this:

Open /admin/viewexpthreads.php in a text editor.

## Change this:


ORDER BY t1.B_Posted DESC


## To this:


ORDER BY t1.B_Last_Post DESC


that should do the trick - sorting by the last post to the thread. If they seem "upside down" you can do this instead:

ORDER BY t1.B_Last_Post ASC

Many thanks folks and especially to Joshpet - it worked a treat, many thanks.