MySQL API 2.4

Native Minecraft Version:

Legacy (< 1.13)

Tested Minecraft Versions:

• 1.7
• 1.8
• 1.9
• 1.10
• 1.11
• 1.12
• 1.13

Contributors:

Can be found in the Discord server (https://discord.gg/TTrqRkM)

Languages Supported:

English

Donation Link:

https://www.paypal.me/VagdedesBilling

Permissions:
mysql.admin - Gives your permission to /mysql command.

Commands:
/mysql <reload/rl> - Reloads the config.
/mysql <connect/disconnect/reconnect> - Interacts with the connection.

Config API:
Class: me.vagdedes.basic.Config

Code (Text):

void create() // Creates the config or object if doesn't exist.
void reload() // Reloads the plugin config.
void clear() // Clears the mysql configuration file.

String getHost() // Returns the host.
String getUser() // Returns the user.
String getPassword() // Returns the password.
String getDatabase() // Returns the database.
String getPort() // Returns the port.

void setHost(String s) // Changes the host.
void setUser(String s) // Changes the user
void setPassword(String s) // Changes the password.
void setDatabase(String s) // Changes the database.
void setPort(String s) // Changes the port.
 

Basic API:
Class: me.vagdedes.mysql.MySQL

Code (Text):

void connect() // Connects to the database.
void disconnect() // Disconnects from the database.
void reconnect() // Restarts the connection to the database.
Boolean isConnected() // Checks if the connection exists.
void update(String command) // Excecutes an update to the database.
ResultSet query(String command) // Returns a query from the database.
Connection getConnection() // Returns the mysql current connection.
 

Advanced API:
Class: me.vagdedes.mysql.SQL

Code (Text):

void deleteTable(String table) // Deletes a table from the database.
void truncateTable(String table) // Clears a table in the database.
Integer countRows(String table) // Coureturns retunrs the number of rows in a table.
Boolean tableExists(String table) // Returns if a table exists in the database.
 

Object get(String selected, String column, String logic_gate, String data, String table)
Returns an object variable owned by the selected column.

Code (Text):

Object o = SQL.get("kills", "uuid", "!=", "6t4efghsdq251", "pvp_stats");

void set(String selected, Object object, String column, String logic_gate, String data, String table)
Updates the data of a column with your inserted object.

Code (Text):

SQL.set("cooldown", 5, "name", "=", "Player", "basic_table");

void deleteData(String column, String logic_gate, String data, String table)
Deletes data from a table.

Code (Text):

SQL.deleteData("nickname", "=", "George2009", "ranks");

void insertData(String columns, String values, String table)
Inserts data into a table.

Code (Text):

SQL.insertData("name, kit, cooldown", " 'Sam', 'Fisherman', '29' ", "kitpvp");

Boolean exists(String column, String data, String table)
Checks if a data exists in a certain column.

Code (Text):

Boolean b = SQL.exists("custom_nickname", "&1J&2o&3h&4n", "player_settings");

void createTable(String table, String columns)
Creates a new table if it doesn't already exist.

Code (Text):

SQL.createTable("ranks", "rank INT (11), join_date TIMESTAMP");

If the advanced methods of the SQL class aren't enough for your systems, you can still make your own by using MySQL's class update and query methods.