[PHP]Скрипт онлайн

Код:

<div class="notes"></a><h3>Сейчас в игре:</h3><table width="450" border="0" cellspacing="0" cellpadding="0"><tr><td width="380" align="left" valign="top">
<table width="100%" border="1" cellspacing="0" cellpadding="0" class="userstop">
<?php 
$databaseHost = 'localhost'; 
$databaseLogin = 'root'; 
$databasePassword = 'ПарольБД'; 
$databaseName = 'НазваниеБазы'; 
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
$result = mysql_query("SELECT name, account_id, exp, player_class, race FROM players WHERE online=1");
while ($row = mysql_fetch_array($result))
{

if($row["race"] == ASMODIANS) $race = "<img src='/images/asmodian.png' alt='Асмодиан'>";
if($row["race"] == ELYOS) $race = "<img src='/images/elyos.png' alt='Элиос'>";
printf ("".$race."<font color=green>&nbsp;<a href=# title='ID: {$row['account_id']} | Класс: {$row['player_class']} | EXP: {$row['exp']} '>%s</a></font>
", $row[0], $row[1]); } $num=mysql_numrows($result); echo "
<h3>Всего игроков: <font color=green>$num</font></h3>";
?>
</table></div></table></td></tr></table></div>

© Invision