Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted September 5, 20204 yr Was just wondering how many members make use of the google, apple etc etc login feature is there a way in acp to list all or if not is there a way to list via a mysql query ? anyone help? Edited September 5, 20204 yr by sound
September 5, 20204 yr Solution I don't believe this is accessible in the ACP, yet after making backups of your backups and running this entirely at your own risk, you could use something like the following SQL query to return the results you're looking for: SELECT substring_index(clm.`login_classname`,'\\', -1) AS LoginMethod ,count(1) AS NumberOfMembersLinked FROM `core_login_links` cll INNER JOIN `core_login_methods` clm ON clm.`login_id` = cll.`token_login_method` WHERE cll.`token_linked` = 1 /* Only those who have successfully linked */ GROUP BY substring_index(clm.`login_classname`,'\\', -1) Edited September 5, 20204 yr by Paul E. Only show those who have successfully linked