MySQL Module Installation

The Mysql module stores reports in tables on a MySQL server. This open up many ways to use the report data from external sources like the web scripts. For example, the windows client uses the web scripts to retrieve calls.

Installation

1. Put the calladmin_mysql.smx file into your .../addons/sourcemod/plugins directory
2. Open .../addons/sourcemod/configs/databases.cfg and add a new entry with the key CallAdmin (You can change this later on)
3. Load the plugin or change the map, the plugin will create a file named plugin.calladmin_mysql.cfg in your .../cfg/sourcemod folder
4. Edit the config to your purposes (see the Server keys article for how to set up server keys)
5. Reload the module if you changed the table name.
6. Setup the Webscript-Installation
7. You're done

Requirements

• The base CallAdmin plugin
• The CallAdmin webscript

Additional information

Here's an example of how the entry in the databases.cfg should look like

"CallAdmin"
{
    "driver"            "mysql"
    "host"              "yourhost.com"
    "database"          "CallAdmin"
    "user"              "YourUser"
    "pass"              "YourPassword"
}

The Name is case sensitive. If the CallAdmin entry is missing the default entry is used.