<style type="text/css">
.parne {
background-color:#33ccff;
}
.neparne {
background-color:#3399ff;
}
.onOver {
background-color:#fa7c00;
}
table.tab1
{
border: 1px #000000 solid;
border-collapse: collapse;
border-spacing: 0px;
width:100%;
}
table.tab1 td { border: 1px #000000 solid;}
</style>
<!-- <table align="center" width="100%" bordercolor="#00" border="1" cellspacing="0" > -->
<table class="tab1">
<tr align="left" bgcolor="#3e3e3e" style="border-bottom:solid 2px black;">
<td style="font-weight: bold; color:#fa7c00; font-size:20px;" width="7%">Rank</td>
<td style="font-weight: bold; color:#fa7c00; font-size:20px;" width="28%">Nick</td>
<td style="font-weight: bold; color:#fa7c00; font-size:20px;" width="15%">Points</td>
<td style="font-weight: bold; color:#fa7c00; font-size:20px;" width="20%">Money</td>
<td style="font-weight: bold; color:#fa7c00; font-size:20px;" width="15%">Wins</td>
<td style="font-weight: bold; color:#fa7c00; font-size:20px;" width="15%">Losts</td>
</tr>
<?php
$connect = mysql_connect("","","") or die ($error);
mysql_select_db("vx446001db") or die ($error);
$db = @mysql_query('SET NAMES UTF8');
if (isset($_GET['page'])) $page = $_GET['page']; else $page = 1;
$page = mysql_real_escape_string($page);
$start = ($page - 1) * 50;
$q = mysql_query("SELECT nick, money, points, wins, lost FROM mta ORDER BY points DESC LIMIT $start, 50");
echo "<p>Showing players with rank $start - ".($start + mysql_num_rows($q))."</p>";
$i=0;
while ($row = mysql_fetch_array($q))
{
$start = $start + 1;
if(($i%2)==0) {
$class="parne";
} else {
$class="neparne";
}
echo "<tr class=\"".$class."\" onMouseOver=\"this.className='onOver'\" onMouseOut=\"this.className='".$class."'\"><td>$start</td><td>".$row['nick']."</td><td>".$row['points']."</td><td>".$row['money']."$</td><td>".$row['wins']."</td><td>".$row['lost']."</td></tr>\n";
$i++;
}
echo "</table>";
$cq = mysql_query("SELECT userid FROM mta");
$count = mysql_num_rows($cq);
mysql_free_result($q);
mysql_free_result($cq);
$pages = ceil($count / 50 );
if ( $count <= 50 )
{}
else
{
echo "<p align=center>";
if (($page - 3 ) > 0 )
{
echo "<a href='leaderboards.php?page=".($page-3)."'> ".($page-3)." </a>";
}
if (($page - 2 ) > 0 )
{
echo "<a href='leaderboards.php?page=".($page-2)."'> ".($page-2)." </a>";
}
if (($page - 1 ) > 0 )
{
echo "<a href='leaderboards.php?page=".($page-1)."'> ".($page-1)." </a>";
}
echo " $page ";
$pagesright = $pages - $page;
$ic = 0;
while ( $ic < 3 && $pagesright > 0 )
{
$ic = $ic + 1;
$pagesright = $pagesright - 1;
echo "<a href='leaderboards.php?page=".($page + $ic)."'> ".($page + $ic)." </a>";
}
echo "</p>";
}
?>
