diff options
Diffstat (limited to 'classes/labels.php')
| -rw-r--r-- | classes/labels.php | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/classes/labels.php b/classes/labels.php index 19d060617..1f27ee25c 100644 --- a/classes/labels.php +++ b/classes/labels.php @@ -12,7 +12,7 @@ class Labels static function find_id($label, $owner_uid) { $pdo = Db::pdo(); - $sth = $pdo->prepare("SELECT id FROM ttrss_labels2 WHERE caption = ? + $sth = $pdo->prepare("SELECT id FROM ttrss_labels2 WHERE LOWER(caption) = LOWER(?) AND owner_uid = ? LIMIT 1"); $sth->execute([$label, $owner_uid]); @@ -57,7 +57,7 @@ class Labels $pdo = Db::pdo(); if ($force) - Labels::clear_cache($id); + self::clear_cache($id); if (!$labels) $labels = Article::get_article_labels($id); @@ -82,7 +82,7 @@ class Labels static function remove_article($id, $label, $owner_uid) { - $label_id = Labels::find_id($label, $owner_uid); + $label_id = self::find_id($label, $owner_uid); if (!$label_id) return; @@ -95,12 +95,12 @@ class Labels $sth->execute([$label_id, $id]); - Labels::clear_cache($id); + self::clear_cache($id); } static function add_article($id, $label, $owner_uid) { - $label_id = Labels::find_id($label, $owner_uid); + $label_id = self::find_id($label, $owner_uid); if (!$label_id) return; @@ -123,7 +123,7 @@ class Labels $sth->execute([$label_id, $id]); } - Labels::clear_cache($id); + self::clear_cache($id); } @@ -186,7 +186,7 @@ class Labels } $sth = $pdo->prepare("SELECT id FROM ttrss_labels2 - WHERE caption = ? AND owner_uid = ?"); + WHERE LOWER(caption) = LOWER(?) AND owner_uid = ?"); $sth->execute([$caption, $owner_uid]); if (!$sth->fetch()) { @@ -202,4 +202,4 @@ class Labels return $result; } -}
\ No newline at end of file +} |