Go Back   vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Please Register to get full access to the forums.
Post New Thread  Reply



#1   10-10-2008, 11:34 PM
Soliloquy is a jewel in the rough Join Date: Jun 2007 Posts: 2,620 Location: New York City
iTrader: (0)
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?
--------------------
Science Chats | Disabled NYC | The Chic Petite
Quote   |  



#2   10-12-2008, 09:06 PM
Nick R has a spectacular aura about Join Date: May 2008 Posts: 143 Location: Sarasota, FL
iTrader: (0)
User-Submitted Tools: MrLogin, OnlineClock
Re: deleting the visitor messages a spammer left


Sure thing. Run this query:

Code:
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.
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   |  



#3   10-15-2008, 12:55 AM
Soliloquy is a jewel in the rough Join Date: Jun 2007 Posts: 2,620 Location: New York City
iTrader: (0)
Re: deleting the visitor messages a spammer left


saving that in my file of useful sql queries, thanks!
--------------------
Science Chats | Disabled NYC | The Chic Petite
Quote   |  
Post New Thread  Reply
vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Thread Tools
Display Modes

 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
What's the longest you've left your forum alone? Soliloquy Community Forum Management 22 09-23-2008 06:58 PM
If a spammer fails to spam, is he really a spammer? Soliloquy Community Forum Management 21 09-15-2008 11:16 AM
Postbit_Legacy (right and left) Norman vBulletin Questions 4 07-06-2008 06:22 PM
People sending visitor messages instead of private messages vwdforum vBulletin Questions 8 03-27-2008 07:36 AM


All times are GMT -6. The time now is 06:26 AM.

vBulletin Setup, vBulletin Setup Forums, vBulletin Services, vBulletin Blogs, vBulletin SEO, vBulletin Questions
vBulletin Skins, Styles, Templates, vBulletin Monetization, Blogs, vBulletin Link Directory,Quality Link Directory