Changelog

• Fix notification click not navigating on iOS PWA
• client.navigate() is not supported on iOS Safari PWA. Now catches the
• error and falls through to clients.openWindow() which works cross-platform.
• Also uses full URL to ensure proper routing.

• Add Source PDF link to schedule page header
• Shows a link to the original PDF when fileUrl is available on the CompetitionSchedule.

Files Changed

• Move stage before competition name in notifications
• "Performs at 1:29 PM EDT in L4.2 Senior on Stage A at Cheer Power Grand Nationals"

Files Changed

• Add stage name to end of performance notifications
• Shows stage/panel info at the end like: "Performs at 1:33 PM EDT in L3 - U16 at Cheer Power Grand Nationals (Stage A)"

Files Changed

• Add @types/pdf-parse to fix build error

• Exclude root scratch files from TypeScript build

• Surface actual push subscription error messages to the user
• subscribe() now returns { ok, error } with specific failure reasons:
• Service worker not supported / failed to register
• PushManager not available (wrong browser on iOS)
• Permission denied
• PushManager.subscribe() failure (with native error message)

Files Changed

• Add push subscribe error feedback and better error logging
• Show toast on success/failure when enabling push
• Display error message if push subscription fails
• Log specific failure points (PushManager.subscribe, missing keys, API error)
• Helps diagnose why push enable appears to do nothing on some devices

Files Changed

• Improve push permission denied message with platform-specific reset instructions

Files Changed

• Fix gym name contamination and improve generic team name validation
• Cleaned 205 contaminated gyms: person names, division suffixes, dash artifacts
• Deleted 13 orphan teams (0 performances)
• Validator now skips schools/dance programs for GENERIC_TEAM_NAME check
• (high schools, universities, etc. legitimately have team name == gym name)
• Bulk scrape re-enabled when RESCRAPE_ENABLED=false

Files Changed

• Add explicit Enable Push button to notification settings
• Shows push subscription status per device with Enable/Disable button
• Removes blanket iOS block from PushPrompt — now checks PushManager API directly
• Users can enable push from settings instead of only via the floating prompt

Files Changed

• Fix iOS push detection: check actual PushManager support instead of blanket-blocking iOS
• iOS 16.4+ Safari PWAs support Web Push. The old check blocked all iOS devices.
• Now only shows the banner when PushManager/Notification APIs are truly unavailable
• (e.g. Chrome on iOS, older iOS versions, non-standalone mode).

Files Changed

• Fix silent push notification failures: validate subscriptions, fix counting, add logging
• resolveChannelFlags now checks PushSubscription table before marking push=true
• Users without a registered push subscription are excluded from push attempts
• Fix push result counting to track per-user delivery (not per-promise)
• Add logging when user has 0 push subscriptions and when subscriptions expire

Files Changed

• Fix SSR crash: wrap useIsIOSPWA in useEffect to avoid window/navigator on server

Files Changed

• Refactor PWA notifications: iOS detection, reorganize alerts page, improve notification URLs
• Add userScheduleId relation to ScheduleEntryBell for bulk schedule bell management
• Add useIsIOSPWA() hook to detect iOS PWA and suppress push prompts
• Move bell/follow management from notifications page to alerts settings page
• Split subscriptions into follows, saved schedules, and orphan bells sections
• Score notifications now link to division page instead of team page

Files Changed

• Fix PDF print: constrain column widths, allow text wrapping
• Use table-layout: fixed with explicit column widths (Team 80px,
• Competition 120px, Division 70px, Round 42px, scores 38px each)
• Remove white-space: nowrap from data cells so competition names wrap
• Reduce font sizes (6.5px headers, 7px body) and padding for density
• Ensures all columns fit on a single landscape page when printing

Files Changed

• Fix saved schedules not appearing until manual reload
• After saving a schedule, router.push() navigated to the schedules page
• but used stale RSC cache. Add router.refresh() to force data refetch,
• matching the pattern already used by delete/rename operations.

Files Changed

• Replace SMS notification settings with "Coming Soon" label
• SMS is not currently functional. Replace the toggle/upgrade/phone
• verification UI with a simple "Coming soon" message in both the
• notification preferences table and the settings card.

Files Changed

