From 4e2dbce045fa380a19d76d861c6d17654c10b786 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 23 Mar 2018 10:47:48 +0100 Subject: web-scripts/blacklist.php new --- web-scripts/blacklist.php | 47 +++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 47 insertions(+) create mode 100644 web-scripts/blacklist.php (limited to 'web-scripts/blacklist.php') diff --git a/web-scripts/blacklist.php b/web-scripts/blacklist.php new file mode 100644 index 0000000..6ad46f4 --- /dev/null +++ b/web-scripts/blacklist.php @@ -0,0 +1,47 @@ + + +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")) { + 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-70-g09d2 From 865de4ebc3753e78cd1fe2083d213c364afe4000 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 23 Mar 2018 10:57:13 +0100 Subject: web-scripts/blacklist.php: order by pkgbase --- web-scripts/blacklist.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'web-scripts/blacklist.php') diff --git a/web-scripts/blacklist.php b/web-scripts/blacklist.php index 6ad46f4..c2810c6 100644 --- a/web-scripts/blacklist.php +++ b/web-scripts/blacklist.php @@ -17,7 +17,8 @@ if ( ! $result = $mysql -> query( "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")) { + "WHERE `build_assignments`.`is_black_listed` IS NOT NULL " . + "ORDER BY `package_sources`.`pkgbase`")) { die($mysql->error); } if ($result -> num_rows > 0) { -- cgit v1.2.3-70-g09d2