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 :)
Comments
-
_ForgeUser7265008 Owner
-
_ForgeUser7441906 Former Author
-
View User Profile
-
Send Message
Posted Oct 10, 2013@TakeruDavis
May be related to: http://dev.bukkit.org/bukkit-plugins/inventorysql/tickets/41-cant-synchornizating-inventory/
Basically this is commonly related to Bungeecord switching the Server too fast for MySQL to read changes, but i added a command, that *should* allow switching by switching the player AFTER everything has been changed,
-
View User Profile
-
Send Message
Posted Oct 9, 2013I noticed there are several useful update events (quit, changeworld, respawn, bedenter, bedleave, death)
I am running two servers bound by BungeeCord and I am trying to get inventories on both sides synchronised, but neither "quit" nor "changeworld" seem to properly synchronise them. It only works sometimes.
Its possible that joining the server happens too soon (in which case its probably not a fault of this plugin).
But could you still take a look at it?
-
View User Profile
-
Send Message
Posted Sep 29, 2013@killtuki
You have already an Issue do NOT ask in comments too.
@fearless2555
The BukkitSerializer depends on native Bukkit implementation and as such should be able to save anything, but i am not sure just test it out.
-
View User Profile
-
Send Message
Posted Sep 28, 2013dyed item makes error and can not save this
-
View User Profile
-
Send Message
Posted Sep 28, 2013Nice plugin, it would be really useful for servers that have multiple sub-servers.
Does it support custom item lore?
-
View User Profile
-
Send Message
Posted Sep 24, 2013@Dev_Codec
Uhm, nbt tags yes i guess it would be possible to investigate further into this. I love FTB.
@Nosxxx
i didn't work on any importer yet
-
View User Profile
-
Send Message
Posted Sep 22, 2013Any way you could add support to store nbt tags? Want to use this on a FTB server with bungee, however it always losses information on items, like charge level or installed modules on power armor.
-
View User Profile
-
Send Message
Posted Sep 18, 2013@wiedzmin137
i honestly hate to answer Problems within the comments, but you need to get a correct error. This error misses some more important informations. Please check login credentials.
-
View User Profile
-
Send Message
Posted Sep 17, 2013Hello. I newbie on this plugin and I have problems with installing it. http://pastebin.com/hFmKBcTz . I used jdbc:mysql://localhost:3306/marek?user=marek&password=xxx but it don't works. What mistake I did?
This plugin may be incompatibile with CombatLog.
-
View User Profile
-
Send Message
Posted Sep 11, 2013@yunho3
Should be fixed with 3.2 and new Bukkit Serializer, but i am not sure
-
View User Profile
-
Send Message
Posted Sep 10, 2013Want to support utf-8 names, such as the language used in other countries, have been tested for playername does not support mysql utf-8 character
-
View User Profile
-
Send Message
Posted Sep 10, 2013@allradio
Updating 2.X would have been quiete a lot work. I use Maven to produce any plugin, Areku didn't. His Version was absolutely great, but i could not work with his code. I didn't liked his code, nor did i want to use Apache License, so yeah. Still i don't see any reasons InvSQL should offer direct edits, i mean of course its possible, but its not database-friendly at all.
-
View User Profile
-
Send Message
Posted Sep 10, 2013@manfie
Hey, thanks for reply ;) i just want to operate php script to add items in player "sql inventory" which adds items on player in-game inventory :)
-
View User Profile
-
Send Message
Posted Sep 9, 2013@manfie Thanks for the answer, but in my opinion plugin is usefull without DB queue. Why did you fully rewrote this plugin, not just update it to the latest version?
-
View User Profile
-
Send Message
Posted Sep 9, 2013@dehood
Modifying a Block by editing the Inventory is not intended, because it will not be safe in any case. I will add tables that are designed for this operation.
@allradio
Sorry i'm not kidding at all. I am a volunteer and i use my free time to maintain a plugin i publish under a open source license. Give you an answer to your question: data is a gzip compressed json array (by using the current defaults). Effectively saved by using one querry and as i already sayed it's not supposed to be changed and i never promised it's intended to do. For further questions just read the page above!
-
View User Profile
-
Send Message
Posted Sep 9, 2013I really like this plugin! But i just want to ask you, why all data saving in blob? I want to make some php scripts which can send some blocks or items in player inventory :) thanks! btw nice plugin! keep it up!
-
View User Profile
-
Send Message
Posted Sep 8, 2013Where's all functionality??? Why data in blob??? Where's queue in DB??? Are you kidding? How should I give some blocks throught the web? What sense of this plugin now?
-
View User Profile
-
Send Message
Posted Sep 5, 2013Version 3.1 is now uploaded. i added a new switch command, which should prevent the current /server exploit
so far so good
-
View User Profile
-
Send Message
Posted Sep 5, 2013@anime5167
Im totally aware of this issue: #41
@Nithlus
Well, actually implementing a save for single items would be a good performence-killer, but i'm gonna add a temporary fix soon, to allow teleporting with InvSQL AFTER anything has been saved. Just need to think about thread safety and gonna release 1.1 with some minor fixes (ender chests maybe, too)
@rocky123xo
InventorySQL is currently not designed to be a logging tool. I think this is a Request for LogBlock etc..
-
View User Profile
-
Send Message
Posted Sep 4, 2013I like the look of this a lot. Is there a way to save copies of everyone's inventories periodically? Such as, if a player has 4 diamond pickaxes in his inventory, and dies, can this plugin save his inventory on death to SQL, so that I can roll it back for him later? That would be amazing! Thank you!