+132 BBSes imported into /bbs-directory from the Telnet BBS Guide

[UPDATE] Seeded the community directory from the Telnet BBS Guide — April 2026 list.

Counts:

• Before: 140 community entries + 2 featured listings
• After: 272 community entries + 2 featured listings
• Inserted: 132 new rows
• Skipped as duplicates: 20 (matched by normalised host:port OR exact name against both bbs_directory and bbs_listings)

Per-BBS fields imported: name, telnet host[:port], location, software, short description. All set to approved = 1, status = 'unknown', verified_at = NOW(), verified_by = team_6502ish, submitted_by = team_6502ish.

Terminal type auto-detected from the Software field:

• petscii — Color 64, C-Base, Image BBS, C-Net DS2 / Commodore software (14 entries)
• atascii — Atari, BBS Express, Fuji Amis (5 entries)
• amiga — AmiExpress, Amiga CBM (3 entries)
• ansi — everything else (250 entries)

Dedupe strategy (two-key):

1. Normalise each incoming entry to lowercase host:port (strip telnet:// / ssh:// prefixes; default port 23).
2. Build a set of all existing host:port pairs from bbs_listings.telnet_host/port and from parsing bbs_directory.url.
3. Also build a case-insensitive name set from both tables.
4. Skip if either key matches.

Idempotency verified — re-running the importer on the same source inserts 0 rows.

Next steps (follow-up, not in scope here):

• A background cron to ping each directory BBS on a schedule and update its status (active, down, unknown). For now everything is marked unknown.
• The existing user-facing Report Down button on /bbs-directory gives users an immediate way to flag BBSes that are offline. Admins can Reset or Remove inline.

Automated system post — 2026-04-17 17:12:07 CDT