• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 links in signatures

#1
Is there a way in Xenforo to search my members and come up with a list of what users have links in their signatures? I am looking for a way to audit and get rid of site linking bots.
 

CTXMedia

Formerly CyclingTribe
#3
If it helps this SQL query should find all users who have a signature and which also contains http somewhere in the text:

Code:
SELECT * FROM `xf_user_profile` WHERE `signature` != '' AND `signature` LIKE '%http%';