EllisLab text mark
Advanced Search
     
Member List showing Entry or no Entry
 
thefifthlion
Posted: 10 July 2012 01:01 PM   [ Ignore ]
Joined: 2011-02-18
196 posts

I want to quickly browse through members to see those who have added an entry and those who haven’t.

At first glance it doesn’t seem like the control panel provides this functionality. Would I need to create a custom template that would build the list for me? I was thinking of restricting the member_group to superadmin so no one else could see the page. Am I headed down the right path or is there an easier way so see which members have published an entry?
 
thefifthlion
Posted: 10 July 2012 01:26 PM   [ Ignore ]   [ # 1 ]   [ Rating: 0 ]
Joined: 2011-02-18
196 posts

answered my own question, see path below, be sure to restrict access to only superadmin

http://mywebsite.com/index.php/member/memberlist
 
thefifthlion
Posted: 10 July 2012 01:29 PM   [ Ignore ]   [ # 2 ]   [ Rating: 0 ]
Joined: 2011-02-18
196 posts

Even though I have superadmin status and am logged in it won’t let me sort the list. I get the following error. Any ideas?

You are not allowed to view member profiles.
 
Dan Decker
Posted: 11 July 2012 03:15 PM   [ Ignore ]   [ # 3 ]   [ Rating: 0 ]
Avatar
Joined: 2005-10-18
7340 posts

Hi thefifthlion,

The information at member/memberlist only pertains to posts to Discussion Forum. It does not reflect channel entries that a user has made.

You may be after something like Zenbu. It allows you to customize the output in the Control Panel based on several different criteria and would allow you to restrict access to Super Admins.

Cheers,

 Signature 

How may I help you?
 
thefifthlion
Posted: 11 July 2012 03:30 PM   [ Ignore ]   [ # 4 ]   [ Rating: 0 ]
Joined: 2011-02-18
196 posts

I’m simply looking for a way to sort a list of members by their entry total. I have the following code on a page (with superAdmin access only). It shows all my members but I want to show how many entries each member has and sort the list in desc order. Can you advise?

{exp:query sql="SELECT screen_name, exp_members.member_id, [b]exp_channel_entries[/b] FROM exp_members WHERE group_id = '8|4'"}
        {screen_name}, {member_id}, [b]{channel_entries_total}[/b]<br />
{/exp:query} 

 
 
Dan Decker
Posted: 12 July 2012 03:16 PM   [ Ignore ]   [ # 5 ]   [ Rating: 0 ]
Avatar
Joined: 2005-10-18
7340 posts

Hey thefifthlion,

This should get you just what you are after!

{exp:member:custom_profile_data member_id="{member_id}"}
        <p>{{screen_name}, {member_id}, {total_entries}<br /></p>
{/exp:member:custom_profile_data} 

Cheers,

 Signature 

How may I help you?
 
thefifthlion
Posted: 12 July 2012 03:28 PM   [ Ignore ]   [ # 6 ]   [ Rating: 0 ]
Joined: 2011-02-18
196 posts

Thanks Dan,

If I adjust the code you sent to group_id I get just the logged in user’s info. Otherwise the code doesn’t do anything with member_id.

I’m looking to retrieve the entrie list of all members info. I thought it might require a dynamic=“no” but that had no effect.

Other thoughts?


——————-

username1, id, 4 entries
username2, id, 2 entries
username3, id, 1 entries
username4, id, 0 entries
 
thefifthlion
Posted: 12 July 2012 03:38 PM   [ Ignore ]   [ # 7 ]   [ Rating: 0 ]
Joined: 2011-02-18
196 posts

This seems to work. Just need to sort by total entries?

<p>
{exp:query sql="SELECT screen_name, total_entries FROM exp_members WHERE group_id = '8|4' "}
        {screen_name}, {total_entries}<br />
{/exp:query}
</p> 
 
thefifthlion
Posted: 12 July 2012 05:04 PM   [ Ignore ]   [ # 8 ]   [ Rating: 0 ]
Joined: 2011-02-18
196 posts

got it, thanks for your help
 
Dan Decker
Posted: 16 July 2012 01:03 PM   [ Ignore ]   [ # 9 ]   [ Rating: 0 ]
Avatar
Joined: 2005-10-18
7340 posts

Hi thefifthlion,

Excellent, glad you have what you are looking for.

If you need anything else, just let us know!

Cheers,

 Signature 

How may I help you?