vB 4.0.6 Visitor messages

[MonsterDK]

Hi,

Is there a modification that enables mass deletion of Visitor Messages (the ones on peoples profiles) or a way to list all the members who have Visitor messages?

I want to clear them off my forum as I've disabled the feature but from what I can see there is no way to do so?

Surely something has been created to assist with this task or locate them?

thanks in advanced...

[LifesGreatestGift]

THIS WILL ERASE ALL VISITOR MESSAGES PERMANENTLY!!!

Your userid must be in the config.php file as being able to run queries
snippit from includes/config.php
// ****** 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.
$config['SpecialUsers']['canrunqueries'] = '1';

seeing as i am userid 1, i am now able to run queries from admincp.

Go to AdminCP>Maintenance>Execute SQL Query>

Leave the dropdown as default (blank) and enter the
following in the "Manual Query" textbox

TRUNCATE visitormessage

hit continue, then on the next page verify by hitting continue again


It will say Affected Rows: 0, but it worked.

Now all visitor messages on the ENTIRE board will be permanently gone.

[MonsterDK]

Worked a treat mate.
Thanks for your help :)