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

[Kurx]

OHHH I never renamed it. After renaming it, It works now! Thank you Distritic! Appreciated! ^_^Y

[justSac]

When try edit the profile of a person (to remove a licence, add note…) the changes is not updated in de db and the console show’s this error:

Another “error” is (with the last version), the bottom to create a new report is not visible for me:

[redde05]

So for you do you just text the police number and it goes to the MDT or how does ur work?

[VakarixsDZ]

I have question, for me everything working fine with the MDT it’s opening closing no errors sql working everything, but the problem when i try search my name it’s saying finding but don’t find it and saying all time same finding, how can i fix that problem, i using esx_kascharacters but everything saving in users all character in user.

Screenshot

[XDope]

cough cough twitch cough cough

Great work then, great work now. Thanks for releasing.

[redde05]

Make sure your searching the full name first and last!

[VakarixsDZ]

i was trying and the full name and surname but didin’t work, just show the finding

[distritic]

If your characters are saved in a different table, you will have to edit the SQL statements in sv_mdt.lua to select from the correct place. The installation does say that you should use the release version of esx_identity which stores characters in a table named characters.

@distritic

esx_identity (release version using characters table)

[WindiestHook381]

Can’t submit the report. Database contains what it needs…

[8zbit]

LOL this NoPixel MDT

[redde05]

Its not the same one its similar not exact tho…

[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)

[justSac]

Now works!
Using users and with these files works 100%.
Th u vmuch! ^^

[Upmarketdread]

It seems with your modified version when I perform a player search it selects the top entry in the list no matter what I select

[distritic]

I don’t quite understand, could you send me an example please?

[VakarixsDZ]

Thanks, now it’s working perfect

[Jonneis]

Thats true so we have to add a line for the police number

here you go

[redde05]

Calls for me still are not going the cad its so weird.

[Steven_Garcia]

Hi. I’ve changed in the
“sv_mdt”, the lines corresponding to “characters”, since we don’t use that table. However, even though I make the changes, the tablet does not register the officer in question at the top and when I try to generate a new report, the button to create such report does not appear. Can you help me identify what I am doing wrong or what I need to do?

[distritic]

Please actually read through the previous questions to check if someone else has already asked about this. Follow the steps below.

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

Please follow these steps: 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)