summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-10-29 15:53:56 +0100
committerErich Eckner <git@eckner.net>2018-10-29 15:53:56 +0100
commitf175baf39675a72426d63b620d968eeaa44648b2 (patch)
tree5606535e2d99ff4a41f73f51b673e485b34b0a17
parentd3c4edc3470a2f66ddf93f3c7cb468d075272d90 (diff)
downloadarchweb32-f175baf39675a72426d63b620d968eeaa44648b2.tar.xz
buildmaster/mysql-issues.php: show architecture of repository, too
-rw-r--r--buildmaster/mysql-issues.php4
1 files changed, 4 insertions, 0 deletions
diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php
index 16dd986..0604167 100644
--- a/buildmaster/mysql-issues.php
+++ b/buildmaster/mysql-issues.php
@@ -9,6 +9,7 @@ require_once BASE . "/lib/mysql.php";
$result = mysql_run_query(
"SELECT CONCAT(" .
+ "`r_a`.`name`,\"/\"," .
"`repositories`.`name`,\"/\"," .
"`binary_packages`.`pkgname`,\"-\"," .
"IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," .
@@ -24,6 +25,7 @@ require_once BASE . "/lib/mysql.php";
" JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" .
" JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" .
" AND `repositories`.`is_on_master_mirror`" .
+ " JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id`" .
" JOIN `dependencies` ON `dependencies`.`dependent`=`binary_packages`.`id`" .
" JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id`" .
" AND `dependency_types`.`relevant_for_binary_packages`" .
@@ -60,6 +62,7 @@ require_once BASE . "/lib/mysql.php";
$result = mysql_run_query(
"SELECT CONCAT(" .
+ "`r_a`.`name`,\"/\"," .
"`repositories`.`name`,\"/\"," .
"`binary_packages`.`pkgname`,\"-\"," .
"IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," .
@@ -74,6 +77,7 @@ require_once BASE . "/lib/mysql.php";
" JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" .
" JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" .
" AND `repositories`.`is_on_master_mirror`" .
+ " JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id`" .
" JOIN `repository_stabilities` ON `repositories`.`stability`=`repository_stabilities`.`id`" .
" JOIN `dependencies` ON `dependencies`.`dependent`=`binary_packages`.`id`" .
" JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id`" .