Changelog

• Gym and team search (used by the experience editor on the profile) now normalizes punctuation in the query and matches each token independently. Typing 'cheer athletics frisco' now finds 'Cheer Athletics - Frisco' without the user needing to add the dash.

• The 'Social Links' section (VideoManager with the paste-a-link form) is no longer rendered on the profile Highlights tab. The Highlights tab now shows only the user's pinned highlight posts. EmbeddedVideo data and the VideoManager component remain available wherever else they're used.

Files Changed

• New Global feed at /global — reverse-chronological firehose of every public PersonPhoto + ProfileVideo upload across the platform. Guest-accessible (no login required) so new visitors can discover athletes before they pick anyone to follow.
• Third tab between For You and Hub in the feed tab nav, on /home, /global, and /news.

• Photo and video posts in the For You feed (and the new Global feed) now display the author's current team and gym under their name, sourced from the most recent ongoing PersonExperience. Mirrors the team · gym pattern already used by performance cards.
• FeedList component accepts an apiPath prop so /global can paginate against /api/feed/global while /home keeps using /api/feed.

Files Changed

• Worlds 2026 Prelims scores — 71 performances across 5 wild-card divisions
• Worlds 2026 Semi-Finals scores — 488 performances across all 29 divisions
• /competitions/cheerleading-worlds-2026 now shows the full Prelims → Semi-Finals → Finals progression for every team that competed

• scripts/import/scrape-worlds-2026-results.ts and import-worlds-2026-results.ts now take a --round flag (prelims | semi-finals | finals); finals remains the default for backward compat

Files Changed

• PRIVACY: 4-tier profile visibility (Only me / People I follow / FullOut users / Everyone)
• Replaces binary Person.isPublic with a Person.visibility enum and applies
• the chokepoint helper across every surface that lists or links to a Person:
• profile page (including SEO metadata + OG image), team rosters, gym rosters,
• /people directory, search APIs, follower/following lists, PDF export, and
• the discover/PCL/athlete-spotlight content surfaces.

Files Changed

• PROFILE: 4-tier privacy controls in the profile overflow menu — Only me, People I follow, FullOut users, Everyone (default)
• Profile visibility filter applied across team rosters, gym rosters, /people directory, search, follower/following lists, OG image, and PDF export
• Private profiles return noindex metadata and a generic OG image (no name/photo/team leak via SEO)

• Replaced binary Person.isPublic with a Person.visibility enum (ProfileVisibility). Legacy isPublic stays in sync until removed in a follow-up migration.
• 'People I follow' tier semantics: following someone consents to letting them see your profile (owner-controlled circle).

Files Changed

• NAV: align expanded/collapsed sidebar shape; move Post button above Collapse
• Groups in the desktop sidebar no longer persist their open/close state to
• localStorage — they default to closed and only auto-open when a child
• route is active. This makes the expanded sidebar's default structure
• match the icon-only collapsed sidebar (same 9 top-level rows).
• Also moves the Post CTA from the top of the nav to directly above the

Files Changed

• NAV: add Post button to desktop sidebar
• Mirrors the mobile bottom-nav "+" pill. Wires up the existing onPostClick
• prop (already passed by app-shell) so the sidebar opens the same
• PostDialog the desktop shell already had plumbed.

Files Changed

