<?php


echo'
<div id="content_top"> </div>
		<div id="content">
<h1 class="titel">Familie lijst</h1>';
  echo'
       <table width="100%" cellpadding="0" cellspacing="0">
         <tr>
           <td class="start">Familie naam</td>
           <td class="start" width="16">&nbsp;</td>
           <td class="start">Eigenaar</td>
           <td class="start" width="16">&nbsp;</td>
           <td class="start">Power</td>
           <td class="start" width="16">&nbsp;</td>
           <td class="start">Geld</td>
         </tr>';
  function rnatsort(&$a){
    if(is_array($a)) {
      natsort($a);
      $a = array_reverse($a, true);
    }
  }


  $perpagina = 20;
  if(!isset($_GET['page'])) {
    $_GET['page'] = 0;
  }


  if ($_GET['page'] >= 0 && floor($_GET['page']) == $_GET['page']) {
    $start = $_GET['page'] * $perpagina;
  } else {
    $start = 0;
  }
  $families = mysql_query("SELECT id, naam, eigenaar, cash, bank, power FROM families ORDER BY power DESC");
  while($familie = mysql_fetch_assoc($families)) {
    $power = $familie['power'];
    $leden = mysql_query("SELECT power, login FROM users WHERE familie = '" . $familie['naam'] . "' AND familierang >= '0'");
    while($lid = mysql_fetch_assoc($leden)) {
      $power = $power + $lid['power'];
    }
    $fampower[$familie['naam']] = $power;
    $famnaam[$familie['naam']]  = $familie['naam'];
    $geld[$familie['naam']]     = $familie['cash'] + $familie['bank'];
    $eigenaar[$familie['naam']] = $familie['eigenaar'];
    $famid[$familie['naam']]    = $familie['id'];
  }
  rnatsort($fampower);
  if(mysql_num_rows($families) > 0) {
    foreach($fampower as $key => $thispower) {
      echo'
           <tr>
             <td class="list"><a href="index.php?p=familyprofile&id=' . $famid[$key] . '">' . $famnaam[$key] . '</a></td>
             <td class="list">' . online($eigenaar[$key]) . '</td>
             <td class="list"><a href="index.php?p=profile&uid=' . $eigenaar[$key] . '">' . special_check($eigenaar[$key]) . '</a></td>
             <td class="list"><img src="images/icons/lightning.gif" alt="Power"></td>
             <td class="list">' . groot($fampower[$key]) . '</td>
             <td class="list"><img src="images/icons/coins.gif" alt="Power"></td>
             <td class="list">' . groot($geld[$key]) . '</td>
           </tr>';
    }
  }
  echo"</table><center>";
  $users = mysql_query("SELECT id FROM families");
  $paginas = floor((mysql_num_rows($users)-1)/($perpagina));
  if($paginas >= 0) {
    if($_GET['page'] > 0) {
      echo"<a href=index.php?p=families&page=" . ($_GET['page'] - 1) . ">&laquo; Vorige</a>";
    } else {
      echo"&laquo; Vorige";
    }
    for($i=0;$i <= $paginas;$i++) {
      if($_GET['page'] == $i) {echo' | <b>';echo $i+1 .'</b>';} else {echo' | <a href="index.php?p=families&page='. $i .'">'; echo $i+1 .'</a>';}
    }
    if($_GET['page'] < $paginas) {
      echo" | <a href=index.php?p=families&page=";
      echo $_GET['page']+1 . ">Volgende &raquo;</a>";
    }
    else {
      echo" | Volgende &raquo;";
    }
  }
  echo'</center>
		</div>
		<div id="content_bottom"> </div>';
?>