[JaKe Elite]

PHP код:

stock ListCharacters(playerid)
{
    new sz_Query[128], DBResult:result, name[MAX_PLAYER_NAME], count;
    format(sz_Query, sizeof(sz_Query), "SELECT * FROM `chars` WHERE `userid` = %d", PlayerInfo[playerid][pUserID]);
    result = db_query(Database, sz_Query);
    for (count = 0; count < db_num_rows(result); count ++)
    {
        db_get_field_assoc(result, "char_name", name, MAX_PLAYER_NAME);
        format(sz_Query, sizeof(sz_Query), "%s\n", name);
        db_next_row(result);
    }
    db_free_result(result);
    
    if(count > 0) 
        SendClientMessage(playerid, COLOR_LIGHTRED, "(( Choose a character. ))") &&
        format(sz_Query, sizeof(sz_Query), "Create Character\n%s", sz_Query) &&
        Dialog_Show(playerid, LoadCharacter, DIALOG_STYLE_LIST, ""COL_GREEN"Characters List", sz_Query, "Load", "");
    else
        SendClientMessage(playerid, COLOR_LIGHTRED, "(( You have not created a character yet, Create one!") &&
        Dialog_Show(playerid, CreateCharacter, DIALOG_STYLE_INPUT, ""COL_RED"Character Name", "* You have not created a character yet, Create one!\nPlease input the name of your character:", "Create", "");
    return 1;
} 


For some reason the code above only lists one character even though the player owns two or more characters, What is with the code?

[Misiur]

pawn Код:

format(sz_Query, sizeof(sz_Query), "%s\n", name);

You are overwriting sz_Query with each new row.

pawn Код:

format(sz_Query, sizeof(sz_Query), "%s%s\n", sz_Query, name);

[JaKe Elite]

Ah, didn't noticed that. Thank you.