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 :)
@TDB_South_Paw
Look at the Known caveats. There is an information about the manual update.
@manfie
Meaning... what?
Where is there anything about database updates...?
@TDB_South_Paw
You forgot to update your Database aswell.
Hey there,
Firstly, thanks for the awesome plugin. Really helpful with multiple servers!
http://pastie.org/private/ogwnrdmz90xehxkgqmg
Getting console spammed with this error (seems to be regarding playing minhealth), what's causing that and/or where would I go to fix it?
@sync667
Save on join is important? How should anyone be able to sync properly? That is nonsense.
Fast relog, yea the time needed to save is exploited by the players. Yep that's nifty. My code is designed to be modular. It's not very hard to understand it. All is seperated in packages.
Loosing Inventory while switching should be uncommon, because you are only transfered, after saving. Anyway i don't have that much time to test my Plugin, that is true, but that's the reason i did not promote a new Version.
@manfie
I don't know where you test it, but i'm saying you that saves fail! My players found to now about 3 ways to clone items... now it's just fast reloging and saves fail.. i start studing your code, but it's simple say wird for me and i think others.
One more thing, save on join is very important! I add to my auth plugin place where all players on join, are saved by command. Why? because maybe my old player won't lost inv, but many times when i test it out i lost my old inv after switch to other server.
@thernztrom
It's on the ToDO. Just learning for my A levels, so not that much time.
@manfie
Working on supporting the new UUID for MC 1.7.8? :)
@madtomic
Seriously. just test it.
Does it work for cb1.7.2-r0.3?
@phoomin2012
Well before ANY Error Report you should run InventorySQL in debug 1000. Then post your Version etc etc.
Anyway any Error-Report belongs in the Tickets. Thanks!
This way i can help.
I found some bug that it mean can't create table enderchest,This is an error "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE, KEY `fk_enderchest_player_idx` (`playerID`) ) ENGINE=InnoDB DEFAU' at line 10" Please check your mysql code please. I will wait for this debug.
@sync667
Well, i published a new Version with a basic Command Version. Anyway it'll save on PlayerQuitEvent, so it will be saved whenever the player leaves the Server.
manfie when you will replace command method? i'm waiting to fix some bug and add exp shareing :) One bug is with not handling kick or connection break event and player eq is not saved at all, that's my first look at that.
@Devanchya
There will be an API to use the upcoming transfer Pipe yes.
Would it be possible to use this to transfer inventory from chest X to chest Y in a bungee server? I'm trying to figure out how to get items from a "mining world server" to a Build server...
@killerchris25
Don't reload then. It's a security flaw otherwise, but i may add a bypass.
Is there anyway i can disable getting kicked on reload so all my players don't get kicked off the server when i reload it (/Reload)?
@sync667
Well, methodcommand will be removed in the next major Versions. (I'm working on a replacement), so it wont be needed and it's pretty annoying to add lib folders (as it is against maven's recommendations). But i could easily add a Repository replacement tomorrow i guess.
I know how to import it manually... but can you add all depen. jar in lib folder for example? its will be much easier.