MITK Member Jun 25, 2014 #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.
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 XenForo moderator Staff member Jun 25, 2014 #2 There is no functionality which will do that. You could try querying the database directly. Upvote 0 Downvote
CTXMedia Well-known member Jun 25, 2014 #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%'; Upvote 0 Downvote
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%';
