Top 10 Karma

[Swarlog]

Código [Seleccionar] Expandir

<table width="250px;">

<?php	$connection = mysql_connect("SERVER IP", "MYSQL USER", "MYSQL PASSWORD") or die("Connection isn't available!");	mysql_select_db("MYSQL DATABASE", $connection) or die("Database isn't available!");			$q = mysql_query("SELECT * FROM characters WHERE karma > 0 AND accesslevel = 0 ORDER BY karma DESC LIMIT 10");	$i = 1;	if ($q) {		while ($char = mysql_fetch_array($q))		{			echo "<tr>";			echo "<td style='width:11px;color:#000;'>" . $i . ".</td>";			echo "<td style='width:20px;color:#000;'>" . $char['char_name'] . "</td>";			echo "<td style='width:20px;text-align:right;padding-left:22px;color:#000;'>" .$char['karma'] . "</td>";			echo "</tr>";			$i++;		}	}?>