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
PHP Code:
// ****** 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
Code:
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.