[Reverend]

Does anyone know which part of the following code i need to edit so that it adjusts the registered joindate to compensate for an offset timezone.
My board is set for -5 hours.At the moment the members registered today total doesn't refresh until 5am.I want to edit the code so that the total refreshes at midnight.

<?php

// Hack made by Psico

if ($action=="+++++gistered") {
	include("./global.php");

$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");

while ($membersreg = $DB_site->fetch_array($registrations)):
	if (($counter++ % 2) != 0) {
				$backcolor="#F1F1F1";
				$bgclass="alt1";
			} else {
				$backcolor = "#DFDFDF";
				$bgclass="alt2";
			}
eval("\$registered .= \"".gettemplate("+++++gisterbit")."\";");
endwhile;
}
eval("dooutput(\"".gettemplate("+++++gister")."\");");
?>