QB Core Mapping Tutorial
Find out how to map a QB Core database with Sonoran CAD!
Last updated
Was this helpful?
Find out how to map a QB Core database with Sonoran CAD!
Last updated
Was this helpful?
QB Core stores player information in the players table.
The player's first and last name is stored as JSON in the charinfo column. We'll toggle these as a JSON Column and set the JSON keys to firstname and lastname.
The citizenid column 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 player_houses table.
Because multiple residences can be listed at once, it's recommended you update your custom record's residence field to the textarea type.
The custom record now shows the residency textarea with all owned addresses.
QB Core stores the vehicle information in the player_vehicles table.
The Unique ID for vehicles is stored in the citizenid column and matches the values stored in the citizenid column from our player mapping.
The plate column 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...
Admin Panel -> Customization -> Custom Records -> Click #4 - License
Replace the last three fields in the License Information: section with the following. Make sure to change the type to text and remove the mask. You can use the screenshot below as a guide. Then click Save before moving on.
Don't forget to click Save before continuing!
Click Advanced -> In-Game Integration to 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 Table Name, Character Mapping Column, Column Names, JSON Columns and Friendly Mappings as shown below. Make sure to click Save Mapping Config once finished.
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.
You can configure other custom fields may include color, make, model, etc. Vehicle colors are often stored as a number. You can use to convert a number to a color name.
