Thread: 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

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