InventorySQL
German developer |
---|
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 :)
@ThisIsAreku
I guess when i get time i could try and make a for loop to seach the data.
@Schlumpf9
Yes, I've made some bad things with debug code.. I'll upload a fix in 2-3h EDIT: fixed in version 0.5.2
Hello, i always get this:
@cky2250
What kind of changes would you like ? I don't have much time for developing this plugin, so I'll probably do not change the format. but take a look at the Data format and the php front-end example. And I you have an idea for a new way to store data, just open a ticket, describe it and I'll make it (maybe ;) )
could you change the way the mysql is stored so it is easyer to work with. http://forums.bukkit.org/threads/web-webstatistic-for-minecraft-v1-4-5-mrplows-any-build.60843/
@ThisIsAreku
I mean it should keep a players inventory history, and if something happens you can restore it to an earlier time. Kinda like rollback, but with their inventory.
@Schlumpf9
Okay :) the link is on the bottom of the description :) (I'll post it as a file later)
@ThisIsAreku Could you please add your php example also here on Bukkit? I think it would bring much players something :)
Would be nice if you could add your webscript here :p
@LtSich
The command do all the things, updating the inventory table and processing the pendings table. And for the result I'll add it in the next release :)
Hello,
Interesting this plugin :)
Did the command invsql check player also check the pending table ? And can you add some output when we use this command.... Because we don't know if it was successfull or not.
Thanks :)
@Kdehner
It do not replace the current inventory system, but it export the inventory on a talbe in mysql and you can modify it (by adding/removing items)
Is this used for backups? or does it replace the curent inventory system? I will be keeping an eye on this project as it looks pretty promising.
@ThisIsAreku Hi,
Is there anything could I do to help you?
Thanks
Hi, sounds good. But the problem is not with mass players, it also happened at my Server with just 2 Players :D
But this happens only after some time. And my max mysql connection I had set to 200 th
Let's hope its fixed :)
@Schlumpf9
@gothroach
Sorry, I can't test it in a big server with plenty of players.. But I have rewrited the database class from scratch and I think it will work. I'll upload it in 10min
@deregudegu
I'm working on it, enchanted items would be for v 0.6 ;)
@hamstain
No, I think not..
Same... I wondered but if you say it 2, then hmm. It spams in my log file: Mysql Connection error: To many connection reached or something, can't give it again, deleted my log :p
But theres a big bug/proglem!
@tomori_peti
Same here, I was astonished with how many concurrent connections InventorySQL is making. It very quickly hits its (quite generous) concurrent connection limit on my MySQL server and then just spams SQL errors.
EDIT: I'll go through the source later today to see if it's a quick fix.
This plugin killed a MySql server. The plugin connect to the server with more then 500 channels!!! xD
Does this work with the MultiInv plugin?
Hi, This plugin suport enchantment itens? Thanks