Comment on page
QB Core Mapping Tutorial
Find out how to map a QB Core database with Sonoran CAD!
QB Core stores player information in the
The player's first and last name is stored as JSON in the
charinfocolumn. We'll toggle these as a
JSON Columnand set the JSON keys to
citizenidcolumn stores a unique player ID. This will be our
Character Mapping Column.
QB Core also allows players to own multiple residences at once.
Sonoran CAD's DB Sync will pull all of these from their external
QB Core - DB Sync - Residency Mapping
Because multiple residences can be listed at once, it's recommended you update your custom record's residence field to the
The custom record now shows the residency textarea with all owned addresses.
QB Core - Multi Residence in Custom Record with DB Sync
QB Core stores the vehicle information in the
Unique IDfor vehicles is stored in the
citizenidcolumn and matches the values stored in the
citizenidcolumn from our player mapping.
platecolumn stores the vehicle's license plates.
Because of how licenses are stored in QB Core, this process adds a couple of extra steps.
You will first need to edit the License record to adapt it for how QBCore stores its licenses. Open the Admin Panel by going to the following...
Custom Records-> Click
#4 - License
Sonoran CAD Custom Record Editor
Replace the last three fields in the
License Information:section with the following. Make sure to change the
textand remove the
mask. You can use the screenshot below as a guide. Then click
Savebefore moving on.
Don't forget to click Save before continuing!
Sonoran CAD custom record editor
In-Game Integrationto open the DBSync settings menu.
As of writing on 2/28/2022, the following pictured settings will work for QBCore's latest version. Fill in the
Character Mapping Column,
JSON Columns and
Friendly Mappings as shown below. Make sure to click
Save Mapping Configonce finished.
We are aware of the misspelling "licence", this is intentional in QBCore to differentiate between another piece of data referred to as "license"
Sonoran CAD DBSync Settings
Sonoran CAD DBSync Friendly Mapping Settings
Congratulations! You should now be all set up to display your licenses from QBCore in Sonoran CAD. Feel free to test a record lookup to verify everything is in order.
Example QBCore DBSynced license data