Lately my site has become a target of posters of a Chinese footware reseller ... amoung other things

Both the blog and the forum has been ``attacked`` by various spammers leaving excessive number ofposting and comments.  The following are the steps I have taken to remove the unwanted entries.

Currently this site is a rather dated - but functional - DNN 4.9.4 - so these steps may not working the more currently versions of DNN, but the methods may prove helpful.

NOTE:  These tips use T-SQL to update the DNN database directly.  I recomend backup the database prior to any changes.  Also, both the blog module and the forum module provide a method to delete individual entries.  If the number of entries is low, you may want to use that method.

Cleaning the forum

1) determine the userid of the user entring the posts. 

2) Via the User Manager I unathorize the user to stop future posting.  However typically they will just register another account.

3) Using the Host SQL module I get a list of PostIDs as follows:

Select * from dbo.Forum_posts where userid = 1234

4) Still using the Host SQL module I execute the appropriate stored procedure to delete the post

Exec dbo.Forum_Post_Delete 1111,  3, `spam`, 2

where 1111 is the postid, 3 is the admin id, `spam` is the reason for deleting, 2 is the portalID containing the posts.  Repeat the execution of the procedure changing the PostID based on the list from step 3.  Luckly, I had not had many so I do it manually , however it would not take much to create a new procedure to delete all post for a userid.  NOTE: You will need to change the value of the Admin UserID and the PortalID to match your site.

Cleaning the Blog comments

1) Attempt to determine the UserID of the user posting the comments

2) Unathorize the User to ensure no new comments.

3) Using the Host SQL module delete all the post by the user

Delete dbo.Blog_Comments where UserID = 1234

Hope this helps
Paul