From 77e5deb9dda0e718227390993346994cf6cc1737 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 6 May 2025 05:06:17 +0300 Subject: use RETURNING syntax when creating base filter record during OPML import --- classes/OPML.php | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) (limited to 'classes/OPML.php') diff --git a/classes/OPML.php b/classes/OPML.php index 1debc8623..bae00b8bc 100644 --- a/classes/OPML.php +++ b/classes/OPML.php @@ -397,14 +397,10 @@ class OPML extends Handler_Protected { //print "F: $title, $inverse, $enabled, $match_any_rule"; $sth = $this->pdo->prepare("INSERT INTO ttrss_filters2 (match_any_rule,enabled,inverse,title,owner_uid) - VALUES (?, ?, ?, ?, ?)"); + VALUES (?, ?, ?, ?, ?) RETURNING id"); $sth->execute([$match_any_rule, $enabled, $inverse, $title, $owner_uid]); - $sth = $this->pdo->prepare("SELECT MAX(id) AS id FROM ttrss_filters2 WHERE - owner_uid = ?"); - $sth->execute([$owner_uid]); - $row = $sth->fetch(); $filter_id = $row['id']; -- cgit v1.2.3-54-g00ecf