connect_error) { die("Connection to mysql database failed: " . $conn->connect_error); } if (!$result = $conn->query( "SELECT" . " `build_slaves`.`name`," . "`build_slaves`.`operator`," . "`package_sources`.`pkgbase`," . "`build_slaves`.`last_connection`," . "`build_slaves`.`logged_lines`," . "`build_slaves`.`last_action`" . " FROM `build_slaves`" . " LEFT JOIN `build_assignments` ON" . " `build_slaves`.`currently_building`=`build_assignments`.`id`" . " LEFT JOIN `package_sources` ON" . " `build_assignments`.`package_source`=`package_sources`.`id`" . " ORDER BY `build_slaves`.`last_connection`" )) die($conn->error); print "\n"; if ($result->num_rows > 0) { print "\n"; while ($row = $result -> fetch_assoc()) { foreach ($row as $key => $value) { if ($value=="") { $row[$key]=" "; } } print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "\n"; } } print "

name	operator	currently building	last connection	logged lines	last action
".$row["name"]."	".$row["operator"]."	".$row["pkgbase"]."	".$row["last_connection"]."	".$row["logged_lines"]."	".$row["last_action"]."

\n"; ?>