LIVESTATS ENGINE™

📱 Viewer App 2.0:

• Client-Side Processing: Moved heavy math (points, averages, sorting) to the user's device to save server CPU.
• Season Log: New "Season Log" view with color-coded status text for DQ (Red), Dropped Hook (Amber), and Exhibition (Blue).
• Event Detail Pages: Completely redesigned event pages with "Total Hooks" and "Full Pulls" stats.
• Performance: Optimized for high-traffic "pulling season" loads.

🔧 Backend & Infrastructure:

• Server Optimization: Prepared codebase for 2 vCPU production environment.
• Stability: Fixed syntax errors and race conditions in the viewer script.
• Footer: Unified footer design across Console and Viewer for consistent branding.

🐛 Bug Fixes:

• Fixed "Total Hooks" showing as undefined in class pages.
• Fixed `getSpeed` reference error causing viewer crashes.
• Fixed points calculation logic to correctly filter non-points events.
• Fixed syntax errors causing event pages to fail loading.

🖥️ Backend Server Infrastructure:

• Full Node.js/Express backend server implementation
• RESTful authentication API with JWT token-based session management
• API endpoints: /api/auth/signup, /api/auth/login, /api/auth/me
• Secure bcrypt password hashing (10 rounds)
• Server-side validation and error handling
• MongoDB integration for user data persistence
• CORS configured for cross-origin requests

🔐 Authentication System Overhaul:

• Username-based login system (stored in user.email field)
• Separate email field (user.userEmail) for Stripe payment receipts
• Dual-field signup form: Username + Email
• JWT tokens stored in localStorage for persistent sessions
• Auto-login on page load if valid token exists
• Backwards compatibility for legacy accounts
• "Remember Me" functionality with token expiration

💰 Token Economy Changes:

• Stripe integration for token purchases
• Token balance displayed in dashboard

🎨 UI/UX Enhancements:

• Signup form redesigned to fit on one screen (no scrolling required)
• Events tab with powerful search by name or location (real-time filtering)
• Six filter options: All Events, Active, Today, Upcoming, Past, Canceled
• Three view modes: List (grouped by status), Grid (responsive cards), Calendar (grouped by month)
• Sort options: Date ascending/descending, Name A-Z/Z-A
• Roster modals (Edit Member, Member Details) optimized with 3-column layout
• Modal sizing: 1100px width, 95vh height - fills screen without scrolling
• State dropdowns in Add Vehicle and Edit Vehicle modals (all 50 US states)
• Compact, readable spacing: 13px fonts, 10px gaps, 7-10px padding

🔧 Technical Improvements:

• Event listeners for search, filter, view mode, and sort controls
• State management for events: viewMode, filter, searchTerm, sortBy
• Responsive grid layout: auto-fill, minmax(320px, 1fr)
• Calendar view with chronological month/year grouping
• Type-based event card styling (Practice/Qualifying/Race/Special)
• Server-side username validation (3-20 characters, alphanumeric + underscore)
• Password strength requirements (8+ characters)

🐛 Bug Fixes:

• Fixed Exhibition/Under100ft/TestRun flagged runs disappearing from lineup
• Fixed flagged runs now remain visible in Results and Live Leaderboard
• Fixed re-pull logic: now appends new rows when distance exists (preserves original)
• Fixed state input consistency across all roster forms
• Fixed modal scrolling issues with optimized dimensions
• Removed duplicate membership number validation
• Fixed archivedRepulls array population for instant display

💳 Stripe Payment Integration:

• Complete Stripe Checkout integration for event token purchases
• Secure payment processing via Stripe API with webhook verification
• Automatic token fulfillment after successful payment
• Payment status tracking and refund prevention for used tokens
• Professional checkout experience with custom success/cancel pages
• Backend server (stripe-server.js) handles all payment operations securely

🎯 Enhanced Flag System:

• Added two new pull flags: "Under 100ft" and "Test Run"
• Radio button implementation for mutually exclusive flag selection
• 7 flag options: None, Scratch, Under 100ft, Reset, Test Run, Exhibition, DQ
• Extended sheet structure from columns A-O to A-Q (added columns P & Q)
• All flagged hooks now properly display in both Results and Live Leaderboard
• Flagged pulls sort to bottom but remain visible for record-keeping

