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

XF 1.4 Facebook registrations

Discussion in 'XenForo Questions and Support' started by CMGDevel, Dec 15, 2014.

  1. CMGDevel

    CMGDevel Active Member

    Is there a way to tell now many new registrations are coming in via a FB linked profile?

    Thanks
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Only by checking the database.
     
  3. CMGDevel

    CMGDevel Active Member

    What table would that be in?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    I'm not at my computer but it's something to do with external auth.
     
  5. Chris D

    Chris D XenForo Developer Staff Member

    Code:
    SELECT COUNT(*)
    FROM xf_user_external_auth AS ext
    INNER JOIN xf_user AS user ON
        (user.user_id = ext.user_id)
    WHERE ext.provider = 'facebook'
    AND user.register_date > unix_timestamp('2014-01-01')
    
    That will give you the number of Facebook registrations since 1st January 2014 (YYYY-MM-DD).

    Change the date accordingly (or remove that line to count them all).
     
    Brogan likes this.

Share This Page