function wp_eMember_dashboard1()
{
global $wpdb;
$wp_total_members = dbAccess::findCount(WP_EMEMBER_MEMBERS_TABLE_NAME);
$fields = array('count(*)' => 'count', 'membership_level' => 'membership_level', 'alias' => 'alias');
$table = WP_EMEMBER_MEMBERS_TABLE_NAME . ' LEFT JOIN ' . WP_EMEMBER_MEMBERSHIP_LEVEL_TABLE . ' ON (membership_level=id) ';
$last5members = dbAccess::findAll($table, '', ' member_id DESC LIMIT 0,5');
$members = dbAccess::findCount($table, $fields, null, null, ' membership_level ');
$query = "SELECT COUNT(member_id) AS active FROM " . WP_EMEMBER_MEMBERS_TABLE_NAME . " WHERE account_state = 'active'";
$active_members = $wpdb->get_col($query);
?>
<table>
<tbody><tr valign="top">
<td>
<table style="width: 800px;" class="widefat">
<thead>
<tr>
<th scope="col">Membership Stats</th>
</tr>
</thead>
<tbody>
<tr>
<td>
<table cellspacing="5" cellpadding="3" width="100%">
<tbody><tr valign="top">
<td width="50%" style="border: 1px solid rgb(238, 238, 238); background: rgb(248, 248, 248) none repeat scroll 0% 0%; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; line-height: 1.5em;">
<h3 style="margin: 0pt 0pt 5px;">Membership level</h3>
<?php
if ($members) {
foreach ($members as $member) {
?>
<div style="float: left; width: 130px;"><a href="#">· <?php
echo stripslashes($member->alias);
?>
</a></div>
<div style="float: right; width: 35px; text-align: right;"><?php
echo $member->count;
?>
</div>
<br clear="all"/>
<?php
}
} else {
echo __('Nothing to show.', 'wp_eMember');
}
?>
<br clear="all"/>
<hr>
<div style="float: left; width: 130px;">· Total Members</div>
<div style="float: right; width: 35px; text-align: right;"><?php
echo $wp_total_members[0]->count;
?>
</div>
<br clear="all"/>
<div style="float: left; width: 130px;">· Active Members</div>
<div style="float: right; width: 35px; text-align: right;"><?php
echo $active_members[0];
?>
</div>
</td>
<td width="50%" style="border: 1px solid rgb(238, 238, 238); background: rgb(248, 248, 248) none repeat scroll 0% 0%; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; line-height: 1.5em;">
<h3 style="margin: 0pt 0pt 5px;">Recent 5 members</h3>
<table cellpadding="10px">
<thead>
<tr>
<th>ID</th>
<th>User</th>
<th>Level</th>
<th>Since</th>
</tr>
</thead>
<tbody>
<?php
if ($last5members) {
foreach ($last5members as $member) {
?>
<tr>
<td>
<?php
echo $member->member_id;
?>
</td>
<td>
<?php
echo stripslashes($member->user_name);
?>
</td>
<td>
<?php
echo stripslashes($member->alias);
?>
</td>
<td>
<?php
echo date(get_option('date_format'), strtotime($member->member_since));
?>
</td>
</tr>
<?php
}
} else {
echo '<tr> <td colspan="4">' . __('No Members found.', 'wp_eMember') . '</td> </tr>';
}
?>
</tbody>
</table>
<br/>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody></table>
<?php
}
