SIMPLIX IT · SCRIPT DOCUMENTATION

CASE FILES &
REPORTS.

V1.2.1 · REDM / VORP CORE

An immersive Mobile Data Terminal (MDT) for RedM (VORP Core) styled like a real case file. Police, Medic, and Lawyer each get their own theme, catalog, and reports — including a status system and printable document copies.

Feature Overview

Police (Sheriff/Marshal) — "Sheriff's Office", manages accused persons and penal code violations, tracks involved officers
Medic (Doctor) — "Medical Center", manages patients and treatments, tracks involved medics
Lawyer — its own legal services catalog and client management
Create and edit reports, filter by status (Open, In Progress, Closed)
Printable document copies (document_paper) as a read-only snapshot of a report
Fully bilingual: German and English pre-configured

Dependencies

vorp_core
oxmysql

Installation

Upload mulderdev_document_script to your resources directory.
Import mulderdev_records.sql into your database (it creates the mulderdev_records table):

CREATE TABLE IF NOT EXISTS `mulderdev_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference_id` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `author_identifier` varchar(50) DEFAULT NULL,
  `author_name` varchar(100) DEFAULT NULL,
  `target_name` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `fine_amount` decimal(10,2) DEFAULT 0.00,
  `status` varchar(50) DEFAULT 'open',
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Important: Also add the document_paper item to your items table:

INSERT INTO `items` (`item`, `label`, `limit`, `can_remove`, `type`, `usable`) VALUES
('document_paper', 'Document Copy', 10, 1, 'item_standard', 1);

Adjust config.lua — locale, open key, jobs, the fines/treatments/legal-services catalogs, and optionally Config.Society (see config reference below).
Add ensure mulderdev_document_script to your server.cfg and restart the server.

Usage

Open the menu: Press B (or your configured key) — requires a Police, Medic, or Lawyer job.
New report: Click "New Report", then add charges or treatments from the catalog on the right and submit.
History & editing: Filter by status in the "History" tab, open an entry, and edit it via "EDIT REPORT".
Document copy: Click "PRINT COPY" in the report view to receive a physical document_paper item. Used from the inventory, it shows the report read-only.

External trigger: To open the menu from another script (e.g. a radial menu), use:

TriggerEvent("mulderdev_document_script:open")

Config Reference — General & Jobs

Setting	Description
`Config.Locale`	Language: `'en'` or `'de'`
`Config.OpenKey`	Key to open the menu (default: `B`)
`Config.Jobs.Police`	Jobs with access to the Police view (default: police, sheriff, marshal)
`Config.Jobs.Medic`	Jobs with access to the Medic view (default: doctor, medic)
`Config.Jobs.Lawyer`	Jobs with access to the Lawyer view (default: lawyer, anwalt, judge)

Config Reference — Catalogs & Billing

Setting	Description
`Config.Fines`	List of penal code entries — each with `label`, `price`, `jailTime`
`Config.Treatments`	List of medical treatments — each with `label`, `price`
`Config.LegalServices`	List of legal services — each with `label`, `price`
`Config.Billing.Currency`	Payment method: `0` = cash, `1` = gold, `2` = rol
`Config.Billing.MaxDistance`	Maximum distance to target for billing, in meters (default: `3.0`)

Config Reference — Society / Ledger Payout

By default, billed money is paid directly to the character who issued the bill. Optionally, per job, it can instead be paid into a database table (e.g. your banking/society system).

Setting	Description
`Config.Society.<Job>.Enabled`	`true` = pay into the DB table instead of the character (default: `false`)
`Config.Society.<Job>.Table`	Database table that holds the account balance
`Config.Society.<Job>.SectionColumn`	Column that identifies the account/section
`Config.Society.<Job>.SectionValue`	Value in `SectionColumn` for this job's account
`Config.Society.<Job>.MoneyColumn`	Column that stores the balance

Ask whoever manages your banking/society system for the correct table and column names for Config.Society.

License / Terms of Use

This resource is proprietary software by MulderDev. The unencrypted source is included for customization and debugging on your own server, but it may not be redistributed, resold, or leaked — including modified versions. Code from this resource may not be used to create a new resource for public distribution or sale.

CASE FILES &REPORTS.