[maza51]

Hello. I'm trying to make the top 10 players' statistics.
And when I take the information to the players:

PHP Code:

Format(query, sizeof(query), "SELECT * FROM 'Players' WHERE map ='%s'", currentMap); 


Then I want to write all of the chat:

PHP Code:

        decl String:Toptime[30];
        decl String:Topname[30];
        
        SQL_FetchString(hndl, 1, Topname, sizeof(Topname));
        SQL_FetchString(hndl, 2, Toptime, sizeof(Toptime));
        
        PrintToChatAll("\x05%s %s", Toptime, Topname); 


And I wrote in the chat for all players, without sorting. How to sort them in descending order?

[Silvers]

http://dev.mysql.com/doc/refman/5.0/...imization.html

[maza51]

PHP Code:

Format(query, sizeof(query), "SELECT * FROM 'Players' ORDER BY time WHERE map ='%s'", currentMap); 


so?

[Leonardo]

Originally Posted by maza51 PHP Code: Format(query, sizeof(query), "SELECT * FROM 'Players' ORDER BY time WHERE map ='%s'", currentMap);

PHP Code:

"SELECT * FROM `Players` WHERE `map` ='%s' ORDER BY `time` LIMIT 0, 10" 


Originally Posted by maza51 How to check if the player is already in the database or not?

if SELECT query return 0 rows, so player isn't in DB

[Silvers]

Yeah, try it.

[maza51]

Thank you. Work.

Another question.
How to check if the player is already in the database or not?

[maza51]

A sample can be?

[maza51]

Thanks Leonardo. Everything turned out =)

[maza51]

I did statistics on the point.


How to make rank? To specify which positions are occupied by players.

[Leonardo]

is it top10 ?

PHP Code:

new i=1;
while(SQL_FetchRow(sQuery))
{
      ...
      PrintToChat(iClient, "#%i %s with %i pts", i++, sPlayerName, iPlayerPoints)
}