connect_error) { die("Connection failed: " . $mysql->connect_error); } if ( ! $result = $mysql -> query( "SELECT DISTINCT `architectures`.`name` AS `architecture`,`package_sources`.`pkgbase`,`build_assignments`.`is_black_listed` " . "FROM `build_assignments` " . "JOIN `architectures` ON `build_assignments`.`architecture`=`architectures`.`id` " . "JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` " . "WHERE `build_assignments`.`is_black_listed` IS NOT NULL " . "ORDER BY `package_sources`.`pkgbase`")) { die($mysql->error); } if ($result -> num_rows > 0) { while($row = $result->fetch_assoc()) { print "\n"; } } ?>

architecture	package	reason
"; print $row["architecture"]; print "	"; print $row["pkgbase"]; print "	"; print preg_replace( array ( "/FS32#(\\d+)/", "/FS#(\\d+)/" ), array ( "$0", "$0" ), $row["is_black_listed"] ); print "