[Jawelin]

Originally posted by genial
[...]and replace this line:

PHP Code:

$unixtoday = $bbuserinfo[timeoffset] * 3600 + $unixtoday; 


with this:

PHP Code:

$unixtoday = $unixtoday + ($bbuserinfo['timezoneoffset'] - $timeoffset) * 3600; 


and test it again.
i hope so it will work well. please give me your feedback about it.

Excuse me.
If you make the correction to $unixtoday between the two SELECTs, you'll obtain different results from SELECT COUNT and SELECT... Shouldn't you ?

I think it should be bette place the

PHP Code:

$unixtoday = $unixtoday + ($bbuserinfo['timezoneoffset'] - $timeoffset) * 3600; 


right after the first $unixtoday = assignment.

Do you agree ?