From 8aa568b3a22ca613eee488843f415080554c1ecd Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 1 Dec 2017 10:35:22 +0300 Subject: [PATCH] some more pdo stuff --- include/functions.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/include/functions.php b/include/functions.php index 1f9c80a0..58f4ba31 100644 --- a/include/functions.php +++ b/include/functions.php @@ -600,8 +600,9 @@ $profile = $profile ? $profile : null; $u_sth = $pdo->prepare("SELECT pref_name - FROM ttrss_user_prefs WHERE owner_uid = ? AND profile = ?"); - $u_sth->execute([$uid, $profile]); + FROM ttrss_user_prefs WHERE owner_uid = :uid AND + (:profile IS NULL AND profile is NULL OR profile = :profile)"); + $u_sth->execute(['uid' => $uid, 'profile' => $profile]); $active_prefs = array(); @@ -1966,7 +1967,7 @@ $pdo = Db::pdo(); $sth = $pdo->prepare("SELECT id FROM ttrss_feed_categories - WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ?"); + WHERE parent_cat = ? AND title = '$feed_cat' AND owner_uid = ?"); if (db_num_rows($result) == 0) { -- 2.39.5