The recent posts block shows time as FROM_UNIXTIME. Is there a way I could change this to GMT + X. I have tried things such as FROM_UNIXTIME+10 etc but these are a real no no.

Any help would be appreciated please.

Thank you.

does it show FORUM_UNIXTIME where the time should be displayed?? OR is your time just off?

could u be more specific please

Thanks for your reply.

I am using a block which shows the last five forum topics on my nuke homepage. The server is in the US and the post times are US times. I would like to show the time as local Australian time (usually GMT+15).

Here is the line of code:

$result3 = sql_query("SELECT poster_id, FROM_UNIXTIME(post_time,'%d %M %y at %h:%i %p') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id'", $dbi);

hi i would also like to know how to fix this
cheers

no1 any ideas ?