N+1 fixes:
- Add withCount('furniture') to rare categories sidebar (prevents N queries)
- Add tags and user.permission eager load in ArticleController
- Add rooms and photos.user eager load in ProfileController
- Add user eager load in MediaApiController (API was returning null user data)
SELECT * fixes:
- Replace WebsitePermission::all()->pluck() with direct pluck()
- Replace WebsiteHousekeepingPermission::all()->pluck() with direct pluck()
- Add select(['id', 'public_name']) to ItemBase query in furniItems()
- Add select(['id', 'name']) to help categories query
- Add select(['id', 'name', 'code']) to languages query
Memory/performance:
- Replace full collection load with aggregate queries in getRareStatistics()
- Add limit(50) to open tickets query in TicketController
- Move popper.js, tippy.js, alpine-ui, alpine-focus, flowbite, jquery,
jquery-ui, and swfobject from local assets to CDN (jsDelivr/cdnjs)
- All new CDN URLs are configurable via .env variables
- Old local assets remain as fallback for flowbite CSS/JS only
Dead code removed:
- DRY_RUN: set but never checked anywhere
- debug(): defined but never called
- C_BG_YELLOW: defined but never used
- --dry-run/-n flag: accepted but had no effect
- --verbose/-v flag: accepted but not used (comment said 'not used yet')
Bugs fixed:
- --url flag was broken: URL derivation (NITRO_DOMAIN, NITRO_SOCKET_URL, etc.)
happened at module level BEFORE CLI parsing, so --url had no effect on derived
values. Moved URL derivation into main() after CLI parsing.
Cleanup:
- Extracted load_branches() helper to replace 3x duplicated branch loading pattern
- Total: -35 lines, same functionality
sync_configs() was missing the Python URL fix that patches:
- socket.url → wss://ws.epicnabbo.nl
- api.url, image.library.url, gamedata.url, etc.
This caused renderer-config.json and ui-config.json to have broken wss://ws. values.
Now sync_configs() applies the URL fix after copying .example files.
Verified: socket.url=wss://ws.epicnabbo.nl in both public/ and dist/ configs.
- Add IN_INTERACTIVE flag to detect interactive mode
- die() now returns to menu instead of exiting in interactive mode
- Update options (1-6) run with 'set +e' to prevent crash on errors
- 'set -e' restored after update completes
- Errors are logged and shown as warnings, menu keeps running
- New premium ASCII art banner with EMULATOR text
- Banner shows: Emulator / Nitro-V3 / Nitro-V3-Render
- Subtitle: Updater by Remco — epicnabbo.nl
- Mini banner updated with same branding
- Menu header updated
- Help text updated with branding
- Gold color theme for title text
Running ./update-Nitrov3.sh without arguments now opens the TUI
control panel instead of immediately running a full update.
Use 'update' subcommand or --only= for direct CLI updates.
- Add pick_branch_and_update() wizard for all update options
- Auto-detect available branches from all git repos
- Show branch list with (current) marker for active branch
- Show update summary (branch, mode, site) before confirmation
- Add detect_available_branches() helper to avoid duplication
- Restructure menu: UPDATE / TOOLS categories with labels
- Option 1: Quick Update (uses current branch, no prompts)
- Options 2-6: Full/Selective update with branch picker
- Branch switcher shows all detected branches from repos
- Menu header shows current time, branch, and site URL
- Add detect_branch() function with smart fallback per repo
- Auto-detect branches: tries exact match, capitalization variants,
development/Development, main/master, remote branches
- Never crashes on missing branch - warns and skips instead
- Remove hardcoded branch validation (now accepts any branch name)
- Add branch switcher to interactive menu (option 6)
- Shows current branch and site URL in menu header
- git_update() now uses git pull origin instead of generic pull
- Update help text for --branch option
- Complete rewrite from 584 to 1902 lines
- Interactive TUI control panel with 13 menu options
- CLI subcommands: update, interactive, status, health, backup, restore,
backups, services, database, config, logs, clean, help, version
- Selective updates with --only=emulator|client|renderer|configs
- Animated spinners and progress bars during operations
- System diagnostics: CPU, memory, disk, Redis, Nginx, SSL cert check
- Database manager: info, tables, sizes, optimize, check, custom queries
- Backup management: create, restore with interactive selection, list view
- Service manager: start/stop/restart for emulator, nginx, PM2
- System status dashboard with server info and resource usage
- Health check with 20+ checks and scoring system
- Cache cleanup: Yarn, Laravel, Redis, logs, backups, temp files
- Enhanced webhook notifications with color support
- CLI flags: --dry-run, --force, --verbose, --quiet, --branch, --url
- Fix: derive NITRO_SITE_URL from APP_URL before URL calculation
- Full UTF-8 and ASCII fallback support
The vendor/ entry in .gitignore was blocking lang/vendor/filament/
from being tracked. Added !lang/vendor/ exception and committed all
21 language translation files (login.php + resources.php) so the
other VPS can pull them via git.
All language JSON files (ar, br, cs, da, de, el, es, fi, fr, hu, it, no, pl, pt, ro, ru, se, tr, uk) were missing commandocentrum.* and radio.* keys that were only present in en.json and nl.json.
Added the missing keys with English values as placeholders. All 21 languages now have 305/305 keys (100%). Filament vendor PHP translations were already 100% complete.
- Add CSS variable support to dusk theme components for dynamic text colors
- Fix low-contrast preset color combinations (cyberpunk, neon, magma, forest, obsidian, space)
- Add text-shadow utility classes and apply to site header and backgrounds
- Style logout buttons as proper buttons matching other button styles
- Fix hardcoded text colors in atom theme components
- Replace flowframe/laravel-trend with direct Eloquent DB queries
- Replace srmklive/paypal (abandoned) with new PayPalService using PayPal REST API v2 via Guzzle
- Remove old config/paypal.php, migrate to config('habbo.paypal.*')
- Update blade templates to use habbo.paypal config
- Bump npm packages to latest: @inertiajs/react, axios, esbuild, eslint, sass, tailwindcss, etc.
- Run composer update and yarn upgrade
- Rename all .js/.jsx files to .ts/.tsx across resources/js and theme dirs
- Add TypeScript 6.0 with strict mode, tsconfig.json
- Add type definitions for Inertia page props, Alpine.js, Turbolinks
- Update vite.config.js entries to .ts/.tsx extensions
- Update all Blade @vite() calls to match new .ts/.tsx entry points
- Add TypeScript ESLint config (replacing unused Vue plugin)
- Add @types/react, @types/react-dom, @types/lodash
- Add typecheck script and integrate into check pipeline
- Full tsc --noEmit, ESLint, and production build pass cleanly
- Add pagination to ShopController (50 per page)
- Add throttle:3,10 to radio application store route
- Replace mixed Dutch/English labels in RadioWizardController (English only)
- Replace Dutch error messages in RadioController and RadioSetupController
- Add config('habbo.defaults.avatar_look') for SocialAuthController
- Remove hardcoded default stream URL from RadioSetupController
- Add database indexes for radio_listener_points.earned_at and bans.ip
HIGH:
- Add missing import RadioSongRequestFormRequest (fixes crash on POST)
- Add Purify XSS sanitization for article full_story
- Fix duplicate radio API routes (/api/radio vs /api/radio/v2)
- Add try-catch guards in InstallationController for missing records
MEDIUM:
- Fix N+1: eager load comments.user in ArticleController::show()
- Fix GuestbookController authorization logic
- Remove dead doSetup() method and duplicate route
- Extract shared HasRadioDefaults trait (remove code duplication)
- Use named routes in ForceStaffTwoFactorMiddleware
- Fix WebsiteHelpCenterTicket::isOpen() (no permission leak)
- Enable on WebsiteHelpCenterTicket (matches schema)
- Replace WebsiteTeam::all()->pluck() with direct pluck()
- Replace CatalogPage::all()->pluck() with direct pluck()
- Replace WebsiteBadge::all() with direct pluck()
- Add throttle middleware to guestbook store, logo-generator, radio embed
LOW:
- Remove unused imports
- Remove dead /inertia-test route
- Consolidate cache keys in RadioController
- Add Fase 3 to sync merged configs to dist/configuration/
- Add Fase 4 to force critical URLs (image.library.url, hof.furni.url, etc.)
- Add NITRO_* env vars with current server defaults
- Prevent git pull from overwriting icon URL config with example values
- All git pull commands now auto-stash local changes first
- .example configs are now merged with live files in Nitro's
public/configuration directory to keep them 100% complete
- Removed unused getTargetName function from merge-config.cjs
- Rewrite .gitignore in English with proper patterns for build artifacts, storage files, and IDE files
- Remove tracked build assets (hash-based) and storage files from git
- Update LICENSE copyright to 2026 Remco (Epicnabbo)
- Fix clone URLs in README (remove placeholder gitea-server)
- Sync docs/INSTALL.md with README installation guide
- Moved Nitro V3 update from web UI (Commandocentrum) to CLI-only
- Removed configure paths form and runUpdateNitrov3() from admin panel
- update-Nitrov3.sh now loads .env automatically from its directory
- Added all NITRO_* env vars to .env.example.linux and .env
- Removed configurable paths from database (replaced by .env)
- Updated README and CHANGELOG
root