• NAV: stop Profile from highlighting on My Stuff routes
• Profile's match list included bare /${username}, which prefix-matched
• every /${username}/* My Stuff route (My Teams, My People, etc.) and
• lit Profile up alongside the active item. The bare path isn't a real
• route — Profile lives at /@${username} — so the matcher entry was
• dead weight that happened to break the active state.

Files Changed

• NAV: fix bottom nav floating mid-screen in iOS PWA — portal to body + force composite layer
• Portal MobileBottomNav directly to document.body so no React-tree ancestor
• can ever introduce a transform that breaks position:fixed. Sibling-rendering
• (commit 6cdc484) relied on Providers never introducing transformed DOM —
• fragile contract. Portal makes the chokepoint enforcement durable.
• Add transform: translateZ(0) on the fixed wrapper to force a GPU composite

Files Changed

• PAYOUTS: escape apostrophe in Awaiting review description
• Vercel build was failing on react/no-unescaped-entities.

Files Changed

• SCHEDULE: import 2026 D2 Summit performance order from Varsity PDF
• Imports 1324 entries (905 confirmed teams + 419 TBD finals slots) across
• 3 days and 5 venues at ESPN Wide World of Sports. 89% triple-matched
• auto-imported, 50 flagged for review, real unmatched teams under 20.
• Multi-track block-schedule layout: lines can carry 1-2 division markers
• (e.g., "L4 SCM #2 L4 SS-A #1 Titan Elite - Immortals") — disambiguated

Files Changed

• PARTNERS: lookup by email OR username in Add Partner form
• The /api/admin/users search already covered username, but the endpoint's
• select omitted it — so the form's slug-from-username fallback (line 64)
• silently never fired. Adds username to the select and surfaces it in the
• form: relabeled input, Enter-to-search, and an exact-match preference so
• a partial query like 'joe' no longer grabs whichever joe* was created

Files Changed

• DEBUG: check out scripts from recent investigations
• Adds the one-off investigation + maintenance scripts that have been
• sitting untracked for a while:
• scripts/health/check-partner-system.ts — health check for the
• partner/affiliate system end-to-end.
• scripts/debug/check-d2-summit.ts, check-summit-finals-detail.ts,

Files Changed

• OG: refresh subtitle to lead with concrete benefits
• Replaces the abstract "Competitive cheerleading, organized." with a
• benefits-led line: live scores, season history, free athlete profiles.
• Same image, sharper hook for link previews.

Files Changed

• PAYOUTS: partner-requested payouts with admin queue, email + in-app alerts
• End-to-end affiliate payout request flow.
• PARTNER SIDE (settings → affiliate)
• "Request payout" button on the Pending card, gated on
• available balance >= partner.payoutMinimumCents and disabled when an
• in-flight request already exists (one at a time).

Files Changed

• BADGES: fix Elite tooltip label — was reading "Prep subscriber"

Files Changed

• UI: cleaner division detail rows — drop medal emojis, surface gym name
• Replaces 🥇🥈🥉/#N placement glyphs with consistent #N for top-3 too.
• Emoji rendering varies wildly across platforms and looked decorative
• next to the otherwise dense, tabular score rows.
• Adds the gym name (linked to the gym page) under team name on each
• score row, hidden on mobile (`hidden sm:inline`) to avoid crowding

Files Changed

• UI: align mobile bottom-nav Post button with icon+label rhythm
• The center compose button was a popped-up 44px FAB (-mt-5, no label),
• which broke the rhythm of the surrounding icon+label nav items. Now it
• matches its siblings: column layout, 28px pink badge with Plus icon
• above a "Post" label, so the whole row reads as five aligned objects
• instead of "four nav items + a floating button."

Files Changed

• BADGES: refresh tier verification colors — Pro = brand pink, Elite = soft cyan
• Tier checkmark badge moves to the brand palette: Pro fills with hero pink
• (#EE2B8C / --primary) + white check; Elite fills with soft cyan (#91E5E5)
• + deep-teal check (#0F4C4C) for tonal cohesion. Replaces the old generic
• blue + yellow.
• Also moves the PRO row in `tierColors` from hardcoded pink-* Tailwind

Files Changed

• URLS: route person search results to /people/<username>, not opaque ID
• Search results now carry the username as `slug` so consumers can build
• the human-readable /people/<username> URL. The dynamic route accepts
• either shape, but the username path was 404'ing for follows because the
• fallback used Person.id directly.

Files Changed

• SKILLS+VERIFY: by-level visualization, click-to-add, pink hero, 20s video cap
• Skills tab on profiles is now organized by USP level (1, 2, 3, 4, 4.2, 5,
• 6-Junior, 6-Worlds) instead of category. Each level is a collapsible card
• showing claimed/total + a pink progress bar; collapsed by default so the
• landscape is browsable without overwhelming the page.
• Every rubric skill renders (claimed + unclaimed), so viewers can see what

Files Changed

• Skills tab on profiles is now organized by USP level (1, 2, 3, 4, 4.2, 5, 6-Junior, 6-Worlds) instead of category. Each level is a collapsible card showing claimed/total count and a pink progress bar. Levels are collapsed by default — expand the ones you care about.
• Every rubric skill is rendered (mastered + unmastered) so viewers can see what an athlete has and hasn't claimed at each level. Unclaimed skills appear as ghost chips.
• FullOut Verified hero color swapped from emerald to brand pink (#EE2B8C) across the chip, showcase preview, and PDF profile export.
• Under-review chips moved from amber to soft cyan (#91E5E5) for a calmer in-progress signal.
• Skills tab copy updated: 'Track your mastered skills. Submit them for review to become FullOut Verified.'
• Verify page now states the constraints up front: one skill per video, 20s max, three separate clips.

• Click-to-add: clicking any unclaimed (ghost) chip on the skills tab adds it as self-reported instantly — no modal. Hover state telegraphs clickability with a pink tint and Plus icon. Spinner shows while the request is in flight.
• Color legend at the top of the skills tab so viewers know what each chip state means at a glance.
• Per-level progress bar in each level header showing claimed/total proportion (visible on mobile too).
• Tooltip-on-hover for every chip showing the full skill name + status (e.g. 'Verified · 4/15/2026'). Replaces native title with Radix Tooltip.
• 20-second client-side cap on verification video uploads. Files are probed via a hidden <video> element before upload — clips longer than 20s are rejected with the actual duration in the error toast, saving bandwidth.

• Add Skill modal and its search/filter UI — the by-level grid replaces it. Roughly 150 lines of dialog code retired.

• Verify-skill upload link previously pointed at /people/<personId>/... and 404'd because the route expects a username. Now uses person.username with proper URL-encoding.

Files Changed

• SUBSCRIBE+CANCEL+TRIAL: trial-end Klaviyo event, Resume button, banked months UI, cancellation banner
• Trial-ending notification (the actual bug)
• Webhook now handles customer.subscription.trial_will_end. Stripe fires
• this 3 days before trial_end automatically; we forward to Klaviyo as a
• "Trial Ending" event with tier, end date, charge amount, and cadence so
• a Klaviyo flow can send "your card will be charged on {date}" with a

Files Changed

• PROMO: clearer admin form copy + Stripe coupon-mapping unit tests
• Rewrites the Create/Edit Promo Code dialog so non-engineers can read it:
• Three preset buttons (1 month free, free forever, 50% off 3 months)
• Duration field relabeled with an inline cheat-sheet (1 / 6 / blank)
• Live "What the user gets" preview that mirrors the Stripe coupon shape
• Extracts buildStripeCouponParams() into src/lib/promo-coupon-mapping.ts

Files Changed

• FIX: don't bounce off /login when ?switch or ?add and useSession is stale
• Account switcher fall-back ended on a blank page: signOut sometimes can't
• clear the session cookie (e.g. COOKIE_DOMAIN drift), so useSession still
• reports "authenticated" on /login. The form returned null and redirected
• to /home, which redirected back to /login — a loop that rendered blank.
• Always show the form on the explicit switch/add flows so a fresh sign-in

Files Changed

• CHORE: gitignore /og-previews/ — local design-review PNG dumps
• Generated by curling the OG image routes from prod for visual QA;
• shouldn't ship in the repo.

• SUBSCRIBE+CANCEL: surface referrer profile + trial copy on subscribe; cancel at period end
• Subscribe page
• Show the referrer's avatar, name, and profile link in the green
• callout when arriving via a ?ref= URL. /api/referral/validate now
• returns name/username/image instead of hardcoded "A friend".
• Mirror the server-side REFERRAL coupon client-side so the Order

Files Changed

• ADJUST: bump OG card text sizes/weights + load real Inter font
• Per design feedback that the OG cards looked thin/small:
• Load Inter from Google Fonts at render time (subsetted to only the
• glyphs each card uses, ~80% bandwidth saving) and pass to
• ImageResponse so fontWeight 700-900 actually renders heavy. Without
• this Satori falls back to its built-in font where every weight looks

Files Changed

• FIX: team KPI strip overlapping sidebar + truncating labels at lg
• Switched the strip to a 3-col grid at lg (5-col at xl) and removed the
• mobile edge-bleed margins once the sidebar layout activates, so the
• cards stay inside the left column instead of crashing into the Athletes
• sidebar. Trimmed cell padding to px-3 at lg so "PERFORMANCES" fits.

Files Changed

• FIX: inline FullOut logo as base64 so OG entity routes actually find it
• outputFileTracingIncludes globs with bracketed dynamic segments like
• [id] don't reliably bundle public/ assets — minimatch treats brackets
• as character classes. The brand /opengraph-image route worked because
• its key was a simple path; /teams/[id]/opengraph-image kept ENOENT'ing.
• Inline the 84KB PNG as a base64 data URI in src/lib/og-logo.ts. The

Files Changed

• FIX: bundle public/Logos with OG image routes via outputFileTracingIncludes
• The redesigned OG cards read the FullOut logo PNG with fs.readFile, but
• the public/ directory isn't auto-traced into Vercel's serverless bundles.
• Result: ENOENT on every entity OG render. Following the existing pattern
• in this config (already used for /api/admin/.../scorecards and the cron
• content routes) to explicitly include public/Logos for the four OG routes.

• ADJUST: bigger FullOut logo + Build Your Legacy tagline + higher contrast on OG cards
• Per design feedback:
• Replace the small text wordmark with the actual FullOut logo PNG
• (read once per cold start from public/Logos and embedded as a base64
• data URI so the renderer doesn't depend on a reachable host)
• Add the "Build Your Legacy" tagline directly under the logo on every

Files Changed

• FIX: drop explicit openGraph.images so file-based OG cards take effect
• The new src/app/opengraph-image.tsx (brand) and
• src/app/people/[username]/opengraph-image.tsx (profile) cards weren't
• showing up because both pages set openGraph.images explicitly in their
• generateMetadata, which beats the file-based metadata convention.
• Removing the explicit array lets Next.js auto-attach the rendered PNGs.

Files Changed

• ADD: branded opengraph-image cards for profiles, gyms, teams + brand fallback
• Drops the one-off /build-your-legacy OG image and replaces it with a
• cascading set:
• src/app/opengraph-image.tsx — brand fallback (FullOut · Build Your
• Legacy) used by every route that doesn't override it
• src/app/people/[username]/opengraph-image.tsx — avatar + name + handle

Files Changed

• ADD: opengraph-image.tsx for /build-your-legacy
• 1200x630 PNG generated from JSX via next/og, pulling the featured athlete
• (currently @babygraham) from the DB. Auto-attached to the page via
• Next.js metadata file convention, so any platform that scrapes the URL
• (Slack, iMessage, Twitter, Discord, LinkedIn) shows a rich preview.
• Cached for 1h. Directly downloadable at

Files Changed

• FIX: escape apostrophes in referral admin + card so prod build passes
• ESLint react/no-unescaped-entities was failing the build, blocking the
• SKILLS+VERIFY deploy that fixes the prod 500s on every user page.

Files Changed

• SKILLS+VERIFY: rebuild skills system on USP rubric + ship FullOut Verified Phase 1+2
• Replaces the hand-curated 77-skill catalog with a versioned-rubric foundation
• so atomic skills survive when scoring orgs republish levels season-to-season.
• Atomic skills are durable (Back Handspring is always Back Handspring); the
• level/tier they earn at lives in LevelRubricEntry per (ScoringSystem × season),
• so when USP shifts a skill in 2027-2028 we add new mapping rows without

Files Changed

• AFFILIATE+REFERRAL: namespace campaign URLs, stackable referral months for everyone
• Partner program
• PartnerCampaign.code: drop global @unique, add @@unique([partnerId, code]).
• Campaign URLs now live under the partner slug (?p=joe-rodgers/test-1)
• so two partners can't collide on the same root code. Validate, track,
• checkout, webhook, OG-metadata, referral, and admin paths all parse

Files Changed

• FIX: desktop sidebar avatar disappearing in md-to-lg viewport range
• Sidebar grid is 72px wide below lg even when expanded, but the avatar
• block was using sidebarCollapsed alone to switch between small avatar
• and full profile card — and the full card was gated on `hidden lg:block`.
• Result: at md (768-1023px) with sidebar expanded, neither variant
• rendered. Always render the small avatar when the sidebar column is

Files Changed

• LEGAL: Children's Privacy Policy + COPPA-compliant signup with verifiable parental consent
• The previous flow had a self-attestation checkbox at upload time that does not
• satisfy 16 CFR § 312.5(b) — under-13 PII was collectable based on the child
• clicking 'my parent approves'. This commit closes that gap on the front end and
• fills the entire § 312.4(d) notice obligation.
• Front-end:

Files Changed

• Children's Privacy Policy at /childrens-privacy covering all 16 CFR § 312.4(d) notice elements: operator identification (FullOut LLC), what we collect from children, how we use it, third-party disclosure categories, written retention policy, persistent identifier handling, parental rights, and contact info.
• Date-of-birth field on signup with under-13 branching: when the entered DOB indicates the user is under 13, the form asks for a parent or guardian's email instead of creating an account immediately, and the submit button reads 'Send approval request'.
• Parental consent magic-link flow: under-13 signups create a ParentConsentRequest row instead of a User; the parent receives an email at the address they provided with a 7-day signed link to /parent-consent/[token] where they review the data practices, confirm parental status, accept the policy, and approve. On approval the User+Profile+Person are created in a single transaction with parentalConsentAt set and isPublic=false (private by default for under-13).
• Awaiting-approval landing page at /awaiting-parent-consent for the child to see after they submit.
• Footer 'Children's Privacy' link in src/app/layout.tsx between Privacy and Terms.

• Privacy Policy fully rewritten to be COPPA-honest: identifies FullOut LLC as the operator with full mailing address, phone, and team@fullout.energy email; replaces the prior 'we do not knowingly collect from children under 13' line (which was inaccurate given Mini/Youth profiles) with a pointer to the Children's Privacy Policy; documents specific service-provider categories (Vercel, Supabase, Mux, Stripe, Resend, Google Analytics); adds a written retention policy (active data while account exists, 30-day deletion, 90-day backup overwrite, 24-month log retention).
• Terms of Service updated with age requirements (must be 13+ to self-register; under-13 profiles must be parent-created with verifiable consent), FullOut LLC entity block, and references to both privacy policies.
• Register API now requires birthDate; for 13+ accounts the birthDate is stored on the Person record (previously not captured at signup).

• Under-13 signups never create a User row until verifiable parental consent is recorded — the child's hashed password is held in ParentConsentRequest until approval and discarded if expired or denied.
• Parent consent links expire in 7 days; expired links surface a clear error page rather than silently failing.
• Re-using an already-approved or already-denied consent link shows a final-state page instead of letting it be replayed.

Files Changed

• UI: tighten radii globally + fix mobile overflow on gym page and post action bar
• Drop the borderRadius scale from xl=24px/2xl=32px down to xl=8px/2xl=10px
• across all rounded-* tokens so cards and surfaces feel less bubbly. Fix
• gym page double-padding (was stacking px-4 over app-frame), kill the
• overflow-x-auto wrapper that was masking long competition names, and
• truncate the comp name link properly with flex-1 min-w-0. Hide

Files Changed

• scripts/import/scrape-worlds-2026-results.ts: scrape the master Finals Score Ranking table from cheertheory.com/the-cheerleading-worlds-2026-finals-results/ and write data/inbox/worlds-2026-cheertheory-finals.json. The per-division sections higher on the page render scores inline (no <table>) so we deliberately parse only the master table.
• scripts/import/import-worlds-2026-results.ts: idempotent importer for the Finals JSON. Maps rawDivision → canonical name to match the schedule importer's DIVISION_CODE_MAP, parses country suffix off team and program names, routes through the alias-aware gym/team matchers. Defaults to --dry-run; --execute writes; --reset wipes existing Finals rows for this competition only (scoped to (competitionId, round='Finals')).
• Already run in prod — checking these in for posterity so the import path is reproducible.

Files Changed

• New helper src/lib/teams/normalize-team-name.ts strips a leading gym-name prefix from a team name ("Cheer Athletics Panthers" at gym "Cheer Athletics" → "Panthers"). Comparison is case + punctuation insensitive ('Twist & Shout' == 'Twist and Shout'). Single-token gym names, mid-word matches, and brand-tail-only remainders (athletics/allstars/cheer/...) are guarded against to avoid corrupting names when the gym side itself is a stub.
• src/lib/import/team-matcher.ts findOrCreateTeam now normalizes the incoming team name through the helper before computing the cache key + DB lookup, so dirty inputs hit the same canonical row instead of creating duplicates. Gym name is cached per gymId.
• scripts/maintenance/normalize-team-names.ts backfills historical rows: rename in place when no sibling clash, otherwise merge the prefix-team into the cleaner sibling (re-point Performance/Deduction/ScheduleEntry FKs, handle unique-constraint collisions, delete the loser). Defaults to --dry-run; --execute writes. Scope with --gym-name= or --gym-id=. Stubs (team.name === gym.name) are intentionally skipped.

Files Changed

• sendSms() in src/lib/sms.ts now short-circuits with a single console.warn and returns false when SMS_NOTIFICATIONS_DISABLED is true. Twilio client is not constructed; no outbound SMS leaves the app.
• This is a hot-patch kill switch, not a config flag — flipping it back on is a one-line revert. Track the underlying volume investigation separately.

Files Changed

• Feed was showing Pumas' Summit Semi-Finals (97.27, 3rd) instead of Finals (97.58, 3rd). Cause: /api/feed sorted performances by Competition.date, which is identical for every round at a multi-day event, so Finals vs Semis was a non-deterministic tie and one round often got dropped from the page. The 'Xd ago' label was also the comp's start date, not when the score landed.
• Switched the orderBy to scoreChangedAt → performedAt → Competition.date, widened the cursor filter to match, mapped the feed item createdAt to the same effective timestamp, and added per-(team, competition) dedup that keeps the latest round. Verified Summit data: 2253/2253 performances have scoreChangedAt populated, and Pumas Finals' scoreChangedAt is later than Semis' as expected.

Files Changed

• UI: clear nav search on pathname change + widen team stats breakpoint to xl
• HomeSearch holds the previous query when the navbar persists across
• client-side navigations (typing "lions" then clicking a result left
• "lions" in the input). Reset query/results/open-state on pathname change.
• TeamStatsStrip switches its mobile-stack→grid breakpoint from lg to xl
• and adds whitespace-nowrap to label rows so multi-word stats don't wrap

Files Changed

• DATA: durable Division-name dedupe — normalize on write + consolidate existing dupes
• Across ingest paths Division.name had accumulated 1,667 near-duplicate rows
• that differed only by whitespace, dash style, or punctuation
• ("L1 Youth - D2 - Medium - WC" vs "L1 Youth - D2 Medium - WC", "L4 U17 -" vs
• "L4 - U17"). These bypassed @@unique([disciplineId, name]) and split single
• competition divisions into multiple Division rows, which split team

Files Changed

• UI: team page — clickable Level/Age/Size chips, drop medal emoji, score-signature dedupe
• TeamHero now renders Level / Age / Size as individually clickable filter chips,
• plus a combined Level Age Size badge that filters /teams by all three
• PerformanceCard shows uniform numeric placement circles instead of trophy
• emoji medals for top placements
• Performance dedupe key drops round so identical placement+score+deductions at

Files Changed

• FIX: route scraped-score imports through alias-aware gym/team matchers
• The score-import pipeline (scripts/import/import-scraped-data.ts) had its
• own naive findOrCreateGym/Team that did exact case-insensitive name
• match and created a new row on miss — bypassing GymAlias entirely. So
• every scrape after a gym merge would happily re-create the duplicate,
• fragmenting the data we just consolidated.

Files Changed

• DATA: merge Spirit of Texas Houston into Spirit of Texas
• Two gym rows for the same All Star program in Houston, TX — one created
• 2026-03-14 with the rich historical data (47 teams, 1018 perfs), one
• created 2026-03-21 from a recent live-scrape import (18 teams, 42 perfs)
• with the cleaner /gyms/spirit-of-texas slug. Merge preserves the slug
• the user wants to keep while pulling all historical scoring/follow data

Files Changed

• DATA: cleanup prefix-artifact team names in Woodlands Elite chain
• The CheerTheory importer strips "Gym - Team" prefixes correctly but the
• live-scrape import path does not, so new All Star imports keep creating
• teams named "Woodlands Elite - Black Ops" instead of "Black Ops". The
• April 15 cleanup (commit f0660e4) handled the backlog at the time, and
• 17 new artifacts have accumulated in the Woodlands Elite chain since.

Files Changed

• UI: deterministic initials-avatar fallback when logo/photo missing
• New <InitialsAvatar name src size /> in src/components/ui/. Renders the
• image when src is set, otherwise a colored circle with name initials.
• Background hue is a deterministic hash of name, so the same brand
• lands the same color across pages.
• Replaced six bare-icon placeholders (Building2/Users/GraduationCap/

Files Changed

• UI: show gym + round on feed performance cards

Files Changed

• UI: smarter discover-page ranking — follow-boost, starts-with, quality tiebreakers
• Discover-page results were effectively alphabetical because trigram
• similarity ties (every "Wild..." team scored the same) had no useful
• secondary sort. Apply the same boost pattern shipped to the typeahead,
• plus a starts-with bonus and per-type quality tiebreakers.
• Discover ORDER BY layers (per entity type):

Files Changed

• UI: tighten feed card radius; fix avatar fallback for non-letter usernames

Files Changed

• UI: smarter search — follow-boost, follows-on-focus, substring highlight
• /api/search now boosts followed entities in ORDER BY. Teams whose gym
• you follow outrank unfollowed teams of equal similarity; directly-
• followed teams outrank same-gym matches. Anonymous users see no boost
• (empty arrays make ANY('{}'::text[]) a no-op).
• Empty query returns the 24 most-recent follows (gyms, teams, people,

Files Changed

• Search: focusing the navbar search with no query now shows your followed teams, gyms, people, and choreographers immediately so the most-relevant entities are one click away.
• Search: typing 1 character filters your follows locally (instant, no network); 2+ chars hits the full trigram search.
• Search: matched query tokens are highlighted in result names and subtitles.

• Search ranking now boosts followed entities. Teams whose gym you follow rank above unfollowed teams of equal similarity (so 'Wild...' surfaces the Wildcats from your followed gym first). Directly-followed teams beat same-gym matches.
• Wired HomeSearch typeahead into the navbar (replacing the plain submit form on both desktop and mobile auth views) with a new compact size variant.

Files Changed

• UI: hide stray feed-tabs scrollbar; unify feed card style across breakpoints

Files Changed

• UI: show rank in performance trends tooltips (gym + team pages)

Files Changed

• UI: surface division + placement on /home performance cards, link to division group page
• Pull Division (with slug + display fields) and Performance.placement into
• the home feed query (both server-render in app/home/page.tsx and the
• infinite-scroll API in app/api/feed/route.ts) and pre-compute a
• divisionHref on each performance feed item.
• Performance cards now show the division name as a third subtitle line and

Files Changed

• DEBUG: add paid-tier audit script
• scripts/debug/audit-paid-tier-users.ts groups users by subscriptionTier
• and lists every paid-tier account with its role, Stripe state, and most
• recent Subscription row. Used to verify admin-driven tier flips after
• the auth.ts session-refresh fix.

Files Changed

• FIX: resumable + hash-skipped imports so live events update fast
• The Summit (220 divisions, 2145 teams) couldn't finish a full import in
• the live-monitor cron's 5-min maxDuration. Status never flipped to
• COMPLETED, the next tick re-imported from scratch, and the loop never
• made progress — Finals from May 4 never reached the DB.
• Two changes, one chokepoint:

Files Changed

• UI: cleanup competition page — collapsibles, rank numbers, Insights tab
• My Teams & Gyms: card and each gym row now collapsible via native
• <details>; gym rows default closed and toggle on click (no longer
• navigates to gym page).
• Division cards: replace medal emojis with #1/#2/#3 rank numbers; #1
• renders bold in primary color. Show all divisions per level (drop the

Files Changed

• UI: align navbar bottom border with page content shell
• Move border-b from the full-width <header> onto an inner div sitting
• inside the app-frame's 12px gutter so the navbar's visible bottom line
• ends at the same horizontal extent as the sticky profile header, the
• profile card, and the photo feed below. Background stays edge-to-edge
• so the iOS status-bar area still renders consistently.

Files Changed

• FIX: admin tier changes ignored until user re-logs in
• Session callback was overlaying token.subscriptionTier and token.role
• into the session without ever refreshing them from the User row. So
• when an admin updated a user's tier in /admin/users, the User.subscriptionTier
• column flipped correctly, but the user's existing JWT still carried the
• old value. Every paywalled page reads session.user.subscriptionTier, so

Files Changed

• FIX: live-scores feed showing stale rows as "1m ago"
• The feed was sorting by Performance.updatedAt, which Prisma bumps on any
• row touch. The live-monitor cron's 5-min function timeout was killing
• the post-import status flip on large events, so every minute it
• re-imported the same SCRAPE_COMPLETE Summit job, bumping updatedAt on
• 1500+ unchanged rows. The user saw 4-day-old scores marked "1m ago".

Files Changed

• Live-scores feed was sorting by Performance.updatedAt, which Prisma bumps on any row touch — so the live-monitor cron's idempotent re-imports made every Summit row look like it just changed.
• Add Performance.scoreChangedAt column maintained by Postgres triggers — bumps only when score values or placement materially change. Defense-in-depth: every writer (Prisma, raw SQL, scripts) participates automatically.
• Live-monitor harvest now atomically claims jobs (SCRAPE_COMPLETE → IMPORTING → COMPLETED). Stuck IMPORTING jobs re-arm to SCRAPE_COMPLETE after 45min instead of failing. Fixes the root cause: 5-min function timeout was killing the COMPLETED flip, causing infinite re-import.
• Live-scores API + /live + /gyms/[id] now sort and display freshness based on scoreChangedAt instead of updatedAt.
• Backfilled scoreChangedAt for 325k existing rows using COALESCE(notifiedAt, score.createdAt, performance.createdAt).

Files Changed

• FIX: move iOS-zoom @media block out of @layer base
• Nesting @media inside @layer base appears to have broken Tailwind/PostCSS
• compilation, causing the page to render as unstyled HTML. Move the rule
• to the top level of globals.css where it's processed independently.

Files Changed

• UI: add "My Teams & Gyms" panel to competition page
• Shows followed teams and gyms performing at the competition, grouped
• by gym → team → rounds, above the Division Winners chart. Followed-gym
• includes all of that gym's teams at the comp; followed-team is shown
• on its own under its gym. Each team lists every round it competed
• (Prelims/Semis/Finals/etc.) with final score and placement; #1

Files Changed

• FIX: iOS Safari auto-zooming on input focus
• Force inputs/textareas/selects to 16px on viewports <=768px so iOS doesn't
• zoom in when focusing the search box and other small inputs.

Files Changed

• FIX: team cards on /discover missing logo when gym only has photoUrl
• Team query SELECT'd g."logoUrl" but not g."photoUrl", so the
• team.gymLogoUrl fallback was null for gyms with only photoUrl set
• (e.g. Cheer Athletics - Frisco → NovaCats).
• Added g."photoUrl" AS "gymPhotoUrl" to the query, extended TeamResult
• + TeamRow types, and appended gymPhotoUrl to the fallback chain in

Files Changed

• FIX: competition page showing Prelims when Finals have scored
• User reported Youth Summit 2026 competition overview showing Prelims
• for L3 Youth - Medium even though Finals had landed in the DB with
• real placements + scores. Division detail page was correct.
• Root cause in src/components/competitions/divisions-tab.tsx: the round
• picker filtered out any performance whose performedAt was in the future

Files Changed

• FIX: Varsity scraper dropping Finals for divisions with Prelims
• User reported Finals visible on Varsity TV but missing from competition
• pages. Investigation on Youth Summit 2026: 46 of 54 divisions had only
• Prelims, 7 had both rounds, 1 had only Finals. Scraper ran 18 times today
• and completed cleanly every time — Finals were being fetched from Varsity
• and then thrown away.

Files Changed

• Youth Summit 2026 and similar live events were missing Finals rounds
• on most divisions (46 of 54 Prelims-only, only 7 with both rounds).
• Root cause was in the Python scraper's filter-sweep merge step: when
• Varsity TV's results endpoint is queried with a roundName facet, it
• often returns a record whose name field has been stripped of the
• round suffix, so a Prelims query and a Finals query produce records
• with identical names. The four merge sites in varsity_api_scraper.py
• all keyed on the raw name, collapsing the two records into one via
• choose_preferred_division — which prefers team count, so Prelims
• (larger field) always won and Finals were silently dropped.

• python-scraper/scraper/varsity_api_scraper.py: new division_merge_key()
• helper keys on (base_name, round_label); all four merge sites now use
• it so Prelims and Finals survive as distinct records.
• python-scraper/tests/test_division_merge_key.py: 9 unit tests locking
• in the round-preservation invariant.

Files Changed

• FIX: canonicalize Division.level at the write layer
• User reported Youth Summit 2026 showed only 2 of 16 L2 divisions. Root
• cause was inconsistent Division.level spelling across imports — 2,455 rows
• DB-wide stored "Level N" while others stored "LN", splitting single levels
• into separate UI groups.
• Four-layer fix:

Files Changed

• Competition pages were splitting a single level (e.g. L2) into two
• separate headers when some divisions had been imported as 'Level 2'
• and others as 'L2'. Most visible on Youth Summit 2026, which showed
• only 2 of 16 L2 divisions under the 'Level 2' heading. 2,455 rows
• across the whole DB had non-canonical level strings (Level 1-7).

• src/lib/division-level.ts: new canonical normalizeLevel() utility.
• src/lib/prisma.ts: Prisma client $extends hook routes every
• division.create/createMany/update/updateMany/upsert through
• normalizeLevel so no import path can write a non-canonical value.
• src/components/competitions/divisions-tab.tsx: normalizes at grouping
• as defense-in-depth.
• scripts/maintenance/normalize-division-levels.ts: idempotent backfill
• (ran once to clean up 2,455 historical rows).

Files Changed

• FIX: live-monitor now harvests SCRAPE_COMPLETE jobs (admin-sync race)
• The admin scraper dashboard polls /api/admin/scraper/jobs every 10s
• whenever an admin has the page open, and its sync function flips any
• SCRAPING row whose Python work is done to SCRAPE_COMPLETE. Because
• live-monitor Phase 1 only harvested jobs with status="SCRAPING", any
• scrape the admin path caught first got stuck forever — Python finished,

Files Changed

• LIVE: tighten live-monitor cadence to 10 min (was 45 min)
• Competitions in their live window are now re-scraped every 10 minutes
• instead of every 45. Also split "in-flight" from "recently completed"
• checks so the tighter cadence can't stack duplicate scrapes on the same
• event while one is still running — STALE_JOB_THRESHOLD_MS (45 min)
• still reclaims truly stuck jobs.

Files Changed

• LIVE: tighten live-monitor cadence to 10 min (was 45 min)
• Competitions in their live window are now re-scraped every 10 minutes
• instead of every 45. Also split "in-flight" from "recently completed"
• checks so the tighter cadence can't stack duplicate scrapes on the same
• event while one is still running — STALE_JOB_THRESHOLD_MS (45 min)
• still reclaims truly stuck jobs.

Files Changed

• DOCS: consolidate brand positioning across overview + brand guide
• Rewrite FULLOUT_COMPANY_OVERVIEW.md to align with media-company + athlete-first positioning, drop the phantom 4th tier, and use Prep/Elite/Pro naming. Fix stray "Novice" tier references in brand-guide.md and upgrade-prompt-audit.md to match live /pricing.

• FIX: guard against session.user.id=undefined in dashboard layout
• Prod logs showed "Invalid prisma.user.findUnique() invocation: where.id=undefined"
• on GET /home when a session existed without an id. Tightening the guard from
• session?.user to session?.user?.id redirects those requests to /login instead.

Files Changed

• DATA: strip "TBD" prefix from competition names at all ingest + display paths
• Varsity event listings sometimes use a "TBD" placeholder prefix for unfinalized
• event titles (e.g. "TBDThe U.S. Finals Worcester"). Only the schedule-intake
• route was sanitizing it — auto-discover, bulk-scrape, and rescrape-orchestrator
• all wrote raw titles. Now all three run parseEventName(), the /competitions and
• /competitions/browse pages scrub names on render, and the fix-competition-names

Files Changed

• DATA: audit + merge 19 duplicate gyms created by STUNT import
• The 2026-04-20 STUNT import created new gym records for entities that
• already existed (e.g. "Cheer Athletics Frisco" vs "Cheer Athletics -
• Frisco", Purdue × 2, UT × 2, etc.). scripts/debug/stunt-audit.ts tiers
• candidates by normalized-name + city/state match; scripts/maintenance/
• merge-stunt-gyms.ts moves all 15 gym FK references from dupe → canonical

Files Changed

• UI: consolidate /search + /explore + /discover into single search page
• /discover now hosts the full search experience: trigram + normalized-ILIKE
• matching (fixes "cheer athletic plano" returning no results), tabs with
• counts, grid/table view toggle with sortable table columns, claim banner,
• and category cards as the empty state. /search and /explore became 301
• redirects. Updated all callers (home autocomplete, landing hero, mobile

Files Changed

• PCL: add International Cheer + NBA disciplines, link national teams
• Two new disciplines for PCL athletes' non-all-star/college experiences:
• international_cheer (USA Cheer Coed Premier, All Girl Premier,
• National Team — Anuhea Keene, Maddie Hayes, Kollin Cockrell, Ryan
• Claunch, Hailey Smith, Sahanna Doherty, James Thomas, Anuhea Keene)
• nba (Utah Jazz Stunt Team — Kollin Cockrell, Hailey Smith)

Files Changed

• PCL: backfill gym/team logos and create missing program stubs
• backfill-pcl-gym-logos.ts gains throttling + Wikimedia PNG-thumb URLs
• (Supabase bucket rejects image/svg+xml). Pulled 12 college logos
• (Navarro, TX Tech, Kennesaw, UCF, UWG, Louisville, Morehead State,
• Troy, Sam Houston, Eastern Michigan, UGA, Weber State, Lindenwood)
• plus 3 program logos (Southwestern Christian, Twist & Shout,

Files Changed

• PCL: link athlete experiences to real gym/team IDs
• Resolved 88% of PCL athletes' historical PersonExperience rows
• (224 / 255 gym links, 174 / 255 team links). Previously all rows had
• \`manualGymName\` / \`manualTeamName\` strings only — so PCL pros never
• showed up on their former gym/team pages.
• scripts/setup/link-pcl-gyms-teams.ts — manual rule table for the messy

Files Changed

• UI: add /gyms/[id]/athletes + /teams/[id]/athletes roster pages
• The compact sidebar's "View all" link was pointing at an #athletes
• anchor that didn't exist on desktop, so historical athletes (PCL pros
• whose tenure was years ago) had no way to surface — the season filter
• hid them and there was no full-roster view to fall back on.
• New AthleteRosterBrowser with search, season filter, and sort

Files Changed

• UI: render discipline badges across search, team listings, gym rosters, and athlete profiles
• Teams carry their own Team.disciplineId; athletes aggregate disciplines from
• their team history (PersonExperience + PersonTeamTimeline) so multi-discipline
• pros — e.g. PCL players with All Star and College history — surface all three
• badges side-by-side. Wave 1 covers the home search dropdown and athlete profile
• header; Wave 2 covers /teams grid + list views and the gym page team roster.

Files Changed

• PERF: speed up schedule filters by removing nested Division where-clauses
• The /competitions/[id]/schedule filters were slow because both API routes
• used `where.Division = {...}`, which CLAUDE.md flags as generating slow
• correlated subqueries through PgBouncer (~15x slower). filter-options
• also re-scanned every entry with a Division JOIN on each filter click
• (300ms debounced), and the SSR page re-derived sessions/dates from a

Files Changed

• STUNT: import Youth Summit 2026 schedule (551 performances)
• Parse Varsity PDF performance order and insert CompetitionSchedule +
• ScheduleEntry rows for youth-summit-2026. Thursday, April 23 is split
• across West/Central/East Hall (179/181/191 entries). Friday finals are
• skipped — they are blank bracket slots in the source PDF.
• Match rates: 551/551 divisions, 545/551 gyms, 148 teams exact-matched.

Files Changed

• STUNT: import 849 PSAL HS matches with point scores (2015-2026)
• Reverse-engineered PSAL's WCF JSON service at /SportDisplay.svc — same
• API the team-standings.aspx page uses. Bootstrap session by GETting any
• public PSAL page (cookies set automatically), then call:
• GetSportLeague?csports='069'&season='YYYY' (find STUNT leagues per year)
• getTeamScheduleAny?csports='069'&season=YYYY&schoolid='XXXXX'

Files Changed

• UI: fix unreadable gym popup on /gyms map
• The global maplibre popup override strips background/padding for the dark
• theme, so the gyms-map popup's dark text rendered invisible on the dark
• basemap. Wrap the popup content in a dark card with light text, matching
• the density map treatment.

Files Changed

• STUNT: import 5 historical club championship finals (2022-2024)
• From stuntthesport.org/club-team-rankings/ "Club STUNT Championship
• History" table (10 rows = 5 finals × 2 teams each).
• Covered:
• 2024 West Coast Regional (18U + 14U)
• 2023 West Coast Regional (18U + 14U)

Files Changed

• PROFILE: build Chris Muniz athlete/coach profile + career history
• Person record @roostermuniz with 24 PersonExperience rows covering
• 1999-2019 career arc (Cheer Athletics Plano, TVCC, U of Houston,
• GymTyme, PowerHouse Belton, World Cup Freehold, + 4 historical gyms
• created: Texas Air Force, Cheer Nation, Texas Lonestar teams).
• Also materializes 30 Performance records across 16 newly-created

Files Changed

• STUNT: import 2025 Youth Club Nationals brackets (22 matches)
• Scraped via Playwright MCP from stuntthesport.org/youthclubnationals/.
• Two schedule tables (Day 1, Day 2) — winners are bolded text in either
• the Home or Away cell. Two championship rows (18U + 14U) lack the
• "Game (N)" pattern, parsed separately.
• Special case: 18U Championship row has no bolded winner in HTML — only

Files Changed

• STUNT: webpoint Gym team-coverage diagnostic
• Cross-references webpoint-imported Gyms with their Team counts:
• 71% are directory-only (no teams yet — expected, will accrue from
• competition data). Big all-star programs already have 15-43 teams
• from Varsity TV imports; webpoint just enriched their contact info.

Files Changed

• STUNT: ingest entire 545-program webpoint directory + 188 logos
• Scraped via Playwright MCP: empty-filter search on usacheer.webpoint.us
• returned the complete USA Cheer programs database (545 listings, no
• pagination cap). Cf_clearance cookie from interactive session passed
• Cloudflare invisibly.
• Pipeline:

Files Changed

• STUNT: import 42 more teams from webpoint via interactive browser
• Pivoted from custom scraper to using the Playwright MCP browser directly
• in the user's interactive session. cf_clearance cookie from prior
• solves let us pass Cloudflare Turnstile invisibly. Searched
• CompanyName=STUNT on usacheer.webpoint.us/Clubs-wp.php → 47 STUNT-named
• programs returned with full address + head coach contact info.

Files Changed

• STUNT: import 51 non-college teams from stuntthesport.org
• Webpoint scraper hit a wall — Cloudflare requires a fresh Turnstile token
• in every form POST body, not just the cf_clearance cookie, so cookie-replay
• via Playwright's APIRequestContext also returns a challenge. Captured the
• attempt in scrape-webpoint-http.ts as documentation; persistent-profile
• flow stays as scrape-webpoint.ts (only useful with paid Captcha solver).

Files Changed

• STUNT: webpoint scraper using persistent Chromium profile
• Bypasses Cloudflare Turnstile checkbox-mode challenge by using
• chromium.launchPersistentContext — user solves the checkbox once on
• first run, cf_clearance cookie persists in playwright-profile/ for
• subsequent unattended runs.
• Iterates 7 webpoint categories (Club, Dev Club, Elem-Club, HS,

Files Changed

• PDF extractor: NCA cheer-21 + flex-no-toss templates, max-value validation
• pdf-score-extractor: nca_cheer_21 template (NCA Division Averages PDFs
• omit runningTumblingMpd; 21 values per team), cheer_flex_no_toss_20
• template (Flex divisions skip TOSS, have RT MAX/MPD)
• pdf-completeness-loop: per-field FIELD_MAX bounds reject mis-mapped values
• from shifted templates so we don't propagate garbage scores

Files Changed

• STUNT discipline launch: hub, ~2k matches, scoring + standings
• Schema: VarsityOrClub enum, Gym.ncaaDivision/institutionConference,
• Team.varsityOrClub/conference/scholarshipsOffered, StuntMatchTeam.quarterScores
• Discipline registry as single source of truth (src/lib/disciplines/registry.ts)
• /stunt hub: landing, programs directory, match feed, match detail with
• quarter-by-quarter scoring, standings, conferences

Files Changed

• STUNT (Stunt The Sport) added as first-class discipline with MATCH scoring model
• /stunt hub with category navigation (College, Conferences, Matches, Standings)
• /stunt/programs filterable directory of 88 college programs
• /stunt/matches feed with quarter-by-quarter scoring on detail pages
• /stunt/standings with W/L/PF/PA grouped by NCAA division
• /stunt/conferences and /stunt/conferences/[slug] for league-level browsing
• <DisciplineBadge> component with color-coded discipline tags integrated into team-hero, gym-hero, athlete experience
• Discipline registry at src/lib/disciplines/registry.ts as single source of truth
• ~2,000 historical STUNT matches imported from collegestunt.org with quarter-by-quarter scoring
• 36 STUNT head coaches imported with team affiliations
• Daily collegestunt.org sync + weekly usacheer.org sync wired into Railway worker

• Discipline taxonomy cleaned up: 5 inactive disciplines activated (~15,700 hidden teams now visible in filters)
• Renamed legacy STUNT discipline (140 Group Stunt teams) to Group Stunt
• Merged All Star duplicate discipline into All Star Cheer (1,196 teams + 533 divisions consolidated)
• 2,496 NULL-discipline teams classified via heuristic
• 67 STUNT logos mirrored to Supabase storage to remove partner-CDN dependency
• Sitemap updated to include /stunt routes

• Empty placeholder disciplines deleted: CheerABILITIES, Rec Cheer (dupe), Pro, Sideline

• Pricing page: align features with actual tier gates, add audit skill
• Added missing features to comparison table: media uploads, PDF export,
• scorecard share, coach/choreographer pages, division access, CSV export,
• advanced filters, schedule reminders
• Removed SMS notifications (not shipped)
• Fixed Score Breakdown using wrong feature flag

Files Changed

• Cross-surface polish: consistent heading styles, profile max-width
• Division page season chart CardTitle aligned to text-base (was text-sm)
• Athlete profile constrained to max-w-3xl to prevent ultrawide stretch

Files Changed

• Athlete profile: PDF export, empty states, motion, perf, a11y
• PDF export route (/api/pdf/profile/[username]) generates resume-style
• PDF with experience, skills, competition results, stats, and profile URL
• Pro tier can export any profile, Elite can export their own, free users
• see upgrade CTA
• Timeline empty state shows helpful message instead of blank

Files Changed

• Athlete profile: KPIs in header, remove profile type badges, auto-derive discipline
• KPI stats (Performances, Wins, Podiums, Avg Score) render inside the
• profile card on desktop, eliminating the standalone strip
• Removed profile type badges (ATHLETE, PARENT, etc.) — role is shown
• via experiences instead
• Discipline field removed from Add/Edit Experience form — auto-fills

Files Changed

• Athlete profile: add See Less toggle on results, taller timeline with uncropped tooltips
• RecentResultsList client component with View All / See Less toggle (5 initial)
• Timeline height scales to 350px/year and 50px per performance marker
• Performance hover tooltips no longer truncated or clipped by container

Files Changed

• Add season-based athlete filtering and confirmation system
• Athletes on team/gym pages now filter by the selected season dropdown
• instead of being hardcoded to the current season. Ongoing experiences
• require confirmation each August — athletes see "Still on [Team]?"
• on their home feed and profile, preventing stale rosters.
• SeasonAthleteGrid client component filters by season context

Files Changed

• Division page: remove confusing charts, add analyze button, clean up line chart
• Removed Score Bands chart (confusing, low value)
• Kept Season line chart with fixes: removed tick marks, transparent
• dots (only current competition shows filled dots), tighter margins
• Added "Analyze [Division]" button that loads all division teams
• into /analyze workspace as temporary group

Files Changed

• Competition page: Pro tier division modal, wins filter on gym map
• Division cards show glass upgrade overlay for non-Pro users instead
• of redirecting to /pricing. "Upgrade to Pro to unlock" + Dismiss.
• Divisions limited to 6 per level with expand link
• Gym map: Wins | All | No Wins filter on same row as D1/D2 toggle
• "No Wins" shows blue-gray bubbles (same size as 1-win)

Files Changed

• Competition page: admin tier override, division limit, glass upgrade modal
• Admin accounts get PRO-equivalent tier access
• Divisions limited to 6 per level with "Show all" expand link
• Free users see glass overlay on division cards instead of redirect
• to /pricing — "Unlock full scorecard details" + Upgrade/Dismiss
• Cards use overflow-hidden to contain the overlay

Files Changed

• Design overhaul: Teams + Gyms pages, design system foundation, tier gating
• Phase 3: Design system foundation
• 29 new UI primitives (scoring, skills, progression, tier, layout)
• Design tokens (level colors, skill categories, tier colors, locked states)
• Spring motion system (snappy/smooth/bouncy/heavy presets)
• /design-system preview page

Files Changed

• Perf: faster builds and page loads — force-dynamic, parallel queries, lazy charts
• Add force-dynamic to 78 DB-backed pages to prevent build-time static generation
• (eliminates DB connections/timeouts during Vercel builds)
• Remove duplicate prisma generate from build script (postinstall handles it)
• Dynamic import 15+ Recharts chart components with ssr:false (~90KB bundle savings)
• Parallelize sequential DB queries in schedules, gyms, leaderboard breakdown API

Files Changed

• Add force-dynamic to search page to prevent static generation DB timeouts

Files Changed

• Move sidebar collapse toggle above logout divider for clarity

Files Changed

• Update hero background image to Group 198

Files Changed

• Fix mobile sticky CTA: hide near final CTA, cap button width

Files Changed

• Add bottom padding to final CTA so it clears sticky mobile bar

Files Changed

• Hero headline: single line, all white, lighter weight

Files Changed

• Add maintenance toolkit, growth docs, search avatars + gitignore cleanup
• Search page: add avatar/logo images for gyms, teams, coaches,
• choreographers, and competitions in search results
• Growth docs: add outreach scripts, IG calendar, Klaviyo sequences,
• ManyChat flows, and growth strategy
• Maintenance scripts: commit 90+ operational tools for data quality,

Files Changed

• Dedupe 130 gyms + 317 teams + fix Cheer Athletics city data
• Full-database dedup Ralph loop: merged duplicate gyms (exact-name),
• teams (same-gym exact, prefix-artifact, franchise siblings), cleaned
• orphans, and fixed CA franchise city/state data (10 locations had
• wrong city from backfill, e.g. Pensacola showed MS instead of FL,
• Pittsburgh showed OH instead of PA, St. Louis showed Monroe LA).

Files Changed

• Make FullOut logo larger, shrink Build Your Legacy to match width

Files Changed

• Redesign landing page: dark mode, broader positioning, team preview
• Force dark mode on landing page via wrapper class
• Update hero subhead to cover scores + profiles (not just profiles)
• Broaden search placeholder to include competitions
• Reorder sections: fans/parents module now appears first after hero
• Add team data preview mockup (Orange / Stingray Allstars) with

Files Changed

• Group nav into My Stuff / Explore / More collapsibles
• Collapse the flat 15-item nav into 4 top-level anchors (Feed, Scores,
• Profile, Notifications) plus three collapsible groups:
• My Stuff: My People, Teams, Gyms, Competitions, Schedules
• Explore: People, Teams, Gyms, Competitions, Schedules
• More: News, Learn, Analyze, Settings

Files Changed

• Fix PDF extractor + UI polish + dedupe R1/R2 scores
• PDF extractor (src/lib/import/pdf-score-extractor.ts)
• Delay team flush until next team label is seen so the 22-field template
• wins over the 15-field template when the numeric buffer crosses 15.
• Skip "-" / "--" null placeholders that previously split Team labels.
• Add header-fragment noise detection ("mansh", "ip", "pyram", etc.) for

Files Changed

• Dedupe 622 more same-gym prefix-artifact Team rows
• User still saw "Top Gun All Stars - TGLC" alongside "TGLC" at the same
• gym — the original audit didn't catch this class because the prefix is
• only part of the gym name (franchise root), not the full gym name.
• This adds merge-same-gym-prefix-dupes.ts which, for each Team, tries
• stripping a leading "<gym-name>[ - | ]" OR "<franchise-prefix>[ - | ]"

Files Changed

• Dedupe 419 duplicate Team rows + prevent recurrence
• Problem: /search surfaced 15+ fragmented cards for single franchises
• (Top Gun, Stingray, etc.) because team imports created bare-gym artifact
• teams alongside the real located-gym teams, and no DB constraint stopped
• same-gym same-name dupes from forming.
• Cleanup (data):

Files Changed

• Dedupe 419 duplicate Team rows + prevent recurrence
• Problem: /search surfaced 15+ fragmented cards for single franchises
• (Top Gun, Stingray, etc.) because team imports created bare-gym artifact
• teams alongside the real located-gym teams, and no DB constraint stopped
• same-gym same-name dupes from forming.
• Cleanup (data):

Files Changed

• Dedupe 419 duplicate Team rows + prevent recurrence
• Problem: /search surfaced 15+ fragmented cards for single franchises
• (Top Gun, Stingray, etc.) because team imports created bare-gym artifact
• teams alongside the real located-gym teams, and no DB constraint stopped
• same-gym same-name dupes from forming.
• Cleanup (data):

Files Changed

• Add onboarding routes and harden team import safety

Files Changed

• Fix gym season filtering and franchise team resolution

Files Changed

• Fix schedule import: strict gym matching + franchise-aware team lookup
• Two latent bugs surfaced importing the 2026 Northeast Summit schedule:
• 1. findOrCreateGym fuzzy-matched at 0.75 with no city/state, collapsing
• distinct franchises (e.g. "Force Athletics" -> "G-Force Athletics",
• "Cheer Idol Athletics" -> "Cheer Athletics"). Summit spreadsheets
• rarely ship city/state, so the fuzzy branch was ungrounded.

Files Changed

• Match desktop sidebar to mobile drawer (parity nav)
• Desktop sidebar was showing 4 items (Feed/Scores/Plan/Me) while mobile
• drawer has 15. Rewrites DashboardSidebarNav to render the full rich list
• that mirrors the drawer, so every destination reachable from mobile is
• also reachable from desktop in one click.
• Desktop sidebar now shows:

Files Changed

• Add My People and News to mobile drawer nav
• Drawer was missing two destinations users want quick access to:
• My People (/:username/people) — follows people/athletes
• News (/news) — the public cheer hub
• Added to the main drawer section alongside the other personal destinations.

Files Changed

• Fix empty mobile drawer: rich Twitter/X-style personal hub
• Phase 5 scoped the drawer down too far — it ended up with 4 items in a full-height container, looking broken. Rebuild the drawer as a proper Twitter/X-style personal navigation hub.
• User header card at top (tap to Profile): avatar, display name, @handle
• Main personal destinations: Profile, Notifications (with unread badge), My Teams, My Schedules, My Gyms, My Competitions, Analyze, Groups
• Settings section: Settings, Switch accounts, Send feedback, Learn
• Conditional Upgrade to Elite pill (free tier only) with the existing pink/purple gradient

Files Changed

• Nav redesign: mobile header + 4-tab bottom bar + audience-aware /my
• Mobile header now has search + notification bell for auth users (was logo-only)
• Bottom bar: Feed / Scores / Plan / Me (4 tabs, renamed from 5). News merged into Feed context
• Me tab routes to /my (dashboard), unorphaning the personalization surface
• /my hero card adapts to audience: athletes see profile completion pull, free watchers with 2+ follows see Elite upgrade CTA, new users see welcome nudge
• /my tile grid reorders by audience (athlete/watcher/new)

Files Changed

• Allow logged-in users to view landing page at /
• Remove the RootPage redirect to /home so both guests and authenticated
• users can revisit the onboarding pitch and product overview on the
• landing page. Middleware already treats / as public, so no other
• changes were needed.

Files Changed

• Fix schedule display: Summit routine codes + /schedules dedupe
• Three schedule-page bugs spotted on fullout.energy:
• 1. Summit regional schedules rendered routine/entry IDs (L2S82936, L3Y0114,
• CA-EL102772) as bold team names because Varsity's Summit spreadsheets put
• codes in the "Team" column and the matcher created Team rows keyed to
• them. New isRoutineCode() helper in src/lib/schedule-display.ts; card

Files Changed

• Fix Stingray Allstars franchise mapping: split 291-team HQ into 15 locations
• The main "The Stingray Allstars" Marietta gym had 291 teams dumped into it
• across multiple real franchise locations. Research-verified the full list
• of ~15 active Stingray Allstars franchises and re-assigned teams by theme:
• Marietta HQ: 291 → 73 (Green flagship + core colors)
• Cartersville: 8 → 40 (weather/elements)

Files Changed

• Fix Vercel build: add missing src/components/growth/ directory
• subscription-actions.tsx was committed earlier (a7a0156) importing
• @/components/growth/CancelSaveFlow but the growth/ directory was left
• untracked, breaking the Vercel build. Adds the three growth components
• that were sitting in the working tree so the build can resolve the import.

Files Changed

• Import The Cheerleading Worlds (2004-2025) + 2026 schedule + franchise remap
• Adds full historical Worlds ranking data from thecheerleadingworlds.net
• and the 2026 compete order PDF, plus cleanup tools for the franchise
• gym naming drift that the import surfaced.
• Historical import (2004-2025, 2020 cancelled for COVID):
• scripts/import/scrape-cheerleading-worlds.ts parses the TablePress HTML

Files Changed

• C:/Program Files/Git/home Instagram redesign + /scores cleanup + perf pass
• /home feed redesign
• Kill giant "Your feed of highlights..." header (wasted 20% of viewport)
• Kill "Photo uploaded / Video uploaded / Performance update" titles
• Collapse card to Instagram layout: avatar + name + relative time in one row,
• edge-to-edge media on mobile, icon-only share action, name-prefixed caption

Files Changed

• Schedule filters + grouping: dynamic Division + Discipline
• The schedule viewer's filters and group-by were hardcoded around
• all-star data (level L1–L7, Tiny/Mini/Youth ages, etc.), so college
• schedules showed empty filter sections and no useful grouping
• options (level/age/size/divisionGroup were all null for NCA
• Collegiate rows).

Files Changed

• Phase 3e: Elite 14-day trial + invite friends + Klaviyo events + brand polish
• Five threads of polish landing together:
• 1. 14-day free trial for Elite monthly
• Stripe checkout accepts a new trial: true flag and sets trialDays=14
• when the plan is Elite monthly with no conflicting offer code.
• Pricing page adds a secondary "Try Elite Free for 14 Days" button

Files Changed

• Track college cheer + dance: NCA Collegiate 2026 setup
• The site has never tracked college cheer or dance as first-class
• disciplines before. NCA & NDA Collegiate Nationals (Daytona Beach)
• starts 2026-04-09, so:
• Activate College Cheer discipline (was inactive) and add new
• College Dance discipline with category+tier classification schema.

Files Changed

• Update hero search helper copy on landing page
• Replace "Find your team — your data might already be here" with
• "Your team's already here. Now build your profile." The old copy
• sounded surveillance-y ("your data might already be here"). The new
• line leads with the real value prop (team history is already tracked)
• and ties directly to the primary CTA.

Files Changed

• Content queue: swap Buffer schedule for in-app post flow
• Replace the "Schedule to Buffer" button with a self-contained manual
• posting workflow. Everything stays on the app — no external service
• dependency for daily use.
• Admin queue preview dialog now has three footer actions:
• Download Image — downloads the rendered PNG with a filename-safe slug

Files Changed

• Phase 3c + 3d: Kill ambient upgrade nags + Pro tier /go-pro showcase
• Phase 3c — Contextual upgrade prompts
• Based on the Phase 1c audit, the app had two patterns competing: ambient
• banners / persistent sidebar nags (passive, annoying, low-converting) and
• contextual prompts that fire at the moment of the limit (targeted,
• high-converting). This phase removes the ambient pattern and doubles down

Files Changed

• Phase 2: Restructure core logged-in experience
• Three sub-phases that together rebuild the /home experience, create a
• public /news hub, and simplify the navigation to 5 clear destinations.
• ## Phase 2a — Move hub to /news
• The existing content hub (scores ticker, news articles, podcasts,
• leaderboards, featured gyms, competition timeline, etc.) now lives at

Files Changed

• Content factory: add athlete, rankings, gym generators + LLM captions
• Expands the content queue into a hands-off weekly content machine covering
• all 5 content pillars from the growth playbook.
• New generators (all follow the existing satori→resvg→sharp pipeline):
• ATHLETE_SPOTLIGHT: picks a high-density public Person (photos + teams +
• badges), renders portrait card for the Build Your Legacy track. 30-day

Files Changed

• Phase 3a + 3b: Expand /welcome to 6 steps with pain setup, friends finder, soft paywall
• Rebuild the post-signup onboarding flow following validated patterns from
• Duolingo, Strava, and Hudl: remind users of the pain, show the solution,
• ask for commitment (soft paywall) before the celebration.
• Previous flow (3 steps):
• Photo → Follow team → Share link

Files Changed

• Phase 1: Content lock + Athletes tab + upgrade audit + docs realign
• Three independent tactical wins that prepare FullOut for monetization
• and reinforce the profile-first pitch, plus PRD and brand guide updates
• to match the new product direction.
• ## Content creation locked to Elite+ (Phase 1a)
• Free users can no longer post photos, videos, or link embeds. The prior

Files Changed