From 225fef295a1f6e9187c0ffc96eb85d8108ce89bb Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 20 Jan 2019 20:12:24 +0100 Subject: use mysql_query_package_version() even more often --- buildmaster/mysql-issues.php | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) (limited to 'buildmaster/mysql-issues.php') diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php index 0c27608..1397141 100644 --- a/buildmaster/mysql-issues.php +++ b/buildmaster/mysql-issues.php @@ -30,10 +30,8 @@ require_once BASE . "/lib/mysql.php"; "`r_a`.`name`,\"/\"," . "`repositories`.`name`,\"/\"," . "`binary_packages`.`pkgname`,\"-\"," . - "IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . - "`binary_packages`.`pkgver`,\"-\"," . - "`binary_packages`.`pkgrel`,\".\"," . - "`binary_packages`.`sub_pkgrel`,\"-\"," . + mysql_query_package_version("binary_packages") . + ",\"-\"," . "`architectures`.`name`) AS `pkgfile`," . "`install_targets`.`name` AS `install_target`," . "IF(`binary_packages_in_repositories`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`," . @@ -109,10 +107,8 @@ require_once BASE . "/lib/mysql.php"; "`r_a`.`name`,\"/\"," . "`repositories`.`name`,\"/\"," . "`binary_packages`.`pkgname`,\"-\"," . - "IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . - "`binary_packages`.`pkgver`,\"-\"," . - "`binary_packages`.`pkgrel`,\".\"," . - "`binary_packages`.`sub_pkgrel`,\"-\"," . + mysql_query_package_version("binary_packages") . + ",\"-\"," . "`architectures`.`name`) AS `pkgfile`," . "`install_targets`.`name` AS `install_target`," . "`repository_stabilities`.`name` AS `stability`," . -- cgit v1.2.3