Order by Join date - Order by posts ";
include LOCALE.LOCALESET."members-profile.php";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
if($order == "join"){
$orderby2 = " user_joined ASC ";
} elseif($order == "posts"){
$orderby2 = " user_posts ASC ";
} else {
$orderby2 = " user_level DESC, user_name ";
}
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
echo "
| ".$locale['401']." |
".$locale['402']." |
Posts |
Join Date | ";
if(iADMIN){
echo "Options | ";
}
echo "
\n";
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." ORDER BY ".$orderby2." LIMIT $rowstart,20");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "\n| \n".$data['user_name']." | \n";
echo "".getuserlevel($data['user_level'])." | ";
echo "".$data['user_posts']." | ".showdate("forumdate", $data['user_joined'])." | ";
if(iADMIN){
echo "Delete | ";
}
echo "\n
";
}
echo "
\n";
} else {
echo "
\n".$locale['403']."$sortby
\n\n";
}
$search = array(
"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R",
"S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9"
);
echo "
\n\n";
closetable();
if ($rows > 20) echo "".makePageNav($rowstart,20,$rows,3,FUSION_SELF."?page_id=".$page_id."&sortby=$sortby&order=".$order."&")."\n
\n";
?>