Troubleshooting vBulletin Problems Discuss deleting the visitor messages a spammer left in the vBulletinSetup Information forums; I've had to ban and/or delete some trolls and spammers in the past few weeks--some by One Touch Ban and Clean, others through the control panel--and today discovered some had ...

[Soliloquy]

I've had to ban and/or delete some trolls and spammers in the past few weeks--some by One Touch Ban and Clean, others through the control panel--and today discovered some had left visitor messages for other members that weren't cleaned up even after deleting all their posts. Is there any easy way to hunt down and delete them all? Maybe a sql query?

[Nick R]

Sure thing. Run this query:

DELETE FROM visitormessage WHERE userid=X;

Where X is the UserID of the user.

To run SQL Queries:
AdminCP -> Maintenance -> Execute SQL Query

Ensure you have permissions to execute/run SQL Queries by editing the */includes/config.php file and change X to your user ID.

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
 = 'X';

[Soliloquy]

saving that in my file of useful sql queries, thanks!

[lifeinitaly]

I just had the same problems and found this answer - well if the spammer id is lets say 888
the sql should be
DELETE FROM visitormessage WHERE postuserid=888;
Not Userid

anyway run first SELECT FROM visitormessage WHERE postuserid=X;
Just to see what you are deleting

My question is then : there is another table called vistiromessage_hash if I run the above sql will this effect the visitormessage_hash table ??