[nGen.SoNNy]

Hello!

Can somebody give me an example of mysql top player order by ex: Score ?? in MSGBOX style dialog

REP++;

[nGen.SoNNy]

No Ideas

[Vince]

[SQL]select name, score from playertable order by score desc limit 5[/SQL]

I'm not in the mood to type out an entire function, so here's some pseudo-code.

pawn Код:

while( fetch row )
    sscanf/split/explode
    format tempstring
    strcat output, tempstring

showplayerdialog

Edit: damn, if I'd have seen that bump earlier I wouldn't have replied at all.

[nGen.SoNNy]

Thx! and when you have a good mood type all the example!

[SuperViper]

pawn Код:

new playerData[30], playersName[MAX_PLAYER_NAME], playersScore;
mysql_query("SELECT `name`, `score` FROM `users` ORDER BY `score`");
mysql_store_result();
while(mysql_retrieve_row())
{
    mysql_fetch_row(playerData);
    sscanf(playerData, "p<|>s[24]d", playersName, playersScore);
    // do something with 'playersName' and 'playersScore'
}
mysql_free_result();

[nGen.SoNNy]

I will try this Thx! REP++

EDIT: and if i want to order by score and money?

I made this but have some bugs Can Fix this?

pawn Код:

CMD:top(playerid, params[])
{
    new playerData[512], clanname[MAX_PLAYER_NAME], string[512], clankills;
    mysql_query("SELECT `clanname`, `clankills` FROM `clans` ORDER BY `clankills`");
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        mysql_fetch_row(playerData);
        sscanf(playerData, "p<|>s[512]d", clanname, clankills);
        // do something with 'playersName' and 'playersScore'
        format(string, sizeof(string), "%s\n"R"Clan: %s"W"Kills: %d", string, clanname, clankills);
        //SendClientMessage(playerid, ~1, string);
        ShowPlayerDialog( playerid, 1, DIALOG_STYLE_MSGBOX,"Location: Top Clans", string, "(Close)", "");
    }
    mysql_free_result();
    return 1;
}