prepare("SELECT id FROM builds WHERE ipaddress = ?"); $stmt->bind_param("s", $ipaddress); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows == 1) { $stmt->bind_result($buildID); $stmt->fetch(); $url = "status.php?uuid=".$buildID."&simultaneous=true"; header("Location: ".$url); } $stmt->close(); } $timezones = array(); $zonetab = file(ZONETAB); foreach ($zonetab as $buf) { if (substr($buf, 0, 1)=='#') { continue; } $rec = preg_split('/\s+/', $buf); $key = $rec[2]; $val = $rec[2]; $c = count($rec); for ($i=3;$i<$c;$i++) { $val.= ' '.$rec[$i]; } $timezones[$key] = $val; ksort($timezones); } $timezoneOption = ""; foreach ($timezones as $timezone => $description) { $timezoneOption .= "\n"; } ?>