UBB.Dev
Posted By: donJulio SQL to delete all of one user's messages? - 02/13/2005 10:49 PM
My board got spammed by one person offering to sell illegally copies Spanish soap operas. I wasn't so bother that it's ethically wrong, but they posted the identical topic in 24 different forums.

Is there an SQL commaned to remove all these messages from the database w/o me deleting them one at a time? Their user id is 7587.
Posted By: JoshPet Re: SQL to delete all of one user's messages? - 02/13/2005 10:50 PM
You mean posts or private messages? You can prune topics by user id in 6.5. I wouldn't recommend a direct MySQL query for posts as the forum counts will all be off and it could screw up your pagination.
I had no idea you could do that, Josh! I've already taken care of it! Thanks!
© UBB.Developers