From 99dc799143026ce7354bab4d2e78a3ebc2dfc95c Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sat, 14 Apr 2018 13:32:45 +0200 Subject: packages/pkginfo.php: add bug links --- packages/pkginfo.php | 28 ++++++++++++++++++++++++---- 1 file changed, 24 insertions(+), 4 deletions(-) (limited to 'packages') diff --git a/packages/pkginfo.php b/packages/pkginfo.php index 68f0ee2..2c580ec 100644 --- a/packages/pkginfo.php +++ b/packages/pkginfo.php @@ -40,6 +40,7 @@ "`binary_packages`.`sub_pkgrel`" . ") AS `version`," . "`repositories`.`stability` AS `repo_stability`," . + "`repository_stabilities`.`name` AS `repo_stability_name`," . "`repositories`.`name` AS `repo`," . "`architectures`.`name` AS `arch`," . "`git_repositories`.`name` AS `git_repo`," . @@ -48,6 +49,7 @@ " FROM `binary_packages`" . " JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" . " JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id`" . + " JOIN `repository_stabilities` ON `repositories`.`stability`=`repository_stabilities`.`id`" . " JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id`" . " JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id`" . " JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id`" . @@ -280,12 +282,30 @@ } ?> -