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

markku

Well-known member
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
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
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
 
Top