December 10, 2018 in Technical Problems
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 ...
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
@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!
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.
I will give that a try ... thank you. Can I do this if I'm on a cloud account?
The SQL toolbox is a tool that's built into the ACP and probably purposely dedigned for cloud accounts.
This topic is now archived and is closed to further replies.
Started 2 hours ago
Started 4 hours ago
Started Yesterday at 02:27 PM