Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- mysql_connect("127.0.0.1","root","") or DIE ("No se pudo establecer conexion con el servidor.");
- mysql_select_db("pepixiko") or DIE ("No se pudo conectar a la base de datos.");
- $query = mysql_query("SELECT * FROM ranks ORDER by points DESC LIMIT 20");
- echo "<font face='Comic Sans MS'>";
- echo "<table align='center' id='borde' background='../iconos/negro.jpg'>";
- echo "<tr><td width='150' align='center'></td><td width='150' align='center'></td><td width='150' align='center'></td><td width='150' align='center'></td></tr>";
- echo "<tr><td align='center'><font color='#FFCC00' size='3'>lastDisplayName</font></td><td align='center'><font color='#FFCC00' size='3'>Puntos</font></td><td align='center'><font color='#FFCC00' size='3'>steamId</font></td><td align='center'><font color='#FFCC00' size='3'>balance</font></td></tr>";
- echo "<tr><td colspan='5'><hr align='center' /></td></tr>";
- while ($a=mysql_fetch_array($query))
- {
- $balance = mysql_fetch_array(mysql_query("Select balance from uconomy where steamId='".$a['steamId']."' limit 1"));
- echo "
- <tr>
- <td align='center'><font color='#FFFF00'>".$a['lastDisplayName']."</font></td>
- <td align='center'><font color='#FFFF00'>".$a['points']."</font></td>
- <td align='center'><font color='#FFFF00'>".$a['steamId']."</font></td>
- <td align='center'><font color='#FFFF00'>".$balance['balance']."</font></td>
- </tr>";
- }
- echo "</table>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement