SQLDrill.com - Excel Addin for using SQL

Microsoft® Excel® based database addin

 

Go Back   SQL Drill Excel Add-in > Database Specific > MYSQL with SQL Drill

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-25-2009, 06:05 PM
admin's Avatar
Administrator
 
Join Date: Apr 2008
Posts: 325
Default check signatures in vbulletin / MYSQL

Hi guys
here is a usefule query to check user signatures in vbulletin.. Have to do this due to the spammers unfortunately.. Spammers keep putting in p0rn related links so for the time being have to go in an delete them.
Code:
Select sigparsed.userid, sigparsed.styleid, sigparsed.languageid,
  sigparsed.signatureparsed, sigparsed.hasimages
From sigparsed
Limit 0, 30
__________________
SQL Drill Support
www.sqldrill.com

Reply With Quote
  #2 (permalink)  
Old 04-25-2009, 06:07 PM
admin's Avatar
Administrator
 
Join Date: Apr 2008
Posts: 325
Default

for vbulletin users, another useful table to check for spammers is the user table where there is a "homapage" field...

Code:
Select user.userid, user.username, user.homepage
From user
WHERE user.homepage <> ""
Limit 0, 30
__________________
SQL Drill Support
www.sqldrill.com

Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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


All times are GMT. The time now is 04:08 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0 |Website Pricer