summaryrefslogtreecommitdiff
path: root/app
AgeCommit message (Collapse)Author
2014-07-18Add statistics support for SqliteGravatar Alexis Degrugillier
Add statistics support for Sqlite by tweeking one query and rewrite an other. The rewrite implied a complete refactor of the MySql query as well. Now the code is more flexible and make less queries to the database. See #527
2014-07-17SQL: Bug with order ASCGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/538
2014-07-13Number of unread articles as prefix in page titleGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/536
2014-07-10Fix bug changement default viewGravatar Marien Fressinaud
- It was impossible to set default view to "Show all articles" - "0" was compared to 0 ("O" === 0 => false) - cast value from Minz_Request into integer
2014-07-10Fix a bug during installationGravatar Marien Fressinaud
- If MySQL database was configured and user choosed SQLite, an error was raised at the first submit. - Cast STEP into integer
2014-07-10Add base-theme in p/themesGravatar Marien Fressinaud
This base theme is not visible by default (no name). You can use it to create new theme. Fix https://github.com/marienfressinaud/FreshRSS/issues/533 (comment)
2014-07-10SQL: MySQL speed optimisationGravatar Alexandre Alapetite
Would be nice to test with other versions of MySQL too. Comparison before/after: mysql> EXPLAIN SELECT e.id, e.guid, e.title, e.author, UNCOMPRESS(content_bin) AS content, e.link, e.date, e.is_read, e.is_favorite, e.id_feed, e.tags FROM `freshrss_alex_entry` e INNER JOIN (SELECT e1.id FROM `freshrss_alex_entry` e1 INNER JOIN `freshrss_alex_feed` f ON e1.id_feed=f.id WHERE f.priority > 0 AND (e1.id >= 1381615200000000 OR e1.is_read=0 OR e1.is_favorite=1 OR (f.keep_history <> 0)) ORDER BY e1.id DESC LIMIT 31) e2 ON e2.id=e.id ORDER BY e.id DESC; +----+-------------+------------+--------+-------------------------------------+----------+---------+---------------+------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+------------+--------+-------------------------------------+----------+---------+---------------+------+----------------------------------------------+ | 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 31 | Using temporary; Using filesort | | 1 | PRIMARY | e | eq_ref | PRIMARY | PRIMARY | 8 | e2.id | 1 | | | 2 | DERIVED | f | range | PRIMARY,priority,keep_history | priority | 1 | NULL | 137 | Using where; Using temporary; Using filesort | | 2 | DERIVED | e1 | ref | PRIMARY,id_feed,is_favorite,is_read | id_feed | 2 | freshrss.f.id | 452 | Using where | +----+-------------+------------+--------+-------------------------------------+----------+---------+---------------+------+----------------------------------------------+ 4 rows in set (3.50 sec) mysql> EXPLAIN SELECT e.id, e.guid, e.title, e.author, UNCOMPRESS(content_bin) AS content, e.link, e.date, e.is_read, e.is_favorite, e.id_feed, e.tags FROM `freshrss_alex_entry` e INNER JOIN (SELECT e1.id FROM `freshrss_alex_entry` e1 INNER JOIN `freshrss_alex_feed` f ON e1.id_feed=f.id WHERE f.priority > 0 AND e1.id <=9000000000000000 AND (e1.id >= 1381615200000000 OR e1.is_read=0 OR e1.is_favorite=1 OR (f.keep_history <> 0)) ORDER BY e1.id DESC LIMIT 31) e2 ON e2.id=e.id ORDER BY e.id DESC; +----+-------------+------------+--------+-------------------------------------+---------+---------+---------------------+-------+---------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+------------+--------+-------------------------------------+---------+---------+---------------------+-------+---------------------------------+ | 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 31 | Using temporary; Using filesort | | 1 | PRIMARY | e | eq_ref | PRIMARY | PRIMARY | 8 | e2.id | 1 | | | 2 | DERIVED | e1 | range | PRIMARY,id_feed,is_favorite,is_read | PRIMARY | 8 | NULL | 70084 | Using where | | 2 | DERIVED | f | eq_ref | PRIMARY,priority,keep_history | PRIMARY | 2 | freshrss.e1.id_feed | 1 | Using where | +----+-------------+------------+--------+-------------------------------------+---------+---------+---------------------+-------+---------------------------------+ 4 rows in set (0.01 sec)
2014-07-09Block user to click many times on the refresh buttonGravatar Marien Fressinaud
See https://github.com/marienfressinaud/FreshRSS/issues/513
2014-07-09Coding style header.phtml + possibility to change logoGravatar Marien Fressinaud
See https://github.com/marienfressinaud/FreshRSS/issues/532
2014-07-08SQL: removed superfluous transactions to avoid some dead locksGravatar Alexandre Alapetite
2014-07-07Add a configuration parameterGravatar Alexis Degrugillier
Add a parameter to choose wether or not the user want to display a confirmation dialog when clicking on "mark all as read" actions.
2014-07-07Add confirmation on button as wellGravatar Alexis Degrugillier
2014-07-07Add a confirmation dialog when clicking on the big tickGravatar Alexis Degrugillier
See #519 Before, when clicking on the big tick to mark all articles as read, it triggers directly the action. Now, it asks for a confirmation to block unwanted user clicks.
2014-07-07SQL: SQLite syntax uniformisationGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/commit/805c91da98c2f582e279f3c853fba9e43f572419#diff-101042bec0ff3ac9d691b2e77fca3313R7
2014-07-07SQL: improved performance for adding new articlesGravatar Alexandre Alapetite
2014-07-06Prepare statistics for SQLiteGravatar Alexandre Alapetite
Temporarily disable 30-day statistics for SQLite https://github.com/marienfressinaud/FreshRSS/issues/100 https://github.com/marienfressinaud/FreshRSS/issues/90
2014-07-06Minor #524Gravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/524
2014-07-06Merge pull request #525 from aledeg/issue524Gravatar Alexandre Alapetite
Change behavior when selecting an article
2014-07-06Bug global TTLGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/250
2014-07-06Minor white space parenthesesGravatar Alexandre Alapetite
2014-07-06Add TTL to control feed freshnessGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/250
2014-07-05Merge pull request #516 from aledeg/statsGravatar Alexandre Alapetite
Refactor statistics
2014-07-05Change behavior when selecting an articleGravatar Alexis Degrugillier
See #524 Before, when the configuration was set so the article is marked as read when selected, if you mark it as unread while it is open and then close it, it is marked again as read. This behavior was not straightforward. Now, the article is not marked again as read.
2014-07-05Bug searchGravatar Alexandre Alapetite
Following introduction of user-queries https://github.com/marienfressinaud/FreshRSS/commit/2b8dc666345d334f50bf2f4f32f0b127edb40c3a#diff-be03dd1f6b53ebb2682ba9dd334bc273
2014-07-05Bug feed->hash for 301 redirections, faviconsGravatar Alexandre Alapetite
2014-07-05Add support for SQLiteGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/100 Warning: MySQL has been changed too, so bugs may have been introduced
2014-07-05SQL: Add f.ttl column to control feed cache durationGravatar Alexandre Alapetite
Preparation of https://github.com/marienfressinaud/FreshRSS/issues/250 Will also be used to disable automatic update for selected feeds
2014-07-03Preparation #3 for SQLiteGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/100
2014-07-03Preparation #2 for SQLiteGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/100
2014-07-03Preparation for SQLiteGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/100
2014-07-03New install logicGravatar Alexandre Alapetite
Now the install.php is kept in ./app/ and the trigger is ./data/do-install.php There is no need anymore to have write access in ./p/i/
2014-07-03Small correction faviconGravatar Alexandre Alapetite
Ensure to try the website favicon before trying the feed URL favicon (which might be on e.g. FeedBurner with an anonymous favicon).
2014-07-03Cleaning some hash functionsGravatar Alexandre Alapetite
2014-07-02Minz_Log::NOTICE instead of DEBUG if failing to update cache of unread articlesGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/commit/300c508d9e4732a7c6e8025ee62f934f7ecc5328
2014-07-01Automatically correct cache number of unread articlesGravatar Alexandre Alapetite
2014-07-01SimplePie HTTP 301 Moved PermanentlyGravatar Alexandre Alapetite
Add support for HTTP 301 Moved Permanently in SimplePie FreshRSS will automatically update the address of a feed, only in this case.
2014-06-15Merge branch 'stats' of https://github.com/aledeg/FreshRSS into statsGravatar Alexis Degrugillier
Conflicts: app/Controllers/statsController.php app/Models/StatsDAO.php app/i18n/en.php app/i18n/fr.php app/layout/aside_stats.phtml app/layout/header.phtml app/views/index/stats.phtml app/views/stats/idle.phtml app/views/stats/index.phtml app/views/stats/main.phtml
2014-06-15Refactor and formattingGravatar Alexis Degrugillier
2014-06-15Fix syntaxGravatar Alexis Degrugillier
2014-06-15Refactor idle feed statsGravatar Alexis Degrugillier
2014-06-15Refactor statisticsGravatar Alexis Degrugillier
I made a new controller to handle statistics. The old statistics have been moved in that controller and a new action has been added to display idle feeds. I also added a menu in the left panel to navigate between the statistics pages. See #90
2014-06-15Add two wrappers (_t() and _i())Gravatar Marien Fressinaud
- _t() is a wrapper for Minz_Translate::t() - Improve coding style of Translate.php - _i() is a wrapper for FreshRSS::icon() - queries.phtml shows how they work - It is a lot easier to read files with these functions :)
2014-06-15Fix syntaxGravatar Alexis Degrugillier
2014-06-14Merge branch 'dev' of github.com:marienfressinaud/freshrss into devGravatar Marien Fressinaud
2014-06-14Change query iconGravatar Marien Fressinaud
- Menu button is a down arrow - Bookmark icon has moved near of "add a query" See https://github.com/marienfressinaud/FreshRSS/pull/498
2014-06-14Merge pull request #518 from aledeg/wordingGravatar Marien Fressinaud
Wording
2014-06-14Solve bug for passwords with special charactersGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/328#issuecomment-43250647
2014-06-14Fix wordingGravatar Alexis Degrugillier
2014-06-14Un peu de typo FR (points/exclam)Gravatar draky50110
2014-06-14Improve system of queriesGravatar Marien Fressinaud
- Coding style - More checks server side - Default query name is "Query n°X" - List of queries is moved into nav_menu, in a dropdown - Better system to remove fields in JS (to a.remove elements, give an attibute data-remove="id_to_remove") - Fix a bug in lib/Mine/Request.php (htmlspecialchars_utf8 can be applied on arrays now) - Few theme improvements - Add an element .no-mobile to apply to elements which should not appear on mobiles See https://github.com/marienfressinaud/FreshRSS/pull/498
generated by cgit v1.2.3 (git 2.39.1) at 2026-02-10 15:52:45 +0000