SA-MP Forums Archive
Date in MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Date in MySQL (/showthread.php?tid=291852)



Date in MySQL - System64 - 21.10.2011

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;
}



Re: Date in MySQL - -John- - 21.10.2011

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


Re: Date in MySQL - System64 - 21.10.2011

thank you very much