[PHP]Скрипт Богачей.

Если кому интересно.

config.php

代码:

<?
$dbip ="127.0.0.1"; // IP mysql
$dbport ="3306"; // порт mysql
$dblogin ="root"; // логин mysql
$dbpass =""; // пароль mysql
$gameserver ="au_server_gs"; // название game базы
?>

index.php

代码:

<table>
<tr>
<td><strong>Имя персонажа</strong></td>
<td><strong>Денег</strong></td>
</tr>
<?php
require_once ('config.php');
mysql_connect ("$dbip:$dbport","$dblogin","$dbpass");
mysql_selectdb ("$gameserver");
mysql_query ('set names cp1251');
$result = mysql_query ("SELECT inventory.itemId, inventory.itemCount, inventory.itemOwner, players.Id, players.admin, players.name AS players FROM inventory LEFT JOIN players ON itemOwner = players.id WHERE inventory.itemId = 182400001 AND NOT players.admin = 1 ORDER by itemCount DESC LIMIT 100");
while ($row = mysql_fetch_array ($result))
{
$ch_name = $row['players'];
$ch_money = $row['itemCount'];
echo "<tr><td><strong>$ch_name</strong></td>";
echo "<td><strong>$ch_money</strong></td></tr>";
}
?>
</table>