[Bondage]

Here i'm trying to display top ten online players list but fails

pawn Код:

CMD:top10on(playerid, params[])
{
    new full_info[500];
    for(new row, rows = cache_get_row_count(mysql); row < rows; row ++)
    {
        new
            username[MAX_PLAYER_NAME + 1],
            pphour,
            ppmins,
            ID,
            sub_info[50]
        ;
        ID ++;
        cache_get_field_content(row, "user", username, mysql);
        pphour = cache_get_field_content_int(row, "phours", mysql);
        ppmins = cache_get_field_content_int(row, "pminutes", mysql);

        format(sub_info, sizeof(sub_info), "%s"ccwhite"%d. %s with "ccgreen"%d "ccwhite"hours, "ccgreen"%d "ccwhite"minutes\n", row + 1, ID, username, pphour, ppmins);
        strcat(full_info, sub_info);

    }
    ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Top 10 Online", full_info, "OK", "Cancel");
    return 1;
}

This is what shows in the log

Quote:

[22:08:13] [DEBUG] cache_get_row_count - connection: 1 [22:08:13] [WARNING] cache_get_row_count - no active cache

Why is that error, how could it be fixed?

[J0sh...]

You aren't sending a query.

[Bondage]

Can ya show how the code would get rearranged

[d1git]

PHP код:

CMD:top10on(playerid, params[])
{
    new query[100];
    mysql_format(connection, query, sizeof(query), "SELECT * FROM TableName ORDER BY pHours LIMIT 10;");
    mysql_tquery(connection, query, "top10onQ", "d", playerid);
    return 1;
}
forward top10onQ(playerid);
public top10onQ(playerid)
{
    for(new i=0; i<cache_get_row_count(); i++)
    {
        new
            username[MAX_PLAYER_NAME + 1],
            pphour,
            ppmins,
            sub_info[50]
        ;
        GetPlayerName(playerid, username, sizeof(username));
        cache_get_field_content(i, "user", username);
        pphour = cache_get_field_content_int(i, "phours");
        ppmins = cache_get_field_content_int(i, "pminutes");
        format(sub_info, sizeof(sub_info), "%s"ccwhite"%d. %s with "ccgreen"%d "ccwhite"hours, "ccgreen"%d "ccwhite"minutes\n", row + 1, ID, username, pphour, ppmins);
        strcat(full_info, sub_info);
    }
    ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Top 10 Online", full_info, "OK", "Cancel");
    return 1;
} 


This should work, might have a few typo's but you can correct those I guess... this is pretty fast but yeah.