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

MySQL Graphical Interface for Spigot

  1. HarmonyPlugins
    Native Minecraft Version:
    Legacy (< 1.13)
    Tested Minecraft Versions:
    • 1.8
    • 1.9
    • 1.10
    • 1.11
    • 1.12
    • 1.13
    • 1.14
    • 1.15
    • 1.16
    • 1.17
    Source Code:
    https://github.com/HarmonyPlugins/HarmonySQL
    [​IMG]
    Description

    Harmony SQL is a Graphical User Interface for MySQL inside of Minecraft. It allows server admins to Create / Remove Databases, Create / Remove tables, Add/Remove/Alter Columns and Select Rows all while in game.

    [​IMG]

    Configuration

    config.yml is responsible for entering the MySQL server credentials as well as the security method for gaining access.

    Code (YAML):
    mysql:
    username
    : "user"
    password
    : "pass"
    host
    : "127.0.0.1"
    port
    : 3306

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

    language.yml is reponsible for all the messages in the plugin alongside the prefix.

    Code (YAML):
    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."

    Commands & Permissions

    HarmonySQL has one command with two aliases:
    Code (Text):
    /harmonysql
    /hsql
    /harsql

    HarmonySQL has two permissions:
    Code (Text):
    harmonysql.admin - allows access to the GUI
    harmonysql.reload - allows reloading the config with /hsql reload

    API

    HarmonySQL has a developer API for executing queries inside of databases.
    In order to use the API you need to enable API access in the HarmonySQL config.
    Code (YAML):
    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.
    Code (YAML):
    depend: [HarmonySQL]
    The API will connect you to the same MySQL server as the credentials in the HamonySQL config.

    Example:
    Code (Java):
        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
        }




Recent Updates

  1. Added Developer API

Recent Reviews

  1. Emelji
    Emelji
    5/5,
    Version: 1.8
    oh my god its sooo good no bugs at all! please make more plugins, ALLLAH HU AKBAR