Player bags, carried anywhere [MySQL] 1.0.1

Contributors:

N/A

This plugin allows players to carry an extra bag, there's set permissions for each command and a config file to customize it more.

You're gonna need the provided below SQL table:

Spoiler: Table

Code (MySQL):

CREATE TABLE `invs` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UUID` longtext,
  `content` longtext,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 

You're also gonna need the following MySQL API I made for this: (Place the jar file in your plugins folder otherwise this plugin won't start)
https://www.spigotmc.org/resources/mysql-api.16454/

Config file:

Spoiler: Config file

Code (YAML):

# database information #
host: 'localhost'
user: 'root'
pass: 'dbpass'
db: 'database'

# Backpack size, must be multiply of 9 #
bag-size: 27

# True - drops bag items when player dies, false - Player keeps the items #
death-drop: false

# Auto save of all player bags in minutes #
# Setting it to anything lower or equal to zero will only save when the player quits the server #
auto-save: 10
 

Picture from the game:


Commands:
/bag
/savebags
/viewbag


Permissions:
- bag.open: Allow players to view their own backpacks
- bag.saveall: Default OP, lets the player save all player bags
- bag.viewbag: Default OP, lets the player view someone's bag