Mass Remove Visitor Messages AFTER You've Deleted Their Profile?

[toneloc]

I have vbulletin 3.8.7.

After I deleted a user/spammer, I realized later that he left tons of spam visitor messages on other members profiles.

I've removed tons of them manually, one by one, but it's a long painful process.

Is there any way to mass delete any users "visitor messages" AFTER I've deleted them?

Anyone know of a mod to do this?

Thanks!

P.S. Now, before I delete a spam user I "Delete all visitor messages."

[kh99]

I think what you can do is a query like:

DELETE FROM visitormessage WHERE postusername = 'username'

where you'd replace username with the actual name. Of course you should be careful to get it right so you don't accidentally remove anyone else's messages. You could first change "DELETE" to "SELECT *" and check to see if the results look like what you want to remove.

[toneloc]

Originally Posted by kh99

I think what you can do is a query like:

DELETE FROM visitormessage WHERE postusername = 'username'

where you'd replace username with the actual name. Of course you should be careful to get it right so you don't accidentally remove anyone else's messages. You could first change "DELETE" to "SELECT *" and check to see if the results look like what you want to remove.

THanks for your response. Can you tell me where I can do that query inside the admin control panel?

[kh99]

You can only do it from the admin cp if your userid is listed in the includes/config.php file 'canrunqueries' variable, that looks like this:

$config['SpecialUsers']['canrunqueries'] = '';

if your id is there, then "Execute SQL Query" will appear under the Maintenance menu. You might also be able to do it from outside vb using phpadmin, for example, depending on what kind of hosting setup you have.

Edit: obviously they make it a little difficult because it's dangerous. If you have any doubt about it you should make a backup before doing anything.

[toneloc]

Hello,

Thanks for walking me through that.

I ran a query from the vbulletin admin cp and got this:

Message
Affected Rows: 6,359 (0.5059s)

That's all that came up. I didn't see any messages that I was able to delete.

[kh99]

Yeah, that's all it does is tell you how many rows were affected, but they should be gone now. Hopefully those were the correct messages, but unfortunately there's no way to know without looking where they used to be. I guess you could look around and make sure everyone's vistor messages look OK.

You could do this:

SELECT * FROM visitormessage WHERE postusername = 'username'

and if you get no results, then you've succeeded.

[toneloc]

Originally Posted by kh99

Yeah, that's all it does is tell you how many rows were affected, but they should be gone now. Hopefully those were the correct messages, but unfortunately there's no way to know without looking where they used to be. I guess you could look around and make sure everyone's vistor messages look OK.

You could do this:

SELECT * FROM visitormessage WHERE postusername = 'username'

and if you get no results, then you've succeeded.

You know... I think they're all gone! I put one profile up for an example to my Mods on what to look out for and that profile is clean as a whistle now without the spam message from that user that was deleted.

You saved me hours and hours of work! You are my hero, man! Thanks a bazillion!:up: