From 14649d9c2f14677952127a26dea086c0bd5acc3e Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sat, 14 Apr 2018 13:08:40 +0200 Subject: packages/pkginfo.php: show links to package sources --- packages/pkginfo.php | 60 +++++++++++++++++++++++++++++++++++++--------------- 1 file changed, 43 insertions(+), 17 deletions(-) diff --git a/packages/pkginfo.php b/packages/pkginfo.php index cf89e9b..b618d6f 100644 --- a/packages/pkginfo.php +++ b/packages/pkginfo.php @@ -41,12 +41,17 @@ ") AS `version`," . "`repositories`.`stability` AS `repo_stability`," . "`repositories`.`name` AS `repo`," . - "`architectures`.`name` AS `arch`" . + "`architectures`.`name` AS `arch`," . + "`git_repositories`.`name` AS `git_repo`," . + "`package_sources`.`uses_upstream`," . + "`package_sources`.`uses_modification`" . " FROM `binary_packages`" . " JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" . " JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`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`" . + " JOIN `git_repositories` ON `upstream_repositories`.`git_repository`=`git_repositories`.`id`" . " WHERE `binary_packages`.`pkgname`=from_base64(\"" . base64_encode($_GET["pkgname"]) . "\")" . " AND `architectures`.`name`=from_base64(\"" . base64_encode($_GET["arch"]) . "\")" . " AND `repositories`.`name`=from_base64(\"" . base64_encode($_GET["repo"]) . "\")" @@ -237,17 +242,49 @@

Package Actions

-- cgit v1.2.3-54-g00ecf