"`ssh_log`.`date`", "build slave" => "`build_slaves`.`name`", "action" => "`ssh_log`.`action`", "parameters" => "`ssh_log`.`parameters`" ); $join = " LEFT JOIN `build_slaves` ON `ssh_log`.`build_slave`=`build_slaves`.`id`"; } else { $to_show = "email"; $columns = array( "date" => "`email_log`.`date`", "action" => "`email_actions`.`name`", "count" => "`email_log`.`count`", "success" => "`email_log`.`success`", "person" => "`persons`.`name`", "comment" => "`email_log`.`comment`" ); $join = " LEFT JOIN `email_actions` ON `email_log`.`action`=`email_actions`.`id`" . " LEFT JOIN (`gpg_keys`" . " JOIN `persons` ON `gpg_keys`.`owner`=`persons`.`id`" . ") ON `email_log`.`gpg_key`=`gpg_keys`.`id`"; } if (isset($_GET["from"])) $min_time = $_GET["from"]; elseif ($to_show == "email") $min_time = "1 00:00:00"; else $min_time = "00:42:00"; $query = "SELECT "; foreach ($columns as $name => $column) $query .= $column . " AS `".$name."`,"; $query = substr($query,0,-1); $query .= " FROM `" . $to_show . "_log`" . $join . " WHERE TIMEDIFF((" . // NOW() is wrong here - due to differing time zones O.o "SELECT MAX(`l`.`date`) FROM `" . $to_show . "_log` AS `l`" . "),`" . $to_show . "_log`.`date`) < from_base64(\"" . base64_encode( $min_time ) . "\")" . " ORDER BY `" . $to_show . "_log`.`date` DESC"; $result = mysql_run_query($query); ?> $column) { print " \n"; } ?> fetch_assoc()) { print " \n"; foreach ($row as $val) { print " \n"; } print " \n"; } ?>

\n"; print " " . $label . "\n"; print "
\n"; print " " . $val . "\n"; print "