USCJ Digital Posted December 10, 2018 Share Posted December 10, 2018 Is there a way to print out or create an Excel listing of individuals who are following a club or forum? We want to cross check to see which members of a club have actually chosen to follow the club (or at least the forum tab of the club) vs. those who have not. The scrolling list that is shown on-screen is not a great way to manage this check, and also there are individuals who are following anonymously. Any insights would be appreciated! Perhaps I should post this in the "suggestions" forum also ... Link to comment Share on other sites More sharing options...
newbie LAC Posted December 10, 2018 Share Posted December 10, 2018 SELECT m.name FROM core_follow AS f LEFT JOIN core_members AS m ON m.member_id=f.follow_member_id WHERE follow_app='forums' AND follow_area='forum' AND follow_rel_id=X; X is forum ID SELECT m.name FROM core_follow AS f LEFT JOIN core_members AS m ON m.member_id=f.follow_member_id WHERE follow_app='core' AND follow_area='club' AND follow_rel_id=Y; Y is club ID Link to comment Share on other sites More sharing options...
USCJ Digital Posted December 10, 2018 Author Share Posted December 10, 2018 @newbie LAC ... Please forgive my ignorance. This looks like code, but I have no idea where this should be inserted/how it should be used in order to accomplish the listing of followers for a club. Could you provide a few more details on the procedure you are suggesting? Thank you! Link to comment Share on other sites More sharing options...
newbie LAC Posted December 10, 2018 Share Posted December 10, 2018 Go to phpMyAdmin and run above sql-queries Or go to ACP - Support - SQL Toolbox - Run above sql-queries. For 1st query change X on forum ID. For 2nd query change Y on club ID. Link to comment Share on other sites More sharing options...
USCJ Digital Posted December 10, 2018 Author Share Posted December 10, 2018 I will give that a try ... thank you. Can I do this if I'm on a cloud account? Link to comment Share on other sites More sharing options...
Joel R Posted December 10, 2018 Share Posted December 10, 2018 Yes The SQL toolbox is a tool that's built into the ACP and probably purposely dedigned for cloud accounts. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.