[Sands]

pawn Код:

CMD:top(playerid, params[])
{
    mysql_query("SELECT `Score`, `Playername` FROM `#MYSQL_TABLE` ORDER BY `Score` DESC LIMIT 10");
    mysql_store_result();

    new
        ID,
        output[800];

    while(mysql_retrieve_row())
    {
        ID ++;

        new
            Name[24],
            scorevariable[80];

        mysql_fetch_field_row(Name, "Name");
        mysql_fetch_field_row(scorevariable, "pScore");

        format(output, sizeof(output), "%s%d. %s %d Score\n", output, ID, Name, strval(scorevariable));
    }
    mysql_free_result();

    ShowPlayerDialog(playerid, DIALOG_TOP, DIALOG_STYLE_MSGBOX, "Top 10 Players", output, "OK", "");
    return 1;
}