Please Register to get full access to the forums.
 Contributor vBulletin Owner
#1
10-10-2008, 11:34 PM
deleting the visitor messages a spammer left 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? Quote |
 Supporters vBulletin Owner
#2
10-12-2008, 09:06 PM
Re: deleting the visitor messages a spammer left Sure thing. Run this query: Code: DELETE FROM visitormessage WHERE userid=X; 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. 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. = 'X'; Quote |
All times are GMT -6. The time now is 06:26 AM. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Linear Mode
