Minequest

Minequest

32.5k Downloads

SQL database handling

robxu9 opened this issue ยท 6 comments

commented

Handle storage of players in an SQL database (sqlite or mysql, both queries should be the same)

commented

Made easier with 2f4ce11 - one SQL query per file, please.

commented

SQL Functions should be implemented ASAP:

in src/main/resources/sql, the following should be implemented (probably):

-- table: mq_players (folder: player)

add new player (automatically given player ID)
update player level
update player exp
update player class
update player abilities

-- in "setup" folder

setup_player_table.sql to setup player tables
migration_0.sql to setup SQL migration from version 0

blocks #9 until finished.

commented

Yeah that's what I'm working on today

commented

What should the location be when using Sqlite?

commented

Should be getDataFolder()/minequest.db...

commented

We're done with this.