Roster

[insert_php]
$get_Founder = mysql_query(“SELECT u.ID, u.user_login, u.display_name, u.user_email FROM wp_users u INNER JOIN wp_usermeta m ON m.user_id = u.ID WHERE m.meta_key = ‘wp_capabilities’ AND m.meta_value LIKE ‘%administrator%’ ORDER BY u.user_registered”)or die(mysql_error());
while($row = mysql_fetch_array($get_Founder)) {
$displayname = $row[‘display_name’];
$username = $row[‘user_login’];
$userid = $row[‘ID’];
$avatar = get_avatar($userid, ‘305’);
$jointeamdate = ”;
$getJoinTeamDate = mysql_query(“SELECT * FROM wp_usermeta WHERE user_id=’$userid’ AND meta_key=’teamjoindate'”)or die(mysql_error());
while($row = mysql_fetch_array($getJoinTeamDate)) {
$jointeamdate = $row[‘meta_value’];
}
if($username != ‘Da11aS’) {
$title = “Admin”;
} else {
$title = “Owner”;
}
$list .= ”

$avatar

$displayname

$title
Member Since: $jointeamdate

“;

}

$get_Captain = mysql_query(“SELECT u.ID, u.user_login, u.display_name, u.user_email FROM wp_users u INNER JOIN wp_usermeta m ON m.user_id = u.ID WHERE m.meta_key = ‘wp_capabilities’ AND m.meta_value LIKE ‘%admin\”%’ ORDER BY u.user_registered”)or die(mysql_error());
while($row = mysql_fetch_array($get_Captain )) {
$displayname = $row[‘display_name’];
$username = $row[‘user_login’];
$userid = $row[‘ID’];
$avatar = get_avatar($userid, ‘305’);
$jointeamdate = ”;
$getJoinTeamDate = mysql_query(“SELECT * FROM wp_usermeta WHERE user_id=’$userid’ AND meta_key=’teamjoindate'”)or die(mysql_error());
while($row = mysql_fetch_array($getJoinTeamDate)) {
$jointeamdate = $row[‘meta_value’];
}
$title = ‘Moderator’;
$list .= ”

$avatar

$displayname

$title
Member Since: $jointeamdate

“;

}

$get_Team = mysql_query(“SELECT u.ID, u.user_login, u.display_name, u.user_email FROM wp_users u INNER JOIN wp_usermeta m ON m.user_id = u.ID WHERE m.meta_key = ‘wp_capabilities’ AND m.meta_value LIKE ‘%author%’ ORDER BY u.display_name”)or die(mysql_error());
while($row = mysql_fetch_array($get_Team)) {
$displayname = $row[‘display_name’];
$username = $row[‘user_login’];
$userid = $row[‘ID’];
$avatar = get_avatar($userid, ‘305’);
$jointeamdate = ”;
$getJoinTeamDate = mysql_query(“SELECT * FROM wp_usermeta WHERE user_id=’$userid’ AND meta_key=’teamjoindate'”)or die(mysql_error());
while($row = mysql_fetch_array($getJoinTeamDate)) {
$jointeamdate = $row[‘meta_value’];
}
$list .= ”

$avatar

$displayname

Team Member
Member Since: $jointeamdate

“;

}

echo $list;
[/insert_php]