looking to delete all blog posts by user

[Lpspider]

I'm trying to delete all blog posts by certain users. In the past they used a spam bot to create 10,000's of blog posts with spam. Vbulletin by default has no way to do this.

Is there an existing mod or method you've used?

[WorldCraft]

Go to the user's profile and click "View Blog Entries"

On the list of blogs, click the Inline Mod dropdown and choose Select All

Scroll to bottom and in Moderation dropdown, delete and choose method of deletion

Unfortunately, you will have to do Select All for each page. If there are truly 10,000 blog posts, there may be another way (via SQL query or some other method. I would advise you seek vBulletin's official support for that though as deleting directly from the database can cause major issues)

Once you do get them deleted, I'd advise you up your anti-spam measures. Question/Answer verification is one of the best methods vB has built in. Pick at least 5 good, but simple questions (not what is 2+2). Also, there are a variety of great spam protection products here such as Spam-o-Matic which help block spambots from even registering in the first place.

[Lpspider]

It is literally 10,000s. Maybe around 40,000. I've long since plugged the issue, so there are no new spam blog posts being made.

The inline method will take far to long, unfortunately. It only shows a few blog entries per page. I guess I'm going to have to look for a sql query.

If anyone reading this is interested, I'd be willing to pay someone for a custom mod to delete all blog posts by a user or to set up the proper sql query.

[DoubleGlasses]

So this mod apparently can do it - but I'm struggling to get the step in response #36 to do the trick. It works beautifully on forum posts....

https://vborg.vbsupport.ru/showthread.php?p=2295100

[Lynne]

If you need help with a modification, you should post in the modification thread.