You can, instead, just edit the templates in Admin -> Membership Profile Templates. I believe it’s Member List Page - remove the columns you don’t want. You’ll need to do the same in Member List Rows.
I suggest you back up system/member_skins/default.php first. =)
You can, instead, just edit the templates in Admin -> Membership Profile Templates. I believe it’s Member List Page - remove the columns you don’t want. You’ll need to do the same in Member List Rows.
I suggest you back up system/member_skins/default.php first. =)
That’s true, you can, but it’s a royal pain. It’s the *adding* of custom fields that doesn’t work.
Did you want a separate memberlist? Otherwise you can modify member/index (the wrapper for thees templates) to look like your site, and just edit the actual membership list. That’s the easiest way, anyway. =)
Sue, probably - I learned that before the wiki. I’ll do it tonight. It’s important to note NOT to forget the encoding in my original code paste. That HAS to be there for it work, that is the encoding of the last { in the if and /exp: thing.
To change the columns shown you would modify member list page and member list rows. To change the overall look (header, footer, etc) you’d change member/index =)
You can, instead, just edit the templates in Admin -> Membership Profile Templates. I believe it’s Member List Page - remove the columns you don’t want. You’ll need to do the same in Member List Rows.
I suggest you back up system/member_skins/default.php first. =)
it gets {content} from those membership profile templates. =)
Not sure I want to permanently alter the core list of available information. Just looking to present a small subset of the available data.
I’m thinking the query idea is looking to be the best.
Do you know the query syntax?
Here’s an example:
select exp_members.member_id, exp_members.username, exp_members.screen_name, exp_member_data.m_field_id_2 as city from exp_members, exp_member_data where exp_members.member_id = exp_member_data.member_id and exp_member_data.m_field_id_2 > '' order by exp_members.member_id asc
This will return the member_id, username, screen_name, and a field called city (which is my m_field_id_2) where there is a value for that field, ordering it by member_id in ascending order.
The key is to set the value of m_field_x to something that you’ll remember.
This example doesn’t have a lot of formatting done to it, but you’ll see what I’ve done. If you want to return more info, you add it to the select statement.
Edit: Changed code to use single quotes instead of double quotes - Sue Wednesday, October 11, 2006 07:28AM
I’ve been trying to create my own customized member list following your models/advice but I also wanted each members’ Member group title to appear by his/her name and I can’t seem to do this.
Can anyone suggest how I might succeed?
I’ve tried using this code - but I am improvising as I have no real knowledge of MY SQL syntax (clearly…):
{exp:query sql="SELECT exp_members.member_id, exp_members.group_id, exp_members.screen_name, exp_members.email, exp_member_data.m_field_id_11, exp_member_data.m_field_id_12, exp_member_data.m_field_id_13, exp_member_data.m_field_id_14, exp_member_data.m_field_id_15, exp_member_data.m_field_id_16, exp_member_groups.group_title FROM exp_members, exp_member_data, exp_member_groups WHERE exp_members.member_id = exp_member_data.member_id, exp_members.group_id = exp_member_groups.group_id ORDER BY exp_members.screen_name asc"}
The group_title field is stored in a different table, actually, which is why that won’t work. MySQL queries aren’t my bag either, so cross your fingers, heh. Remove the group_title portion from your big SQL query, and then above
<td align="center">{group_title}</td>
put
{exp:query sql="SELECT group_title FROM exp_member_groups WHERE group_id = '{group_id}'"}
