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 Oct 31, 2012please add support for vault, as most of the permission plugins does not support this permission system :/
-
View User Profile
-
Send Message
Posted Oct 30, 2012I don't get how to use this it's not updating my inventory to the MySQL DB but servers reporting back successful
what permissions do players need so there inventories are uploaded the my MySQL DB so i can run queries and make sure they don't have items they shouldn't
-
View User Profile
-
Send Message
Posted Oct 29, 2012@mosa90
Fixed in v 2.4
@wumpyc
Too many mysql connections :/ I'll try to find a workaround in the next version.
-
View User Profile
-
Send Message
Posted Oct 20, 2012http://pastebin.com/4KPdfmQf
-
View User Profile
-
Send Message
Posted Oct 17, 201208:35:23 [WARNUNG] [Authenticator] The updater encounter an unexpected error 08:35:23 [WARNUNG] [Authenticator] Don't panic ! Your plugin still works, but please report the error :) 08:35:23 [WARNUNG] [Authenticator] The updater will now be disabled 08:35:23 [WARNUNG] [Authenticator] Updater version 1.0 08:35:23 [WARNUNG] [Authenticator] Message: https://raw.github.com/ThisIsAreku/Authenticator/main/src/plugin.yml 08:35:23 [WARNUNG] [Authenticator]
------- 08:35:23 [WARNUNG] [InventorySQL] The updater encounter an unexpected error 08:35:23 [WARNUNG] [InventorySQL] Don't panic ! Your plugin still works, but please report the error :) 08:35:23 [WARNUNG] [InventorySQL] The updater will now be disabled 08:35:23 [WARNUNG] [InventorySQL] Updater version 1.0 08:35:23 [WARNUNG] [InventorySQL] Message: https://raw.github.com/ThisIsAreku/InventorySQL/main/src/plugin.yml 08:35:23 [WARNUNG] [InventorySQL]-------Bukkit 1.3.2 R2.0 since i updated Authenticator from 1.3 to 1.3.1
-
View User Profile
-
Send Message
Posted Oct 14, 2012@wumpyc
http://pastebin.com/
You are welcome
-
View User Profile
-
Send Message
Posted Oct 14, 201214.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.Util.handleNewInstance(Util.java:407) 14.10 11:45:30 [Server] SEVERE [InventorySQL] java.lang.reflect.Constructor.newInstance(Unknown Source) 14.10 11:45:30 [Server] SEVERE [InventorySQL] sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 14.10 11:45:30 [Server] SEVERE [InventorySQL] sun.reflect.GeneratedConstructorAccessor77.newInstance(Unknown Source) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.Util.getInstance(Util.java:382) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.Util.handleNewInstance(Util.java:407) 14.10 11:45:30 [Server] SEVERE [InventorySQL] java.lang.reflect.Constructor.newInstance(Unknown Source) 14.10 11:45:30 [Server] SEVERE [InventorySQL] sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 14.10 11:45:30 [Server] SEVERE [InventorySQL] sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 14.10 11:45:30 [Server] SEVERE [InventorySQL] sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 14.10 11:45:30 [Server] SEVERE [InventorySQL] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections : Too many connections 14.10 11:45:30 [Server] SEVERE [InventorySQL] Error Code: 1040 14.10 11:45:30 [Server] SEVERE [InventorySQL] SQLState: 08004 14.10 11:45:30 [Server] SEVERE [InventorySQL] Message: Cannot get a new connection 14.10 11:45:30 [Server] SEVERE [InventorySQL] Authenticator version 1.3.1 14.10 11:45:30 [Server] SEVERE [InventorySQL] Bukkit version git-Bukkit-1.3.2-R1.0-b2377jnks (MC: 1.3.2) 14.10 11:45:30 [Server] SEVERE [InventorySQL] InventorySQL version 2.3.1 14.10 11:45:30 [Server] SEVERE [InventorySQL]
please send line below to the dev14.10 11:45:30 [Server] SEVERE [InventorySQL]- an unexpected error has occured- 14.10 11:45:30 [Server] SEVERE [InventorySQL]-------14.10 11:45:29 [Server] INFO ... 16 more 14.10 11:45:29 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:339) 14.10 11:45:29 [Server] INFO at java.lang.reflect.Method.invoke(Unknown Source) 14.10 11:45:29 [Server] INFO at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 14.10 11:45:29 [Server] INFO at sun.reflect.GeneratedMethodAccessor498.invoke(Unknown Source) 14.10 11:45:29 [Server] INFO at de.quurks.wishingwell.WWListener.onBlockDrop(WWListener.java:28) 14.10 11:45:29 [Server] INFO Caused by: java.lang.NullPointerException 14.10 11:45:29 [Server] INFO at net.minecraft.server.ThreadServerApplication.run(SourceFile:539) 14.10 11:45:29 [Server] INFO at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:405) 14.10 11:45:29 [Server] INFO at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:473) 14.10 11:45:29 [Server] INFO at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:213) 14.10 11:45:29 [Server] INFO at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:577) 14.10 11:45:29 [Server] INFO at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30) 14.10 11:45:29 [Server] INFO at net.minecraft.server.ServerConnection.b(SourceFile:35) 14.10 11:45:29 [Server] INFO at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109) 14.10 11:45:29 [Server] INFO at net.minecraft.server.NetworkManager.b(NetworkManager.java:282) 14.10 11:45:29 [Server] INFO at net.minecraft.server.Packet14BlockDig.handle(SourceFile:46) 14.10 11:45:29 [Server] INFO at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498) 14.10 11:45:29 [Server] INFO at net.minecraft.server.EntityHuman.bB(EntityHuman.java:389)-
View User Profile
-
Send Message
Posted Oct 12, 2012@ThisIsAreku
What lightweight mode does?
-
View User Profile
-
Send Message
Posted Oct 6, 2012I am doing an overhall on my WebStats web interface. would you care if i just used your code formats to just put into my interface, it will not be your code 100%
-
View User Profile
-
Send Message
Posted Sep 25, 2012@Slaand
yes :)
-
View User Profile
-
Send Message
Posted Sep 24, 2012Then i need to download MySQL for my pc and then it can launch withn't problems,right?
-
View User Profile
-
Send Message
Posted Sep 23, 2012@Slaand
The message is pretty obvious : the plugin can't connect to mysql. Check the config and your mysql server
-
View User Profile
-
Send Message
Posted Sep 22, 2012Hi all! When server loading is done, i have this..
2012-09-22 19:02:38 [SEVERE] [InventorySQL] Cannot connect to mySQL database ! 2012-09-22 19:02:38 [SEVERE] [InventorySQL] Message: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 2012-09-22 19:02:38 [WARNING] [InventorySQL] Check your config and use /invsql reload
And i type this commands and nothing happens, the same error What i should to do? Help me! Thanks :)
-
View User Profile
-
Send Message
Posted Sep 20, 2012I installed this plugin, with Authenticator and AuthMe.
Start it up, set the config file and all and I get severe errors on the authenticator plugin. (When i disable plugin, the errors are gone.)
Am I installing this wrong? I dont really get it.
Errorlog:
http://pastebin.com/F2E7KqfL
-
View User Profile
-
Send Message
Posted Sep 17, 2012but it will share like this: world: world_nether, world_the_end factions: factions_nether, factions_the_end
And this is compatible with inventory protect from xauth?
Thanks in advance, great plugin.
-
View User Profile
-
Send Message
Posted Sep 16, 2012@mig4ng
Yes it does, because both Multiverse and InvSQL save the inventory per-world :)
-
View User Profile
-
Send Message
Posted Sep 15, 2012this works with multiverse inventories?
-
View User Profile
-
Send Message
Posted Sep 12, 201202:36 PM [INFO] [InventorySQL] Enabling InventorySQL v2.3
02:36 PM [INFO] [InventorySQL] ThisIsAreku present INVENTORYSQL, v2.3
02:36 PM [INFO] [InventorySQL] = http://areku.fr/ =
02:36 PM [INFO] [InventorySQL] Loading config...
02:36 PM [SEVERE] [InventorySQL] ---------------------------------------
02:36 PM [SEVERE] [InventorySQL] --- an unexpected error has occured ---
02:36 PM [SEVERE] [InventorySQL] -- please send line below to the dev --
02:36 PM [SEVERE] [InventorySQL] InventorySQL version 2.3
02:36 PM [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.3.1-R1.0-b2320jnks (MC: 1.3.1)
02:36 PM [SEVERE] [InventorySQL] Message: Unable to load config
02:36 PM [SEVERE] [InventorySQL] java.lang.ClassCastException java.util.ArrayList cannot be cast to org.bukkit.configuration.MemorySection : java.util.ArrayList cannot be cast to org.bukkit.configuration.MemorySection
02:36 PM [SEVERE] [InventorySQL] fr.areku.InventorySQL.Config.<init>(Config.java:93)
02:36 PM [SEVERE] [InventorySQL] fr.areku.InventorySQL.InventorySQL.onEnable(InventorySQL.java:96)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:365)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:265)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:247)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.i(MinecraftServer.java:296)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.d(MinecraftServer.java:275)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.a(MinecraftServer.java:225)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.DedicatedServer.init(DedicatedServer.java:140)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.run(MinecraftServer.java:380)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
02:36 PM [SEVERE] [InventorySQL] ---------------------------------------
02:36 PM [INFO] [InventorySQL] Disabling InventorySQL v2.3
02:36 PM [SEVERE] [InventorySQL] ---------------------------------------
02:36 PM [SEVERE] [InventorySQL] --- an unexpected error has occured ---
02:36 PM [SEVERE] [InventorySQL] -- please send line below to the dev --
02:36 PM [SEVERE] [InventorySQL] InventorySQL version 2.3
02:36 PM [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.3.1-R1.0-b2320jnks (MC: 1.3.1)
02:36 PM [SEVERE] [InventorySQL] Message: Error while disabling..
02:36 PM [SEVERE] [InventorySQL] java.lang.NullPointerException : null
02:36 PM [SEVERE] [InventorySQL] fr.areku.InventorySQL.InventorySQL.onDisable(InventorySQL.java:79)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:219)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:391)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:400)
02:36 PM [SEVERE] [InventorySQL] fr.areku.InventorySQL.InventorySQL.Disable(InventorySQL.java:157)
02:36 PM [SEVERE] [InventorySQL] fr.areku.InventorySQL.InventorySQL.onEnable(InventorySQL.java:99)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:365)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:265)
02:36 PM [SEVERE] [InventorySQL] org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:247)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.i(MinecraftServer.java:296)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.d(MinecraftServer.java:275)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.a(MinecraftServer.java:225)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.DedicatedServer.init(DedicatedServer.java:140)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.MinecraftServer.run(MinecraftServer.java:380)
02:36 PM [SEVERE] [InventorySQL] net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
02:36 PM [SEVERE] [InventorySQL] ---------------------------------------
-
View User Profile
-
Send Message
Posted Sep 8, 2012@ThisIsAreku
You added the sync mode!?! I LOVE YOU FOREVER <3
-
View User Profile
-
Send Message
Posted Sep 8, 2012@chickenputty