'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

'; echo 'Members'; echo '
'; echo 'In order to view the user\'s profile, simply click on their name.'; echo '

'; echo ''; echo '
'; echo 'Sorted by :
Alphabetically | Newest to Oldest | Nationality | Status

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $sort = $_GET['sort']; $page = $_GET['page']; $stop = 30; $logged = time() - (3600 * 24 * 7); if (!$page) $page = 1; $offset = (($page - 1) * 30); if (($sort == "alpha") || (!$sort)) { $result = getRows(users,"WHERE NPC='' and logged>='$logged' ORDER BY username ASC","LIMIT $offset, 30"); } elseif ($sort == "newest") { $result = getRows(users,"WHERE NPC='' and logged>='$logged' ORDER BY id DESC","LIMIT $offset, 30"); } elseif ($sort == "kingdom") { $result = getRows(users,"WHERE NPC='' and logged>='$logged' ORDER BY nationality DESC","LIMIT $offset, 30"); } elseif ($sort == "status") { $result = getRows(users,"WHERE NPC='' and logged>='$logged' ORDER BY status ASC","LIMIT $offset, 30"); } while ($row = mysql_fetch_array($result)) { $user = $row['id']; $username = $row['username']; $posts = numRowsConditions(posts,"WHERE username='$user' AND ooc=''") + numRowsConditions(archives,"WHERE username='$user' AND ooc=''"); $nationality = $row['nationality']; $kingdom = getInfo(name,kingdoms,"WHERE id='$nationality'"); $master = $row['master']; $masterName = getInfo(username,users,"WHERE id='$master'"); $status = $row['status']; if ($status) $status[0] = strtoupper($status[0]); if ($counter % 2 == 1) $userRead = ' bgcolor="#260000"'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $userRead = ''; } echo ''; echo ''; echo '

'; echo 'Member'; echo '	'; echo 'Status'; echo '	'; echo 'Master/Mistress'; echo '	'; echo 'Kingdom'; echo '	'; echo 'Posts'; echo '
'; echo ''.$username.''; echo '	'; echo $status; echo '	'; echo ''.$masterName.''; echo '	'; echo ''.stripslashes($kingdom).''; echo '	'; echo $posts; echo '

'; echo ''; echo '

'; $max = numRowsConditions(users,"WHERE NPC='' and logged>='$logged'"); if ($max > 30) { echo ''; echo ''; echo ''; echo '

Pages '; $pages = truncate(($max - 1)/ 30) + 1; $pstart = $page - 3; if ($pstart < 1) $pstart = 1; if ($pstart != 1) echo '1, '; $pend = $page + 3; if ($pend > $pages) $pend = $pages; if ($pstart > 2) echo '..'; for ($p = $pstart;$p <= $pend;$p++) { if ($p == $page && $page != $pend) echo $p.', '; elseif ($p == $pages) echo ''; else echo ''.$p.', '; } if ($pend < $pages - 1) echo '..'; if ($page != $pend) echo ''.$pages.''; if ($page == $pend) echo $pages; echo '

'; echo ''; } ?>