|
|
|
|
Joined: Jun 2002
Posts: 670
Code Monkey
|
|
Code Monkey
Joined: Jun 2002
Posts: 670 |
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.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
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.
|
|
|
|
|
Joined: Jun 2002
Posts: 670
Code Monkey
|
|
Code Monkey
Joined: Jun 2002
Posts: 670 |
I had no idea you could do that, Josh! I've already taken care of it! Thanks!
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 5,833
Joined: January 2000
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
