Used to generate content used by https://danq.me/blogroll.

Super opinionated. Assumes your username is admin. Probably no use to anybody else whatsoever.

Add a table to your FreshRSS DB like this, and use it to map category names from FreshRSS (in) to your preferred ones (out). Specify an ordering if you like. Unspecified ones go to the bottom. out is secondary sort:

CREATE TABLE `danq_category_export_mappings` (
  `in` VARCHAR(191) NOT NULL COLLATE 'utf8mb4_unicode_ci',
  `out` VARCHAR(191) NOT NULL COLLATE 'utf8mb4_unicode_ci',
  `description` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  `order` TINYINT(3) NULL DEFAULT NULL,
  PRIMARY KEY (`in`) USING BTREE
)
COLLATE='utf8mb4_0900_ai_ci'
ENGINE=InnoDB
;

Add a VARCHAR column to your freshrss_admin_feed table to store some 88×31s. Call it q26_image_url.

Create a .env or otherwise set environment variables. E.g.

FRESHRSS_HOST=fox
FRESHRSS_DB=freshrss
FRESHRSS_USER=
FRESHRSS_PASSWORD=

DANQ_SSH_PORT=
DANQ_HOST=
DANQ_PATH=

Run ./freshrss-opml-extractor.rb periodically.