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`" . " 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 "
name
operator
currently building
last connection
logged lines
\n"; while ($row = $result -> fetch_assoc()) { foreach ($row as $key => $value) { if ($value=="") { $row[$key]=" "; } } print "
"; print "
".$row["name"]."
"; print "
".$row["operator"]."
"; print "
".$row["pkgbase"]."
"; print "
".$row["last_connection"]."
"; print "
".$row["logged_lines"]."
"; print "
\n"; } } print "
\n"; ?>