https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 09:53:38 +0000 Thu, 13 Apr 2006 17:31:17 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19286 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/mass-delete-spam-posts-by-username_topic19286_post104143.html#104143 Author: voip-dude
Subject: 19286
Posted: 13 April 2006 at 5:31pm

I have spammers posting junk on my forum and sometimes it takes me awhile before I notice. How do I mass-delete all their posts?

I've been manually searching by the spammer's username in my browser and then deleting the posts one at a time. Very tedious.

I'm on SQL Server, so I could write an SQL query to delete the post from the main entry table, but I'm not sure if there are any dependencies with other tables.

I'm surprised this isn't part of the forum administation. I'm running 7.9

Any recommendations? Is there a plugin to do this? Or does anyone know the exact SQL query to delete from the multiple tables by username?
]]> Thu, 13 Apr 2006 17:31:17 +0000 https://forums.webwiz.net/mass-delete-spam-posts-by-username_topic19286_post104143.html#104143