ну например так:
немного стиля для красоты примера(из стилей EE):
<style type="text/css">
.memberlistRowOne {
background: #FBFBFC url(http://www.uWebSite.ru/themes/forum_themes/blue/images/bg_table_td_one.jpg)
repeat-x left top;
font-family: Verdana, Geneva, Kristian Sysikoma, Trebuchet MS, Arial, Sans-serif;
font-size: 11px;
color: #38394B;
padding: 3px 6px 3px 6px;
border-top: 1px solid #fff;
border-bottom: 1px solid #B2B3CE;
border-left: 1px solid #B2B3CE;
border-right: 1px solid #fff;
}
.memberlistRowTwo {
background: #F0F0F0 url(http://www.uWebSite.ru/themes/forum_themes/blue/images/bg_table_td_two.jpg)
repeat-x left top;
font-family: Verdana, Geneva, Kristian Sysikoma, Trebuchet MS, Arial, Sans-serif;
font-size: 11px;
color: #38394B;
padding: 3px 6px 3px 6px;
border-top: 1px solid #fff;
border-bottom: 1px solid #B2B3CE;
border-left: 1px solid #B2B3CE;
border-right: 1px solid #fff;
}
.memberlistHead {
font-family: Verdana, Geneva, Kristian Sysikoma, Trebuchet MS, Arial, Sans-serif;
font-size: 11px;
font-weight: bold;
background: #74779D url(http://www.uWebSite.ru/themes/forum_themes/blue/images/bg_profile_heading.jpg)
repeat-x left top;
color: #fff;
border-bottom: #4B5388 1px solid;
padding: 8px 0 8px 8px;
}
.memberlistFooter {
font-family: Verdana, Geneva, Kristian Sysikoma, Trebuchet MS, Arial, Sans-serif;
font-size: 11px;
color: #000;
padding: 6px 10px 6px 6px;
border-top: 1px solid #fff;
border-bottom: 1px solid #999;
border-right: 1px solid #fff;
background-color: #B8B9D1;
}
.tableBorderLeft {
border-left: 1px solid #B2B3CE;
padding: 0;
margin-top: 1px;
margin-bottom: 3px;
}
</style>
И основной код, где в основе всего лежит запрос, который вытягивает данные из таблицы exp_members (список вы можете посмотреть в конце поста или непосредственно в вашей базе). Для более удобного визуального ряда, я добавил переключатель(switch) меняющий стиль строки через одну:
<table class="tableBorderLeft" style="width: 100%;" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td class="memberlistHead" width="21%">Name</td>
<td class="memberlistHead" width="13%">Total Posts</td>
<td class="memberlistHead" width="8%">Email</td>
<td class="memberlistHead" width="8%">URL</td>
<td class="memberlistHead" width="8%">AOL</td>
<td class="memberlistHead" width="8%">ICQ</td>
<td class="memberlistHead" width="8%">Yahoo</td>
<td class="memberlistHead" width="13%">Join Date</td>
<td class="memberlistHead" width="13%">Last Visit</td>
</tr>
{exp:query sql="select member_id, avatar_filename, avatar_width, weblog_id, avatar_height, username, total_comments,
total_forum_posts, join_date, url, screen_name,last_visit from au_members order by member_id asc" limit="10"}
<tr>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}" width="20%">
<span class="defaultBold"><a href="http://www.uWebSite.ru/member/{member_id}/">{screen_name}</a></span>
</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">{total_forum_posts}</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">
<a href="http://www.uWebSite.ru/member/email_console/{member_id}/">
<img src="http://www.uWebSite.ru/themes/forum_themes/eeclub/images/icon_email.gif" alt="Email Console" title="Email Console" border="0" height="14" width="56"></a>
</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">
{url}
</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">
{aol_im}
</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">
<a href="http://www.uWebSite.ru/member/icq_console/{member_id}/">
<img src="http://www.eeclub.ru/themes/forum_themes/eeclub/images/icon_icq.gif" alt="ICQ" title="ICQ" border="0" height="14" width="56"></a>
</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">
{yahoo_im}
</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">{join_date format="%m/%d/%Y"}</td>
<td class="{switch="memberlistRowOne|memberlistRowTwo"}">{last_visit format="%m/%d/%Y"}</td>
</tr>
{paginate}
<tr>
<td class="memberlistFooter" colspan="9" align="center" valign="middle">
<div class="pagination">
{pagination_links}</div>
</td>
</tr>
{/paginate}
{/exp:query}
</tbody></table>
Список полей в exp_members
member_id
group_id
weblog_id
tmpl_group_id
upload_id
username
screen_name
password
unique_id
authcode
email
url
location
occupation
interests
bday_d
bday_m
bday_y
aol_im
yahoo_im
msn_im
icq
bio
signature
avatar_filename
avatar_width
avatar_height
photo_filename
photo_width
photo_height
sig_img_filename
sig_img_width
sig_img_height
ignore_list
private_messages
accept_messages
ip_address
join_date
last_visit
last_activity
total_entries
total_comments
total_forum_topics
total_forum_posts
last_entry_date
last_comment_date
last_forum_post_date
last_email_date
in_authorlist c
accept_admin_email
accept_user_email
notify_by_default
notify_of_pm
display_avatars
display_signature
smart_notificatio
language
timezone
daylight_savings
time_format
cp_theme
profile_theme
forum_theme
tracker
template_size
notepad
notepad_size
quick_links
quick_tabs
