From eaa13742eebde1dcec6be3fa39ed77776da74dd1 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 25 May 2023 12:05:03 +0200
Subject: packages/pkginfo.php: fix git links and mysql query

---
 packages/pkginfo.php | 17 +++++------------
 1 file changed, 5 insertions(+), 12 deletions(-)

diff --git a/packages/pkginfo.php b/packages/pkginfo.php
index a42b949..775934c 100644
--- a/packages/pkginfo.php
+++ b/packages/pkginfo.php
@@ -80,7 +80,6 @@ require_once BASE . "/lib/style.php";
     "`r_a`.`name` AS `repo_arch`," .
     "`architectures`.`name` AS `arch`," .
     "IFNULL(`compressions`.`suffix`,\"xz\") AS `suffix`," .
-    "`git_repositories`.`name` AS `git_repo`," .
     "`package_sources`.`uses_upstream`," .
     "`package_sources`.`uses_modification`," .
     "MAX(`binary_packages_in_repositories`.`last_moved`) AS `last_moved`," .
@@ -97,7 +96,6 @@ require_once BASE . "/lib/style.php";
     mysql_join_binary_packages_build_assignments() .
     mysql_join_build_assignments_package_sources() .
     mysql_join_package_sources_upstream_repositories() .
-    mysql_join_upstream_repositories_git_repositories() .
     mysql_join_upstream_repositories_repository_moves() .
     " JOIN `repositories` AS `sr` ON `sr`.`id`=`repository_moves`.`to_repository`" .
     " JOIN (" .
@@ -413,20 +411,15 @@ require_once BASE . "/lib/style.php";
 <?php
   if ($content["uses_upstream"]) {
     print "              <li>\n";
-    print "                <a href=\"https://github.com/archlinux/svntogit-";
-    print $content["git_repo"];
-    print "/tree/packages/";
-    print $content["pkgbase"];
-    print "/trunk";
+    print "                <a href=\"https://gitlab.archlinux.org/archlinux/packaging/packages/";
+    print $content["pkgname"];
     print "\" title=\"View upstream's source files for ";
     print $content["pkgname"];
 
     print "\">Upstream's Source Files</a> /\n";
-    print "                <a href=\"https://github.com/archlinux/svntogit-";
-    print $content["git_repo"];
-    print "/commits/packages/";
-    print $content["pkgbase"];
-    print "/trunk";
+    print "                <a href=\"https://gitlab.archlinux.org/archlinux/packaging/packages/";
+    print $content["pkgname"];
+    print "/-/commits/main";
     print "\" title=\"View upstream's changes for ";
     print $content["pkgname"];
     print "\">Upstream's Changes</a>\n";
-- 
cgit v1.2.3-54-g00ecf