InventorySQL

Table of Contents

	^{German developer}

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

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

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 :)

Comments

_ForgeUser23894556
- Join Date: 3/1/2016
- Posts: 41
- Member Details
#819 _ForgeUser23894556

View User Profile

Send Message

Posted Apr 21, 2016
Update to 1.9 plz, I like it.

Rollback Post to Revision RollBack
_ForgeUser22020855
- Join Date: 10/1/2015
- Posts: 4
- Member Details
#818 _ForgeUser22020855

View User Profile

Send Message

Posted Dec 9, 2015
[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

Last edited by _ForgeUser22020855: Dec 9, 2015

Rollback Post to Revision RollBack
_ForgeUser22090672
- Join Date: 10/7/2015
- Posts: 5
- Member Details
#817 _ForgeUser22090672

View User Profile

Send Message

Posted Nov 18, 2015
Anybody share me a full webshop source code ? please?

Last edited by _ForgeUser22090672: Nov 18, 2015

Rollback Post to Revision RollBack
_ForgeUser11783054
- Join Date: 7/1/2013
- Posts: 1
- Member Details
#816 _ForgeUser11783054

View User Profile

Send Message

Posted Apr 20, 2015
Is there a version that works with bungeecord to 1.5.2?

Last edited by _ForgeUser11783054: Apr 20, 2015

Rollback Post to Revision RollBack
_ForgeUser11055338
- Join Date: 4/28/2013
- Posts: 271
- Member Details
#815 _ForgeUser11055338

View User Profile

Send Message

Posted Jan 21, 2015
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

Rollback Post to Revision RollBack
Misc4HD
- Location: Peer
- Join Date: 1/5/2013
- Posts: 114
- Member Details
#814 Misc4HD

View User Profile

Send Message

Posted Jan 3, 2015
Hy i'm using spigot 1.8 build and i'm getting a error on enable and disable.

Link to error

Rollback Post to Revision RollBack
_ForgeUser8971318
- Join Date: 6/1/2012
- Posts: 177
- Member Details
#813 _ForgeUser8971318

View User Profile

Send Message

Posted Dec 1, 2014
@yanniclord

Using a mysql based permissions plugin is the way to do that.

Rollback Post to Revision RollBack
_ForgeUser6252692
- Join Date: 1/5/2011
- Posts: 34
- Member Details
#812 _ForgeUser6252692

View User Profile

Send Message

Posted Sep 19, 2014
Thanks for update! Can you make it compatible with BossShop plugin and other Bar-based plugins? :c This plugin is amazing. Thank you.

Rollback Post to Revision RollBack
leetzer0
- Join Date: 9/14/2013
- Posts: 42
- Member Details
#811 leetzer0

View User Profile

Send Message

Posted Sep 4, 2014
@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.

Rollback Post to Revision RollBack
_ForgeUser10851183
- Join Date: 3/27/2013
- Posts: 394
- Member Details
#810 _ForgeUser10851183

View User Profile

Send Message

Posted Sep 3, 2014
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?

Rollback Post to Revision RollBack
_ForgeUser7265008
- Join Date: 7/25/2011
- Posts: 191
- Member Details
#809 _ForgeUser7265008

View User Profile

Send Message

Posted Aug 25, 2014
@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.

Rollback Post to Revision RollBack
_ForgeUser8812076
- Join Date: 4/28/2012
- Posts: 259
- Member Details
#808 _ForgeUser8812076

View User Profile

Send Message

Posted Aug 24, 2014
Is it possible to do something like this with Permissions to?

Rollback Post to Revision RollBack
_ForgeUser7265008
- Join Date: 7/25/2011
- Posts: 191
- Member Details
#807 _ForgeUser7265008

View User Profile

Send Message

Posted Aug 21, 2014
@piter909

Uploaded 3.5 for approval.

Rollback Post to Revision RollBack
_ForgeUser6252692
- Join Date: 1/5/2011
- Posts: 34
- Member Details
#806 _ForgeUser6252692

View User Profile

Send Message

Posted Aug 18, 2014
We need update ;/

Rollback Post to Revision RollBack
Forge_User_52477262
- Join Date: 4/22/2012
- Posts: 55
- Member Details
#805 Forge_User_52477262

View User Profile

Send Message

Posted Aug 8, 2014
@LenartSys

Same problem here. It's a big problem for our server, since we use bungeecord! Please update.

Rollback Post to Revision RollBack
_ForgeUser11813644
- Join Date: 7/6/2013
- Posts: 21
- Member Details
#804 _ForgeUser11813644

View User Profile

Send Message

Posted Aug 6, 2014
[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.

Rollback Post to Revision RollBack
_ForgeUser16578390
- Join Date: 7/30/2014
- Posts: 2
- Member Details
#803 _ForgeUser16578390

View User Profile

Send Message

Posted Jul 30, 2014
@manfie

Thank you so much it working.

Rollback Post to Revision RollBack
_ForgeUser7265008
- Join Date: 7/25/2011
- Posts: 191
- Member Details
#802 _ForgeUser7265008

View User Profile

Send Message

Posted Jul 30, 2014
@stun10sec

Look at Issue #68. This error looks just translated.

Rollback Post to Revision RollBack
_ForgeUser16578390
- Join Date: 7/30/2014
- Posts: 2
- Member Details
#801 _ForgeUser16578390

View User Profile

Send Message

Posted Jul 30, 2014
Hi manfie

How to fix this problem ?

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe pr??s de 'food

or do you have .sql file for create database ?
Rollback Post to Revision RollBack
_ForgeUser7265008
- Join Date: 7/25/2011
- Posts: 191
- Member Details
#800 _ForgeUser7265008

View User Profile

Send Message

Posted Jul 26, 2014
@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.

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Project ID

35989
Created

Jan 25, 2012
Last Released File

Aug 21, 2014
Total Downloads

51,662
License

zlib/libpng License

Bukkit

InventorySQL

Bukkit Plugins

InventorySQL

Table of Contents

I n v e n t o r y S Q L

Features

Disclaimer

Metrics

Autoupdater

For Serverowners

Permissions

Commands

Links

License

Contact

Comments

Link to error

About This Project

Categories

Members

Recent Files

Bukkit