• Fix push notifications not sent: trigger push subscription on bell toggle
• Users with belled follows had zero push subscriptions because the push
• prompt only fired on initial follow and could be permanently dismissed.
• Now when the bell is toggled ON, we auto-subscribe if permission is
• already granted, or re-show the push prompt (clearing dismissed state).
• Also auto-show prompt on page load for users with belled follows but

Files Changed

• Add color-coded column groups to PDF export matching website
• Add grouped header row with colored backgrounds (Building=blue,
• Tumbling=orange, Performance=violet) spanning their columns
• Add left border dividers on first column of each group in data rows
• Add light tinted backgrounds on column headers per group
• Two-row thead: group labels on top, column names below

Files Changed

• Move filter sidebar toggle below folder toggle, remove from card header
• Filter sidebar toggle is now a Filter icon button stacked below the
• saved scorecards panel toggle. GymScorecard accepts filterSidebarOpen
• and onFilterSidebarToggle props so the parent controls visibility.

Files Changed

• Add toggle to hide/show the scorecard filter sidebar
• Sidebar toggle button (panel icon) in the scorecard header lets users
• collapse the entire filter/controls sidebar so the performance table
• can use the full width. Only visible on desktop (xl breakpoint).

Files Changed

• Move grouping, sorting, and display controls into collapsible sidebar
• Move Group by, Sub-group by, Sub-sub-group, Level sort, Averages
• toggle, and score column group pills from the inline card header
• into the filter sidebar
• Sidebar now has two collapsible sections: "Controls" and "Filters"
• Both sections are collapsible with chevron toggles

Files Changed

• Fix PDF export: wrap score column headers and use landscape layout
• Score column headers with full labels (e.g. "Stunt Difficulty") were
• using white-space: nowrap, making columns too wide to fit on one page.
• Now headers wrap text with constrained max-width, use smaller font,
• and the page defaults to landscape orientation for better fit.

Files Changed

• Show Scorecards link on all analyze modes, apply layout tweaks
• Scorecards nav link now falls back to first followed gym when not in
• gym mode, so it's always visible on Dashboard/Team/Group pages too
• Apply full-height layout for scorecards page (user styling changes)
• Use text-foreground for scorecard breakdown column headers

Files Changed

• Fix rescrape: disable bulk scrape when RESCRAPE_ENABLED to prevent month contention
• Bulk scrape and rescrape both competed for PENDING BulkScrapeMonth records.
• Bulk scrape ran every 5 min and would mark months DISCOVERED without force-rescraping,
• starving the rescrape timer which only ran every 10 min.

Files Changed

• Add PDF scoresheets feature to PRO tier on pricing page
• Shows in both the plan card bullet points and the feature comparison
• table under Pro Intelligence.

Files Changed

• Fix Railway crash: validate Supabase URL before creating client
• The Railway worker had placeholder Supabase env vars (e.g. "https://[project-ref].supabase.co")
• which caused createClient to throw on module load. Now validates the URL is parseable before
• attempting to create the client, falling back to a proxy that throws on actual use.

Files Changed

• Fix backfill script: correct Varsity API parsing and round stripping
• The API response nests items in container.content.items (initial) and
• data.data.content.items (partial). Round names are appended without
• a dash separator (e.g. "L5 Junior Finals" not "L5 Junior - Finals").

Files Changed

• Fix broken search: invalid regex character range in REGEXP_REPLACE
• The PostgreSQL regex pattern '[\s\-.'']' had an invalid character
• range because the hyphen was interpreted as a range operator between
• \s and the dot. Fix by moving hyphen to end of character class:
• '[\s.''-]'. This was causing the entire search query to fail silently,
• returning zero results for all searches.

Files Changed

• Add PDF scoresheet storage & PRO-tier access
• Store original Varsity TV score breakdown PDFs in Supabase before they
• get removed each season. New ScoresheetPdf model keyed by
• (competition, division, round). Import pipeline downloads PDFs
• sequentially after division processing. PRO users get a clickable
• FileText icon to view the original scoresheet via signed URL.

Files Changed

• Fix scorecard column header text color and improve level parsing in import scripts
• Use text-foreground instead of group textColor for breakdown column
• full-name headers so they remain readable against tinted backgrounds
• Switch level parsing from includes() chains to regex for accurate
• decimal level extraction (L1.1, L4.2, etc.) across all import scripts
• Skip generic "LEVEL X" Level Finals entries in NCA import

Files Changed

