XF 1.4 Facebook registrations

[CMGDevel]

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

Thanks

 

[Paul B]

Only by checking the database.

 

[CMGDevel]

What table would that be in?

 

[Paul B]

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

 

[Chris D]

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