UBB.Developers Forums UBB.threads 7 Development How Do I? Delete replies and move 1000 threads

Happy new eyar, everyone!

One of my forums have +1200 threads with lots of replies.

I would like to take the 1000 oldest threads, delete all replies all move them all to a new archive forum.

How do I do this without having to detele every single reply by hand?

Whilst the Mass Move will allow you to mass move the threads - i can't think of an easy way to remove all the replies to just leave the initial post.

It might be easier to keep all the replies, when you move the threads using the above mod.

First you move them to the forum "newforum", then do an sql querry

DELETE FROM `w3t_Posts`
WHERE `B_Board` LIKE 'newforum'
AND `B_Parent` != 0

Make sure you know what you are doing when using DELETE in your database though!!!

Btw, why do you want to get rid of the replies?

I will try these suggestions. Sounds like they will work!

I´d like to delete the replies to lower the server load.

Edit Worked great with massmove and the sql command! Thanks!

Btw... the field that indicates the number of replies for the archive forum and its threads still holds the old info. Same with the old forum.

How to I set this to "0" for the archive forum and update it for the old forum?

I have to throw caution here.

Be careful with direct deletes like that. If one of the replies is listed as the "last post" in a forum, and you manually delete it. The whole forum will disappear from the main index.

Use extreme caution when manually deleting stuff from the database, often other tables will need to be adjusted as well.

If you delete posts, you'll need to recalculate the thread/reply total in the boards table, and if you're deleting replies, you'll need to readjust the number of replies in each thread, to avoid the dreaded "blank page issue" which happens when those counts get off.

Usually to delete anything in threads, multiple tables will need to be updated.... which is why it's not usually wise to use a MySQL command. You can have bigger problems later.