SQL Connection Credentials
section of the configuration, and toggle on Database Sync and the optional Database Merge feature.address
field in your custom record is blank (your DB doesn't have this info). DB merge allows you to manually edit the record pulled from your database and edit any blank field.localhost
or 127.0.0.1
. This must be the external IP or domain to reach your database. Learn more about creating an external SQL connection.table name
field will contain the name of your database table containing character records.column name
field will contain the name of the specific column in the character records table containing data for this row.Character Mapping Column
contains a unique ID for the specific character. This unique identifier will also map records in your license and vehicle registration tables back to the character that owns them. Typically, this is a Steam ID or license ID.identifier
column to map back to the other characters table.characters
table contains our character records. The identifier
column contains the character's unique ID, the firstname
column contains the characters first name, the lastname
character contains the characters last name, etc.Character Mapping Column
specified. Again, this is the name of the column in your license/vehicle table containing a unique ID that maps back to the character that owns it.owned_vehicles
table contains our stored vehicles. The owner
column contains the character's unique ID that owns the vehicle, and the plate
column contains the vehicle's license plate.accounts
column stores JSON formatted data. For this example, we want to display the bank
money in the custom character record.bank
.eye_color
is a JSON object, with the item
property of 0
.eye_color.item
0
value to an actual color, like "brown".Character Mapping ID
column (a column with an ID that directly maps back to the character/civilian record), but may contain a unique ID that maps back to a specific character in another table.vehicle
table contains all of the vehicle information, but does not contain a CharacterID
column. Instead, the vehicle
table contains a VehicleRegistrationID
column.VehicleRegistrationId
column then maps to the vehicleregistration
table. The vehicleregistration
table then contains a corresponding CharacterId
column, which maps back to the character
table.External Key
checkbox, as the vehicle
table's VehicleId
needs to be mapped to an external table to be turned into the proper characterId
.vehicleregistration
) and the external key's column CharacterId
.JSON Column
and set the column name to accounts
as this is the column in our character table that contains the JSON data.bank
.drive_license
in your database is converted to Driver's License
.tinyint
column types may be displayed as numerical values 0
and 1
but be read as True
and False
by Sonoran CAD.
Instead of mapping the "Database Vaue" as 0
or 1
you will need to map False
and True
.taxi
job value can be automatically converted to Taxi Driver
in DB Sync records, and the cardealer
jon can be automatically converted to Car Dealer
.Modify
on the job
field's friendly mapping.taxi
to a friendly value of Taxi Driver
and the raw db value of cardealer
to Car Dealer
.Import
> CSV
> Select your downloaded Google spreadsheetImport
> JSON
> Paste your JSON formatted structurejob
field in our character's table.Job
field has been added. We can map this new field to our database as any other field.