diff options
Diffstat (limited to 'buildmaster/blacklist.php')
| -rw-r--r-- | buildmaster/blacklist.php | 63 |
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> |