Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/packages/index.php
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-11-09 10:50:09 +0100
committerErich Eckner <git@eckner.net>2018-11-09 10:50:09 +0100
commitf89a3fd4c3577eba5a9e3f1c1d27c26fb8432f7b (patch)
treea7720fef45dd700374cda0843ed2d2354ac5bc28 /packages/index.php
parent1a9e9dc143b73b29113c5d22c0812f25c43cd34a (diff)
lib/mysql-joins.php new: it contains mysql_join_* functions similar to the ones in lib/mysql-functions of the build scripts
Diffstat (limited to 'packages/index.php')
-rw-r--r--packages/index.php20
1 files changed, 10 insertions, 10 deletions
diff --git a/packages/index.php b/packages/index.php
index a99744c..bb0aa94 100644
--- a/packages/index.php
+++ b/packages/index.php
@@ -109,12 +109,12 @@ require_once BASE . "/lib/format.php";
}
$query = " FROM `binary_packages`" .
- " JOIN `architectures` ON `architectures`.`id`=`binary_packages`.`architecture`" .
- " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" .
- " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" .
+ mysql_join_binary_packages_architectures() .
+ mysql_join_binary_packages_binary_packages_in_repositories() .
+ mysql_join_binary_packages_in_repositories_repositories() .
" AND `repositories`.`is_on_master_mirror`" .
- " JOIN `build_assignments` ON `build_assignments`.`id`=`binary_packages`.`build_assignment`" .
- " JOIN `package_sources` ON `package_sources`.`id`=`build_assignments`.`package_source`" .
+ mysql_join_binary_packages_build_assignments() .
+ mysql_join_build_assignments_package_sources() .
$filter . $exact_filter .
" ORDER BY ";
@@ -187,12 +187,12 @@ require_once BASE . "/lib/format.php";
);
$query = " FROM `binary_packages`" .
- " JOIN `architectures` ON `architectures`.`id`=`binary_packages`.`architecture`" .
- " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" .
- " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" .
+ mysql_join_binary_packages_architectures() .
+ mysql_join_binary_packages_binary_packages_in_repositories() .
+ mysql_join_binary_packages_in_repositories_repositories() .
" AND `repositories`.`is_on_master_mirror`" .
- " JOIN `build_assignments` ON `build_assignments`.`id`=`binary_packages`.`build_assignment`" .
- " JOIN `package_sources` ON `package_sources`.`id`=`build_assignments`.`package_source`" .
+ mysql_join_binary_packages_build_assignments() .
+ mysql_join_build_assignments_package_sources() .
$filter . $fuzzy_filter .
" ORDER BY ";