SA-MP Forums Archive
Top Kills in Mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Top Kills in Mysql (/showthread.php?tid=61010)



Top Kills in Mysql - scooby307 - 09.01.2009

my server is in mysql.

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

thx




Re: Top Kills in Mysql - ICECOLDKILLAK8 - 09.01.2009

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


Re: Top Kills in Mysql - scooby307 - 09.01.2009

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


Re: Top Kills in Mysql - scooby307 - 09.01.2009

help?


Re: Top Kills in Mysql - Antironix - 09.01.2009

Код:
$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>";



Re: Top Kills in Mysql - scooby307 - 09.01.2009

i need this in pawn for view in game


Re: Top Kills in Mysql - ICECOLDKILLAK8 - 09.01.2009

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


Re: Top Kills in Mysql - Kriztian - 10.01.2009

Quote:
Originally Posted by ███▓▒░SKB░▒▓███
help?
And have some patience.


Re: Top Kills in Mysql - scooby307 - 10.01.2009

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


Re: Top Kills in Mysql - scooby307 - 10.01.2009

help?