Any good plugins for saving inventories to MySQL?

Basically im looking for a good plugin that will save inventories to MySQL.

My issue is all the plugins i found were inactive/broke I would really love some feedback if you know one that works and will hopefully work with 1.0.0 (Eventually). I really need something like this for a upcoming project and i would definitely appreciate this.

Thanks for your help!

 

Hello

 

I don't think you'll find mySQL support in any of the inventory plugins out there.

Put in a plugin request with a good use case, maybe a programmer will bite.

 

Exactly why do you want to use databases to store potentially rapidly-changing data in the first place (fast use of tools in particular), when there is already a dedicated player storage system in place? It seems that this would involve quite a bit of processing overhead especially if you have a large player base.

 

It was made once, but went unloved and became inactive. Saving it to MySQL every 5mn but keeping it saved into the world incase of a crash is my idea to solve that rapidly changing.

Also i needed it for cross-server playing haha

 

If you have all of the servers running on the same computer, you may want to consider some other alternatives, such as hard links or symbolic links for your server directories to point to the directory storing your player data, if it's running on Windows or some variant of Unix or Linux-based distribution. This should be safe as long as your users don't try to log in to more than one of your servers at the same time.

 

If a single file were to be shared:

On windows this will likely end in IO exceptions, windows by default will not allow 2 or more processes to access a file in write mode at the same time, that an exclusive lock is created. There are ways around this using SAC or byte-range locking but the server code would have to support this and i don't think it does.

On most *nix platforms files are not automatically elusively locked to a process by default. You wouldn't get an IO exception but rather just end up corrupting your file, again unless you implemented byte-range locking in the server code or are lucky enough that the file format is segmented in such a way that there is no danger of multiple processes butting heads.

If the files are unique at the user level:

Ensuring a user isn't logged into multiple servers wouldn't be enough. You'd have to ensure that the server has flushed(fsync'd) and closed the user's file handles before allowing the other server to open. To do this without blocking while waiting on IO you'd need communication between the processes about the current state of the files. That is likely more of a pain in the ass than just storing the data somewhere else, like a DB.