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 :)
Hmm, theres a little AuthMe Issue. If you login in Authme with /login <pw> and look at your database with inventorysql you will see that it saves your inventory and it is empty. Only the armor is registered alle other Items are away and not stored in the database
After the next tick of inventorysql the data is stored again, but this time beetwen you have no items in the database :). Maybe you could fix it with a little delay beetwen login and saving I don't know :D
Edit:
Found also a bug on your webscript. I know php, but I don't get it work that CD's are given out. if you have a CD in your inventory and you give it out on the web it shows:
instead of:
or something. In the database it is stored, the problem must be here:
after this code the the record's id is 0 :p
Can you add command for reload config ? ...
Thanks ! I'll go to test this :D
[EDIT] Work fine, thanks a lot ! [/EDIT]
@LtSich
I was too fast ;) download the v0.6.9, it goes up to 8 digits
go to 5, industrialcraft have item like 30 000....
Thanks ! :)
Sich
@LtSich
Yes, it's because the regex isn't configured to handle id's with 4 digits. Wait a minute..
Hello,
Can you add support for big id item ? Like the oilbucket in buildcraft, the ID is : 4063:0
The inventory raw is ok : [0(4063:0)x2]
But if I try to add or remove the pending is just cleared.... Nothing change in the inventory... Pending : [+(4063:0)x1]
Any idea to change this ?
Thanks !
Sich
Again web overview :)?
Hi,
on startup I get this error, but it seems to be working normal. Table was created and filled with my Items.
<<code>>
2012-03-26 06:26:49 [INFO] [InventorySQL] Loading InventorySQL v0.6.7
2012-03-26 06:26:52 [INFO] [InventorySQL] Enabling InventorySQL v0.6.7
2012-03-26 06:26:52 [INFO] [InventorySQL] ThisIsAreku present INVENTORYSQL, v0.6.7
2012-03-26 06:26:52 [INFO] [InventorySQL] = http://alexoft.x10.mx/ =
2012-03-26 06:26:52 [INFO] [InventorySQL] Enabling...
2012-03-26 06:26:52 [INFO] [InventorySQL] MySQL connection successful
2012-03-26 06:26:52 [INFO] [InventorySQL] Starting Metrics
2012-03-26 06:26:52 [INFO] [InventorySQL] Enabled !
2012-03-26 06:26:53 [SEVERE] [InventorySQL] ---------------------------------------
2012-03-26 06:26:53 [SEVERE] [InventorySQL] --- an unexpected error has occured ---
2012-03-26 06:26:53 [SEVERE] [InventorySQL] -- please send line below to the dev --
2012-03-26 06:26:53 [SEVERE] [InventorySQL] InventorySQL version 0.6.7
2012-03-26 06:26:53 [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.2.3-R0.2-90-ga9ae139-b2120jnks (MC: 1.2.4)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] Message: UpdateChecker run()
2012-03-26 06:26:53 [SEVERE] [InventorySQL] javax.net.ssl.SSLException java.lang.RuntimeException Unexpected error: java.security.InvalidAlgorithmParameterException the trustAnchors parameter must be non-empty : java.lang.RuntimeException Unexpected error: java.security.InvalidAlgorithmParameterException the trustAnchors parameter must be non-empty
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.security.ssl.Alerts.getSSLException(Alerts.java:208)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1869)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1827)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1810)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1329)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1306)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:523)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1296)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:254)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] java.net.URL.openStream(URL.java:1035)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] alexoft.InventorySQL.UpdateChecker.run(UpdateChecker.java:29)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] java.lang.Thread.run(Thread.java:722)
2012-03-26 06:26:53 [SEVERE] [InventorySQL] ---------------------------------------
<</code>>
Looking at this I can see the massive benefit that it can have for a larger server but I am curious is there a tool that can be used to export the data from the mysql database to the decault Minecraft format? With out that a server would have to wait on this plugin before they could update to a new version as player inventory's would be broken -_-
Thx
Thanks for your answer, I'm waiting for the support ;)
Plugins like LimitedCreative or the old CreativeBurningSuite are storing 2 inventories per Player. Don't know, how this will work with your plugin, but you can take a look: http://dev.bukkit.org/server-mods/limited-creative/
@Jobsti2
well, this plugin is mainly designed to work with survival gamemode. in creative, your inventory is just hid, replaced by the list of items, but it still here. I don't know the plugin you've mentionned, but I'll inquire about it. Otherwise, I'll maybe make the performing of database updates only if the player is in survival mode.
But the plugin will support per-world/gamemode inventories soon
Works this with different inventories for the 2 gamemodes? Because LimitedCreative provides 2 inventories, each for every gamemode.
Is there possobility to convert from flatfile to mysql? :/
@DaleMartinWatson
Added ! For translation, edit the config file
@ThisIsAreku I want to add "/invUpd" (do like "/invSQL check") and allow it for all users, not only ops. Also I want translate in-game messages into russian.
@DaleMartinWatson
what kind of changes would you like ? I've planned an update tomorow, i can add it.
@ThisIsAreku Sorry:) I am noob. I am edit inventory without "pendings". This project is OpenSource? Can i grab sources anywear? I want to change "/invSQL check" to some ease for remember and shortly to typing. And translate to my language.
@DaleMartinWatson
You're problably doing it the wrong way. how are you modifying it ?
Why I can not modify iventory from web site? Read only?