- Joined
- Jun 5, 2011
- Messages
- 180
- Reaction score
- 205
It's easy as hell so it's not worth to put in release section.
You can also change it to any item ranking.
It's only remaded player ranking.
You can also change it to any item ranking.
It's only remaded player ranking.
PHP:
<?php
// table style
DEFINE("STYLE", "font: 12px Verdana, Geneva, sans-serif; color: black; text-align; center;");
$config = array(
'db_username' => '', // database username
'db_password' => '', // database password
'db_dsn' => '', // system DSN to the database
'debug' => false,
);
$conn = odbc_connect($config['db_dsn'],
$config['db_username'],
$config['db_password']);
$top = 1;
$plist = "SELECT TOP 100 Player.Name, Player.Level, Player.Specialty, Item.Num, Player.Class
FROM Player
LEFT JOIN Item
ON Player.PID=Item.PID
WHERE
[Index] = 31
ORDER BY
Item.Num DESC";
$pplist = odbc_exec($conn,$plist);
echo '<br><br><br>';
echo '<center><table width="400px" style="STYLE">';
echo '<tr style="text-align: center">
<td width="100px"><b>Rank</b></td>
<td width="100px"><b>Name</b></td>
<td width="100px"><b>Gold</b></td></tr>';
while($r = odbc_fetch_array($pplist)){
echo '<tr style="text-align: center"><td>'.$top.'</td><td>'.$r['Name'].'</td><td>'.$r['Num'].'</td></tr>';
$top++;
}
echo '</table>';
?>