XF 1.3 links in signatures

[MITK]

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.

 

[Paul B]

There is no functionality which will do that.
You could try querying the database directly.

 

[CTXMedia]

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

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