🔒 Formula Protection:

• Complete protection for Place (column I) and Points (column J) formulas
• All write operations skip or preserve formula columns
• Clear Hook Data detects formulas vs manual values before clearing
• Flagged runs append as new rows without touching formula columns
• Fixed updateNameInAllEvents to write single column only (not full rows)

⚡ Real-Time Updates:

• Flagged hooks now appear immediately in live leaderboard and results
• archivedRepulls array properly populated for instant display
• Live Event leaderboard combines active lineup with archived flagged runs
• No more refresh required to see flagged hooks

🔧 Technical Improvements:

• Updated all sheet read operations from A:O to A:Q range
• Enhanced sort logic to check string 'TRUE' values for flags
• Improved error handling with toast notifications
• Better console logging for debugging flagged hooks

🐛 Bug Fixes:

• Fixed Clear Hook Data "currentEventSheet is not defined" error
• Fixed columns I & J being overwritten by various operations
• Fixed flagged hooks not appearing in live displays
• Fixed Under100ft and TestRun flags not being checked in sort/display logic

🚀 Major Update - Google Sheets Integration:

• Full Google Sheets API integration - all data now syncs to cloud
• Professional login screen with secure OAuth authentication
• Settings sync across devices via Google Sheets
• Removed all CSV fallbacks - API-only data management
• Real-time sync timestamp shows last successful data write to Google Sheets

✨ New Features:

• Classes Management tab - centralized class list for entire organization
• Archive/restore system for classes (soft delete with toggle to show archived)
• Soft delete/restore system for roster members (preserves all data)
• Restore button in roster view details modal for deleted members
• Class dropdown in Add Vehicle modal (synced with Classes tab)
• Updated Roster form with new fields: Phone, Address, Make | Model
• Connection status indicator (red/yellow/green)
• Dedicated Logout tab with confirmation screen
• Enhanced Classes Tab documentation in Support tab

⚙️ Improvements:

• ALL data operations now sync to Google Sheets immediately (classes, roster, lineup, live results)
• Sync timer only updates after successful Google Sheets writes (no false updates)
• Enhanced error handling for Google authentication failures
• Improved dropdown styling to match themes
• Classes load before roster for proper dropdown population
• Professional authentication flow with loading screens
• Settings persist to Google Sheets for cross-device sync
• Cleaner UI text (removed technical implementation details)
• Smart button visibility in roster details (edit/delete vs restore based on status)
• Secondary button theme styling for archive/delete toggles

🔧 Technical:

• Google Sheets API with full read/write capabilities
• Sheet auto-creation if missing (Roster, Lineup, Settings, Classes)
• Boolean conversion fixes for Google Sheets data types
• Roster now uses 11 columns (A-K) with Deleted column (YES/NO)
• Classes sheet uses 2 columns (A-B) with Archived column (TRUE/FALSE)
• Lineup/Results save to database with 8 columns (Draw, Class, Truck, Driver, Member, Distance, Speed, DQ)
• All write operations validate success before updating sync timestamp

🐛 Bug Fixes:

• Fixed duplicate `];` syntax error that was breaking authentication
• Fixed sync timer continuing to count even after data updates
• Fixed local-only data changes that weren't syncing to Google Sheets
• Removed "Robert Young" auto-population placeholder (now uses proper soft delete)

New Features:

• Support tab with help documentation and system info
• Preset color themes (Purple, Blue, Pink, Teal, Neutral + Neutral variants)
• Export column customization (choose which columns to export)
• Multiple export formats: CSV, PDF, JPG
• Interface density modes: Compact (Mobile) and Comfortable (Desktop)
• Collapsible settings sections for better organization

Improvements:

• Class lineup order automatically syncs between Lineup and Live Event tabs
• Class order chips can no longer be manually deleted (auto-managed)
• Theme selection now persists and loads on refresh
• Density button highlighting now matches selected theme
• Default theme is Purple when no preference is saved

Removed:

• Light mode (app is now dark mode only)