Connect with Facebook
Go Back   vBulletin Setup > vBulletinSetup Information > vBulletin Hacks & Questions


Please Register to get full access to the forums.
Reply
 
LinkBack Thread Tools Display Modes
Old 10-10-2008, 10:34 PM   #1
vBulletin Owner
 
Soliloquy's Avatar
 
Join Date: Jun 2007
Location: New York City
Posts: 2,693
Recipes: 60
Soliloquy is a jewel in the rough
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
Soliloquy is offline   Reply With Quote
Old 10-12-2008, 08:06 PM   #2
vBulletin Owner
 
Nick R's Avatar
 
Join Date: May 2008
Location: Florida
Posts: 400
Nick R is a jewel in the rough
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';
Nick R is offline   Reply With Quote
Old 10-14-2008, 11:55 PM   #3
vBulletin Owner
 
Soliloquy's Avatar
 
Join Date: Jun 2007
Location: New York City
Posts: 2,693
Recipes: 60
Soliloquy is a jewel in the rough
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
Soliloquy is offline   Reply With Quote
Old 07-01-2009, 10:49 AM   #4
vBulletin Owner
 
lifeinitaly's Avatar
 
Join Date: Jul 2007
Location: Rockville MD
Posts: 10
lifeinitaly will become famous soon enough
Re: deleting the visitor messages a spammer left

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 ??
__________________
http://my.lifeinitaly.com

Last edited by lifeinitaly; Yesterday at 07:50 PM.
lifeinitaly is offline   Reply With Quote
Reply

Tags
deleting, left, messages, spammer, visitor

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 05:58 PM
If a spammer fails to spam, is he really a spammer? Soliloquy Community Forum Management 21 09-15-2008 10:16 AM
Postbit_Legacy (right and left) Norman vBulletin Hacks & Questions 4 07-06-2008 05:22 PM
People sending visitor messages instead of private messages vwdforum vBulletin Hacks & Questions 8 03-27-2008 06:36 AM


All times are GMT -6. The time now is 10:02 PM.

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