[AlexMSK]

Hi all, i'm trying to make a event point system, /winers based in mysql.
So yea heres the command.

PHP код:

CMD:winers(playerid, parmas[])
{
    mysql_tquery(sql_connect, "SELECT * FROM `users` ORDER BY `eventpoints` DESC LIMIT 10", "OnQueryFinishup", "ii", THREAD_EVENTWINER, playerid);
    return 1;
}
        case THREAD_EVENTWINER:
        {
            new username[MAX_PLAYER_NAME], eventpoints[24];
            SendClientMessage(extraid, COLOR_GREEN, "---- Event Winners ----");
            for(new i = 0; i < rows; i ++)
            {
                cache_get_field_content(i, "username", username);
                cache_get_field_content(i, "eventpoints", eventpoints);
                SendClientMessageEx(extraid, COLOR_GREY2, "%s - Event points: %d", username, eventpoints);
            }
        } 


Now everything runs fine, there's no mysql error given i cant get more than 10 players in the server, it start crashing the others for some reason, probably i missed up something?

[doreto]

What OnPlayerConnect with MySQL has to do with this command ?
Either your title is misleading or you have posted wrong code.

[AlexMSK]

Nothing man i just created this command right now

case THREAD_EVENTWINER: is under OnQueryFinishup

[Hunud]

What about this and number 10 in it ?

Код:

 mysql_tquery(sql_connect, "SELECT * FROM `users` ORDER BY `eventpoints` DESC LIMIT 10", "OnQueryFinishup", "ii", THREAD_EVENTWINER, playerid);

[Banana_Ghost]

Quote:

Originally Posted by Hunud What about this and number 10 in it ? Код: mysql_tquery(sql_connect, "SELECT * FROM `users` ORDER BY `eventpoints` DESC LIMIT 10", "OnQueryFinishup", "ii", THREAD_EVENTWINER, playerid);

All the LIMIT 10 does is it finds the first 10 results from your query and thats it.