[System64]

Ok, I'm finishing my custom ban system and I have field date in witch I store date when I ban user, I have in game ban and in ACP, so I made when player connect and he is banned he got dialog with ban inf. but it doesn't show date corectly, what to do?

pawn Код:

stock CustomBanCheck(playerid)
{
    new name[MAX_PLAYER_NAME], administrator[MAX_PLAYER_NAME], reason[128], date[11], bstring[256];
    format(Query, sizeof(Query), "SELECT * FROM `bans` WHERE `Banned` = '%s' LIMIT 1", mysql_get_name(playerid));
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_fetch_row_format(Query, "|"))
        {
            mysql_fetch_field_row(name, "Banned");
            mysql_fetch_field_row(administrator, "Administrator");
            mysql_fetch_field_row(reason, "Reason");
            mysql_fetch_field_row(date, "Date");
        }
        format(bstring, sizeof(bstring), "{F81414}Name: {FFFFFF}%s\n{F81414}Administrator: {FFFFFF}%s\n{F81414}Reason: {FFFFFF}%s\n{F81414}Date: {FFFFFF}%d", name, administrator, reason, date);
        ShowPlayerDialog(playerid, 87, DIALOG_STYLE_MSGBOX, "     {FFFFFF}Protjerani ste s ovog servera!", bstring, "Ok", "");
        ClearChatForPlayer(playerid);
        Kick(playerid);
    }
    mysql_free_result();
    return 1;
}

[-John-]

"date" is a string, but you are using decimal in your format

[System64]

thank you very much