yes i figured it out.
in ghmattimysql
open the __resource and add
server_scripts {
‘@mysql-async/lib/MySQL.lua’
}
in the file.
i read through the instructions and saw that it said to edit __resource.lua so it links to mysql so i did what the mysql instructions said which add that line of code to any __resource.lua that requires mysql lmao.
now my only issue is that any car i go in the tires spin sooo fast and such idk what is causing that issue XD
Thank you man!!!<3
Actually that is not how it works.
Only thing you needed to do is download the latest release of ghmattimysql, place it in your resources folder so it looks like resources/ghmattimysql, change the db credentials and after that add start ghmattimysql to server.cfg and you are done.
Adding this line would only cause issues
server_scripts {
‘@mysql-async/lib/MySQL.lua’
}
worked for me.
now where in the ghmattimysql/readme file does it say to do that…?
mysql-async isn’t used anymore, not even by ghmattimysql.
You guys probably just pressed the Download or clone button which contains the source code for the resource instead of downloading the actual release from
For this to work you need to delete the config.json file in your /resources/ghmattimysql/ folder. Then the server.cfg needs to be modified by adding set mysql_connection_string "mysql://mysqluser:password@localhost/database?dateStrings=true" before the start ghmattimysql line. As an example it can look like this:
is there an onduty/offduty script for this?
Not in the current version, however the upcoming update for Cops_FiveM contains the 2 chat commands (onduty/offduty)
How I can add more garage for Police?
Honestly, this is a must have for trainer menu based servers. It has worked flawlessly through the two months our community has been using it. Thank you for the awesome release
somone know how do i make when somone logged in x account then it will automatic spawn him on station and dont need him to go on duty?
so with ghmattimysql how do i whitelist and how do i give the role to a user, also how can i add loadout for cops in the amorey and cars to the garage??? can someone please help
I’m so confused on how to get this to work.
Is there a youtube video or something?
Can someone make a youtube video, on how to install this onto your server.
As there is two vairents on a mysql data base to use since Async is no longer used.
Can someone just make a youtube video for us server dumb dumbs.
Dose it work if i have esx and remove The esx_policejob
I cant get it do work 
Couldn’t start resource police.
now i got the cant start police away and i have
couldn’t load resource ghmattimysql
i tryd the
server_scripts {
‘@mysql-async/lib/MySQL.lua’
}
but it didint work for me
Sure it is a standalone resource, so it does not interact with essentialmode, esx or any other framework.
You need to setup ghmattimysql.
Change the mysql credentials in resources/ghmattimysql/config.json and add start ghmattimysql above start police in server.cfg.
hi everyone if you need help how to install, pm me out 
i pm u