Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/buildmaster/blacklist.php
diff options
context:
space:
mode:
Diffstat (limited to 'buildmaster/blacklist.php')
-rw-r--r--buildmaster/blacklist.php63
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>