Database Sync and Merge

​

What is DB Sync?

​

Configuring DB Sync

​

1. Enter Connection Credentials

• RocketNode
• Zap Hosting
• HeidiSQL
• phpMyAdmin

Rocket Node Hosting - Database Credentials1. LoginLogin to your RocketNode game panel and navigate to your FiveM Server.2. Select the DatabaseOn the left sidebar select Databases > … menu > Details3. Copy Connection CredentialsEnter the following items from the RocketNode database details panel into Sonoran CAD

• Endpoint
  • This includes the “Host” and “IP” portions for Sonoran CAD. From the image below, the Sonoran CAD Host would be db-ash-06.apollopanel.com and the Port would be 3306.
• Username
  • Direct copy from RocketNode to the Sonoran CAD’s Username field.
• Password
  • Direct copy from RocketNode to the Sonoran CAD’s Password field.
• Database
  • Outside of the database details window the database name can be clicked to be copied and pasted into the Sonoran CAD Database field (image 2).

Zap Hosting - Database Credentials1. LoginLogin to your Zap Hosting Account and Navigate to your FiveM Server.2. View the Tools SectionScroll down until you see TOOLS on the left hand side of your screen and select Databases.3. View Database CredentialsIn the Center of your screen you will see you’re database Credentials.4. Set DB Credentials in Sonoran CADDatabase Translation Information

Zap Hosting	SonoranCAD
Server/IP	Host/Address
Database	Database
User	Username
Password	Password

See Database Sync and Merge Connection Credentials to figure out how to add Credentials to your CAD Instance using the information above.

HeidiSQL - Database Credentials1. Login to your database using HeidiSQL.2. Open the User ManagerAt the top of your screen click Tools and then User Manager.
Then, click Add at the top left.3. Enter the Account InformationEnter a user name, password, and enter % in the From host field. This will allow external IPs (Sonoran CAD) to connect to your database.Under Allow Access To select Add Object4. Select the DatabaseSelect the name of your database, then hit Ok.5. Select the PermissionsCheck off the EXECUTE, SELECT, and SHOW VIEW read permissions. Then press Save.6. Save the user and set credentials in Sonoran CADYou will now want to go to http://whatsmyip.org and get your Public IP Address to use as your Host.Database Translation Information

HeidiSQL	SonoranCAD
Host	Host/Address
User name	Username
Password	Password
Database	Database

See Database Sync and Merge Connection Credentials to figure out how to add Credentials to your CAD Instance using the information above.

phpMyAdmin - Database Credentials1. Navigate to your phpMyAdmin Web Panel2. Navigate to User AccountsAt the top of your screen click on User Accounts.3. Create a new user account4. Fill out the account informationThe Host Name field should be set as Any Host and the value as %. This will allow external IPs (Sonoran CAD) to connect to your database.5. Once created, edit the user account privileges6. Select your specific database7. Select only the required permissionsSELECT and SHOW VIEW will ensure this account can only read from your database.8. Save the user and set credentials in Sonoran CADYou will now want to go to http://whatsmyip.org and get your Public IP Address to use as your Host.Database Translation Information:

phpMyAdmin	SonoranCAD
Host	Host/Address
Database	Database
User name	Username
Password	Password

See Database Sync and Merge Connection Credentials to figure out how to add Credentials to your CAD Instance using the information above.

34.173.36.190

​

2. Combine API and DB Sync Records

Combine API and DB Sync Records

When a community uses database sync, all record lookups run against that community’s external database. Some communities may also want to include CAD records created through integrations such as ERS. Enabling this option allows lookups to return both in-game data, such as characters, licenses, and vehicles, and API-created characters and vehicles from ERS.To enable this, turn on Include CAD API records in DB Sync lookups.

​

3. Automatic AI Setup

Automatic AI Setup

Sonoran CAD’s automatic AI setup handles all of the configuration for you. Once your connection credentials are entered correctly, select AI Automatic Setup to complete the full configuration.The AI will automatically add any primary key columns if missing, will update your license record for any additional types, and will configure friendly mapping values if your community is on the Pro version. This process typically takes 60-90 seconds.Once completed, the AI will inform you of any missing columns (record fields that don’t exist in your database) and will save the new configuration.Next, run a lookup in the police or dispatch panel to test searching for exisitng in-game characters, licenses, and vehicle registrations.

​

4. Automatic Selfie/Portraits

​

Database Merge

Database Merge

For security, Sonoran CAD’s database sync is read-only. It retrieves information from your in-game database but never modifies it. Available fields—such as vehicle color, hair color, and other character details—are automatically loaded into your custom record templates.If your database does not contain the information required for certain custom fields, those fields will appear blank. Database Merge allows you to manually complete these records without changing your in-game database.When you enter information into a blank field, Sonoran CAD saves the additional data separately. During future lookups, it automatically combines your in-game database information with the manually entered CAD data to display a more complete record.Database Merge is available exclusively to Pro communities and can be enabled from the Connection Credentials tab.

​

Friendly Mapping

Friendly Mapping

Friendly mapping allows you to convert any raw database value to a more user friendly value.
Ex:

• drive_license in your database is converted to Driver's License.
• color1 in your database is converted to Brown.

To manually configure friendly mapping on a field, select the Modify button under the Friendly Mapping column. Enter in a raw database value and the friendly value that should be replaced.