diff options
author | Erich Eckner <git@eckner.net> | 2018-11-09 10:50:09 +0100 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-11-09 10:50:09 +0100 |
commit | f89a3fd4c3577eba5a9e3f1c1d27c26fb8432f7b (patch) | |
tree | a7720fef45dd700374cda0843ed2d2354ac5bc28 /packages/index.php | |
parent | 1a9e9dc143b73b29113c5d22c0812f25c43cd34a (diff) | |
download | archweb32-f89a3fd4c3577eba5a9e3f1c1d27c26fb8432f7b.tar.xz |
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.php | 20 |
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 "; |