<?php
$host="";
$username="";
$password="";
$database="";

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$rowsPerPage = 20;
$pageNum = 1;

if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}


$offset = ($pageNum - 1) * $rowsPerPage;

$query = " SELECT * FROM users ORDER BY RANK ASC " .
         " LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
?>
<style type="text/css">
            table.fancy {
              margin: 1em 1em 1em 0;
              background: whitesmoke;
              border-collapse: collapse;
            }
            table.fancy tr:hover {
               background: #CC0000 !important;
            }
            table.fancy th, table.fancy td {
              border: 1px silver solid;
              padding: 0.2em;
            }
            table.fancy th {
              background: #990000;
              text-align: left;
            }
            table.fancy caption {
              margin-left: inherit;
              margin-right: inherit;
            }
</style>
<table class="fancy"><center>
<tr>
            <th width="25%"><center>Name</center></th>
            <th width="15%"><center>SteamID</center></th>
            <th width="25%"><center>Rank</center></th>
</tr></center>
<?php


while($row = mysql_fetch_array($result))
{
   echo "<tr>";
   $ID = $row['ID'];
   $NAME = $row['NAME'];
   $RANK = $row['RANK'];
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo $NAME;
                        echo "</center></font></td>";
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo $ID;
                        echo "</center></font></td>";
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                       if ( $RANK == 0 ){
                            echo "<font color=\"red\"><b>Owner</b></font>";
                        }
                        elseif ( $RANK == 1 ){
                            echo "<font color=\"orange\"><b>Super Administrator</b></font>";
                        }
                        elseif ( $RANK == 2 ){
                            echo "<font color=\"green\"><b>Administrator</b></font>";
                        }
                        elseif ( $RANK == 3 ){
                            echo "<font color=\"pink\"><b>Trial Administrator</b></font>";
                        }
                        elseif ( $RANK == 4 ){
                            echo "<font color=\"blue\"><b>VIP</b></font>";
                        }
                        elseif ( $RANK == 5 ){
                            echo "Registered User";
                        }
                        echo "</center></td>";
echo "</tr>";

}




$query   = "SELECT COUNT(ID) AS numrows FROM users";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];


$maxPage = ceil($numrows/$rowsPerPage);


$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page ";
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   }
}

if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page\">[Prev]</a> ";

   $first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
   $prev  = '&nbsp;';
   $first = '&nbsp;';
}

if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page\">[Next]</a> ";

   $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
   $next = '&nbsp;';
   $last = '&nbsp;';
}


echo $first . $prev . $nav . $next . $last;



?>