From 3a0292303e453f38204279b5d1c978a4b9c367e9 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 3 Nov 2018 15:08:43 +0300 Subject: php: remove trailing whitespaces --- classes/opml.php | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'classes/opml.php') diff --git a/classes/opml.php b/classes/opml.php index ae995860f..5b7690375 100644 --- a/classes/opml.php +++ b/classes/opml.php @@ -75,7 +75,7 @@ class Opml extends Handler_Protected { $sth = $this->pdo->prepare("SELECT id,title FROM ttrss_feed_categories WHERE - (parent_cat = :cat OR (:cat = 0 AND parent_cat IS NULL)) AND + (parent_cat = :cat OR (:cat = 0 AND parent_cat IS NULL)) AND owner_uid = :uid ORDER BY order_id, title"); $sth->execute([':cat' => $cat_id, ':uid' => $owner_uid]); @@ -85,7 +85,7 @@ class Opml extends Handler_Protected { } $fsth = $this->pdo->prepare("select title, feed_url, site_url - FROM ttrss_feeds WHERE + FROM ttrss_feeds WHERE (cat_id = :cat OR (:cat = 0 AND cat_id IS NULL)) AND owner_uid = :uid AND $hide_qpart ORDER BY order_id, title"); @@ -421,9 +421,9 @@ class Opml extends Handler_Protected { $inverse = bool_to_sql_bool($rule["inverse"]); $match_on = json_encode($match_on); - $usth = $this->pdo->prepare("INSERT INTO ttrss_filters2_rules + $usth = $this->pdo->prepare("INSERT INTO ttrss_filters2_rules (feed_id,cat_id,match_on,filter_id,filter_type,reg_exp,cat_filter,inverse) - VALUES + VALUES (NULL, NULL, ?, ?, ?, ?, false, ?)"); $usth->execute([$match_on, $filter_id, $filter_type, $reg_exp, $inverse]); @@ -454,9 +454,9 @@ class Opml extends Handler_Protected { $filter_type = (int)$rule["filter_type"]; $inverse = bool_to_sql_bool($rule["inverse"]); - $usth = $this->pdo->prepare("INSERT INTO ttrss_filters2_rules + $usth = $this->pdo->prepare("INSERT INTO ttrss_filters2_rules (feed_id,cat_id,filter_id,filter_type,reg_exp,cat_filter,inverse) - VALUES + VALUES (?, ?, ?, ?, ?, ?, ?)"); $usth->execute([$feed_id, $cat_id, $filter_id, $filter_type, $reg_exp, $cat_filter, $inverse]); } @@ -467,9 +467,9 @@ class Opml extends Handler_Protected { $action_id = (int)$action["action_id"]; $action_param = $action["action_param"]; - $usth = $this->pdo->prepare("INSERT INTO ttrss_filters2_actions + $usth = $this->pdo->prepare("INSERT INTO ttrss_filters2_actions (filter_id,action_id,action_param) - VALUES + VALUES (?, ?, ?)"); $usth->execute([$filter_id, $action_id, $action_param]); } @@ -613,7 +613,7 @@ class Opml extends Handler_Protected { $parent_cat_id = (int) $parent_cat_id; $sth = $this->pdo->prepare("SELECT id FROM ttrss_feed_categories - WHERE title = :title + WHERE title = :title AND (parent_cat = :parent OR (:parent = 0 AND parent_cat IS NULL)) AND owner_uid = :uid"); -- cgit v1.2.3