1. 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

Discussion in 'XenForo Questions and Support' started by MITK, Jun 25, 2014.

  1. MITK

    MITK Member

    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.
  2. Brogan

    Brogan XenForo Moderator Staff Member

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

    CyclingTribe Well-Known Member

    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%';

Share This Page