• Add Scorecards button to gym dashboard, move filters into scorecard panel
• Add Scorecards link button at top of standalone gym dashboard page
• Move season, gym, and worlds filters from scorecards page header into
• GymScorecard's existing filter sidebar via new headerFilters prop
• Remove Pro plan badge from scorecards page

Files Changed

• Convert Whole Gym page from tabs to single scrollable page
• Remove tab navigation and render Overview, Trends, Deductions, and
• Consistency sections as one continuous page. This gives a better
• overview experience now that Scorecards has its own dedicated page.

Files Changed

• Move Scorecards to top-level navigation, remove from Whole Gym tabs
• Add "Scorecards" link in the top nav bar (Dashboard | Single Team | Team Group | Whole Gym | Scorecards)
• Link navigates to the standalone scorecards page for the selected gym
• Remove Scorecard tab from Whole Gym dashboard (now 4 tabs: Overview, Trends, Deductions, Consistency)
• Clean up unused GymScorecard import and gymSlug/username props from GymDashboard

Files Changed

• Pass gymSlug and username to GymDashboard in analyze page
• The "Open Full Scorecards" link was only showing on the standalone gym page
• because the analyze page's GymDashboard call was missing the gymSlug and
• username props needed to build the link URL.

Files Changed

• Add rt_drivers and st_drivers aliases to score mapper for DOD fields
• These keys appear in PDF scorecards from ASC, Spirit Celebration, and
• other events where the PDF parser produces "rt_drivers"/"st_drivers"
• instead of "rt_dod"/"st_dod" for tumbling degree-of-difficulty drivers.

Files Changed

• Add standalone scorecards page with saved scorecards & folders
• Add ScorecardFolder and SavedScorecard database models with nested folder support
• Add CRUD API routes for scorecards and folders (/api/scorecards, /api/scorecards/folders)
• Add last-opened scorecard endpoint for auto-restore on page load
• Create standalone scorecards page at /[username]/analyze/gym/[slug]/scorecards
• Add ScorecardLibrary sidebar component with folder tree, save/load/rename/delete

Files Changed

• Fix gym scorecard header rendering and readability
• Split sticky colspan cells in group/full-name header rows to prevent
• blacked-out rendering artifacts from sticky positioning on multi-span cells
• Increase full-name header font size from 8px to 10px for readability
• Widen max column width from 48px to 60px for longer category names

Files Changed

• Improve scraper pipeline: gym name splitting, level parsing regex, program filter sweep, and normalized competition search
• Scraper: split program_name into gym+team using known prefixes and dash separators
• Scraper: program filter sweep to catch teams hidden behind pagination
• Scraper: retry logic for filter sweep queries
• Scraper: /api/validate endpoint for data validation
• Import: cleanGymName() strips team suffix from gym names

Files Changed

• Handle status poll timeouts gracefully in scrape job processor
• Previously a single timeout on the /api/status endpoint would fail the
• entire scrape job. Now tolerates up to 10 consecutive poll errors before
• giving up, which handles the case where the scraper is busy processing
• large events.

Files Changed

• Add data quality overhaul: validation framework, rescrape orchestrator, and auto-changelog
• CompetitionValidation model + 7 automated post-import checks
• Rescrape orchestrator for full 2020-present month-by-month re-scraping
• Python scraper improvements: gym/team name splitting, program filter sweep, retry logic
• Validation API endpoint for Python scraper
• Auto-changelog hook for automatic version bumping on every commit

Files Changed

• Inline schedule entries preview in event review — expand to see Division, Gym, Team, Time, Day, Session without leaving the page
• Schedule review & editing admin pages with approve/reject workflow
• Pending schedules list for quick admin triage
• Enhanced Python scraper with improved pagination and data extraction
• Schedule import pipeline now handles staged entries for preview before commit

• Import pipeline improvements for better gym and team matching accuracy
• Schedule import logic expanded with smarter conflict resolution
• Competition performances component updated with improved display

• Removed problematic Division unique constraint that caused import conflicts
• Scraper dashboard and event selector UI refinements

Files Changed

