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

XF 1.5 Statistics of how many members have signed up with Facebook/Twitter/Google

markku

Well-known member
#1
Is there a way (MySQL search is okay too if someone can give a command) to see the number of members who have signed up / associated their accounts with Facebook / Twitter / Google?

Thanks in advance!
 

Liam W

Well-known member
#3
Count of connections per provider:
SQL:
SELECT provider, COUNT(*) AS count FROM xf_user_external_auth GROUP BY provider
Count of registered using external auth (and haven't set password manually):
SQL:
SELECT provider, COUNT(*) AS count FROM xf_user_external_auth AS external INNER JOIN xf_user_authenticate AS internal ON (internal.user_id = external.user_id) WHERE internal.scheme_class = 'XenForo_Authentication_NoPassword' GROUP BY provider
Liam
 

Mouth

Well-known member
#4
Is there a way (MySQL search is okay too if someone can give a command) to see the number of members who have signed up / associated their accounts with Facebook / Twitter / Google?
For another option; I created a usergroup called 'Social Linked' and then set a User Group Promotion for Apply This Promotion While ... user account is associated with their [social] account. Then whenever interested, just a Users Search for members of this UserGroup