<?php
mysql_connect("127.0.0.1","root","") or DIE ("No se pudo establecer conexion con el servidor.");
mysql_select_db("unturned") or DIE ("No se pudo conectar a la base de datos.");

$query = mysql_query("Select * from ranks order by points Desc limit 10");

echo "<table>";
echo "<tr><td>SteamId</td><td>Name</td><td>Points</td><td>CharName</td><td>Total Play Time</td><td>Balance</td></tr>";
while ($a=mysql_fetch_array($query))
{
    // Player info
    $playerInfo = mysql_fetch_array(mysql_query("Select * from playerinfo where SteamID=".$a['steamId']));
    // Uconomy
    $uconomy = mysql_fetch_array(mysql_query("Select * from uconomy where SteamID=".$a['steamId']));
    echo "<tr><td>".$a['steamId']."</td><td>".$a['lastDisplayName']."</td><td>".$a['points']."</td><td>".playerInfo['CharName']."</td><td>".$playerInfo['TotalPlayTime']."</td><td>".$uconomy['balance']."</td></tr>";
}

echo "</table>";
?>