[1.8-1.17] Harmony MySQL | In-Game MySQL GUI | Database Mana

mysql:
username: "user"
password: "pass"
host: "127.0.0.1"
port: 3306

security:
password: false
console: false
passphrase: "1234"

prefix: "&f[&bHarmony&f]"

messages:
admin:
  console_execute: "&fSorry, but this command can only be run by a &bPlayer&f."
  console_code: "&b%player%&f's code is &l&b%code%"
  config_reloaded: "&fConfig reloaded successfully."
  custom_query: "&fType in your &bcommand&f in chat."
  create_database: "&fEnter the name of the &bdatabase&f in chat."
  create_table: "&fEnter the name of the &btable&f in chat."
  create_column: "&fEnter the name of the &bcolumn&f in chat."
  first_column: "&fIn order to create the table, you'll need to create a &bcolumn&f."
  column_size: "&fEnter the &bsize&f of your column."
  enter_condition: "&fQuery: \n\n&b%query%&f\n\n Enter your new condition in chat(or type &bnone&f to cancel)."
player:
  no_access: "&fSorry, but this command requires the &bharmonysql.admin&f permission."
  no_password: "&fYou must type in the &bpassphrase&f to proceed. (/harmonysql password)"
  invalid_password: "&fSorry, but the passphrase you entered is &binvalid&f."
  code_sent: "&fYou need to enter the confirmation code sent to the &bConsole&f."

/harmonysql
/hsql
/harsql

harmonysql.admin - allows access to the GUI
harmonysql.reload - allows reloading the config with /hsql reload

In order to use the API you need to enable API access in the HarmonySQL config.

api_access: true

If you want to create an instance of the API when your plugin loads, make sure to set HarmonySQL as a dependency.

depend: [HarmonySQL]

The API will connect you to the same MySQL server as the credentials in the HamonySQL config.

Example:

public void onEnable() {
        HarmonyAPI api = new HarmonyAPI(Bukkit.getServer().getPluginManager().getPlugin("HarmonySQL"));
        try {
            api.setDatabase("DATABASE");
        }
        catch (HarmonySQLException e) {
            e.printStackTrace(); //gets thrown if api access is disabled
        }
        JSONArray rows = api.executeQuery("SHOW TABLES");
        for (int i=0;i<rows.size();i++) {
            JSONObject row = (JSONObject) rows.get(i);
            row.get("COLUMN");
        }
        api.executeSetQuery("CREATE TABLE..."); //executes query that doesn't return anything
    }