SA-MP Forums Archive
Cant display FROM_UNIXTIME? - 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: Cant display FROM_UNIXTIME? (/showthread.php?tid=368294)


Cant display FROM_UNIXTIME? - Kyra - 12.08.2012

Hello, i have a problem to dispay a result sql with FROM_UNIXTIME

My code

PHP код:
stock GetDateUnban(timestamp)
{
    new query[128];
    format(query, sizeof(query),"SELECT FROM_UNIXTIME(%d,'%d %m %Y %H:%I' )",timestamp);
    mysql_query(query);
    mysql_store_result();
    new result[15];
    mysql_fetch_row(result);
    mysql_free_result();
    return result;
} 
And when i want to display this result sql

PHP код:
format(string, sizeof(string), "Unban : %s",GetDateUnban(1344800906));
ShowPlayerDialog(playerid,MESSAGE,DIALOG_STYLE_MSGBOX,"Unban Test",string,"OK","Close"); 
He dont display, he display an empty code or he display "Unban: d m Y H i"

Thx for your help and sorry my english is bad

Re: Cant display FROM_UNIXTIME? - Vince - 12.08.2012

To format a literal percent sign into a string, it must be doubled. I think it should work like this:

pawn Код:
format(query, sizeof(query), "SELECT FROM_UNIXTIME(%d, '%%d %%m %%Y %%H:%%I')", timestamp);


Re : Cant display FROM_UNIXTIME? - Kyra - 13.08.2012

Nice works now +1 thx!