lib/mysql-joins.php new: it contains mysql_join_* functions similar to the ones in lib/mysql-functions of the build scripts

1 files changed, 2 insertions, 2 deletions

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`"