[Loinal]

Hello guys i have a command to check admin levels

And its R5 i want to convert to R41-2

PHP код:

CMD:admlevel10(playerid, params[])
{
    mysql_query("SELECT user FROM playerdata WHERE level = 10");
    mysql_store_result();
    if(mysql_num_rows()) {
    new
        ID,
        output[800];
    while(mysql_retrieve_row())
    {
        ID ++;
        new
            username[24];
        mysql_fetch_field_row(username, "user");
        format(output, sizeof(output), "%s"ccwhite"%d. %s\n", output, ID, username);
    }
    mysql_free_result();
    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");}
    return 1;
} 


[BiosMarcel]

Can u please ****** for tutorials / check the R40+ wiki page?

If you encounter problems while converting (meaning you at least tried), then you can come here

[Loinal]

Quote:

Originally Posted by [Bios]Marcel Can u please ****** for tutorials / check the R40+ wiki page? If you encounter problems while converting (meaning you at least tried), then you can come here

if i found anything that i can do to convert why should i come here and post -___-

[Stev]

Marcel is saying that, Attempted to learn yourself, But if you struggle post your issues and the fellow members will assist you.

[oMa37]

This should work, But don't just copy paste.
Next time search before posting.

PHP код:

CMD:admlevel10(playerid, params[]) 
{
    new Cache:results, rows;
    results = mysql_query(connectionHandle, "SELECT user FROM playerdata WHERE level = 10");
    rows = cache_num_rows();
    if(rows) { 
    
        new 
            ID, 
            output[800]; 
        for(new i; i < rows; i++) {
            ID ++; 
            new 
                username[24];
            cache_get_value_name(i, "user", username);
            format(output, sizeof(output), "%s"ccwhite"%d. %s\n", output, ID, 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;
} 


[Loinal]

Quote:

Originally Posted by oMa37 This should work, But don't just copy paste. Next time search before posting. PHP код: CMD:admlevel10(playerid, params[])  {     new Cache:results, rows;     results = mysql_query(connectionHandle, "SELECT user FROM playerdata WHERE level = 10");     rows = cache_num_rows();     if(rows) {               new              ID,              output[800];          for(new i; i < rows; i++) {             ID ++;              new                  username[24];             cache_get_value_name(i, "user", username);             format(output, sizeof(output), "%s"ccwhite"%d. %s\n", output, ID, 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; }

1- iam not copying and pasting
2- i searched but my problem that for example "Loinal" is in R5 and in R41-2 is "Loinaal" how should i know?? :\

[Loinal]

Quote:

Originally Posted by oMa37 This should work, But don't just copy paste. Next time search before posting. PHP код: CMD:admlevel10(playerid, params[])  {     new Cache:results, rows;     results = mysql_query(connectionHandle, "SELECT user FROM playerdata WHERE level = 10");     rows = cache_num_rows();     if(rows) {               new              ID,              output[800];          for(new i; i < rows; i++) {             ID ++;              new                  username[24];             cache_get_value_name(i, "user", username);             format(output, sizeof(output), "%s"ccwhite"%d. %s\n", output, ID, 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; }

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)

[X337]

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)

Change the query to: "SELECT user FROM playerdata WHERE level = 10"

Also you said:

Quote:

Originally Posted by Loinal 1- iam not copying and pasting

You are just copy and paste oMa37's code, and you don't even change the query.

[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.

[Loinal]

Quote:

Originally Posted by X337 Change the query to: "SELECT user FROM playerdata WHERE level = 10" Also you said: You are just copy and paste oMa37's code, and you don't even change the query.

Iam not copying and also "Admin" is my variable. iam just testing it.