From 6987716324f8995f3f8e01273dec3c4ec2439a46 Mon Sep 17 00:00:00 2001 From: Banana Date: Sun, 30 May 2021 11:19:17 +0200 Subject: [PATCH] fixed an sql query --- webclient/lib/managecollections.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/webclient/lib/managecollections.class.php b/webclient/lib/managecollections.class.php index 5e0898d..324153d 100644 --- a/webclient/lib/managecollections.class.php +++ b/webclient/lib/managecollections.class.php @@ -445,7 +445,7 @@ class ManageCollections { $queryStr = "SELECT `t`.`id`, `t`.`name`, `t`.`description`, `t`.`action`, `t`.`target` FROM `".DB_PREFIX."_tool2collection` AS t2c - LEFT JOIN `".DB_PREFIX."_tool` AS t ON t2c.fk_collection_id = t.id + LEFT JOIN `".DB_PREFIX."_tool` AS t ON t.id = t2c.fk_tool_id WHERE t2c.fk_collection_id = '".$this->_DB->real_escape_string($id)."'"; if(QUERY_DEBUG) error_log("[QUERY] ".__METHOD__." query: ".var_export($queryStr,true)); try { -- 2.39.5