connect_error) { die("Connection to mysql database failed: " . $conn->connect_error); } $result = $conn->query( "SELECT" . " `build_slaves`.`name`," . "`build_slaves`.`operator`," . "`package_sources`.`pkgbase`," . "`build_slaves`.`last_connection`" . " 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`" ); 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 "\n"; } } print "
nameoperatorcurrently buildinglast connection
".$row["name"]."".$row["operator"]."".$row["pkgbase"]."".$row["last_connection"]."
\n"; ?>