top 5 kills in mysql
#3

Quote:
Originally Posted by nmader
Посмотреть сообщение
pawn Код:
stock ShowTopKills()
{
    new names[100],tKills[100],ID;
    mysql_query("SELECT `Username`, `Kills` FROM `Accounts` ORDER BY `Kills` DESC LIMIT 5");
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        new count = mysql_num_rows();
        while(count != 0)
        {
            new username[24],pkills[80];
            ID++;
            count--;
            mysql_fetch_field_row(username, "Username");
            mysql_fetch_field_row(pkills, "Kills");
            format(names, sizeof(names), "%s%d. i%s~n~~n~~n~", names, ID, username);
            format(tKills, sizeof(tKills), "%d~n~~n~~n~",strval(pkills));
        }
    }
    TextDrawSetString(Top1[0], names);
    TextDrawSetString(Top1[1], tKills);
    mysql_free_result();
    return 1;
}
Untested, I think it would work, but lemme know how it goes.
That crashed the server for some reason.
Reply


Messages In This Thread
top 5 kills in mysql - by Onfroi - 08.07.2014, 02:08
Re: top 5 kills in mysql - by nmader - 08.07.2014, 03:09
Re: top 5 kills in mysql - by Onfroi - 08.07.2014, 03:58

Forum Jump:


Users browsing this thread: 1 Guest(s)