aboutsummaryrefslogtreecommitdiff
path: root/classes/Feeds.php
diff options
context:
space:
mode:
authorAndrew Dolgov <fox@fakecake.org>2025-05-19 08:06:56 +0300
committerAndrew Dolgov <fox@fakecake.org>2025-05-19 08:06:56 +0300
commiteab69f8796c1d42b2e0d08282b5ff1859f689a8a (patch)
treea7ec25ba4300ded6cccd974857e49a0debbd019c /classes/Feeds.php
parentf4973264d35cd95a110225b2e274a38bf9c7f3a6 (diff)
parentce36b27a0d01bcc61114028d0f8ec3d3e20d30de (diff)
Merge branch 'feature/orm-and-misc' into 'master'
Use ORM in more places, deprecate const SUBSTRING_FOR_DATE, some minor fixes See merge request tt-rss/tt-rss!135
Diffstat (limited to 'classes/Feeds.php')
-rw-r--r--classes/Feeds.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/classes/Feeds.php b/classes/Feeds.php
index 7640185c1..7b0fc60cc 100644
--- a/classes/Feeds.php
+++ b/classes/Feeds.php
@@ -400,8 +400,8 @@ class Feeds extends Handler_Protected {
$reply['content'] .= "<p><span class=\"text-muted\">";
- $sth = $this->pdo->prepare("SELECT " . SUBSTRING_FOR_DATE . "(MAX(last_updated), 1, 19) AS last_updated FROM ttrss_feeds
- WHERE owner_uid = ?");
+ $sth = $this->pdo->prepare("SELECT SUBSTRING_FOR_DATE(MAX(last_updated), 1, 19) AS last_updated
+ FROM ttrss_feeds WHERE owner_uid = ?");
$sth->execute([$_SESSION['uid']]);
$row = $sth->fetch();
@@ -2239,7 +2239,7 @@ class Feeds extends Handler_Protected {
$orig_ts = strtotime(substr($k, 1));
$k = date("Y-m-d", TimeHelper::convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
- array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH(".$pdo->quote($k).")) $not = ".$pdo->quote($k).")");
+ array_push($query_keywords, "(SUBSTRING_FOR_DATE(updated,1,LENGTH(".$pdo->quote($k).")) $not = ".$pdo->quote($k).")");
} else {
// treat as leftover text