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++;
		}
	}
?>