A Full Broadcast Network, Built for a Virtual City

LSN Hub is the command center for Los Santos News — a 65-person virtual newsroom inside Highlife RP. What started as a CSV shift tracker is now a full newsroom OS: Claude-powered AI writing, browser-based video-to-GIF via FFmpeg.wasm, a Discord bot that cross-posts breaking news to the Highlife Publications channel, a phased onboarding system with portal tooltips and a three-phase checklist, and an immutable audit trail. 15+ Vercel serverless endpoints, 30+ PostgreSQL migrations, dual-environment deployment on hub.lossantos.news — and a companion public website at lossantos.news.

ReactViteSupabaseClaude APIFFmpeg.wasmDiscord APINext.jsVercel

Dashboard — 8 tools, one newsroom. Each card routes to a specialized module.

100%

👤

Reporter / Admin

hub.lossantos.news

🔐

Supabase Auth

JWT, 24h TTL, force reset

🛡️

Row-Level Security

4-tier via Postgres funcs

🗂️

Profiles Table

Role, Discord ID, certs

📋

Employees Table

Rank, callsign, Steam ID

📊

Shift Analytics

CSV parse + anomaly flags

Phase 0•Core Platform•Tap a node for details

Key component

Infrastructure

Data flow

Core Platform

Phase 0

The foundation. Supabase Auth with JWT (24h TTL), PostgreSQL Row-Level Security enforcing a 4-tier role hierarchy (Admin > Editor > Creator > Viewer), employee roster with Steam ID matching, and CSV-based shift analytics with anomaly detection.

What Ships

→Supabase Auth with email/password + forced password reset gate on first login

→Row-Level Security — 4-tier enforcement via is_admin(), is_editor_or_admin(), get_my_role()

→Employee Roster — directory with rank, certs, callsigns, Steam name/hex, Discord username

→Time Tracker — CSV upload, dual-format parsing (clock events + paired in/out)

→Shift Builder — clock in/out pairing with anomaly flags (>4h, <30m, missing clock-out)

→Analytics — Recharts area/bar charts with 7d/14d/30d/90d/custom ranges

→3-pass auto name matching (exact, normalized, reversed name order)

→localStorage fallback + Supabase cloud sync (fast offline, authoritative online)

Impact

LSN staff have secure, role-isolated access to shift data and employee records. Multi-tenancy is structurally enforced at the database — data leaks are impossible by design.