From 7d4bf784bb57fbc330d205ee4621ec6cf6ae9ed6 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sat, 14 Apr 2018 20:10:02 +0200 Subject: packages/pkginfo.php: remove duplicate dependencies (only show most unstable one) --- packages/pkginfo.php | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'packages') diff --git a/packages/pkginfo.php b/packages/pkginfo.php index 2429975..fe03802 100644 --- a/packages/pkginfo.php +++ b/packages/pkginfo.php @@ -106,6 +106,16 @@ " AND `repository_stability_relations`.`less_stable`=" . $mysql_content["repo_stability"] . ") ON `install_target_providers`.`install_target`=`dependencies`.`depending_on`" . " WHERE `dependencies`.`dependent`=" . $mysql_content["id"] . + " AND NOT EXISTS (" . + "SELECT 1 FROM `binary_packages` AS `subst_bp`" . + " JOIN `repositories` AS `subst_r` ON `subst_bp`.`repository`=`subst_r`.`id`" . + " JOIN `repository_stability_relations` AS `subst_rsr` ON `subst_rsr`.`less_stable`=`subst_r`.`stability`" . + " AND `subst_rsr`.`less_stable`!=`subst_rsr`.`more_stable`" . + " JOIN `repository_stability_relations` AS `subst_rsr2` ON `subst_rsr2`.`more_stable`=`subst_r`.`stability`" . + " WHERE `subst_bp`.`pkgname`=`binary_packages`.`pkgname`" . + " AND `subst_rsr`.`more_stable`=`repositories`.`stability`" . + " AND `subst_rsr2`.`less_stable`=`repositories`.`stability`" . + ")" . " GROUP BY `install_targets`.`id`,`dependency_types`.`id`" . " ORDER BY FIELD (`dependency_types`.`name`,\"run\",\"make\",\"check\",\"link\"), `install_targets`.`name`" )) -- cgit v1.2.3