SQL Permissions plugin

Plugin category: Admin Tools

Minecraft version: 1.9/1.10

Suggested name: PermissionSQL

What I want: I would like a permissions plugin that saves the users on a SQL database and saves the permissions locally on a yml file.

Ideas for commands:
/psql group add [group]
/psql group [group] perms [permission 1] [permission 2] [permission 3]
/psql group [group] set prefix [prefix]
/psql group [group] set suffix [suffix]
/psql player [player] add [group] Moves player to group
/psql player [player] remove [group] Removes player from group
/psql player [player] perms [permission 1] [permission 2] [permission 3] Gives player permissions
/psql player [player] set prefix [prefix]
/psql player [player] set suffix [suffix]
/psql db check Checks if the database is online
/psql db columns Lists the columns

Ideas for permissions:
psql.group.add
psql.group.perms
psql.group.set.suffix
psql.group.set.prefix
psql.player.add
psql.player.remove
psql.player.perms
psql.player.set.suffix
psql.player.set.prefix
psql.db.check
psql.db.columns

Idea for config:

Code:

#config.yml
#user database
userdb:
      #sql or yaml
      type: sql
      #only for sql:
      database:
            ip: 192.168.1.0:9351
            username: admin
            password: iluvsql
            columns:
                  #player column, stores uuid of player
                  playercolumn: players
                  #rank column, ranks seperated by semicolons
                  rankcolumn: playerranks
#permissions database (where the permissions for groups are stored)
permissiondb:
      #obviously local
      filename: permissions.yml

This will be way better than PEX! This may be a couple days worth of work, but it will help thousands of Minecraft server network owners save their permissions. Maybe a major server like CubeCraft or Mineplex will use it!

Database example (playercolumn = players, rankcolumn = ranks, ABUSNA1996 = op, DAD_1996 = default, cutoffpie = donator):



When I'd like it by: As soon as possible

I hope that this isn't too big. Is there already a plugin like the one I requested?

Wait... oops not SQL, MYSQL... oh well xD

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Because I want to keep the permissions per group locally, because different gamemodes require different permissions (for example, I would need factions permissions for factions and survival permissions for survival).

The reason I cannot use PEX is because the backend stores both the permissions and ranks in the same file, not separately, so it would only be useful if my server only had one gamemode.

Maybe since I am a java developer I will try to make it myself, it will only take a couple days research on how to connect to a database through java. Connecting to a database in PHP was hard enough !

 

@MCFunCubes PEX has "per-world-permissions"

 

No, my server will be multi-server (with bungeecord)!