[SyS]

Quote:

Originally Posted by Loinal PHP код: CMD:admlevel10(playerid, params[]) {     new Cache:results, rows;     results = mysql_query(mysql, "SELECT user FROM players WHERE Admin = 10");     rows = cache_num_rows();     if(rows) {         new             output[800];         for(new i; i < rows; i++) {             new                 username[24];             cache_get_value_name(i, "Username", username);             format(output, sizeof(output), "%s %s\n", output, username);         }         ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Level 10 Admins", output, "OK", "Cancel");     }     else ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Level 10 Admins", "No Admins of this level.", "OK", "Cancel");     cache_delete(results);     return 1; }  It says Код: No Admins of this level. and /admins says Код: Martex [Level 10] (ServerOwner)

Take a look @ your code (red part)

Код:

CMD:admlevel10(playerid, params[])
{
    new Cache:results, rows;
    results = mysql_query(mysql, "SELECT user FROM players WHERE Admin = 10");

    rows = cache_num_rows();

    if(rows) {

        new
            output[800];

        for(new i; i < rows; i++) {

            new
                username[24];

            cache_get_value_name(i, "Username", username);

            format(output, sizeof(output), "%s %s\n", output, username);
        }
        ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Level 10 Admins", output, "OK", "Cancel");
    }
    else ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Level 10 Admins", "No Admins of this level.", "OK", "Cancel");
    cache_delete(results);
    return 1;
}

Also dont declare variables inside the loop and usage of id variable is not needed use i instead.

PHP код:

CMD:admlevel10(playerid, params[])
{
    static  Cache:results,
              rows;
    results = mysql_query(mysql, "SELECT user FROM players WHERE Admin = 10");
    rows = cache_num_rows();
    if(rows) {
        new
            output[800];          
       static username[24];
        for(new i; i < rows; i++) {
           
            cache_get_value_name(i, "user", username);
            format(output, sizeof(output), "%s %s\n", output, username);
        }
        ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Level 10 Admins", output, "OK", "Cancel");
    }
    else ShowPlayerDialog(playerid, 1101, DIALOG_STYLE_MSGBOX, "Level 10 Admins", "No Admins of this level.", "OK", "Cancel");
    cache_delete(results);
    return 1;
} 


Also using strcat would be more perfect than format as it use less memory.