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 Sep 7, 2012Cheers for the update works great, now to start playing with php to make a viewer/editor
-
View User Profile
-
Send Message
Posted Sep 7, 2012-
View User Profile
-
Send Message
Posted Sep 7, 2012@pugsx
in v2.3 I added permissions :) Let me know if this fix your problem
-
View User Profile
-
Send Message
Posted Sep 7, 2012Hi, Im getting a message saying I cannot use this command, Im using permissionex plugin but I cant see any mentions of permissions on this plugin.
Cheers PugsX
-
View User Profile
-
Send Message
Posted Sep 5, 2012@digitalfiz
id are standart strings (maximum 36 characters) I use GUID because it's easy to generate in java. but you can use anything, "bukkit", "toto", "azerty", .. But it must be unique
-
View User Profile
-
Send Message
Posted Sep 5, 2012@fede1608
data and damage are sometime the same (although I don't understand clearly) but are different number type in code. data are byte (max 255) and damage are int (max 2.147.483.647). Sometime they are equals, sometime not.. I really don't know. The plugin takes these values directly from the bukkit API
-
View User Profile
-
Send Message
Posted Sep 4, 2012@ThisIsAreku
I am having trouble wrapping my head around this system and I insert an item into pending and I am trying to add enchantments to them but i am having trouble understanding the ids. Are they just standard guids or is it an id that comes from minecraft?
Do you hang out on irc or a messenger?
-
View User Profile
-
Send Message
Posted Sep 4, 2012@ThisIsAreku
Awesome that worked!
-
View User Profile
-
Send Message
Posted Sep 4, 2012Thanks for the answer! I have another question, is it on purpose that data and damage fields are connected no matter what item is (and so having different meanings) or is it the game who uses the same variables to specify the data and the damage of an item? Is there any way the plugin can fix this? BTW the plugin is great! It really helps a lot in my server!
-
View User Profile
-
Send Message
Posted Sep 4, 2012this message is come after i shutdown the server.
-
View User Profile
-
Send Message
Posted Sep 4, 2012@BioBG
Check your MySQL server .seems that it drops the connection
-
View User Profile
-
Send Message
Posted Sep 4, 2012http://pastie.org/4661230
bukkit 1.3.2R0.1
invsql 2.2.2
-
View User Profile
-
Send Message
Posted Sep 3, 2012@digitalfiz
You have to insert values in the pending table, not in the inventories table.
@fede1608
Yes, simply add a row in the enchantments table with the same id as the inserted item in pendings table
-
View User Profile
-
Send Message
Posted Sep 3, 2012Is there any way to add an item with an enchantment included?
-
View User Profile
-
Send Message
Posted Sep 3, 2012I updated to the latest version and the errors are gone but if I change someones inventory in mysql it doesn't reflect in minecraft even after a sync. It just says no changes. Also when it syncs it overwrites the mysql values. Am I doing something wrong?
-
View User Profile
-
Send Message
Posted Sep 3, 2012I'll be happy as you do documentation of this plugin or You'll make a sample script.
-
View User Profile
-
Send Message
Posted Sep 2, 2012@ThisIsAreku
Indeed it is :)
-
View User Profile
-
Send Message
Posted Sep 1, 2012@rfsantos1996
If you have errors in console, it won't work. I've tested with my mysql server, which is open to my local subnet
-
View User Profile
-
Send Message
Posted Sep 1, 2012@rfsantos1996
Hm... I thinked about that. Just server statistics how much mined each player. It will enough :) 848x64 = 54272
848 x 64
-3392 + 50880- 54272-
View User Profile
-
Send Message
Posted Sep 1, 2012@ThisIsAreku
How long is the sync? I tried for 3-4 minutes and nothing, i think my MySQL dont allow other people connect ):