Cleaning up USER THREADS AND POST

[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.