Re: [aur-dev] AUR 2.0.0 released

[matthias]

I know that I am a little bit late to the party, but the German
translation has been pushed from 86% to 99% a few days ago. We could
easily get rid of the ugly hosh-posh on the German frontpage, if someone
would pull the current version from Transifex. There are still things to
be done - a reported bug (Anmelden/Registrieren), a few untranslated
strings (flag/unflag is really a hard one), and the whole thing needs to
be improved with regard to style and consistency. In the meantime,
however, we would do much better with the 99%-version.

Re: [aur-dev] AUR 2.0.0 released

[Alexander Rødseth]

Hey,

Norwegian is at 100% too. :)

-- 
Sincerely,
  Alexander Rødseth
  xyproto / tu

[aur-dev] [PATCH] pkgfuncs.inc.php: Rework query to avoid Required by duplicates

[canyonknight]

Packages with multiple DepConditions are returned multiple
times in the Required by column.

Limit SQL results to distinct packages.

Fixes FS#32478

Signed-off-by: canyonknight canyonkni...@gmail.com
---

Ignore previous duplicates fix. This works better as an SQL fix.

 web/lib/pkgfuncs.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index 8f84cdf..cfdd9a7 100644
--- a/web/lib/pkgfuncs.inc.php
+++ b/web/lib/pkgfuncs.inc.php
@@ -169,7 +169,7 @@ function package_required($name=, $dbh=NULL) {
if(!$dbh) {
$dbh = db_connect();
}
-   $q = SELECT p.Name, PackageID FROM PackageDepends pd ;
+   $q = SELECT DISTINCT p.Name, PackageID FROM PackageDepends pd 
;
$q.= JOIN Packages p ON pd.PackageID = p.ID ;
$q.= WHERE DepName =  . $dbh-quote($name) .  ;
$q.= ORDER BY p.Name;
-- 
1.8.0