📁 What Is CaseFile?
CaseFile gives your detectives, lawyers, judges, and law enforcement a dedicated panel to build real case files — complete with witnesses, testimony, physical evidence, formal charges, and documented verdicts. Every case tells a story that persists across sessions.
⚖️ Features
Case Management
- Create, update, and track cases with unique auto-generated case numbers
- Assign case types, locations, and detailed descriptions
- Three case statuses: Open, Closed, and Cold
- Full audit log of every action taken on a case
Witness & Testimony
- Add witnesses by proximity (nearby player picker) or manually by name
- Witnesses can self-submit their own statements in-character
- Staff/detectives can enter or revise statements on behalf of witnesses
- Full statement revision history with superseded tracking
Charges & Verdicts
- Assign a primary charge to any case, plus unlimited additional charges
- Set individual verdicts per charge: Guilty, Innocent, or Dismissed
- Verdict summary displayed directly on the case list card at a glance
- Document the official ruling and sentence when closing a case
Parties
- Assign a Judge, Defendant, and Prosecution to any case
- Add parties by nearby player picker or manual entry
Exhibits
- Attach physical evidence items to a case with labels and notes
- Supports external system integration via reference IDs
🔧 Technical
- Zero setup — tables create automatically on first resource start, no manual SQL import
- Framework support — QBCore, ESX, or Standalone (ace permission based)
- Dual access control — ace permissions + job-based check, fully configurable
- oxmysql — parameterized queries throughout, no SQL injection surface
- Clean NUI panel — dark themed, keyboard closeable, manager vs. player view modes
- Configurable case types, max open case limits, statement modes, and key binding
📋 Requirements
- oxmysql
- MySQL / MariaDB
🔒 One-time purchase. Lifetime updates included.