Changelog

• Fixed database connection issues in admin tools (AdminUserLookup, AdminActivityHeatmap, AdminBulkActions, CacheHealthMonitor)
• Converted PostgreSQL-specific queries to SQLite/PostgreSQL compatible syntax
• Fixed NotificationManager to use correct PostgreSQL schema (title/message columns)
• Fixed broadcast notification system to properly create notifications
• Improved user lookup page styling with dedicated CSS classes
• Fixed notifications.js to handle API response format correctly
• Added database driver detection for proper table creation (SERIAL vs AUTOINCREMENT)
• Fixed SQL syntax errors and missing file checks in admin classes

• Recreate admin.css from scratch with clean design system
• Fix CSS variable conflicts (use --space-* instead of --spacing-*)
• Standardize card headers with icons across all admin pages
• Unify button styles (btn-admin, btn-danger, btn-warning)
• Remove unwanted hover effects and gradients
• Restructure claim-org page to 2-column layout
• Fix donations page button styling and spacing
• Fix warmup-redis grid layout
• Improve responsive breakpoints for mobile/tablet
• Clean up inline styles and use admin.css classes

• Convert all SQLite syntax to PostgreSQL (strftime, julianday, boolean comparisons)
• Fix CSS/layout issues across admin pages (active-users, warmup-redis, broadcast-notification)
• Create missing analytics API endpoints (realtime, behavior, comparison, predictions)
• Add proper timestamp casting and type conversion for PostgreSQL
• Fix JavaScript null checks in analytics-advanced
• Remove deprecated links from admin index (API Documentation, Steam Friends Cache)
• Add deprecation warning to steam-friends-cache page
• Ensure consistent admin.css styling across all pages

• Add s&box ownership check via Steam API
• Award sbox_owner badge to verified owners
• Fix leaderboard to show display names and avatars
• Fix user package fetching for player profiles with claimed orgs
• Remove artificial limits on claimed org packages (was 4 per org, 12 total)
• Improve pagination to fetch all packages (up to 10k per type)
• Fix user-experience API to return empty array instead of 401 for unauthenticated users
• Add admin tools: sync-reputation.php, clear-user-cache.php, clear-all-user-caches.php

• Added server-side checks for favorite and follow status on page load
• Query favorites and followed_packages tables to set initial button state
• Removed JavaScript checkFollowStatus call on init to prevent overriding server state
• Fixed follow button to use 'following' class instead of 'active'
• Updated button text to show 'Following' when active
• Added error handling for database queries

• Disabled PHP CompressionMiddleware (Apache handles compression)
• Disabled cache compression to prevent corruption
• Fixed PostgreSQL schema: removed user_type column from user_sessions INSERT
• Added steam_presence_settings table to PostgreSQL migration
• Fixed SQLite syntax in SteamPresenceIntegration for PostgreSQL compatibility
• Fixed saveUserSettings to use PostgreSQL ON CONFLICT syntax
• Added ini_set to disable zlib compression in API endpoints
• Fixed Steam Presence toggle to load server-side for instant display
• Fixed API URLs for Steam Presence endpoints
• Removed temporary debug tools

• Add mobile-web-app-capable meta tag
• Fix getDatabase() to support PostgreSQL
• Add saved_searches table to both SQLite and PostgreSQL
• Fix NotificationManager and WatchlistManager to use getDatabase()
• Fix PostgreSQL boolean comparisons (FALSE/TRUE vs 0/1)
• Fix I18n to work with both SQLite and PostgreSQL
• Remove PWA install prompt auto-trigger warning
• Fix user_id vs steam_id column naming in PostgreSQL schema

• Updated NotificationManager to use 'content' column instead of 'title'/'message'
• Fixed dispatch-notifications.php to use consolidated DB when available
• Updated createNotification and createBatchNotifications methods
• Notifications now fire correctly when packages are updated

• Increased SQLite busy_timeout to 30s and added retry logic to cache operations
• Added ProcessLockManager to limit concurrent workers to 5 max
• Disabled CURLOPT_FAILONERROR and added smart 404 filtering for missing packages
• Added 2s batch delays between worker spawns in schedulers
• Prevents database lock contention and worker stampedes

Changed {steamLink} to {{steamLink}} across all locale files to match i18n system's double-brace placeholder format

• Removed opacity: 0 from .commit-item causing hidden text
• fadeInUp animation now handles visibility correctly

• Fixed 5 extra closing braces in pages.css breaking stylesheet
• Removed opacity: 0 from news-item inline style causing hidden posts
• News posts now display correctly with fadeInUp animation

• Add prefers-reduced-motion support for animations
• Add visible focus indicators for keyboard navigation
• Increase touch targets to 44px minimum (WCAG AA)
• Add disabled state styling for search input

• Remove duplicate getDatabase() function conflict
• Add profile-widgets API routes (GET/POST) to profile-api.php
• Add profile-widgets routing in router.php
• Add debug logging for profile layout loading
• Profile custom layouts now load and save correctly
• Widgets system now functional with default widgets support

just some css cleaning

hopefully

Remove htmlspecialchars from storage layer - encoding should only happen at output time to prevent & issues

• Wrap layout data in {'layout': ...} format in POST endpoint to match GET format
• Remove auto-initialization that was overwriting custom layouts
• Add detailed logging for debugging layout load issues

Changed overflow from hidden to visible on .site-nav to allow dropdown menu to display properly