[ESX] Mobile Data Terminal | Reports, warrants, calls, searches & more

[distritic]

Please follow these steps:

@distritic

1. There are a few dependencies, please follow the installation steps provided for these scripts and ensure they are running:
   es_extended (v1, duh)
   esx_kashacters
   esx_identity (release version using characters table)
   esx_license
   esx_vehicleshop
   esx_policejob
   mythic_notify : for 911 call notifications
   mysql_async
   gcphone : the MDT fetches phone numbers from gcphone, edit lines 119 and 197 of sv_mdt.lua to select from elsewhere
2. Execute the provided SQL queries in the user_mdt.sql file.
3. If your characters database table from esx_identity does not contain a primary key (old version), you will have to execute the following query:

ALTER TABLE `characters` ADD COLUMN `id` int(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT

If you are using a table named users to store characters and this table already has a column named identifier as a primary key, you will have to use this edited file of sv_mdt.lua and use the database structure below for step 2.
sv_mdt.lua (23.8 KB)
user_mdt.sql (1.4 KB)