From 6d93913ca2893a7fc5499c0cb5d6e70831e7af50 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 11 Apr 2018 16:54:13 +0200 Subject: status quo --- scripts/blacklist.php | 48 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) create mode 100644 scripts/blacklist.php (limited to 'scripts/blacklist.php') diff --git a/scripts/blacklist.php b/scripts/blacklist.php new file mode 100644 index 0000000..c2810c6 --- /dev/null +++ b/scripts/blacklist.php @@ -0,0 +1,48 @@ + + +Blacklisted packages + + + + + +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"; + } +} +?> +
architecturepackagereason
"; + print $row["architecture"]; + print ""; + print $row["pkgbase"]; + print ""; + print preg_replace( + array ( + "/FS32#(\\d+)/", + "/FS#(\\d+)/" + ), + array ( + "$0", + "$0" + ), + $row["is_black_listed"] + ); + print "
+ + -- cgit v1.2.3-54-g00ecf