FreshRSS (Customized)/app/Models/FeedDAO.php, branch custom

More feed info: last received date, publication date (#8799)

2026-05-10T14:47:24+00:00

* More feed info: last received date, publication date Follow-up of https://github.com/FreshRSS/FreshRSS/pull/8670 * Fix
* Change i18n English

Show time since when a feed has problems + new timeago() method and i18n plurals (#8670)

2026-04-07T20:56:02+00:00

Closes https://github.com/FreshRSS/FreshRSS/issues/8508 Changes proposed in this pull request: - Use an integer for `Feed::error` everywhere (follow up to #8646) - Extract `Entry::machineReadableDate()` into function for use in HTML templates - Add `timeago()` function that converts a unix timestamp into a "4 weeks ago" string - Show the last successful feed update, and the last erroneous update How to test the feature manually: 1. Update a feed 2. Modify the feed URL in the database and set it to a non-existing URL 3. Update the feed again 4. Open the "Manage feed" and see the expanded error message: > Blast! This feed has encountered a problem. If this situation persists, please verify that it is still reachable. > Last successful update 3 hours ago, last erroneous update 1 hour ago. You can hover the relative dates to see the timestamp. * Make Feed::error an int everywhere Related: https://github.com/FreshRSS/FreshRSS/pull/8646 * Extract timestamptomachinedate() .. for later usage in the feed error time display. * Show time since when a feed has problems We add our own "timeago" function that converts a unix timestamp into a "4 weeks ago" string. Resolves: https://github.com/FreshRSS/FreshRSS/issues/8508 * Add new translation keys * i18n fr, en-US * Minor XHTML preference * Slightly shorter rewrite, also hopefully easier to read * Rewrite to allow (simple) plural I also moved some functions around for hopefully a more generic and better structure. I made some changes for the sake of speed (e.g. second-based logic instead of datetime intervals). Note: I used automatic translation as I was worried it would be too complicated to explain to translators... I proofread the few languages I have some familiarity with. * Add reference to CLDR * Slightly more compact syntax * Always show last update, fix case of unknown error date * Remove forgotten span * No need for multi-lines anymore * Fix error date thresshold * plurals forms * Extract gettext formula conversion script to cli * Simplify a bit * Escort excess parentheses to the door * Simplify * Avoid being too clever in localization * Fix German * Fix plural TODO parsing * Ignore en-US translation * make fix-all * git update-index --chmod=+x cli/compile.plurals.php * Heredoc indent PHP 7.3+ * compileAll: Continue on error * PHP strict comparisons * Light logical simplification * Cache plural_message_families * Avoid case of empty value * A bit of documentation --------- Co-authored-by: Alexandre Alapetite Co-authored-by: Frans de Jonge Co-authored-by: Frans de Jonge

Fix entry->lastSeen in case of feed errors (#8646)

2026-04-02T10:30:51+00:00

* Fix entry->lastSeen in case of feed errors Fix https://github.com/FreshRSS/FreshRSS/issues/8643 Fix lastSeen and feed's lastUpdate going out of sync Previous related PRs: * https://github.com/FreshRSS/FreshRSS/pull/5404 * https://github.com/FreshRSS/FreshRSS/pull/5382 * https://github.com/FreshRSS/FreshRSS/pull/5315 * Minor uneeded change

SQL improve PHP syntax uniformity (#8604)

2026-03-15T13:44:39+00:00

* New SQL wrapper function `fetchInt()` * Favour use of `fetchAssoc()`, `fetchInt()`, `fetchColumn()` * Favour Nowdoc / Heredoc syntax for SQL * Update indenting to PHP 8.1+ convention * Favour `bindValue()` instead of position `?` when possible * Favour `bindValue()` over `bindParam()` * More uniform and robust syntax when using `bindValue()`, checking return code

Handle null in base64_encode (#8321)

2025-12-16T17:53:00+00:00

* Handle null in base64_encode https://github.com/FreshRSS/FreshRSS/discussions/8314#discussioncomment-15269370 * PHPDoc

Fix MariaDB updateCachedValues (#8255)

2025-11-26T22:47:29+00:00

Changed syntax for an even wider compatibility. Follow-up of https://github.com/FreshRSS/FreshRSS/pull/8254 Regression from https://github.com/FreshRSS/FreshRSS/pull/6957 MariaDB images on Docker Hub go back to 10.6, so changed documentation to indicate support from that version, as I cannot easily test even older versions.

Fix MariaDB for updates (#8254)

2025-11-26T15:47:40+00:00

fix https://github.com/FreshRSS/FreshRSS/issues/8252 regression from https://github.com/FreshRSS/FreshRSS/pull/6957 The current code works with MySQL 8+ (as well as PostgreSQL and SQLite), but not with MariaDB, because MariaDB does not support CTE (Common Table Expression) fully (which I was not aware of)...

Change SQL update query (#6957)

2025-11-17T12:48:48+00:00

* Change SQL update query for MariaDB / MySQL fix https://github.com/FreshRSS/FreshRSS/issues/5707 * No change for SQLite * Fix merge error * Update MySQL version on the model of PostgreSQL Performance to be tested * Fix LEFT JOIN, also for PostgreSQL / SQLite * Fix alias * Reduce MySQL deadlock * Fix compatibility with SQLite * Back to identical SQL for all databases

SQL: Optimise speed of updateCachedValues() (#8207)

2025-11-15T19:11:25+00:00

For PostgreSQL and SQLite fix https://github.com/FreshRSS/FreshRSS/issues/8206

Housekeeping lib_rss.php (#8193)

2025-11-11T07:17:12+00:00

* Housekeeping lib_rss.php `lib_rss.php` had become much too large, especially after https://github.com/FreshRSS/FreshRSS/pull/7924 Moved most functions to other places. Mostly no change of code otherwise (see comments). * Extension: composer run-script phpstan-third-party