<?php
  require("includes/config.php");
  if(isset($_GET['bye'])) {
      unset($_SESSION['id']);
      header("Location: index.php");
  }
  echo template_bovenkant();
  switch ($_GET['sort']) {
      case ('money');
          $li[2] = "class=\"active\"";
          break;
      case ('');
          $li[1] = "class=\"active\"";
      break;
  }
?>
	<div class="content-container">




		<div class="left">


			<div class="intro">
				<div class="intro-content">
				<h1>Leden</h1>
				<p>Een overzicht van alle gangsters.</p>
				<ul>
<?php
echo'					<li ' . $li[1] . '><a href="members.php">Power</a></li>
					<li ' . $li[2] . '><a href="members.php?sort=money">Geld</a></li>';
?>
				</ul>
				<div class="clear"></div>
				</div>
			</div>


			<div class="box-xl">
				<div class="box">
					<table cellpadding="0" cellspacing="0" border="0" class="lijst" >
						<tr>
							<th width="20">&nbsp;</th>
							<th>Gebruikersnaam</th>
							<th>Power</th>
							<th>Geld</th>
							<th>Stad</th>
						</tr>
<?php
  $sort = ($_GET['sort'] == "money") ? ("(cash + bank)") : ("power");
  $perpagina = "50";


  if ($_GET['page'] >= 1) {
      $start = ($_GET['page'] - 1) * $perpagina;
  } else {
      $start = 0;
  }
  $query = $sql->query("SELECT power, cash, bank, health, maffia, familie, stad, rang, rangvordering, username, id FROM users WHERE verwijderd = 'Nee' ORDER BY $sort DESC LIMIT $start,$perpagina");
  $i = $start;
  while($user = $sql->fetch($query, 'assoc')) {
      $i++;
      ($own['satteliet'] == 0 && $own['spacestations'] == 0) ? ($ustad = "verborgen") : ($ustad = $steden[$user['stad']]);
      echo'					<tr>
							<td>#' . $i . '</td>
							<td><a href="profile.php?mid=' . $user['id'] . '" onmouseover="Tip(\'
<table width="300" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="35%">Naam:</td>
<td>' . checkspecial($user['id']) . ' ' . $user['username'] . '</td>
</tr>
<tr>
<td width="35%">Gezondheid:</td>
<td><img src="icons/gezondheid.png" /> ' . $user['health'] . '%</td>
</tr>
<tr>
<td width="35%">Power:</td>
<td><img src="icons/power.png" /> ' . $user['power'] . '</td>
</tr>
<tr>
<td width="35%">Bescherming:</td>
<td><img src="icons/bescherming.png" /> ' . $user['maffia'] . '</td>
</tr>
<tr>
<td width="35%">Geld (contant):</td>
<td><img src="icons/geld.png" /> ' . $user['cash'] . ',-</td>
</tr>
<tr>
<td width="35%">Geld (bank):</td>
<td><img src="icons/bank.png" /> ' . $user['bank'] . ',-</td>
</tr>
<tr>
<td width="35%">Familie:</td><td><img src="icons/familie.png" /> ' . $user['familie'] . '</td>
</tr>
<tr>
<td width="35%">Stad:</td>
<td><img src="icons/stad.png" /> ' . $ustad . '</td>
</tr>
<tr>
<td width="35%">Rang:</td>
<td><img src="images/icons_gif/lightning.gif" /> ' . $user['rang'] . ' (' . $user['rangvordering'] . '%)</td>
</tr>
</table>", TITLE, "<font color="#000000">' . $user['username'] . 's profiel</font>", BGCOLOR, "#d7cdb0", FONTCOLOR, "#000000", FONTSIZE, "8pt", FONTFACE, "Verdana", BORDERCOLOR, "#d7cdb0")"
onmouseout="UnTip()">' . checkspecial($user['id']) . '</a> ' . betaald($user['id']) . '</td>
							<td>' . groot($user['power']) . '</td>
							<td>&euro; ' . groot($user['cash'] + $user['bank']) . '</td>
							<td>' . $ustad . '</td>
						</tr>';
  }
?>
					</table>


				</div>
			</div>


			<div class="paginanav">
				<ul >
<?php
  $users = $sql->query("SELECT id FROM users");
  $paginas = ceil(mysql_num_rows($users) / ($perpagina));
  if(empty($_GET['page'])) {
      $_GET['page'] = 1;
  }
  if ($_GET['page'] > 1) {
      echo "<li><a href=\"members.php?page=" . ($_GET['page'] - 1) . "&sort=" . $_GET['sort'] . "\">vorige</a>";
  } else {
      echo "<li class=\"inactive\">vorige</li>";
  }
  for ($i=1;$i<=$paginas;$i++) {
      if ($_GET['page'] == $i) {
          echo '<li class="active">' . $i . '</li>';
      } else {
          echo '<li><a href="members.php?page=' . $i . '&sort=' . $_GET['sort'] . '">' . $i . '</a>';
      }
  }
  if ($_GET['page'] < $paginas) {
      echo "<li><a href=\"members.php?page=" . ($_GET['page'] + 1) . "&sort=" . $_GET['sort'] . "\">volgende</a></li>";
  } else {
      echo "<li class=\"inactive\">volgende</li>";
  }
?>
				</ul>
			</div>


		</div>
		<div id="menu" class="personal" >


<?php
  echo template_personal_content();
  echo template_onderkant();
?>