From eec594a89a7c59b90357c6a0d9ca4a5f481dfb57 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 20 Jan 2019 20:04:42 +0100 Subject: packages/pkginfo.php: use mysql_query_package_version() --- packages/pkginfo.php | 16 ++++------------ 1 file changed, 4 insertions(+), 12 deletions(-) diff --git a/packages/pkginfo.php b/packages/pkginfo.php index 2081bbc..83ea3bb 100644 --- a/packages/pkginfo.php +++ b/packages/pkginfo.php @@ -65,12 +65,8 @@ require_once BASE . "/lib/style.php"; "`binary_packages`.`pkgname`," . "`sp_q`.`split_packages`," . "`package_sources`.`pkgbase`," . - "CONCAT(" . - "IF(`binary_packages`.`epoch`=\"0\",\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . - "`binary_packages`.`pkgver`,\"-\"," . - "`binary_packages`.`pkgrel`,\".\"," . - "`binary_packages`.`sub_pkgrel`" . - ") AS `version`," . + mysql_query_package_version("binary_packages") . + " AS `version`," . "`repositories`.`stability` AS `repo_stability`," . "`repository_stabilities`.`name` AS `repo_stability_name`," . "`repositories`.`name` AS `repo`," . @@ -345,12 +341,8 @@ require_once BASE . "/lib/style.php"; "`repositories`.`is_on_master_mirror`," . "`architectures`.`name` AS `arch`," . "`r_a`.`name` AS `repo_arch`," . - "CONCAT(" . - "IF(`binary_packages`.`epoch`=\"0\",\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . - "`binary_packages`.`pkgver`,\"-\"," . - "`binary_packages`.`pkgrel`,\".\"," . - "`binary_packages`.`sub_pkgrel`" . - ") AS `version`" . + mysql_query_package_version("binary_packages") . + " AS `version`" . " FROM `binary_packages` " . mysql_join_binary_packages_architectures() . mysql_join_binary_packages_binary_packages_in_repositories() . -- cgit v1.2.3-70-g09d2