Riddle Database — In-Game Database Manager for RedM / VORP

Manage your entire server database without ever leaving the game.
Browse, search, edit, insert and delete rows in any table — a phpMyAdmin-class tool, rebuilt for RedM with a beautiful frontier-ledger interface and a security-first, fail-closed architecture you can trust on a live, populated server.

Fix a stuck character, correct a player's money, clear a duped item, inspect any table — in seconds, in-game, fully audited.

🗄️ Database Management

• Any database, any schema — tables are discovered live; new tables from other resources appear automatically
• Full row-level control — view, sort, paginate, search, edit, insert, delete (composite keys and keyless tables included)
• Smart editors — enums become dropdowns, flags become yes/no, and JSON columns (skin/comps) open in a validated editor that refuses to save broken JSON
• Server-side search across every column of a table
• CSV export — written safely on the server, audited

⚒️ Live Player Tools

• Player Fix panel — give/remove money, gold, rol, items; set job & grade; set group. Applied through VORP's own API: instant for online players, safe DB fallback for offline ones
• Inventory viewer — see an online player's real inventory before touching it
• Character dossier — one click shows EVERYTHING the database knows about a character, across every table. The VORP-aware view phpMyAdmin can't give you

🛡️ Security & Safety

• Deny-by-default, fail-closed permissions — VORP group based, with optional ACE layer and per-tier restriction (read / write / player)
• Online-player guard — rows belonging to connected players are flagged and require explicit confirmation
• Complete audit trail with built-in viewer — who, when, what, including previous values on every update and delete
• Discord webhook — rich embeds showing every change as old → new
• Read-only maintenance mode — freeze all writes server-wide with one command
• Fully parameterized queries, schema allowlisting, rate limiting, two-step deletes
• Gameplay-safe — the client touches nothing but its own panel; zero interference with peds, vehicles, or controls

🎨 Four Designs · 🌍 Five Languages

Frontier Ledger (bound leather & brass), Leather & Gold, Gunmetal, and Mono — switchable in-panel, remembered per admin.
UI fully translated: English, Español, Português, Français, Deutsch — or add your own language file in minutes. Audit log and export files auto-clean on a configurable retention schedule, so the tool never bloats your database.

⚠️ Honest Note — When Do Edits Apply In-Game?

Every edit is saved to the database instantly. But just like with phpMyAdmin: if another script caches its data, you'll need to restart that script to see the change, and a character's row edited while the player is online can be overwritten by VORP's own save — edit offline players, or use the built-in Player Fix tools, which apply instantly through VORP even mid-session. The panel warns you about exactly these cases. Full details in the included documentation.

📋 Requirements

• RedM (rdr3) · VORP Core (Lua — all versions supported)
• oxmysql · ox_lib
• vorp_inventory (only for the item tools)

⚡ Performance

Fully event-driven, no tick loops — 0.00ms idle in resmon.

By Riddle Coding. Test on a development server before production use.