Cleaning up USER THREADS AND POST

[Mrdby]

Is there anyway to CLEAN UP all DELETED USERS that have started threads and made post? I hate having threads that were started by a member that are no longer members.

[Weapon-x]

Shouldn't it just delete members post and topics when you the admin delete them manually? If not I am very curious about this. Do you have an example I can see?

[Eikinskjaldi]

When you delete a user it assigns their posts to guest.

If you delete all the posts belonging to a deleted user then it is going to play havoc with the conversations in the thread.

Generally speaking any kind of hard deletion is a bad thing and should be avoided.

[Mrdby]

phpbb uses it. but for the last poster umm this is a good mod to have..instead of going through deleting guest for ever member you delete. suppose you prune over 300 members that have posted and became inactive....you going to go through each topic started or thread to delete it?

[Weapon-x]

Originally Posted by Eikinskjaldi

When you delete a user it assigns their posts to guest.

If you delete all the posts belonging to a deleted user then it is going to play havoc with the conversations in the thread.

Generally speaking any kind of hard deletion is a bad thing and should be avoided.

Can't you just run a MySQL query? Say user 8 is guests and clean up all guests posts?

[Eikinskjaldi]

Originally Posted by Weapon-x

Can't you just run a MySQL query? Say user 8 is guests and clean up all guests posts?

Yes you can.

But like I said, why would you. What if a now deleted user (and, once again, I am having real trouble understadning why you would ever delete a user, I don't even delete spammers...just ban them) was having a conversation with another user. You are suddenly removing half the conversation.


In addition posts are referenced in other tables, thread for example remembers first and last postids and users. How do you want to handle that? what if the only poster in a thread is a deleted user, you will need to delete the thread as well, or assign the first post to someone else.

You are playing with fire here, I guess I am being less helpful than I might otherwise be because I am having trouble understanding why you would ever delete a user, let alone their posts.

[Weapon-x]

Originally Posted by Eikinskjaldi

Yes you can.

But like I said, why would you. What if a now deleted user (and, once again, I am having real trouble understadning why you would ever delete a user, I don't even delete spammers...just ban them) was having a conversation with another user. You are suddenly removing half the conversation.


In addition posts are referenced in other tables, thread for example remembers first and last postids and users. How do you want to handle that? what if the only poster in a thread is a deleted user, you will need to delete the thread as well, or assign the first post to someone else.

You are playing with fire here, I guess I am being less helpful than I might otherwise be because I am having trouble understanding why you would ever delete a user, let alone their posts.

Yeah. I just ban users too. I leave the post unless it has some mature content in it then I delete it.

But the easy way is to run a MySQL query. To get rid of old posts. Should you post the mySQL script to show people *IF* they still want to delete guest posts?

[Eikinskjaldi]

Originally Posted by Weapon-x

Yeah. I just ban users too. I leave the post unless it has some mature content in it then I delete it.

But the easy way is to run a MySQL query. To get rid of old posts. Should you post the mySQL script to show people *IF* they still want to delete guest posts?

delete from post where userid=$userid

I predict running this query will stuff up the thread table

[Weapon-x]

Originally Posted by Eikinskjaldi

delete from post where userid=$userid

I predict running this query will stuff up the thread table

Oh it will