• Admin feedback dashboard at /admin/feedback with stats cards (New, In Review, Resolved)
• User feedback submission dialog accessible from navbar
• Real-time notification system with unread count badge
• Email notifications for feedback replies using Resend
• Two-way messaging between users and admins on feedback items
• Feedback categorization (General, Request Team/Gym, Correct Scores, Upload Logo)
• Status tracking workflow (New → In Review → Resolved)
• Sortable table columns on feedback list (Date, User, Type, Subject, Status)
• Click column headers to toggle ascending/descending sort with visual indicators
• Search and filter functionality for feedback management
• Login count tracking in admin analytics dashboard
• Follows column in admin analytics to track user engagement
• Graceful map fallback UI for invalid/expired Mapbox tokens
• Static map placeholder on homepage for local development

• Homepage map replaced with static placeholder to eliminate API errors in development
• Map shows attractive gradient with icon and descriptive text
• Production environment continues to use real interactive map with valid token

• React key prop warning by using Fragment with proper keys in feedback list
• Mapbox 403 Forbidden errors on homepage from expired/invalid token
• Geocoding API errors by detecting token failures and showing fallback UI
• Console errors from map tile requests with domain-restricted tokens

Files Changed

• Public competition schedules browser at /schedules with advanced filtering
• User schedule management at /[username]/schedules for saved custom schedules
• Schedule PDF import system with timezone-aware parsing (Eastern Time)
• Custom schedule creator - select specific teams/entries to build personalized schedules
• Multi-level filtering: gym, team, level, age, size, session, date, and location
• Schedule grouping and sub-grouping (by stage, team, gym, level, age, size)
• Collapsible day groups and secondary groups for better mobile navigation
• Manual timezone calculation for consistent Eastern Time display across all browsers
• Schedules navigation link in sidebar and mobile drawer
• Schedules CTA section on home page with dual CTAs for logged out users
• Signup prompt banner on schedule pages for non-authenticated users
• date-fns-tz package for reliable timezone handling

• Mobile schedule cards redesigned: 50% more compact layout
• Reduced card padding from 24px to 12px for tighter mobile display
• Location field moved inline with gym name to save vertical space
• Smaller text sizes and tighter element spacing on mobile cards
• Home page pillar section updated to support dual CTAs
• Navigation sidebar now shows 'Schedules' link dynamically based on auth state
• Mobile users can now see 2-3 schedule cards per screen instead of 1-1.5

• Timezone display inconsistency - all times now show in Eastern Time regardless of user's local timezone
• Browser timezone APIs unreliability - replaced with manual UTC offset calculation
• Mobile schedule grouping and sub-grouping not working (added tertiary group support)
• Schedule cards too large on mobile - reduced height by 50%
• Missing collapsible functionality on mobile grouped schedules

Files Changed

• Root-level /groups redirect page for proper authenticated routing
• Zoom functionality on comparison line chart with interactive Brush component
• Column sorting with visual indicators (arrows) on all comparison table columns
• Custom tooltip for line chart showing team colors, C.PS scores, competition names, and rounds
• Year display on line chart X-axis dates (e.g., 'Jan 31, 2025')
• performedAt field to Performance model for accurate multi-day competition dates
• Database index on performedAt for efficient date-based queries

• Replaced bar and radar charts with continuous line chart showing C.PS progression over time
• Comparison table now shows only C.PS in collapsed view (removed ES, PS, Total columns)
• Column order updated to: RS → DED → C.PS → detailed score columns
• Each score component displayed as single sortable column instead of combined Diff/Exec
• Line chart maximized to fill full section width (500-600px height)
• Y-axis domain adjusted to actual data range with 5% padding for better visualization
• Sidebar sticky behavior with max-height constraint and internal scrolling
• Rankings now based on C.PS (calculatedPerformanceScore) instead of Total score
• Team page Athletes section moved to bottom, Division History section removed
• Chart displays use performedAt for accurate dates on multi-day competitions

• Avatar component missing 'use client' directive causing page crashes and 404 errors
• Multi-day competition dates showing duplicates (now displays unique performedAt per round)
• Missing calculatedPerformanceScore in analysis panel scoreFields array for proper averaging
• Missing performedAt field in groups page performance data transformation
• Date formatting with UTC timezone to prevent timezone shifting issues
• Groups page 404 error with proper authentication and redirect handling
• Recent performances showing incorrect dates due to missing performedAt data
• Line chart width constraint preventing full section display

Files Changed

