Changelog

• fix(college): reparent 26 orphaned college teams off the "Unknown" bucket into real universities
• The /college hub's "Most Active Programs" was topped by a junk placeholder gym
• named "Unknown" (mistyped ALLSTAR_GYM) holding 26 college teams whose names are
• actually their universities (USC, Portland State, New Mexico State, ...). They
• were imported without a matched university and fell into the catch-all.
• scripts/maintenance/reparent-unknown-college-teams.ts (audited, idempotent, dry-run

Files Changed

• feat(admin): title /admin/partners "Partners" and badge each row Event Producer vs Affiliate
• The list mixed EP-linked partners (e.g. Redline) with pure affiliates and
• called them all "Affiliate Partners". Renamed the page to "Partners" and added
• a Type column badging each row Event Producer (has eventProducerId) or Affiliate.
• Claude-Session: https://claude.ai/code/session_01Qz5BcppF3gPYrvFJmV7BnX

Files Changed

• feat(admin): cross-link Partner <-> EventProducer consoles; resolve EP page by id/slug too
• Redline (and any EP-linked partner) exists as two linked admin records, which
• made the admin trees feel scattered. Now:
• Admin partner page shows a "Manage as Event Producer" button when the partner
• has a linked EP; the EP page shows an "Affiliate & payouts" button back.
• /admin/event-producers/[id] resolves a subscription id (as before) OR the

Files Changed

• feat: discipline data-quality loops (placement, dedup, division reclassification)
• Six new clean-data assertions with staged fixes: team-discipline-mismatch,
• division-discipline-misclass (prep->AllStar, junior high/crowdleader->School,
• variety/jazz->Dance, with collision merges), competition-discipline majority
• vote, gym-discipline-links backfill, multi-discipline-teams and
• unregistered-disciplines monitors. duplicate-teams is now discipline-aware

Files Changed

• feat(profile): free parent/child account linking (reuse PersonRelationship)
• Parents can link to their athlete kids without either account paying. Reuses the existing PersonRelationship model + request/approve flow instead of a new table; only the Elite gating and UI mounting are new.
• src/lib/relationships.ts: isGuardianRelationship + effectiveRelationshipLimits + free tier-independent limit floor (parent/child only)
• relationships POST/PATCH/GET: parent/child skip the both-sides Elite gate; guardian links active when accepted regardless of tier
• people/[username]: mount RelationshipButton + RelationshipsSection, seeded via cached getProfileViewer
• spouse/partner/family unchanged (still Elite)

Files Changed

• docs: FOV IAP + App Store approval status and handoff
• Compact record of what's done, current state, and the two remaining blockers
• (Vercel REVENUECAT_SECRET_API_KEY + IAP review screenshot) so work can resume.
• Claude-Session: https://claude.ai/code/session_01SWcAqsXEBQ2XSy5Cqit6dd

• feat(ep): landing-page traffic + acquisition funnel on EP program dashboard
• Gives event producers real performance insight: how many people hit their
• pages and where they come from. New GA4-backed section on
• /event-producers/[slug]/program showing, for the producer's /<slug> landing
• page and any ?p=<slug> ref link:
• volume tiles (page views, visitors, new visitors, sessions) vs prior period

Files Changed

• docs(brand): correct pink-SVG download label and asset-kit Redline logo reference
• /brand: the pink wordmark SVG is a scalable raster embed, not a true vector;
• relabel the download from "Vector source" to "Scalable wordmark".
• asset-kit: Redline's white logo now ships in-repo (public/Logos/redline-logo-white.svg)
• and on /redline; note that instead of "get it from Kevin's team".
• Claude-Session: https://claude.ai/code/session_01Qz5BcppF3gPYrvFJmV7BnX

Files Changed

• fix(brand): rebuild fullout-pink.svg without mask-seam artifacts; add Redline logo to /redline
• The pink wordmark SVG was a Figma export of 8 raster letter-images used as
• alpha masks over a full-bleed pink rectangle; the mask/pattern tile seams
• rendered as stray pink lines in the download. Rebuilt as a clean single-image
• SVG wrapping the high-res FullOut - Pink.png (2984x767) — same look, no seams.
• /redline: add Redline Championships' own logo (redline-logo-white.svg) to the

Files Changed

• feat(partners): hide redundant Affiliate tab for EP-linked partners; generalize commission-defaults button; GTM doc fixes
• settings: only show the standalone Affiliate tab for pure affiliates
• (Partner.eventProducerId == null). EP-linked partners (e.g. Redline) see
• the same ledger inside their richer EP Program dashboard, so the second
• tab was redundant.
• admin: rename "Apply FullOut x LTC defaults" button (and applyLtcSchedule

Files Changed

• refactor(mobile): FOV IAP uses a single consumable product for all levels
• One "fov_verification" consumable covers any level (the chosen level is passed
• to the backend grant), instead of 8 per-level products. Fewer App Store Connect
• products to create + review, same result.
• Claude-Session: https://claude.ai/code/session_01SWcAqsXEBQ2XSy5Cqit6dd

• feat(brand): update brand-page core palette to 8 colors; use "Redline Championships" on /redline
• /brand: replace 3-swatch Core palette with the 8 approved core colors
• (Cyan, FullOut Pink, Black, White, Ice, Blush, Ink, Mist) in a 4x2 grid;
• accents unchanged. Fix accessibility note Ink hex to #261F27.
• /redline: use full partner name "Redline Championships" throughout.
• Claude-Session: https://claude.ai/code/session_01Qz5BcppF3gPYrvFJmV7BnX

Files Changed

• feat(mobile): FOV Apple IAP purchase flow + web handoff
• purchases.ts: getFovOffering() + purchaseFovPackage() (consumable, returns the
• StoreKit transaction id for server-side grant).
• api.ts: grantFovUnlock() -> POST /api/skills/iap/grant.
• New native FOV screen (app/(main)/fov.tsx): reads personId + levels handed off
• from the WebView, buys one consumable per level, grants the unlock.

Files Changed

• fix(security): verify IAP receipt server-side + ownership check on FOV grant
• Harden POST /api/skills/iap/grant per security review:
• Verify the Apple transaction with RevenueCat's REST API server-side (fail
• closed if unconfigured or not found) instead of trusting the client's claim —
• closes a free-unlock trust-boundary bypass.
• Require the caller to own the athlete (person.userId === caller), mirroring

Files Changed

• feat: FOV Apple IAP grant endpoint + appleTransactionId (Verified IAP foundation)
• Add appleTransactionId (nullable, indexed, deduped in code) to
• SkillLevelPurchase for Apple In-App Purchase records.
• New POST /api/skills/iap/grant: grants a SkillLevelUnlock from a native
• RevenueCat IAP purchase, idempotent on the Apple transaction, guarding
• already-unlocked levels. Web (Stripe) and in-app (IAP) purchases now both

Files Changed

• feat: attribute Apple IAP/RevenueCat conversions to partners
• Wire the RevenueCat webhook into the commission engine so in-app
• purchases credit the buyer's durable origin partner (Redline): first
• purchase, renewals capped at 36 months, and 60-day refund clawbacks, on
• a net-of-Apple revenue basis. Adds PartnerCommission.externalPaymentId
• for IAP payment dedup. Dark behind IAP_ATTRIBUTION_ENABLED until the

Files Changed

• fix: prevent a producer from being its own broker
• Skip the broker override when the broker is the EP's own partner, so an
• EP that is also a broker (Redline) never double-earns direct rev share
• plus a broker override on its own conversions. Enforced at the settlement
• chokepoint and rejected at the admin write path.
• Claude-Session: https://claude.ai/code/session_01W9vPhHp47P93n6HHLsPcn2

Files Changed

• feat: attribution-only partner promo codes at checkout
• A 0-discount partner promo code (e.g. base REDLINE) now attributes the
• partner without attaching an invalid 0% Stripe coupon, at both new
• checkout and in-app plan change. Enables handing out an attribution-only
• code alongside discount codes like REDLINEPRO.
• Claude-Session: https://claude.ai/code/session_01W9vPhHp47P93n6HHLsPcn2

Files Changed

• fix(hubs): bump hub-data cache key to v2 to bust stale Data Cache after the discipline-membership change
• unstable_cache keys off keyParts, not the function body, and Vercel's Data Cache
• persists across deployments, so the previous (Competition.disciplineId) results kept
• serving on prod even after the query fix deployed. Versioning the key forces the new
• deployment to recompute. Tags stay version-free so revalidateTag("hub:data") still
• busts every hub on demand.

Files Changed

• feat: /redline landing page with vanity-link attribution
• Conversion-focused co-branded landing page for the Redline partnership.
• Middleware tags a bare /redline visit to the Redline partner (same as
• ?p=redline), so a printed QR or typed URL attributes on load. The redline
• slug is reserved against usernames.
• Claude-Session: https://claude.ai/code/session_01W9vPhHp47P93n6HHLsPcn2

Files Changed

• feat(stunt): add discipline-filtered programs map to the STUNT hub
• Brings the STUNT hub in line with the other discipline hubs, which each render a
• gym map. Reuses the existing MapLibre GymsMap filtered to the STUNT discipline
• (self-fetches /api/gyms/map?discipline=<id> client-side, ssr:false). STUNT programs
• are colleges, so pin density depends on college geocoding coverage.
• Claude-Session: https://claude.ai/code/session_016MBCg7qCGcjdaEhEVTY8wt

Files Changed

• feat(profile): make Experience athletic-only; close coach self-assign backdoors
• Profile Experience is now athletic history only. Removed the free-text role picker (Athlete/Coach/Team Rep/Staff/Parent); coaching, staff, and parent belong to the Pro coach/choreo flow and guardian linking instead.
• person-experience.tsx: drop role checkboxes; card title = position or Athlete
• experience POST/PATCH: ignore incoming role, force TeamSeasonPerson ATHLETE (kills role=Coach backdoor)
• team-seasons POST: clamp non-admins to ATHLETE (was arbitrary role self-assign)
• remove dead AddTeamSeasonForm (unused coach self-assign UI)

Files Changed

• fix(hubs): derive discipline hub competitions from Division.disciplineId, not Competition.disciplineId
• Competition.disciplineId is NULL on ~40% of recent comps (507 since 2024), so the
• hub Upcoming/Recent/Top Teams lists silently fell back to only the handful of old
• (2000-2018) events that happened to be tagged. College recent results showed 2018
• and earlier.
• A competition now belongs to a hub if it has any performance in one of the hub's

Files Changed

• @ feat: /disciplines landing page, choreographers + coaches in nav, gym map on discipline hubs
• feat: /disciplines landing page, choreographers + coaches in nav, gym map on discipline hubs
• New /disciplines page with big gradient buttons (one per discipline), copy
• and hero gradients sourced from the shared hub config.
• Nav: add Choreographers and Coaches to the Explore group, and collapse the
• seven discipline hub links into a single "Disciplines" entry (Explore group

Files Changed

• fix: add Restore Purchases to account menu, wired to native StoreKit (Apple 3.1.1)
• Build 18 was rejected because Restore Purchases wasn't reachable after the
• floating Upgrade button was removed. Add a distinct "Restore Purchases" item to
• the web account menu (shown only inside the native WebView via
• window.ReactNativeWebView) that navigates to an /app/restore sentinel; the iOS
• WebView intercepts it and runs the native StoreKit restore. Upgrade stays in the

Files Changed

• feat: Verified in-person grant + payment-provider foundation (Verified IAP phase 1)
• Add PaymentProvider enum (STRIPE | APPLE_IAP | IN_PERSON) and paymentProvider
• column to SkillLevelPurchase (existing rows default to STRIPE).
• New admin API POST /api/admin/skills/grant-in-person: record a cash/manual
• FullOut Verified sale and unlock levels for an athlete, skipping already-owned
• levels. Bypasses Stripe and Apple IAP (no Apple cut).

Files Changed

• fix(mobile): route all upgrade paths to Apple IAP, drop floating button, fix double username
• Add /go-pro to the WebView purchase-intercept list so every in-app upgrade
• entry point (pricing, subscribe, checkout, go-pro) opens the native StoreKit
• paywall.
• Remove the floating "Upgrade" overlay button; the web navbar's Upgrade CTA
• and premium-feature links already open the Apple paywall, so it was redundant.

• feat: nest Report/Block into the profile ••• menu
• Move the user Report and Block controls into the existing "More options"
• dropdown next to the Follow button instead of a separate menu, so a profile
• has one ••• menu. Removes the standalone UserSafetyMenu component.
• Claude-Session: https://claude.ai/code/session_01SWcAqsXEBQ2XSy5Cqit6dd

Files Changed

• fix: only list EP-program-enrolled producers as dashboards in settings
• EventProducerAccess grants also exist for gated-data visibility (e.g. The
• Open mirrors Redline's grants), so the settings page showed a program
• dashboard link for producers with no EventProducerSubscription. The link
• 404'd on the program page anyway. Filter the list to producers with a
• subscription row, matching the dashboard's own access check.

Files Changed

• feat: App Store rejection fixes (crash, UGC moderation, support URL)
• Address all four items from Apple review of FullOut - Cheer Analytics
• (submission 57173d2c):
• 2.1(a) crash: add NSCamera/PhotoLibrary/Microphone usage descriptions to
• mobile/app.json so the WebView profile-photo "Take Photo" flow no longer
• crashes on iOS.

Files Changed

• feat: gym data enrichment pipeline (contact discovery, logos, geocoding) with provenance chokepoint
• Reusable tooling to enrich orgs (gyms/schools/colleges) with phone, email,
• address, website, Instagram, profile logos, and map coords:
• src/lib/enrichment/write.ts: single write chokepoint. Every enrichment
• write records provenance (logoSource/logoFetchedAt) + a GymEnrichmentLog
• audit row, so a bad run (e.g. Pride-month pics) is a one-query rollback.

Files Changed

• feat: GA4 + Search Console web analytics dashboard in admin
• New /admin/web-analytics page surfaces Google Analytics traffic and Search
• Console performance inside the platform: realtime active users, sessions/
• pageviews/engagement with previous-period comparison, top pages, channels,
• referrers, countries, cities, devices, plus GSC clicks/impressions/CTR/
• position, top and rising queries. Reuses the existing service-account JWT

Files Changed

• feat: split company roster into Current and Previously
• Company 'Our Team' now groups members by tenure: leftAt null = Current,
• leftAt set = Previously (alumni), with a 'Since 2022' / '2022 - 2024' label
• per person. Uses the existing joinedAt/leftAt fields.
• Claude-Session: https://claude.ai/code/session_016MBCg7qCGcjdaEhEVTY8wt

Files Changed

• fix: discipline chips on /gyms now filter the map, not just the table
• The map self-fetches from /api/gyms/map, which never received the ?discipline param, so selecting a discipline chip updated the gym list but left the map pins unchanged. The param now flows page -> map component -> API, where it applies the same Team-in-discipline filter the table uses. With an explicit discipline selected the map also drops its ALLSTAR_GYM-only restriction so STUNT and dance programs (school orgTypes) appear, matching the table; invalid discipline ids are validated against active disciplines and fall back to the default map.
• Claude-Session: https://claude.ai/code/session_01VAHEPaNTRpd1m42VnNmdhS

Files Changed

• feat: EP member + broker delete/deactivate, and traffic intel on admin EP page
• Member management (admin EP detail page): Deactivate/Reactivate (status
• flip) and Delete. DELETE /api/admin/event-producers/[id] hard-deletes only
• when there's no settlement history (statements/accruals); otherwise 409 ->
• deactivate instead, so the financial audit trail is never destroyed.
• Broker management (admin brokers page): 'Remove' per broker clears the

Files Changed

• fix: merge duplicate gyms + identify ghost gym records behind state rankings
• Merged 8 duplicate/artifact gym records via merge-gyms.ts, all performances preserved: Storm All-Stars into Storm Athletics (NY), New York Icons - Rochester into New York Icons, Titanium Force into Titanium Force Cheer (IL), Elite Cheer Center into Elite Cheer (NE), duplicate Fierce Idaho (ID), ghost record Lexington into Cheer Athletics - Lexington (its horse-racing Cats team names identified it), and two North Star Athletics single-team artifacts
• Relocated two misfiled programs identified by their competition footprints: North Star Athletics to East Longmeadow MA, Express Cheer Force (Express Dance and Acro) to Milford MA
• Regenerated authored copy for the 8 affected states (NY, IL, NE, ID, KY, MA, MD, MT); DATA_VERSION bumped to v3 so merged rankings go live with this deploy
• New tooling: inventory-flagged-gyms.ts (teams + competition history per flagged record), fix-ghost-gym-locations.ts
• Remaining unidentifiable records left untouched (real results); listed in tasks/todo.md for manual review

Files Changed

• fix: verify + correct ranked gym locations, surface state rankings in UX
• Verified all 366 ranked gyms via web research; corrected 42 wrong-location records through the audited enrichment chokepoint (Top Gun Allstars UK off the Texas page, Dakota Spirit to SD, Stealth Elite to IL, Rocket Elite to PA, 7 gyms moved out of the US entirely), with Nominatim re-geocoding for corrected pins
• Rewrote authored copy for the 38 states whose rankings changed; AK/DC/WY now render the zero-ranked layout
• Gym profile badge: Top 10 Cheer Gym in {State} (no rank number), linking to the state page via daily-cached getGymStateRanking
• Cross-links: /gyms header button + per-state contextual link, footer Best Gyms link, /cheer hub banner, /leaderboards header link
• POST /api/admin/revalidate-best-gyms (admin or CRON_SECRET bearer) + DATA_VERSION cache-key bump so corrections go live with this deploy

Files Changed

• feat: Best Cheer Gyms in {State} SEO pages for all 50 states + DC
• /best-cheer-gyms index + /best-cheer-gyms/[state] (51 pages, on-demand ISR, 24h revalidate)
• Top 10 all-star gyms per state ranked by 2025-26 banners (1st in finals) and podiums (top 3)
• Interactive MapLibre map with rank-numbered markers (bad-geocode guard), ranking table, per-gym profiles with links
• AI-authored copy per state keyed by gym ID with data-driven fallbacks; no-em-dash rule enforced via npm run seo:check-copy
• ItemList/FAQ/Breadcrumb JSON-LD, sitemap entries (states with gyms only), best-cheer-gyms reserved username

Files Changed

• feat: admin merge UI for duplicate choreographers
• Merge duplicates dialog on /admin/choreographers: pick source + target, preview
• what moves (members/credits/videos/followers, dedupe counts, identity fill),
• then merge. Backed by admin-only /api/admin/choreographers/merge wrapping the
• verified choreographer-merge lib.
• Claude-Session: https://claude.ai/code/session_016MBCg7qCGcjdaEhEVTY8wt

Files Changed

• feat: choreographer merge/dedup tool for consolidating duplicate company pages
• Adds src/lib/choreographer-merge.ts (transactional previewMerge + mergeChoreographers)
• and a dry-run-by-default CLI (scripts/maintenance/merge-choreographers.ts). Moves all
• members, credits, videos, and followers onto the target, deduping by personId /
• unique-credit-key (scopes unioned) / follower, fills the target's empty identity
• fields, then deletes the source. Verified end-to-end against the DB (15/15 checks).

Files Changed

• feat: traffic & click intel on the EP program page
• The EP program page managed tracking URLs but showed no click intel. Add
• the same PartnerAnalytics view affiliates get - clicks over time, referral
• sources, and per-link click/conversion breakdown.
• Authorization: the analytics API only let admins pass ?partnerId=. New
• resolvePartnerAnalyticsAccess authorizes EP seat holders too and reports

Files Changed

• feat: notify choreo-company owner on affiliation claim, choreographer on confirm
• Closes the self-reported affiliation loop: POST affiliation notifies the company
• owner (if claimed) so the confirm inbox doesn't sit unseen; confirming notifies
• the choreographer that their entry is now verified. Both non-fatal in-app
• notifications, reusing the CHOREO_AFFILIATION_CLAIMED/CONFIRMED helpers.
• Claude-Session: https://claude.ai/code/session_016MBCg7qCGcjdaEhEVTY8wt

Files Changed

• feat: EP program seats (up to 5) + admin brokers page
• Seats: EventProducerAccess grows a role (OWNER/FULL/ANALYTICS). Up to 5
• seats per producer; each seat grants the holder PRO on their own account
• (resolved non-destructively at auth time via the access _count, so Stripe
• stays authoritative and revoking reverts cleanly). Owner + Full seats see
• financials; Analytics seats see program analytics only - enforced on the

Files Changed

• feat: choreographers can list companies they've worked with (self-reported affiliations + owner confirm)
• Choreographers add companies to their profile's Choreography tab with a role and
• year range. Each shows as Self-reported until the company owner confirms it into
• a Verified roster member. Company owners get a confirm inbox in Our Team;
• unconfirmed claims stay out of the public roster so they can't be spoofed onto a
• company page. Completes the choreographer-companies feature alongside self-serve

Files Changed

• feat: include event producers (Redline etc.) in search
• Search now covers a seventh entity: event producers. runUnifiedSearch
• grows a buildEventProducerSearchSql that rides the same trigram matching
• and the SAME gating posture as competition search - confidential
• (non-PUBLIC) producers stay hidden except for admins and
• EventProducerAccess holders, whose widened results only ship on private

Files Changed

• fix: hide broker relationship from the brokered EP (confidential)
• The EP program page showed 'Brokered by {name}' in the negotiated-terms
• card and fetched BrokerPartner into an EP-facing page. A brokered producer
• must never learn a broker took a cut. Remove the display and the include;
• broker data now lives only on the admin console and the broker's own
• /broker portfolio. Statement table already excludes the override (it

Files Changed

• feat: broker verification link on admin EP editor - when an EP is brokered, show the relationship + a link to that broker's rolled-up portfolio

Files Changed

• feat: dedicated EP Broker portfolio page
• New /event-producers/[slug]/broker rolls up every EP a broker (e.g. Redline)
• brought to the platform PLUS their own EP: portfolio revenue (lifetime
• platform rev share across the book), lifetime and current-month broker
• override, a per-producer override chart, and a roster flagging 'Your EP' vs
• 'Brokered' with each EP's rev-share rate, broker %, platform revenue, and

Files Changed

• feat: EP partners can create multiple tracking URLs (campaign links) from their program dashboard
• New resolveManageablePartnerId helper authorizes campaign management for the partner's own account, admins, and EventProducerAccess holders (EP staff)
• Campaign create/toggle/delete now honor the target partnerId, so admins and EP staff can manage a partner's links (previously self-only)
• PartnerCampaigns surfaced on the EP program page: one attributed URL per event/channel/campaign

Files Changed

• feat: add Event Producers and EP Settlements (incl. brokers) to admin Revenue & Partnerships nav

Files Changed

• Reorganize admin nav + fix dead-end Settings Admin tab
• Single source of truth: src/lib/admin-nav.tsx (ADMIN_NAV_SECTIONS),
• consumed by both /admin dashboard and Settings → Admin.
• Regrouped 28 admin links from 5 loose groups into 7 coherent ones
• (Revenue & Partnerships, Users & Growth, Competition Data, Directory,
• Verification, Content & Hub, System), each with a one-line blurb and

Files Changed

• Reorganize admin nav + fix dead-end Settings Admin tab
• Single source of truth: src/lib/admin-nav.tsx (ADMIN_NAV_SECTIONS),
• consumed by both /admin dashboard and Settings → Admin.
• Regrouped 28 admin links from 5 loose groups into 7 coherent ones
• (Revenue & Partnerships, Users & Growth, Competition Data, Directory,
• Verification, Content & Hub, System), each with a one-line blurb and

Files Changed

• Add API docs to footer + Partner API Keys to admin/settings menus
• Footer: "API" link to /developers.
• /admin dashboard: "Partner API Keys" card under Business.
• Settings admin section: direct "Partner API Keys" button.
• /developers contact email -> team@fullout.energy (was a personal gmail).
• Claude-Session: https://claude.ai/code/session_013BKXE8nWCjdWyHSEuVzFUH

Files Changed

• Add API docs to footer + Partner API Keys to admin/settings menus
• Footer: "API" link to /developers.
• /admin dashboard: "Partner API Keys" card under Business.
• Settings admin section: direct "Partner API Keys" button.
• /developers contact email -> team@fullout.energy (was a personal gmail).
• Claude-Session: https://claude.ai/code/session_013BKXE8nWCjdWyHSEuVzFUH

Files Changed

• feat: consolidate partner API invoicing by billing account + direct mark-paid
• Partner API invoicing was strictly per-key, so a partner with a secret key and
• a publishable embed key produced two separate invoice rows each month. Introduce
• a PartnerAccount billing entity: keys attach to an account, the flat monthly
• price and billing email live on the account, and invoices are generated one per
• account per month with usage summed across all the account's keys.

Files Changed

• fix: de-duplicate admin nav - Settings > Admin now links to the dashboard instead of a stale link subset; admin dashboard verification card points to the unified queue (credits + gym claims) and drops the dead page-verification link

Files Changed

• feat: create + manage choreography companies self-serve
• 'Create Company Page' on /choreographers for Pro users
• Owner member management on the company page: add/edit/remove members with tenure years (Member since 2022 / 2022-2024), title, IG, bio, photo
• Member credits roll up into company-wide accolades (existing season stats aggregate all company credits)
• External links (booking/camps/merch) via the shared https-only bulletin board
• ChoreographerMember gains joinedAt/leftAt for membership tenure

Files Changed

• feat: choreography company backend (owner-managed members + external links) + EP/broker program link in settings
• Choreographer.bioLinks (https-only external links, shared parseBioLinks)
• Company members: page owners (not just admins) can add/edit/remove members
• One COMPANY page per non-admin account; individual activation never touches a company page (type INDIVIDUAL scoping)
• Settings gains an EP Program section for EventProducerAccess holders (brokers included), linking to their program dashboards

Files Changed

• feat: pro profile section order - posts move to the bottom; skills, highlights, and timeline sit above the feed

Files Changed

• feat: photo gallery reorder for gym/team pages + robust gym-claims flag parsing (env values with trailing newlines)

Files Changed

• feat: gated events visible in search for authorized viewers + home location setting
• Admins and EventProducerAccess holders now see their gated competitions
• (e.g. ASW under The Open) in /discover and navbar search; everyone else
• keeps the strict isGated=false filter. Widened results only ship on
• private (per-user) responses.
• New Home Location setting (Settings > Account) feeds the near-you search

Files Changed

• feat: professional profile skin + credit-form dropdown fix + directories list activated pros
• Profile skin: profiles with an active Coach/Choreographer module no longer
• use tabs. The page reformats into a professional layout: an identity band
• under the profile card (role title pulled from the newest season's custom
• title, current gym affiliations, jump pills), then stacked full-width
• sections: Coaching, Choreography, Athlete Career (experience + posts),

Files Changed

• feat: manage coach/choreo credits directly on your profile - owners get add/edit/delete in the Coaching and Choreography tabs, and owner-added credits publish immediately (no admin queue)

Files Changed

• feat: coach/choreo are now modules that reskin /@username, not separate pages
• One person, one page. Activating a Coach or Choreographer module now
• transforms the owner's profile: the header stats strip switches to
• professional stats (teams coached, seasons, routines), the Coaching or
• Choreography section becomes the default view for visitors, and the
• professional tabs lead the tab row. Athlete history stays one tab away.

Files Changed

• feat: Division Winner Scores chart now displays ICU named tiers (Novice-Premier) as levels
• The top-of-page competition chart collapsed every ICU Europeans division into
• a single 'Other' row because it only parsed numeric levels (L1-L7). Named
• ability tiers (Novice, Intermediate, Median, Advanced, Elite, Premier) now
• rank, color, and label like numeric levels, ordered lowest to highest, with
• the legend showing the tier name and a wider Y axis for long tier labels.

Files Changed

• feat: ICU European Championships 2026 results import (Prague, Jul 3-5)
• New importer scripts/import/import-icu-europeans-2026.ts pulls the per-division
• result PDFs the ICU posts on cheerunion.org/championships/european/ and loads
• them as the icu-europeans-2026 competition under the International Cheer
• discipline. Parses all three pdf-parse text layouts (row-per-line, columnar,
• glued-rank), anchors rows on a European country whitelist, canonicalizes

Files Changed

• feat: Partner Stunt discipline hub at /partner-stunt with Future Flyer and Stunting is a Habit event producers

Files Changed

• feat: differentiate cheer hubs - All Star (/cheer), Sideline (/sideline, Game Day format), High School (/school), College (/college); nav labels updated

Files Changed

• feat: coach and choreographer pages are now fully self-serve for Pro users - auto-verified on activation, verification form and Unverified labels removed (manual review stays for gym claims)

Files Changed

• fix: nav search Enter left the dropdown open over results when already on /discover - clear input, close dropdown, and blur before navigating

Files Changed

• Partner API: discipline + division filters, /api/v1/disciplines reference
• /api/v1/competitions?discipline=<name>: include-semantics (an event matches
• if any of its divisions run that discipline; Competition.disciplineId is
• null for mixed cheer/dance events). Pre-fetched division/competition ids
• per the no-nested-relation-filter rule; combines with producer/state/status.
• /api/v1/competitions/{id}?division=<id|slug|exact name>: narrow results to

Files Changed

• Partner API: discipline + division filters, /api/v1/disciplines reference
• /api/v1/competitions?discipline=<name>: include-semantics (an event matches
• if any of its divisions run that discipline; Competition.disciplineId is
• null for mixed cheer/dance events). Pre-fetched division/competition ids
• per the no-nested-relation-filter rule; combines with producer/state/status.
• /api/v1/competitions/{id}?division=<id|slug|exact name>: narrow results to

Files Changed

• feat: gym claiming + gym-admin content tools (flagged off pending soft launch)
• Pro users can claim their gym via two verification paths: post a generated
• "Follow us on FullOut" share image (1080x1080 with a QR code to the gym
• page) to the gym's Instagram and submit the post URL for admin review, or
• receive a 6-digit code at an address on the gym's website domain for
• instant auto-approval. Claims land in the existing admin verification

Files Changed

• feat: Pro profile activation for coaches and choreographers + choreographer orgs
• Pro-tier users can now activate public Coach and Choreographer pages from
• Settings > Profile Pages (or their profile menu). Activation creates a page
• linked to their Person; their /@username profile gains Coaching and
• Choreography tabs (season stats + credits, same components as the standalone
• pages) plus role badges. Deactivation hides the page but keeps all credits.

Files Changed

• feat: unified personalized search + discipline hub pages
• Search: one shared SQL core (src/lib/search/unified-search.ts) now powers
• both /discover and the navbar autocomplete. Removes the REGEXP_REPLACE
• anti-pattern from /api/search (incident 2026-05-25), ports gym-abbreviation
• expansion to /discover, and ranks results with a weighted score: followed
• entities, gyms of followed teams, sibling teams, rivals from your teams

Files Changed

• feat: unified personalized search + discipline hub pages
• Cheer Daily technology-partner integration (docs/cheer-daily-partner-feed-plan.md):
• ApiKey/ApiKeyUsage/ApiInvoice models: hashed admin-issued keys (secret
• fo_live_ / publishable fo_pk_), scopes, domain binding, per-key rate limits,
• daily usage rollups, off-platform monthly invoicing (PENDING/INVOICED/PAID).
• /api/v1 read endpoints (scores/recent, competitions, competitions/{id})

• Partner data API + embeds: keyed /api/v1, widgets, admin issuance + invoicing
• Cheer Daily technology-partner integration (docs/cheer-daily-partner-feed-plan.md):
• ApiKey/ApiKeyUsage/ApiInvoice models: hashed admin-issued keys (secret
• fo_live_ / publishable fo_pk_), scopes, domain binding, per-key rate limits,
• daily usage rollups, off-platform monthly invoicing (PENDING/INVOICED/PAID).
• /api/v1 read endpoints (scores/recent, competitions, competitions/{id})

Files Changed

• Gated history visible to authorized viewers on team/gym profiles
• Bug (reported with screenshots): a gatekeeper/admin drills from a gated
• division scorecard into a team profile and sees "0 performances all
• time" — e.g. Fame / World Class Allstars (AR), whose 9 performances are
• all gated (Redline events + ASW). The division page widens access with
• the base client after an access check, but the team/gym profile

Files Changed

• Dedupe ASW duplicate gyms + harden import gym matcher
• The ASW import's conservative matcher missed a small tail of duplicate
• gyms (16 of 4,568 performances): the platform's "- <STATE>" location
• suffixes ("Infinity Allstars - FL") aren't stripped by the variant
• rules, and two same-name accounts in one concurrent chunk raced past
• the in-memory index (PowerHouse Dance Academy x2 — gym name/slug are

Files Changed

• EP (Event Producer) Program: producers pay a per-EP monthly minimum and earn
• rev share (default 20%, per-relationship editable) on subscriptions they bring;
• credits net against the minimum monthly. Broker model: an EP tagged with a
• broker earns that broker a 10% override as pure FullOut cost.
• Durable first-touch origin tagging: free signups arriving via a partner/EP
• link are stamped at registration and credit the EP when they convert later,
• far past the 30-day cookie. Precedence: promo code > origin > cookie > hybrid.
• Monthly settlement engine + cron (1st, 06:00 UTC, EP_SETTLEMENT_ENABLED gated,
• idempotent): sweeps commissions into an append-only accrual ledger with rates
• frozen at earn time, prorates minimums, writes broker overrides, and produces
• per-period statements (EP owes / FullOut owes / zero).
• Admin EP Tier dashboard (/admin/event-producers): program rollups, per-EP
• console with editable terms + contact/billing CRM, settlement queue with
• mark-invoiced/mark-paid/queue-payout (billing settles off-platform).
• Producer EP dashboard (/event-producers/[slug]/program): negotiated terms,
• minimum-offset progress, conversions by type, earned-vs-minimum and stacked
• charts, per-subscriber rate card, promo links, origin funnel, and a broker
• section with per-EP override earnings. All figures before tax and fees.
• Payout generalization: WIRE/ACH/CRYPTO/OTHER methods with crypto settlement
• audit fields (USD stays authoritative); payouts held until W-9 on file.
• Redline rollout: Partner (slug redline, 20%, 36-month tail) + complimentary
• EP subscription through 2029-07-03 per the signed term sheet.

Files Changed

• Division age/size normalization + tolerant division history matching
• The division-page history queries exact-match prior performances on
• (level, ageCategory, sizeCategory), so spelling drift made gated-event
• teams' history invisible: The Open platform's parseAge took the label's
• first word (junk ages like "Level", "Small", "Youth-X-Small-A",
• CheerAbilities-as-age), OPEN divisions carry their level in the label

Files Changed

• Move ASW under The Open Championship Series producer (gated)
• ASW is The Open Championship Series' season-ending destination event, so
• its 5 competitions (2022-2026) now belong to that producer instead of
• Redline Championships. The Open producer is flipped to GATED (slug
• "the-open") BEFORE any competitions point at it, and every Redline
• EventProducerAccess grant is mirrored onto it so the same gatekeepers

Files Changed

• Import Allstar World Championship historicals (gated) + division repair
• Load 5 seasons (2021-22..2025-26) of ASW finals, 4,568 performances
• across 5 competitions, as CONFIDENTIAL gated data under the existing
• Redline Championships producer so the same EventProducerAccess
• gatekeepers apply with no new plumbing. New "Allstar World Championship"
• series for browsing; the newest ASW event becomes The Open Championships

Files Changed

• Per-IP rate limiting on public /api data routes at the edge (Upstash Redis),
• with a tighter cap on the Disk-IO-heavy /api/gyms/density and /api/search
• endpoints. Closes the gap where a scraper with a real browser User-Agent
• sails past the UA blocklist, and prevents crawler floods from exhausting the
• Supabase Disk-IO budget (a past cause of site-wide 504s).
• SAFE BY DEFAULT: completely inert unless UPSTASH_REDIS_REST_URL/TOKEN are set
• AND RATE_LIMIT_MODE is 'monitor' or 'enforce'. Fail-open on any limiter error.
• Pages and static assets are never rate-limited (zero page-latency impact).
• First step of the API hardening + /api/v1 plan (docs/api-hardening-and-v1-plan.md).

Files Changed

• Gating: close nested-include hole + gated-series browsing
• Prisma query extensions only fire on top-level operations, so gated
• Performance/Competition/Score rows leaked through nested includes on
• non-gated parents (teams directory, gym profiles, series pages, public
• team/gym/coach APIs). Add a $allModels extension layer that walks every
• read's include/select tree (DMMF-resolved relations) and injects the

Files Changed

• teams/[id]: split heavy getTeam query + drop nested Person filter
• Harden the team page against intermittent 504s under PgBouncer contention.
• Pull Performance out of the monster getTeam findFirst into a separate
• getTeamPerformances() findMany, fetched in the same Promise.all so it
• parallelizes with the base entity. Removes the 3-4 level nested include
• (Performance -> Competition/Division/Score/Deduction) that CLAUDE.md flags.

Files Changed

• Event producers index: allowlist to Varsity, Redline, The Open, USASF
• Restrict the public event-producers index to four producers, matched by
• exact (case-insensitive) name so Varsity Brands is not swept in with
• Varsity. Redline Championships stays subject to its GATED visibility
• check, so it only appears for admins or granted viewers.
• Claude-Session: https://claude.ai/code/session_01GyNpHJtXj4Dd1n3DQ9xgy6

Files Changed

• Prospects contacts: show Instagram bio links
• The Show-contacts expand now lists the gym Instagram bio links (registration,
• tryouts, Linktree, etc.) alongside website/IG/phone/email, deduped against the
• primary website.

Files Changed

• Gym Instagram enrichment: verified logos, website, bio, bio-links
• Add Gym.bioLinks (JSONB) for the gym's Instagram profile links.
• enrich-gyms-instagram: for top gyms with a handle, hit IG's public
• web_profile_info (via curl — Node fetch trips IG's Sec-Fetch WAF), VERIFY
• the profile full_name matches the gym name, then fill logoUrl (hosted HD
• profile pic), websiteUrl, description (bio), and bioLinks. Only the matched

Files Changed

• Redline event logos: host + display; gym enrichment tooling
• Found logos for all 32 Redline events, rasterized SVGs to PNG, hosted on
• Supabase (gym-assets/events/<id>/logo.png) and set Competition.photoUrl.
• Producer event list now shows each event's logo; competition headers pick
• it up automatically (photoUrl).
• scripts/maintenance: host-logos (download -> sharp SVG rasterize -> Supabase

Files Changed

• Producer events list: client Load-more pagination
• Replaces the fixed 60-event cap with a client ProducerEventsList that renders
• 30 at a time with a "Load more" button. Server fetches up to 400 events
• (covers a full season) with their result counts + disciplines; the footer
• notes when older events require a season filter.

Files Changed

• Prospects tab: map-viewport table filter + expandable contact info
• "Match map view" toggle: the prospects table follows the visible map area
• (pan/zoom updates the list). Map reports bounds via onBoundsChange.
• "Show contacts" toggle: reveals website / Instagram / phone / email links
• under each gym for outreach (data is sparse for now). Prospect rows now
• carry websiteUrl/instagramHandle/phone/email from the gym record.

Files Changed

• Producer page: clarify events scope + make attendee intelligence single-season
• Attendee intelligence now always reflects ONE season (selected, or most
• recent by default), labeled in its header ("... · 2025-2026 season") and
• tab copy. Its scope (attendees/geography/retention/prospects + the prospect
• map's event dots and distance) is computed from that one season, decoupled
• from the events list. Removes the confusing mixed scope where the list

Files Changed

• Fix prospects=0 for long-lived producers; match prospects-map height
• Prospect exclusion now uses gyms that attended in the CURRENT season only,
• decoupled from the display scope (new attendedExcludeScopeIds arg). The
• all-seasons view was excluding every gym that ever attended, which zeroed
• out prospects for Varsity (27 seasons). Varsity now shows ~650, not 0.
• Prospects-tab map height matched to the main event-locations map

Files Changed

• Add Event Producers nav link, taller producer map, gym backfill scripts
• nav-config: add "Event Producers" (/event-producers) to the bottom of the
• Explore group (shared by desktop sidebar + mobile drawer).
• Producer events map: taller (520px mobile / 640px desktop) for easier reading.
• scripts/maintenance: reverse-geocode-gym-cities (backfill city/state from
• coords) and import-gym-locations (geocode + write agent-found gym locations).

Files Changed

• Prospects map: legend shows mapped-of-total counts
• Legend now reads "Attended (489 of 515)" / "Not attending (952 of 991)" so
• the on-map dot count (gyms with resolvable coordinates) is clearly
• distinguished from the true unique-gym total. Resolves the map-vs-stat-card
• discrepancy the user hit.

Files Changed

• Rename Redline producer to Redline Championships
• DB EventProducer.name updated (slug redline). Updated the hardcoded producer
• name in the import/maintenance scripts so re-runs stay consistent, and
• switched the debug lookups to find by slug (stable) instead of by name.

Files Changed

• Expand US_CITY_COORDS with 2,344 geocoded gym home cities
• Ran scripts/maintenance/geocode-gym-cities.ts: 680 -> 3,024 cities. Lifts
• map coverage of Redline attended gyms from 234/515 (45%) to 489/515 (95%);
• Cordova, TN and other small-town gyms now plot. Fixes every map (producer
• attendee/prospect maps + gym maps) since they all read this lookup.

Files Changed

• Add gym-cities geocoder to widen map coordinate coverage
• Geocodes distinct gym HOME (city, state) pairs missing from US_CITY_COORDS
• via Nominatim and appends them, so attendee/prospect/gym maps can place the
• ~55% of gyms that small-town home cities (e.g. Cordova, TN) left unmapped.
• Filters to US states, flushes every 50 so a long run survives interruption.

Files Changed

• Prospects map: separate overlapping city dots + layer show/hide toggles
• Smaller dot cap (16) and a wider triangle offset (event up, attended
• lower-left, prospect lower-right) so a city with multiple layers shows
• distinct dots instead of one perfectly covering another.
• Legend is now interactive: tap Events / Attended / Not attending to show
• or hide that layer. The click popup respects the toggles.

Files Changed

• Prospects: widen active window to this season + prior season
• Non-attending prospects now include gyms that competed at a public
• competition in the current OR previous season (not only this season), so
• recently-active gyms that have not competed yet this season still appear.
• Redline footprint goes 839 -> 991 prospects. ~0.9s.

Files Changed

• Prospects map: unified city popup, clickable events, triangle dot layout
• Clicking a city now queries all three layers and shows one popup with its
• events (links to each competition), attended gyms, and non-attending gyms,
• so overlapping dots are all reachable from a single click. Event dots are
• clickable and link to their event(s). Events/attended/prospect dots are
• offset into a small triangle so a shared city shows all three.

Files Changed

• Prospects map: draw event dots as the top layer

Files Changed

• Prospects map: capture all non-attending gyms; events as sized dark dots
• Prospect cap raised 300 -> 3000 so the full non-attending universe shows
• (incl. small/D2 gyms). Redline went from 300 to 839 prospects (811 mapped,
• 426 city dots) with no real perf cost -- the aggregate scans the same data.
• Event markers are now solid dark dots sized by how many events the city
• hosts (instead of hollow rings), drawn beneath the gym layers so the green

Files Changed

• Prospects map: aggregate gyms by city, size by count, fix occlusion
• Gyms are now aggregated into one dot per city, sized by how many gyms are
• there (area ~ count), instead of one fixed dot per gym stacking on itself.
• Event markers are hollow rings sized to encircle the city's data dot, so
• attended/prospect gyms in an event city (e.g. Frisco) are no longer hidden
• under a filled event dot.

Files Changed

• Prospects tab: filter-driven map (events / attended / not-attending)
• New ProspectsMap: GeoJSON circle layers for event cities (dark), gyms
• that attended (green), and non-attending prospects (red), plus always-on
• state outlines, a legend with live counts, and click-to-popup (gym name
• link + teams/perfs/distance).
• The map is driven by the same filters as the table: state chips scope

Files Changed

• Maps: switch to light Voyager base + always-on state outlines
• New shared MAP_STYLE constant (src/lib/map-style.ts) = CARTO Voyager
• (light, colorful, no API key). One place to restyle every map.
• Producer events map: Voyager base, markers retuned for the light base
• (white halo borders; blue "selected" state, since the old yellow was
• invisible on light), and an always-on US state outline layer so borders

Files Changed

• Producer attendee intelligence: fix mobile layout
• Tab strip was wrapping inside a fixed-height TabsList, so Retention and
• Prospects rendered outside the box (overlapping text, untappable). Now a
• 2x2 grid with auto height on mobile, normal inline-flex on >= sm.
• Tables were too cramped on narrow screens (gym names crushed to "S.."):
• hide the gym logo on mobile, tighten the # column and gap, and shrink the

Files Changed

• Producer attendee intelligence: collapsible, sortable, filterable + blast radius
• Whole "Attendee intelligence" section is now collapsible (collapsed by
• default) via ProducerAttendeeSection; still PRO-gated.
• Top gyms: sortable columns (Teams / Perfs / Events) + 25-per-page
• pagination. Helper now returns up to 1000 attendees; geography and
• retention still compute from the full attendee set.

Files Changed

• Producer page: PRO attendee intelligence (gyms, geography, retention, prospects)
• Adds a season-scoped "Attendee intelligence" section to the event
• producer page, gated to the PRO tier (hasCompetitorIntelligence):
• Top gyms: biggest customers ranked by teams brought, plus perfs and events
• Geography: where attendees travel from, by home state
• Retention: new vs returning vs churned (when a season is selected), plus

Files Changed

• Producer events map: clearer popup close button
• Disable the faint default MapLibre X (it overlapped the inner
• scrollbar) and add a visible close button in a fixed card header,
• above the independently-scrolling event list.

Files Changed

• Producer events map: stronger dot-size scaling for low counts
• sqrt(count)*7+4 instead of pow(count,0.65)*5 so 1 vs 2 vs 3 events
• are clearly distinguishable (the old min floor collapsed them to the
• same size).

Files Changed

• Producer events map: proportional dot sizing instead of count bubbles
• Bigger dot = more events in that city, matching the gyms map on
• competition pages. Count still shows in the click popup; selected
• city gets a highlight ring.

Files Changed

• Team dedup: merge 341 duplicates + durable import chokepoint
• Identity model for a team is (gym, discipline, name-core). The program
• prefix ("Dance Athletics", "STUNT Athletics", "Cheer Athletics") is a
• redundant echo of disciplineId, so it is stripped and discipline drives
• the program label.
• One-time cleanup:

Files Changed

• Merged 341 duplicate teams (e.g. 'Dance Athletics - Comet Crew' into 'Comet Crew') where one physical team was imported under a program-prefixed or spacing-variant name; scoped to (gym, discipline) so cross-discipline same-name teams ('Comet Crew' Dance vs 'CometCats' Cheer) are never merged
• Import team-matcher now strips named-program prefixes ('Dance Athletics', 'STUNT Athletics', 'Cheer Athletics') in addition to the gym name, so re-imports match the existing team instead of minting a new variant
• Team matching (exact + fuzzy + cache key) is now scoped by disciplineId
• Swapped the Team unique index from (lower(name), gymId) to (lower(name), gymId, disciplineId) so a gym may field same-named teams across disciplines

Files Changed

• Division detail page: gating-aware for confidential producer competitions
• The division page fetched the competition under the default (gated) scope, so Redline division pages 404'd. Now reads via the base client with an explicit access check (admin or EventProducerAccess), and authorized viewers of gated data bypass the Elite tier gate (it's their own producer's data). Public competitions are unchanged.

Files Changed

• Geocode competition venue cities into US_CITY_COORDS (+120 cities)
• Adds 120 geocoded city/state pairs (Nominatim) used by competition venues, so ~384 more competitions place on the event-producer maps. 7 skipped: international (Canada/Japan) or placeholder/typo cities. Includes the reusable geocode script.

Files Changed

• Event producer page: discipline badges on each event
• Shows the distinct disciplines at each listed event (derived from its divisions), e.g. 'All Star' + 'Dance'.

Files Changed

• Event producer page: season filter for events list, map, and stats
• Adds a season dropdown (?season=) that filters the events list, the location map, and the stat counts. Hidden for single-season producers (Redline); shows 27 seasons for Varsity, 22 for USASF. Seasons computed July-June to match the team chart.

Files Changed

• Event producer page: add Instagram link to header
• Renamed the Worlds producer to USASF (its actual organizer) with logo + Instagram; the 22 'The Cheerleading Worlds' events remain tagged to it. Header now renders an Instagram link when instagramHandle is set.

Files Changed

• Producer badge: render logo at natural aspect with contrasting tile
• Horizontal logos (Worlds, Varsity) were squished into a square and dark logos were invisible on the dark badge. Use h-4 + auto width and a white/dark mini-tile per logo so all read cleanly.

Files Changed

• Producer logos: dark tile for white logos, light tile for dark logos
• Redline's logo is white (invisible on a light card); Varsity/Worlds are dark (invisible on a dark tile). Pick the tile background per logo so both render in light and dark themes.

Files Changed

• Gating perf: filter raw queries on c.isGated, not p.isGated
• Filtering isGated on the ~340k-row Performance table added ~5-7s/query and pushed the heavy leaderboards page over its 30s limit (intermittent 504s). Gated performances all belong to gated competitions, so filtering on the already-joined Competition (c.isGated, ~32 gated of ~2k) prunes via the join and is ~7s faster. EXPLAIN-verified: 15.9s -> 9.0s.

Files Changed

• Event Producers: index page, event-location map, producer badges, Varsity/Worlds
• /event-producers index listing producers (Redline, Varsity, Worlds)
• Producer page: event-location map (replaces teams map) with readable popup + click-out close; generalized stats/list to handle large producers (Varsity ~1,900 events); Redline logo
• Competition pages: producer badge (logo, hover=name, click->producer); standard layout for all incl. Redline; base-client reveal with explicit gating check
• Multi-line team chart split by scoring system; gating-context pinned to globalThis
• Backfill scripts: Varsity/Worlds producers + scoringSystemTag on ~1,900 comps, Redline slugs + venue locations; import sets slugs

Files Changed

• Event Producer page: show full clickable events list
• Replace the 8-item card grid (no way to reach the rest) with a complete, clearly-clickable list of all the producer's events: date, location, result count, chevron.

Files Changed

• Event Producer pages at /event-producers/[slug] with recent events, a competing-gyms map, and season stats.
• Imported the Redline / The Open Championship Series 2025-26 results (32 events, 4,343 results) as the first Event Producer.
• Dedicated Open Championship Series scorecard: Redline competition pages render Score / % of Max / Placement grouped by division, instead of the Varsity/Worlds difficulty-execution breakdown.

• Confidential event-producer data is gated: hidden from public search, rankings, sitemap, and all pages via a Prisma read-hook chokepoint plus explicit filters on raw SQL. Visible only to admins and granted producer accounts.

Files Changed

• SCORES: Scorecard tables/cards no longer show blank ("-") cells for categories whose values are actually in the database. The breakdown view previously trusted the scrape JSON blob alone, which on some events (e.g. Spirit Sports, The American) was a partial capture missing standing/running tumbling — even though the real tumbling scores were stored in the score columns the whole time. The view now merges the authoritative score columns with the scrape blob, surfacing ~9,000+ previously-hidden standing/running tumbling values across the database. Affects the team performance table, the competition/division scorecards.

• MOBILE: Dialogs no longer overflow off the right edge of the screen. Native date pickers and other form fields now shrink to fit narrow viewports (added min-width:0 to the shared Input, Textarea, and Select components), fixing the Edit/Add Experience modal where the Team field, date pickers, and action buttons were clipped. The fix applies app-wide, so every modal benefits.
• PROFILE: The Edit Experience footer buttons (Delete / Cancel / Save Changes) now wrap gracefully instead of being cut off on small screens.

• ANALYZE: On a team's Analyze → Scoresheet tab, the scorecards now sit at the bottom of the tab (below the competitive analysis) and use the same Cards/Table toggle as the public team page — including the sortable Performances table with grouped Building/Tumbling/Performance breakdown columns and scoresheet PDF links.

• HEADER: The top-bar avatar now falls back to the account avatar when the active profile has no image set, so it shows your profile picture instead of an initial letter — matching the behavior already used elsewhere in the app. Backfilled affected legacy profiles.

• ANALYZE: The Scoresheet tab on a team's Analyze page now shows every routine's full scorecard for the selected season — placement, event/routine score, deductions, and the per-category score breakdown — the same scorecards available on the public team page. The existing competitive analysis remains below them.

• MOBILE: Dialogs no longer sit edge-to-edge on phones — every modal now keeps a 16px gutter on each side (shared DialogContent), while desktop widths are unchanged.
• PROFILE: The Start/End Date fields in Add/Edit Experience no longer overflow their column on iOS Safari (native date inputs can now shrink to fit).

• PROFILE: The "Team Parent" role option in Add/Edit Experience is now "Team Rep". Existing experience entries were migrated to the new label.

• PROFILE: Added "Parent" as a selectable role in Add/Edit Experience.

• SCORES: Scoresheet PDF parsing now reads the printed column headers instead of guessing the layout from the value count — sheets with unusual column subsets (e.g. toss-less L1 divisions) no longer land values in the wrong scorecard columns.
• SCORES: Repaired 1,241 scorecard cells that the old positional parser had mis-mapped (512 corrected to the sheet's true value, 723 phantom values cleared, 6 gaps filled), concentrated in L1 divisions at The D2 Summit, The Youth Summit, and CHEERSPORT.
• SCORES: Breakdown gap-fill recovered a further 3,528 scorecard values (3,339 from stored raw score data via a full-season sweep, 189 from stored PDFs re-parsed with the header-driven parser).

• SCORES: Re-importing an event can no longer wipe previously captured scorecard breakdown columns — a scrape that lacks breakdown data (e.g. a failed PDF merge upstream) now leaves existing values and rawScores.full_breakdown intact instead of nulling them.
• SCORES: Live re-imports of unchanged divisions now still capture the division's scoresheet PDF — previously a division whose API scores never changed could permanently miss its PDF (and all execution/difficulty columns) if the scraper-side merge failed once.
• SCORES: Scoresheet PDF merge now re-runs for already-stored PDFs whose first merge failed, and failed merges in the Python scraper are retried once and surfaced as a per-division status instead of being silently swallowed.
• SCORES: Performance.hasPdfScores now means 'a scoresheet PDF exists for the division' and pdfParsed means 'breakdown data was captured' — the flags were previously both set from API breakdown presence and never reflected PDF state.

• SCORES: DivisionScoreStatus tracking table records per-(competition, division, round) breakdown completeness, merge failures, and fill sources — gaps are now observable instead of requiring ad-hoc audits.
• SCORES: score-gap-fill-loop maintenance script fills missing breakdown columns from rawScores JSON, stored scrape payloads, and stored scoresheet PDFs (null-only writes with per-field validation).
• SCORES: rescrape-gap-competitions maintenance script re-scrapes competitions with missing breakdowns without firing user notifications.
• SCORES: PDF harvest backfill now covers all season competitions (the old hasPdfScores gate excluded exactly the gapped divisions), recovers event ids from ScrapeJob rows, and preserves unmatched-division PDFs in storage before Varsity deletes them.

Files Changed

• BILLING: A single failed payment no longer instantly removes access. Subscribers keep their tier through Stripe's retry window (PAST_DUE) and only drop to Free when the subscription actually cancels. Restored access for customers already affected.

• BILLING (iOS): Unknown RevenueCat webhook event types no longer force a subscription to 'active' — unhandled events are now a no-op.
• BILLING (iOS): Added an ownership guard so a RevenueCat event can't modify a subscription belonging to a different account.

Files Changed

• BILLING: Accounts created via checkout while logged out had no password or username and could not be logged into. They are now fully provisioned (username, profile) and sent a 'set your password' email; affected existing users were remediated.
• BILLING: Subscriptions on a legacy/renamed Stripe price id were silently dropped (leaving a paying customer with no tier); tier is now resolved from the price amount as a fallback.
• BILLING: Cancel/pause/resume could fail to find the account when the session email had mixed casing (now normalized).

• BILLING: Unknown Stripe subscription statuses now fail closed (no access) instead of defaulting to active.

Files Changed

• Fix Supabase egress blowout: cache reference-data loaders
• Public pages were re-loading entire reference tables on every render. teams/[id] pulled all ~8,400 active divisions per view (783k calls, 6.58 billion rows in pg_stat_statements) and the team list pages loaded every active team just to derive the distinct list of gym states. With crawler traffic this drove Supabase egress to 288 GB, past the 275 GB quota.
• Route active-divisions, active-disciplines, gym-name, gym-state lists and division filter facets through a cached reference-data module (Next Data Cache, 1h revalidate) so each payload leaves Supabase about once an hour instead of once per request.
• Wire teams/[id], /teams, /[username]/teams and the smart-group builder to the cached helpers; the builder and list filters now use cached facets instead of whole-table scans.
• Add scripts/debug/egress-diagnostics.ts for future read-only egress triage.

Files Changed

• Surface first-month-free promo framing for free and new subscribers
• A 100% off, one-month promo (PROTRIAL) on a monthly Pro signup now shows the same first-N-days-free, then renews at the full rate framing as a trial, so free and brand-new users see the taste-then-renew offer clearly instead of a misleading $0/month button.
• The card is still collected at checkout and the subscription renews at full price after the free month.

Files Changed

• Add promo codes to in-app upgrades + PROTRIAL (first month of Pro free)
• Existing subscribers can now apply a promo code when upgrading in-app; change-plan validates it (tier, usability, one-per-user) and attaches the matching Stripe coupon.
• Promo upgrades switch immediately with no proration charge today and let the coupon discount the next full invoice, restricted to monthly billing so a free month cannot zero a whole year.
• PROTRIAL gives an Elite member their first month of Pro free via /subscribe?plan=pro&promo=PROTRIAL; seed it with scripts/maintenance/create-protrial-promo.ts.
• In-app upgrade redemptions are recorded directly since no checkout webhook fires; shared coupon-creation and redemption helpers keep checkout and upgrade paths in sync.
• Subscribe page also shows contextual upgrade messaging based on which feature paywall the user came from.

Files Changed

• Update tier seed users to FREE/ELITE/PRO and preserve passwords
• Canonical test accounts now map to the real FREE/ELITE/PRO tiers plus admin.
• Seed no longer resets passwords on update, preserving existing admin/elite logins.

Files Changed

• Fix ghost sessions + land onboarding on /home
• Throw from the session callback when a JWT's backing User row is gone so NextAuth clears the cookie instead of looping a phantom identity at onboarding.
• Thrown outside the try, so a transient DB error never logs out a valid user.
• Route post-onboarding redirects to /home instead of the legacy /feed.

Files Changed

• @ Affiliate generator: config-driven company fields + Alondra Flores docs
• Affiliate generator: config-driven company fields + Alondra Flores docs
• Convert every previously hand-edited legal field in the affiliate
• agreement into config values, with company-wide constants merged from a
• new company-defaults.json so they are set once and inherited by every
• partner.

• @ Pricing accuracy + in-app plan upgrades/downgrades
• Pricing accuracy + in-app plan upgrades/downgrades
• Tier-gate accuracy:
• Division detail pages were marketed as Elite but gate on
• hasCompetitorIntelligence (Pro-only). Moved to Pro; Elite keeps
• benchmarks + percentile rankings. /pricing comparison row now derives

Files Changed

• Existing subscribers can now change plans in-app instead of being sent
• to the hosted Stripe portal (which didn't have plan-switching enabled).
• New POST /api/stripe/change-plan: upgrades switch immediately with
• proration and charge the difference now (payment_behavior
• error_if_incomplete, so access is never granted on a declined card);
• downgrades are scheduled for the end of the paid period via a Stripe
• Subscription Schedule, so the member keeps what they paid for and gets
• no prorated credit.
• On /subscribe, the 'Upgrade to Pro' / 'Switch to Elite' button opens a
• confirmation dialog explaining the charge/timing, then applies the change
• and refreshes the session so gated features unlock without a re-login.
• A 'Manage billing or cancel instead' link still routes to the Stripe
• portal for payment-method and cancellation.
• Apple/iOS subscriptions are detected and the user is told to manage them
• in the app store rather than failing silently.

Files Changed

• ANALYZE: fix mobile tab/filter layout on gym + single-team (F22)
• On phones the 5-tab TabsList (fixed h-10, grid-cols-2) wrapped to 3 rows and
• overflowed its fixed height, colliding with the content heading below it. And
• the gym dashboard's season/level/age selects overflowed the right edge.
• TabsList -> grid-cols-3 sm:grid-cols-5 with h-auto + gap, so tabs wrap to a
• clean 2-row block on mobile and stay a single row on desktop (no overlap).

Files Changed

• ANALYZE: mobile group-save parity, density drill-down, mobile header
• Value-focused pass over the previously-deferred polish items:
• Mobile save-as-group (parity): the "Select Teams" sheet now has a
• "Save as group" button next to "Deselect all", so phone users can turn an
• ad-hoc selection into a group. Previously this only existed on desktop.
• Density map drill-down (F20): expanding a metro row links each gym to its

Files Changed

• ANALYZE: SYS-1 — canonicalize single-entity surfaces
• Every team / whole-gym entry point now lands on its one canonical standalone
• route instead of the duplicate ?mode= tab view:
• team card -> /analyze/team/[slug] (gym + group cards already did this)
• hub "Deep analysis" links (single team, edge, pressure) -> standalone team
• old ?mode=team&team=X and ?mode=gym&gym=X deep links 301 to the standalone

Files Changed

• ANALYZE: SYS-3 — URL-persisted, shareable analysis state
• Season, score metric, event window, smoothing, the Worlds toggle, and the
• density map's season/radius/layer now live in the URL, so an analysis is
• shareable and survives refresh and back/forward.
• New hook src/lib/use-url-state.ts writes via the native History API
• (window.history.replaceState) rather than router.replace, so updating a

Files Changed

• ANALYZE: unify group selection/creation, signpost gating, fix UX inconsistencies
• Implements the high-confidence findings from the /analyze UX audit
• (docs/audits/analyze-ux-audit.md):
• SYS-2 (core ask: ad-hoc selection -> save as group):
• "Save as group" now lives in the analysis selection bar and saves the
• currently-checked teams, so any ad-hoc selection becomes a group

Files Changed

• COMPETITION: Divisions tab — expand Disciplines by default (Levels and Age Groups stay collapsed)
• So users land on a useful overview instead of two collapsed D1/D2 headers.

Files Changed

• COMPETITION: My-Follows team rows link to division; Divisions tab regrouped as Discipline > Level > Age
• Top "My Teams & Gyms" card now treats the team row as one click target
• that opens that team's division at this competition (was: team profile).
• Bottom Divisions tab replaces the flat Level grouping with three nested
• collapsible layers (Discipline > Level > Age Group), all collapsed by
• default. Disciplines sort by sortOrder; ages use canonical cheer order.

Files Changed

• Top 'My Teams & Gyms' card: clicking a team row now opens that team's division at this competition (was: team profile).
• Bottom Divisions tab: replaced flat Level grouping with three nested collapsible layers (Discipline > Level > Age Group). All layers collapsed by default for easier navigation on large events.
• Disciplines sort by Discipline.sortOrder; ages sort by canonical cheer order (Tiny, Mini, Youth, Junior, Senior, Open, Adult, Other).

Files Changed

• ADMIN: split Paid vs Granted in analytics; Paid Users / Paid Mix exclude comps
• Paid now counts only users with an ACTIVE/TRIALING Subscription row.
• New 'Granted Premium' card counts paid-tier users without a sub
• (admin-comped). Paid Mix description clarifies real payers vs free.

Files Changed

• SKILL: add affiliate-contract generator + Hailey Smith contracts
• Templates the locked legal boilerplate (commissions, tail, arbitration,
• ROFR) so future partner contracts can't drift word-by-word. generate.py
• script + .md/.html templates + intake flow with optional web research on
• provided partner links. Supports affiliate-only (4 files) or
• affiliate-and-curriculum (6 files with per-student pricing math).

• ADMIN: add MRR / ARR / New MRR / Active Subs to analytics dashboard
• Sums active+trialing Subscription rows, normalizing annual plans to
• monthly via the Stripe price-ID lookup (with period-length fallback for
• IAP). New MRR is filtered to subs created in the selected timeframe.

Files Changed

• CHANGELOG: bump for v0.2.425 (rebase reconciliation)

• ADMIN: add Source column to user mgmt (Paid vs Granted vs Free)
• Distinguishes real paying Stripe/Apple/Google subs from admin-comped
• premium access. Adds Source column + filter; Paid badge shows platform.

Files Changed

• ADMIN: add Source column to user mgmt (Paid vs Granted vs Free)
• Distinguishes real paying Stripe/Apple/Google subs from admin-comped
• premium access. Adds Source column + filter; Paid badge shows platform.

Files Changed

• CHANGELOG: backfill v0.2.422 entry for KlaviyoOnsite hotfix
• The auto-changelog post-commit hook ran during the prior rebase but the
• rebase swallowed the bump commit. This commits the staged version bump +
• changelog entry that the hook produced, so the changelog matches reality.

• HOTFIX: move KlaviyoOnsite inside Providers so useSession has its provider
• Previous commit mounted <KlaviyoOnsite /> in <head>, above the <Providers>
• wrapper. The KlaviyoIdentify child calls useSession(), which throws during
• SSR when there's no SessionProvider ancestor. Result: every page hit prod
• with TypeError "Cannot destructure property 'data' of useSession() as it is
• undefined" and the homepage was 500ing.

Files Changed

• HOTFIX: move KlaviyoOnsite inside Providers so useSession has its provider
• Previous commit mounted <KlaviyoOnsite /> in <head>, above the <Providers>
• wrapper. The KlaviyoIdentify child calls useSession(), which throws during
• SSR when there's no SessionProvider ancestor. Result: every page hit prod
• with TypeError "Cannot destructure property 'data' of useSession() as it is
• undefined" and the homepage was 500ing.

Files Changed

• KLAVIYO: install client-side onsite snippet + identify-on-login
• The server-side Klaviyo integration (Profiles + Events APIs in src/lib/klaviyo.ts)
• covers signup/subscribe/conversion events. It does NOT cover anything that
• needs a browser session:
• "Active on Site" metric (Welcome Flow dashboard showed 0% for every email)
• Browse-abandonment flows (pricing page, etc.)

Files Changed

• Adds the client-side klaviyo.js snippet (loaded via next/script, strategy=afterInteractive) plus a useSession-driven identify call that pushes ['identify', { $email, $first_name, $last_name, username }] to window._learnq once the user is authenticated.
• Server-side integration in src/lib/klaviyo.ts is unchanged. This adds the browser piece that was missing: 'Active on Site' metric (Welcome Flow dashboard showed 0% for every email because of this), browse-abandonment flows, onsite signup forms, and anonymous-to-identified profile stitching after login.
• New env var NEXT_PUBLIC_KLAVIYO_COMPANY_ID (=SYKEPR). Set in Vercel Production + Development; component renders nothing when unset.
• Bonus: drops 6 Klaviyo-paste-ready welcome email HTMLs under email/klaviyo-ready/ with relative assets/ paths rewritten to absolute https://fullout.energy/email/ URLs.

Files Changed