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

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

MySQL Graphical Interface for Spigot

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
}

View on SpigotMC

Resource Information

Author:

----------

Total Downloads: 125

First Release: Jan 27, 2021

Last Update: Jan 28, 2021

Category: ---------------

All-Time Rating:

1 ratings

Version -----

Released: --------------------

Downloads: ------

Version Rating:

----------------------

-- ratings