• Twitter-style instant account switching without re-authentication
• Account switcher dialog accessible from navbar user menu
• Account storage system with session token management (max 5 accounts)
• Email verification system with verification badges and banners
• Email verification API endpoints (verify-email, resend-verification)
• Account sync component for multi-device session management
• Session token API endpoint for secure token retrieval
• Verification banner on unverified accounts
• Profile creation utility library for streamlined onboarding
• Feature gates system for tier-based feature access
• Season filter UI component for unified filtering
• Max points calculation library for score normalization

• Login page enhanced with account switcher integration
• Signup flow updated to support account switching
• Onboarding profile page streamlined with new utilities
• Dashboard layout updated with account sync component
• Navbar user menu now includes account switcher option
• Auth system extended to store session tokens in JWT
• Registration endpoint enhanced with email verification
• User model extended with email verification fields

• Competition performances component data loading and error handling
• Explore results component search and filtering logic
• Gym PS chart data fetching and display issues
• Team PS chart rendering and data transformation
• Competition performance table sorting and display
• Admin analytics users table pagination and filtering
• Performance API routes authorization and data validation

Files Changed

• 180+ TypeScript compilation errors from Prisma Client relation naming conventions
• All Prisma relation names capitalized in includes/selects (Team, Gym, Person, etc.)
• Field IDs normalized to lowercase camelCase (teamId, personId, etc.)
• Added required id and updatedAt fields to all create operations
• Data transformation for components expecting lowercase property names
• Complex Prisma relation names in self-referential models

• npm run type-check script for quick TypeScript validation
• GitHub Actions CI workflow for automated type checking on PRs
• Comprehensive PRISMA_CONVENTIONS.md documentation guide
• Documentation of all Prisma naming patterns and transform strategies
• Troubleshooting guide for common Prisma type errors

• Standardized all Prisma queries to use capitalized relation names
• Implemented data transformation layer for client components
• Enhanced build process to include Prisma generate automatically

Files Changed

• Complete blog system with MDX support and React component embedding
• Admin interface for creating, editing, and managing blog posts
• Public blog listing page with search, filtering by category/tag
• Blog post pages with SEO optimization and Open Graph metadata
• Username search functionality in main search and people search
• Profile picture upload system separate from cover photos
• Scalloped circle tier badge design with enhanced visual hierarchy
• Blog link in footer navigation for easy access

• Profile page mobile layout and module ordering improved
• Competition performance table simplified (removed redundant Total column)
• Tier badge design updated to scalloped circle style

• Hydration error in VerificationBadgeIcon component
• Profile page loading performance optimized
• Admin permissions for profile picture management

Files Changed

• Profile photo management with cropping and aspect ratio controls
• Tier badges on profile headers and tier-aware avatars
• City display for gym/team explore cards when available
• Athlete avatars and alphabetized athlete lists on team/gym pages
• PersonPhoto model to support multi-photo profiles

• Profile header layout refinements for clearer identity and actions
• People list uses photoUrl for more consistent profile imagery

• Competition performances payload serialization for detail pages
• Profile admin form twitter handle typo
• Tier gating and typing issues in profile photo flows

• 4-tier monetization system (Novice/Prep/Elite/Pro) with feature gating
• PDF export for team comparisons and profile reports (Prep tier)
• Division benchmarks analytics API and Prep-tier access
• Public glossary with admin management and supplemental terms
• Admin tools for profile photos, score maximums, and analytics

• Homepage redesign and navigation updates for clearer conversion flow
• People/teams/gyms views with richer filters and profile visuals

• Production build issues across API routes and PDF rendering
• TypeScript and ESLint errors in UI and export flows

• Public changelog page at `/changelog` with version history
• Version display in footer (v0.1.0) with link to changelog
• Changelog data structure in CHANGELOG.json with full type safety
• Comprehensive user analytics dashboard at `/admin/analytics`
• Login tracking system with `lastSeenAt` field in User model
• 10 key metrics including WAU, conversion rate, and retention
• Daily signups bar chart showing last 30 days of user growth
• Tier growth stacked area chart for free vs paid user trends
• Throttled activity tracking (updates once per hour max)
• 5-minute API response cache for analytics endpoint
• Reusable metric card component for admin dashboards
• Helper script for adding changelog entries (npm run changelog:helper)

• Updated JWT callback to include lastSeenAt tracking
• Enhanced Prisma schema with user activity tracking
• Added index on lastSeenAt field for query performance

• ESLint error with apostrophes in landing page copy
• Profile picture display issues in settings
• Score maximums API routes for static generation

Files Changed