Originally posted by [b]Akenshiro[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=218
Hello, i've find a bug with a SQL query specific.
In MySQL console, the result is good.
fin is a timestamp, and @fin*$ is the result of the DATE_FORMAT.
With this :
CODE
query_sql "SELECT DATE_FORMAT(FROM_UNIXTIME(fin), \"%e/%m/%y\"), DATE_FORMAT(FROM_UNIXTIME(fin), \"%T\") FROM recompenses WHERE ID = "+@menuId[@resultMenu - 1], @finDate$, @finHour$;
@menuId[@resultMenu - 1] is good.
I show the result with that :
CODE
mes @finDate$[0]+" Ã "+@finHour$[0];
IG, eA show this :
CODE
6.396645e-270/Success/07 Ã 19:29:05
Thank (IMG:
style_emoticons/default/smile.gif)