From f89a3fd4c3577eba5a9e3f1c1d27c26fb8432f7b Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 9 Nov 2018 10:50:09 +0100 Subject: lib/mysql-joins.php new: it contains mysql_join_* functions similar to the ones in lib/mysql-functions of the build scripts --- buildmaster/blacklist.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'buildmaster/blacklist.php') diff --git a/buildmaster/blacklist.php b/buildmaster/blacklist.php index acd59e9..24247e8 100644 --- a/buildmaster/blacklist.php +++ b/buildmaster/blacklist.php @@ -9,8 +9,8 @@ require_once BASE . "/lib/mysql.php"; "`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` " . + 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`" -- cgit v1.2.3