code for offset board

[Reverend]

Can anyone tell me which part of the code below i need to edit to in order to get mktime to show a -5 hour offset.

$registrations=$DB_site->query("SELECT COUNT(*) AS count,username,userid,posts FROM user WHERE joindate > ".

mktime(0,0,0,date("m"),date("d"),date("Y")) ." GROUP BY username order by username ASC");

[Xenon]

change the third 0 into a -5

:)

[Reverend]

Thanks Xenon.

One other question.
When a new member signs up,there join date in the admincp shows the server time of -5 hours GMT.
Is there a hack i can use so that the join date shows GMT,or does the timestamp always use the server time regardless of board offset settings.

i.e Instead of join date 13.00, it shows join date 18.00.