Installation

STEP 1 - START ORDER

In order for the resource to start correctly and not receive any errors, we must start the resources in the following order. Make sure that ice_mysql is started on top of any scripts that make use of ice_mysql's functions.

server.cfg

ensure ice_mysql
...
ensure ice_core
ensure ice_hud
ensure ice_gym
ensure ice_trophies

STEP 2 - SETUP CONFIG

In the configuration you only have to enter the licenses of the developers who are going to use the debug UI.

File Location: ice_mysql\config.js

config.js

Config = {}
Config.LicensesDebug = [ // All player licenses that will have acces to debug ui
    "license:1234567890123456789012345678901234567890",
    "license:0987654321098765432109876543210987654321",
]

STEP 3 - SETUP CFG

You can specify several databases to be able to query the desired database simply with the identifier. The minimum number of databases to specify is one. The number that accompanies "mysqlCredentials_" is the identifier of the database and has to go in ascending order, for example: mysqlCredentials_1, mysqlCredentials_2, mysqlCredentials_3, mysqlCredentials_4. If not specified in this order the script will not find any database.

You must edit the text on the right, the text on the left should not change.

server.cfg

set mysqlCredentials_1 "host=127.0.0.1; user=root; password=; dbName=ice_server; port=3306"
set mysqlCredentials_2 "host=127.0.0.1; user=root; password=; dbName=ice_server_2; port=3306"