1 files changed, 63 insertions, 0 deletions
diff --git a/buildmaster/blacklist.php b/buildmaster/blacklist.php
new file mode 100644
index 0000000..24247e8
--- /dev/null
+++ b/buildmaster/blacklist.php
@@ -0,0 +1,63 @@
+<?php
+require_once "../init.php";
+
+require_once BASE . "/lib/mysql.php";
+
+  $result = mysql_run_query(
+    "SELECT DISTINCT" .
+    " GROUP_CONCAT(`architectures`.`name`) AS `architectures`," .
+    "`package_sources`.`pkgbase`," .
+    "`build_assignments`.`is_black_listed` " .
+    "FROM `build_assignments` " .
+    mysql_join_build_assignments_architectures() .
+    mysql_join_build_assignments_package_sources() .
+    "WHERE `build_assignments`.`is_black_listed` IS NOT NULL " .
+    "GROUP BY CONCAT(to_base64(`package_sources`.`pkgbase`),\" - \",to_base64(`build_assignments`.`is_black_listed`)) " .
+    "ORDER BY `package_sources`.`pkgbase`"
+  );
+
+?>
+<html>
+  <head>
+    <title>Blacklisted packages</title>
+    <link rel="stylesheet" type="text/css" href="/static/style.css">
+  </head>
+  <body>
+<?php show_warning_on_offline_slave(); ?>
+    <table>
+      <tr>
+        <th>architectures</th>
+        <th>package</th>
+        <th>reason</th>
+      </tr>
+<?php
+
+if ($result -> num_rows > 0) {
+  while($row = $result->fetch_assoc()) {
+    print "      <tr>\n";
+    print "        <td>";
+    print $row["architectures"];
+    print "</td>\n";
+    print "        <td>";
+    print $row["pkgbase"];
+    print "</td>\n";
+    print "        <td>";
+    print preg_replace(
+      array (
+        "/FS32#(\\d+)/",
+        "/FS#(\\d+)/"
+      ),
+      array (
+        "<a href=\"https://bugs.archlinux32.org/index.php?do=details&task_id=$1\">$0</a>",
+        "<a href=\"https://bugs.archlinux.org/task/$1\">$0</a>"
+      ),
+      $row["is_black_listed"]
+    );
+    print "</td>\n";
+    print "      </tr>\n";
+  }
+}
+?>
+    </table>
+  </body>
+</html>