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 :)
Update to 1.9 plz, I like it.
[09:35:20] [Thread-8/WARN]: [InvSQL] The author of this plugin (manf) has misconfigured their Auto Update system [09:35:20] [Thread-8/WARN]: [InvSQL] Files uploaded to BukkitDev should contain the version number, seperated from the name by a 'v', such as PluginName v1.0 [09:35:20] [Thread-8/WARN]: [InvSQL] Please notify the author of this error. [09:35:20] [Server thread/ERROR]: Error occurred while enabling InventorySQL v3.5.0-SNAPSHOT (Is it up to date?) java.lang.NoClassDefFoundError: org/mcstats/Metrics
Anybody share me a full webshop source code ? please?
Is there a version that works with bungeecord to 1.5.2?
The truth is that it does not work in Bungeecord.
If you press "Q" and loose objects, reconnecting and get back to everyone. The inventory takes too long to save, (and if you write the interval to 1 second, you too spam messages).
Neither works well the command: "/switch".
Finally a shame, but I congratulate you on the plugin.
regards
Hy i'm using spigot 1.8 build and i'm getting a error on enable and disable.
Link to error
@yanniclord
Using a mysql based permissions plugin is the way to do that.
Thanks for update! Can you make it compatible with BossShop plugin and other Bar-based plugins? :c This plugin is amazing. Thank you.
@saxons12
I got the same problem i think the update events doesnt work, i've told manfie already about that but there was no answer atm.
On a bungeecord setup when a players inventory gets saved, they can throw the items and log out then log back in. This causes dube. I am doing something wrong with the config?
@yanniclord
Surely, but i don't think that'd be really necessary. But you can create a ticket and i'll have a look later on.
Is it possible to do something like this with Permissions to?
@piter909
Uploaded 3.5 for approval.
We need update ;/
@LenartSys
Same problem here. It's a big problem for our server, since we use bungeecord! Please update.
[11:05:19] [Server thread/INFO]: [InvSQL][DEBUG] Your Problem was caused by: MySQLDatabaseHandler(connection=com.mysql.jdbc.JDBC4Connection@3d64e73d, q=tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler$Queries@2b897548) [11:05:19] [Server thread/INFO]: null tk.manf.InventorySQL.datahandling.exceptions.SerializationException: Error while serializing: [Parsing Error] at tk.manf.InventorySQL.datahandling.serializer.SimpleSerializer.deserializeItemStacks(SimpleSerializer.java:47) [InventorySQL.3.4.7.jar:?] at tk.manf.InventorySQL.manager.DataHandlingManager.deserial(DataHandlingManager.java:58) [InventorySQL.3.4.7.jar:?] at tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler.loadPlayerInventory(MySQLDatabaseHandler.java:107) [InventorySQL.3.4.7.jar:?] at tk.manf.InventorySQL.manager.DatabaseManager.loadPlayer(DatabaseManager.java:90) [InventorySQL.3.4.7.jar:?] at tk.manf.InventorySQL.manager.DatabaseManager.onPlayerLogin(DatabaseManager.java:99) [InventorySQL.3.4.7.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [?:1.7.0_40] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [?:1.7.0_40] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [?:1.7.0_40] at java.lang.reflect.Method.invoke(Unknown Source) [?:1.7.0_40] at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) [minecraft_server2.jar:git-Spigot-1387] at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) [minecraft_server2.jar:git-Spigot-1387] at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) [minecraft_server2.jar:git-Spigot-1387] at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) [minecraft_server2.jar:git-Spigot-1387] at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.PlayerList.c(PlayerList.java:249) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.PlayerList.a(PlayerList.java:135) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.LoginListener.c(LoginListener.java:97) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.LoginListener.a(LoginListener.java:42) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.NetworkManager.a(NetworkManager.java:151) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.ServerConnection.c(ServerConnection.java:77) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.MinecraftServer.v(MinecraftServer.java:705) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.DedicatedServer.v(DedicatedServer.java:273) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.MinecraftServer.u(MinecraftServer.java:568) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.MinecraftServer.run(MinecraftServer.java:474) [minecraft_server2.jar:git-Spigot-1387] at net.minecraft.server.v1_7_R2.ThreadServerApplication.run(SourceFile:618) [minecraft_server2.jar:git-Spigot-1387] Caused by: org.json.simple.parser.ParseException at org.json.simple.parser.Yylex.yylex(Yylex.java:610) [minecraft_server2.jar:git-Spigot-1387] at org.json.simple.parser.JSONParser.nextToken(JSONParser.java:269) [minecraft_server2.jar:git-Spigot-1387] at org.json.simple.parser.JSONParser.parse(JSONParser.java:118) [minecraft_server2.jar:git-Spigot-1387] at org.json.simple.parser.JSONParser.parse(JSONParser.java:81) [minecraft_server2.jar:git-Spigot-1387] at org.json.simple.parser.JSONParser.parse(JSONParser.java:75) [minecraft_server2.jar:git-Spigot-1387] at org.json.simple.JSONValue.parseWithException(JSONValue.java:78) [minecraft_server2.jar:git-Spigot-1387] at tk.manf.InventorySQL.datahandling.serializer.SimpleSerializer.deserializeItemStacks(SimpleSerializer.java:45) [InventorySQL.3.4.7.jar:?] ... 24 more
When player join server.
@manfie
Thank you so much it working.
@stun10sec
Look at Issue #68. This error looks just translated.
Hi manfie
How to fix this problem ?
or do you have .sql file for create database ?
@WinFamSurv
I cannot confirm the Switch bug, disableling messages is pretty easy, just use language-node: '' in the config for the given node.
@PrototypeII
Entferne mal die Kommentare in der create.sql
@Wolf2323
Leben und Hunger sollten schon gespeichert werden in den neueren Versionen. XP sollte kein Problem sein. Verzauberungen müssen vom Serializer unterstützt werden.
Fehler bei den Tickets bitte melden.
@Mike2033
Nope, pendings is still under dev. Just graduated school, probably got some more time to work on that.