InventorySQL
![]() ![]() |
|
|---|
I n v e n t o r y S Q L
I n v e n t o r y S Q L
Player inventory saved into a Database
Features
Copy users' inventory in a configurable database, allowing it to be displayed on a website and use it for Server-to-Server Inventories
InventorySQL is designed to be as customizable as possible and Server Owners and Developers can choose how they'd like to save their data. Future versions will feature an automatic conversion tool.
Disclaimer
Metrics
This plugin utilises Hidendra's plugin metrics system, which means that the following information is collected and sent to mcstats.org:
- A unique identifier
- The server's version of Java
- Whether the server is in offline or online mode
- The plugin's version
- The server's version
- The OS version/name and architecture
- The core count for the CPU
- The number of players online
- The Metrics version Opting out of this service can be done by editing plugins/Plugin Metrics/config.yml and changing opt-out to true or turning enable-metrics to false in InventorySQLs Configuration.
Autoupdater
This Plugin uses Updater. It will automatically search for Updates. If you'd like to disable this feature you can turn it off in the Configuration by setting auto-update to false.
For Serverowners
- Addons
- Installation
- Configuration
- Localisation
- Frequently Asked Questions (FAQ)
- For Developers (API)
- Special Thanks
Permissions
InventorySQL.*: description: legacy-styled Permission for anything children: InventorySQL.reload: true InventorySQL.save.*: true InventorySQL.reload: description: Allows you to reload Language or Configuration default: op InventorySQL.save.*: description: legacy-styled Permission for anything related to saving children: InventorySQL.save.other: true InventorySQL.save.self: true InventorySQL.save.other: description: Allows you to save other players default: op InventorySQL.save.self: description: Allows you to save yourself default: true
InventorySQL.switch.self -> switching for yourself (No default yet) InventorySQL.switch.other -> switching for others (No default yet)
Commands
<Optional> [Required]
- /invSQL reload config : reloads config
- /invSQL reload language : reloads language file
- /invSQL save <player> : saves yourself or the given player
- /switch [server] <player> : moves yourself or the given player to the given Server
Links
License
Version 3.0 is now under the zlib/libpng License, Versions before 3.0 are still licensed under Apache License 2.0
Contact
You can find me in IRC: #invsql on irc.esper.net Please do not ask me for any Messenger just because you would like to be in my list.
If you like InventorySQL, please consider donating to the project via paypal, using the link on the top-right of the BukkitDev page :)



-
View User Profile
-
Send Message
Posted Jan 28, 2014Just tested this again, transferring inventories across bungee servers don't seem to work.
I can do /server alpha - with a goldblock in my inventory while on "server beta" and it will not have the goldblock on server alpha.
Is there a way to have better bungee/cross-server support?
I also see this error on latest.
http://pastie.org/private/r6yrjd9apqozrrekrljna
-
View User Profile
-
Send Message
Posted Jan 28, 2014@Mike2033
The new Serializer should work fine now. I added a check against null ( == Air)
@Gliby
I'll add some examples for the SimpleSerializer soon.
-
View User Profile
-
Send Message
Posted Jan 27, 2014@Mike2033
I'll fix that later!
@Gliby
Just reverse the Process of your configuration. InventorySQL offers no fixed data-format.
-
View User Profile
-
Send Message
Posted Jan 27, 2014Hi, I cannot find the documentation on the Data-Format for InventorySQL 3.
-
View User Profile
-
Send Message
Posted Jan 26, 2014@manfie
Interesting, saves the username but not the inventory
http://pastebin.com/3SCuByNU
-
View User Profile
-
Send Message
Posted Jan 26, 2014@Mike2033
The snapshot offers a way: SimpleSerializer
It's still very basic, so yeah.
-
View User Profile
-
Send Message
Posted Jan 25, 2014@manfie
We all know what causes it, but I would really appreciate an fix since I want to use JSON
http://pastebin.com/Gjqni7ef
-
View User Profile
-
Send Message
Posted Jan 24, 2014@SupaHam
Maybe i'll add async in future updates, but this will only lag if player are excessively changing/saving. Databases such as MySQL are designed to add a bunch of queries anyway.
-
View User Profile
-
Send Message
Posted Jan 23, 2014@manfile Do you plan to do async queries, I feel it'll be very laggy if a server with thousands of players had this plugin.
-
View User Profile
-
Send Message
Posted Jan 16, 2014I get an error that disables your plugin :(
Error: http://pastebin.com/MxGUt5DU
Full Log: http://pastebin.com/ytas8Ss2
please Help me :) I love this plugin but i can't use because of this error it disables itself
PS: I am on a LINUX system if that makes a difference :)
Ubuntu
5GB - RAM
Quad Core - CPU
Need more details contact me.
EDIT:
Fixed by changing Serializer from tk.manf.InventorySQL.datahandling.serializer.JSONSerializer to tk.manf.InventorySQL.datahandling.serializer.BukkitSerializer
-
View User Profile
-
Send Message
Posted Jan 9, 2014@jonas159753
Oh, that looks like an error in the new Serializer. I'll take a look later.
-
View User Profile
-
Send Message
Posted Jan 7, 2014what is this error? http://pastebin.com/FEvaKvTk
-
View User Profile
-
Send Message
Posted Jan 2, 2014@TakoMT
No problem ;)
-
View User Profile
-
Send Message
Posted Jan 2, 2014@manfie
Oh holy crap... a thousand apologies manfie :'(... I thought I had to download the source code and change the serializer myself...
Just went through the config and noticed exactly what you meant. Updated and it's working.
Thanks and sorry for the confusion from my end.
-
View User Profile
-
Send Message
Posted Jan 2, 2014@TakoMT
Basically you could CONFIGURE InventorySQL a correct Serializer. It is NOT the plugins fault.
-
View User Profile
-
Send Message
Posted Jan 1, 2014Ok I'm confused.... v3.3 starts up fine except when an item is enchanted... if that is the case then it doesnt save to the database and returns errors. This means I need the 1.7.2 version.
If I use the v3.4 which is for 1.7.2, it doesn't startup and it gives me the 'java.lang.ClassNotFoundException: tk.manf.InventorySQL.datahandling.serializer.JSONSerializer' error like Bouger. You mentioned that the Serializer you are using has been removed, but your plugin is calling that serializer no?
I tried again using the very latest version of Spigot (3 days old), but alas I still face the issue.
What can I do please?
-
View User Profile
-
Send Message
Posted Dec 28, 2013@Bouger
Infact there HAS BEEN a warning on each server start since some versions and using this Serializer has been discouraged anyway.
-
View User Profile
-
Send Message
Posted Dec 28, 2013@manfie
Thank you. Apparently many inventories have been deleted when I put this plugin, it will be?
-
View User Profile
-
Send Message
Posted Dec 28, 2013@Bouger
The Serializer you are using has been removed.
-
View User Profile
-
Send Message
Posted Dec 28, 2013I have this crash :/ : http://pastebin.com/FHrue4b9 The mysqld database is well established.