[scooby307]

my server is in mysql.

How i can make Top kills in my server with this example http://pastebin.com/m5ba68e0d

thx

[ICECOLDKILLAK8]

You cant just take it off another CP, Start from cratch, its not that hard

[scooby307]

you can help me do this in pawn? to show the top 5 in the game kill

[scooby307]

help?

[Antironix]

Код:

$result = mysql_query('SELECT * FROM Users ORDER BY kills DESC');
$i=0;
echo "<center>";
echo "Top 15 - Murder Machines:";
echo "<table width='0'
    border='1'
	  font-size='10'
    cellpadding='0'
    align='center'>
   <tr>
   		<td width='80px' align='left' valign='middle'>
		<b>Name</b>
		</td>
		<td width='80px' align='left' valign='middle'>
		<b>Kills</b>
		</td>
		<td width='80px' align='left' valign='middle'>
		<b>Deaths</b>
		</td>
		<td width='80px' align='left' valign='middle'>
		<b>Times logged in</b>
		</td>
		<td width='80px' align='left' valign='middle'>
		<b>Messages</b>
		</td>
		<td width='80px' align='left' valign='middle'>
		<b>Level</b>
		</td>";
while(($row = mysql_fetch_array($result)) AND $i<15)
{
 $i++;
 echo "<tr><td width='0' align='left' valign='middle'>
		". $row['username'] ."
		</td>
		<td width='0' align='left' valign='middle'>
		". $row['kills'] ."
		</td>
		<td width='0' align='left' valign='middle'>
		". $row['deaths'] ."
		</td>
		<td width='0' align='left' valign='middle'>
		". $row['logs'] ."
		</td>
		<td width='0' align='left' valign='middle'>
		". $row['chats'] ."
		</td>
		<td width='0' align='left' valign='middle'>
		". $row['level'] ."</td>";
}
echo "<tr></table>";

[scooby307]

i need this in pawn for view in game

[ICECOLDKILLAK8]

more precise, how do you want it, text draw, game text, what size, what position

[Kriztian]

Quote:

Originally Posted by ███▓▒░SKB░▒▓███ help?

And have some patience.

[scooby307]

I need to textdraw, the textdraw is the link to pastebin, if you have not done as textdraw, may be in SendClientMessage

http://pastebin.com/m2d929eb6

thx

[scooby307]

help?