<?php 
// Identificacion 
$bd = mysql_connect('localhost', 'root', 'daniel');
if (!$bd) {
	die('No pudo conectarse: ' .mysql_error());
}
// Base de datos
$dbs = mysql_select_db('stats_v1', $bd);
if (!$dbs) {
	die(' No pudo conectarse: ' .mysql_error());
}
// Orden SQL
$sql = "SELECT * FROM stats_v1 ORDER BY p_kill DESC LIMIT 30";
$cdb = mysql_query($sql);
if (!$cdb){
	die('No se realizo consulta: ' .mysql_error());
}
while($base=mysql_fetch_array($cdb, MYSQL_ASSOC)){
	$players[]=$base;
}

?>
<link href="/stats/style.css" rel="stylesheet" type="text/css" />
<!-- Barra -->
<div id="btabla" align="center">
<div id="topm" align="left">Ranking Server pug</div>
<hr class="hr" />
<div id="botm" align="left">
&bull;
<a href="/stats.php" class="link, hover, visited" style="text-decoration:none">Top 30</a>&nbsp;&nbsp;
&bull;
<a href="/topRWS.php" class="link, hover, visited" style="text-decoration:none">Top RWS</a>&nbsp;&nbsp;
&bull;
<a href="/topADR.php" class="link, hover, visited" style="text-decoration:none">Top ADR</a>&nbsp;&nbsp;
&bull;
<a href="/topFPR.php" class="link, hover, visited" style="text-decoration:none">Top FPR</a>&nbsp;&nbsp;
&bull;
<a href="/toppWins.php" class="link, hover, visited" style="text-decoration:none">Top Pug Win's</a>&nbsp;&nbsp;
&bull;
<a href="/top5K.php" class="link, hover, visited" style="text-decoration:none">Top 5K</a>&nbsp;&nbsp;
&bull;
<a href="/topPoints.php" class="link, hover, visited" style="text-decoration:none">Top Points</a>&nbsp;&nbsp;
</div>
</div>
<br />
<!-- Barra -->
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" id="bodytable">
  <tr>
    <th width="2%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="POSI&Ccedil;&Atilde;O">#</th>
    <th width="10%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="NICK">Player</th>
    <th width="5%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="p_kill">F</th>
    <th width="5%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_d">D</th>
	<th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_hsp">HS</th>
	<th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_bp">BP</th>
	<th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_bd">BD</th>
	<th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_3k">3k</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_4k">4k</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_5k">5k</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="damage / max(round_p, 1)">ADR</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="damage + p_kill / max(round_p, 1)">FPR</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_w / max(pug_l, 1)">RWS</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_w">Pug Wins</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_dw">Pug Draws</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_l">Pug loses</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="pug_leaves">Pug Leaves</th>
    <th width="3%" align="center" valign="top" id="bgarriba" bgcolor="#F0F0F0" scope="col" abbr="skillpoints">Points</th>
  </tr>
    <?php $i=0;foreach($players as $player){$i++;?>

  <tr>
    <th align="center" valign="top" id="margen" class="spec<?php print ($i%2==0?'alt':'')?>" scope="row"><?php print $i?></th>
    <td align="left" valign="top" id="margen"><?php print $player["authid"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["p_kill"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["pug_d"]?></td>
	<td align="center" valign="top" id="margen"><?php print $player["pug_hsp"]?></td>
	<td align="center" valign="top" id="margen"><?php print $player["pug_bp"]?></td>
	<td align="center" valign="top" id="margen"><?php print $player["pug_bd"]?></td>
	<td align="center" valign="top" id="margen"><?php print $player["pug_3k"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["pug_4k"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["pug_5k"]?></td>
    <td align="center" valign="top" id="margen"><?php print round($player["damage"] / $player["round_p"], 1)?></td>
    <td align="center" valign="top" id="margen">
	<?php
	$fpr = round($player["p_kill"] / $player["round_p"], 3);
	print substr($fpr,1);
	 ?>
    </td>
	<td align="center" valign="top" id="margen"><?php print round($player["pug_w"] / max($player["pug_l"], 1) , 2)?></td>
    <td align="center" valign="top" id="margen"><?php print $player["pug_w"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["pug_dw"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["pug_l"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["pug_leaves"]?></td>
    <td align="center" valign="top" id="margen"><?php print $player["skillpoints"]?></td>
  </tr>
    <?php }?>
    <?php mysql_close ($bd);
	mysql_free_result ($cdb);
	?>
    

</table>
