Because RR just keeps breaking rss.
Find a file
Repository files (latest commit first)
Filename Latest commit message Latest commit date
2026-10-28 10:05:16 -07:00
README.md Update README.md 2026-10-28 10:05:16 -07:00
RoyalRoadApiBridge.php Add RoyalRoadApiBridge.php 2026-10-26 17:08:05 -07:00

see edfig.dev

  1. Put the php file in your $RSSBRIDGE_CONTAINER_DIR/config/ folder if you're running in docker or in /app/Bridges/ otherwise.

  2. Restart rss-bridge

  3. edit the sqlite db in freshrss to rewrite royalroad URLs to the rss-bridge url. Edit this bash and run it yourself

SRC='https://www.royalroad.com'
BRIDGE='$YOUR_RSS_BRIDGE_URL'
DB='$PATH_TO_SQLITEDB'
# if you're using the official image:
# DB='/config/www/freshrss/data/users/$YOUR_FRESHRSS_USERNAME/db.sqlite'

# RR author note flags: '&nopre=on' hides the note before the chapter, '&nopost=on' hides the note after it.
# Use both ('&nopre=on&nopost=on') or leave empty ('') to keep both notes.
FLAGS='&nopre=on&nopost=off'

SQL="
BEGIN;

-- Old articles: set guid to the chapter link so they match the bridge items and keep read status
UPDATE entry SET guid = link
WHERE id_feed IN (SELECT id FROM feed WHERE website LIKE '$SRC/fiction/syndication/%') AND link LIKE '$SRC/fiction/chapter/%';

-- Feeds: bridge URL, website points at the fiction page, CSS selectors cleared
UPDATE feed SET
  url         = '$BRIDGE/?action=display&bridge=RoyalRoadApiBridge&id=' || replace(website, '$SRC/fiction/syndication/', '') || '$FLAGS&format=Atom',
  website     = '$SRC/fiction/' || replace(website, '$SRC/fiction/syndication/', ''),
  pathEntries = NULL,
  attributes  = json_remove(attributes, '\$.path_entries_filter', '\$.content_action', '\$.SimplePieHash')
WHERE website LIKE '$SRC/fiction/syndication/%';

COMMIT;

SELECT id, name, url, website FROM feed WHERE url LIKE '%RoyalRoadApiBridge%';
"
  1. You should probably back up your original.. docker exec freshrss cp "$DB" "$DB.original"

  2. Then run the command docker exec freshrss sqlite3 "$DB" "$SQL"