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

_ForgeUser12510237
- Join Date: 10/27/2013
- Posts: 8
- Member Details
#535 _ForgeUser12510237

View User Profile

Send Message

Posted Oct 29, 2013
@manfie

18:34:39 [INFO] [InvSQL] Enabling InventorySQL v3.3.5 18:34:39 java.sql.SQLException: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working 18:34:39 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) 18:34:39 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) 18:34:39 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) 18:34:39 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) 18:34:39 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) 18:34:39 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) 18:34:39 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570) 18:34:39 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779) 18:34:39 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622) 18:34:39 at tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler.init(MySQLDatabaseHandler.java:70) 18:34:40 at tk.manf.InventorySQL.manager.DatabaseManager.reload(DatabaseManager.java:63) 18:34:40 at tk.manf.InventorySQL.manager.DependenciesManager.checkDatabaseHandler(DependenciesManager.java:79) 18:34:40 at tk.manf.InventorySQL.manager.DependenciesManager.initialise(DependenciesManager.java:54) 18:34:40 at tk.manf.InventorySQL.InventorySQLPlugin.onEnable(InventorySQLPlugin.java:54) 18:34:40 at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217) 18:34:40 at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457) 18:34:40 at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:382) 18:34:40 at org.bukkit.craftbukkit.v1_6_R3.CraftServer.loadPlugin(CraftServer.java:286) 18:34:40 at org.bukkit.craftbukkit.v1_6_R3.CraftServer.enablePlugins(CraftServer.java:268) 18:34:40 at net.minecraft.server.v1_6_R3.MinecraftServer.l(MinecraftServer.java:321) 18:34:40 at net.minecraft.server.v1_6_R3.MinecraftServer.f(MinecraftServer.java:298) 18:34:40 at net.minecraft.server.v1_6_R3.MinecraftServer.a(MinecraftServer.java:258) 18:34:40 at net.minecraft.server.v1_6_R3.DedicatedServer.init(DedicatedServer.java:165) 18:34:40 at net.minecraft.server.v1_6_R3.MinecraftServer.run(MinecraftServer.java:399) 18:34:40 at net.minecraft.server.v1_6_R3.ThreadServerApplication.run(SourceFile:583) 18:34:40 [INFO] [InvSQL][DEBUG] [Developer Message from manf] Sorry, but the loaded class is deprecated 18:34:46 [INFO] [InvSQL][DEBUG] [Developer Message from manf] Thanks for supporting us and using Metrics :)

i want how to do

Last edited by _ForgeUser12510237: Oct 29, 2013

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

View User Profile

Send Message

Posted Oct 28, 2013
@Miracleserver2013

You have a database and you have user credentials. There is nothing i can do!

@dudule223

I do not support deprecated classes anymore, sorry.

Rollback Post to Revision RollBack
_ForgeUser8103442
- Join Date: 12/18/2011
- Posts: 26
- Member Details
#533 _ForgeUser8103442

View User Profile

Send Message

Posted Oct 28, 2013
@dudule223

Obviously a failure while serializing. Since JSON is very buggy, manfie planned to replace it in future updates. You can however change the serializing method to the recommended one: Serializer

Last edited by _ForgeUser8103442: Oct 28, 2013

Rollback Post to Revision RollBack
Forge_User_93600069
- Join Date: 8/29/2012
- Posts: 1
- Member Details
#532 Forge_User_93600069

View User Profile

Send Message

Posted Oct 28, 2013
My error. Here

Rollback Post to Revision RollBack
_ForgeUser12510237
- Join Date: 10/27/2013
- Posts: 8
- Member Details
#531 _ForgeUser12510237

View User Profile

Send Message

Posted Oct 28, 2013
@manfie

i create the database Miracle but can not read username and password

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

View User Profile

Send Message

Posted Oct 28, 2013
@Miracleserver2013

I do not understand, what you are trying to say, sorry. You need to create the Database by yourself. InventorySQL will only create tables.

Rollback Post to Revision RollBack
_ForgeUser12510237
- Join Date: 10/27/2013
- Posts: 8
- Member Details
#529 _ForgeUser12510237

View User Profile

Send Message

Posted Oct 28, 2013
@manfie

can save player Hold block Weapon ？ in the mysql To make changes can straightway updata in minecraft server？

error

19:10:55 [INFO] [InvSQL] Enabling InventorySQL v3.3.5 19:10:55 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'mydb'

Last edited by _ForgeUser12510237: Oct 28, 2013

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

View User Profile

Send Message

Posted Oct 27, 2013
@Miracleserver2013

This plugin syncs player inventory (including armor and enderchests). Nothing else.

Rollback Post to Revision RollBack
_ForgeUser12510237
- Join Date: 10/27/2013
- Posts: 8
- Member Details
#527 _ForgeUser12510237

View User Profile

Send Message

Posted Oct 27, 2013
this plugins can Synchronous update server？

for example

abc health had 100 in mysql update user abc health set 500 Can instantly change the server data?

Last edited by _ForgeUser12510237: Oct 27, 2013

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

View User Profile

Send Message

Posted Oct 26, 2013
@glOOmyART

That's what i'm here for ;) I'm glad this worked for you.

Any Donation is appreciated :)

Rollback Post to Revision RollBack
_ForgeUser12102686
- Join Date: 8/29/2013
- Posts: 7
- Member Details
#525 _ForgeUser12102686

View User Profile

Send Message

Posted Oct 26, 2013
@manfie

wuoah... thank you very very much!!! it works now perfectly!!

you saved my weekend!! i was on the verge of going nuts over this :P

donation is on the way (well as soon as i charged my paypal account) ;)

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

View User Profile

Send Message

Posted Oct 26, 2013
@glOOmyART Yes that should work ;)

Or use latin1_swedish_ci. I will think of an automatic change in the next releases tho..

Rollback Post to Revision RollBack
_ForgeUser12102686
- Join Date: 8/29/2013
- Posts: 7
- Member Details
#523 _ForgeUser12102686

View User Profile

Send Message

Posted Oct 26, 2013
@manfie

thx for the reply..

hm, i always use utf8_bin ;) should i change it to latin1_general_ci??

i'm trying several weeks now, and always hope for the next update to work :p

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

View User Profile

Send Message

Posted Oct 26, 2013
@glOOmyART

What collation is the database? Case-Insensitivity should work, as "Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value are treated as the same character. For example, if “e” and “é” have the same sort value in a given collation, they compare as equal." (Source)

Rollback Post to Revision RollBack

_ForgeUser12102686

Join Date: 8/29/2013
Posts: 7
Member Details

#521 Posted Oct 26, 2013

hi, no matter what i do, i can't get this to work...

and i noticed several strange things...

1. it creates 2 users when i join.. one is all lowercase like player, the other is my actual stylized username plAYer

2. it saves my inventory when i join server and leaves a note in the chat

3. from the log it seems that it loads the inventory from the lowercase name and then save its to the stylized name so there's no way my inventory will be loaded upon join or synced in anyway

15:58:46 [INFO] plAYer[/192.168.0.102:51425] logged in with entity id 291 at ([neverland] 66.00667111384675, 68.0, 107.5122868265567)
15:58:46 [INFO] [InvSQL][DEBUG] Calling Event PrePlayerLoadedEvent( 486195502
15:58:46 [INFO] [InvSQL][DEBUG] Event called (486195502)
15:58:46 [INFO] [InvSQL][DEBUG] Getting Player Inventory
15:58:46 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@12a0c1df: SELECT id FROM player WHERE playername='player' LIMIT 1
15:58:46 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@78182106: INSERT INTO player (id, playername) VALUES (NULL, 'player')
15:58:46 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@38ac7386: SELECT content, armor FROM inventory WHERE playerID=1 AND server='F5F7A8EAA445F628349A9E2B2647B8FC' LIMIT 1
15:58:46 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@41d47f7b: SELECT content FROM enderchest WHERE playerID=1 AND server='F5F7A8EAA445F628349A9E2B2647B8FC' LIMIT 1
15:58:46 [INFO] [InvSQL][DEBUG] No Inventory found
15:58:46 [INFO] [InvSQL][DEBUG] Calling Event PlayerLoadedEvent( 1711113728
15:58:46 [INFO] [InvSQL][DEBUG] Event called (1711113728)
15:58:47 [INFO] [InvSQL][DEBUG] Calling Event PrePlayerSavedEvent( 677015297
15:58:47 [INFO] [InvSQL][DEBUG] Event called (677015297)
15:58:47 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@492dbf59: SELECT id FROM player WHERE playername='plAYer' LIMIT 1
15:58:47 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@5a6d9197: INSERT INTO player (id, playername) VALUES (NULL, 'plAYer')
15:58:47 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@48098446: INSERT INTO inventory (id, playerID, content, armor, server) VALUES (NULL, 2, x'ACED0005757200215B4C6F72672E62756B6B69742E696E76656E746F72792E4974656D537461636B3B96116C8F72A414CF0200007870000000247372001A6F72672E62756B6B69742E7574696C2E696F2E57726170706572F25047ECF1126F050200014C00036D617074000F4C6A6176612F7574696C2F4D61703B78707372003D677561766131302E636F6D2E676F6F676C652E636F6D6D6F6E2E636F6C6C6563742E496D6D757461626C654D61702453657269616C697A6564466F726D00000000000000000200025B00046B6579737400135B4C6A6176612F6C616E672F4F626A6563743B5B000676616C75657371007E00067870757200135B4C6A6176612E6C616E672E4F626A6563743B90CE589F1073296C0200007870000000027400023D3D740004747970657571007E00080000000274001E6F72672E62756B6B69742E696E76656E746F72792E4974656D537461636B740008574F4F445F4158457371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D740009474C4F5753544F4E457371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D74000D4449414D4F4E445F424C4F434B7371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D74000C51554152545A5F424C4F434B7371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D74000D534D4F4F54485F5354414952537371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D74000E52454453544F4E455F424C4F434B7371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D74000553544F4E457371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D74000D4449414D4F4E445F53574F52447371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D740004444952547371007E00027371007E00057571007E00080000000471007E000A71007E000B74000664616D616765740006616D6F756E747571007E00080000000471007E000D74000558313938337372000F6A6176612E6C616E672E53686F7274684D37133460DA5202000153000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700004737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E003F000000097371007E00027371007E00057571007E00080000000471007E000A71007E000B71007E003A71007E003B7571007E00080000000471007E000D74000558313932317371007E003E00097371007E0041000000027371007E00027371007E00057571007E00080000000271007E000A71007E000B7571007E00080000000271007E000D7400075341504C494E477371007E00027371007E00057571007E00080000000471007E000A71007E000B71007E003A71007E003B7571007E00080000000471007E000D71007E00477371007E003E00077371007E0041000000147371007E00027371007E00057571007E00080000000371007E000A71007E000B71007E003B7571007E00080000000371007E000D7400074C4541544845527371007E0041000000037371007E00027371007E00057571007E00080000000371007E000A71007E000B71007E003B7571007E00080000000371007E000D74000553454544537371007E004100000007707070707070707070707070707070707070707070', x'ACED0005757200215B4C6F72672E62756B6B69742E696E76656E746F72792E4974656D537461636B3B96116C8F72A414CF0200007870000000047372001A6F72672E62756B6B69742E7574696C2E696F2E57726170706572F25047ECF1126F050200014C00036D617074000F4C6A6176612F7574696C2F4D61703B78707372003D677561766131302E636F6D2E676F6F676C652E636F6D6D6F6E2E636F6C6C6563742E496D6D757461626C654D61702453657269616C697A6564466F726D00000000000000000200025B00046B6579737400135B4C6A6176612F6C616E672F4F626A6563743B5B000676616C75657371007E00067870757200135B4C6A6176612E6C616E672E4F626A6563743B90CE589F1073296C0200007870000000047400023D3D7400047479706574000664616D616765740006616D6F756E747571007E00080000000474001E6F72672E62756B6B69742E696E76656E746F72792E4974656D537461636B7400034149527372000F6A6176612E6C616E672E53686F7274684D37133460DA5202000153000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870FFFF737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E00027371007E00057571007E00080000000471007E000A71007E000B71007E000C71007E000D7571007E00080000000471007E000F71007E001071007E001371007E00157371007E00027371007E00057571007E00080000000371007E000A71007E000B71007E000C7571007E00080000000371007E000F7400065831313731387371007E0011023A7371007E00027371007E00057571007E00080000000471007E000A71007E000B71007E000C71007E000D7571007E00080000000471007E000F71007E001071007E001371007E0015', 'F5F7A8EAA445F628349A9E2B2647B8FC') ON DUPLICATE KEY UPDATE content=VALUES(content), armor=VALUES(armor)
15:58:47 [INFO] [InvSQL][DEBUG] com.mysql.jdbc.JDBC4PreparedStatement@570bf2e: INSERT INTO enderchest (id, playerID, content, server) VALUES (NULL, 2, x'ACED0005757200215B4C6F72672E62756B6B69742E696E76656E746F72792E4974656D537461636B3B96116C8F72A414CF02000078700000001B707070707070707070707070707070707070707070707070707070', 'F5F7A8EAA445F628349A9E2B2647B8FC') ON DUPLICATE KEY UPDATE content=VALUES(content)
15:58:47 [INFO] [InvSQL][DEBUG] Calling Event PlayerSavedEvent( 1537186100
15:58:47 [INFO] [InvSQL][DEBUG] Event called (1537186100)

_ForgeUser7265008
- Join Date: 7/25/2011
- Posts: 191
- Member Details
#520 _ForgeUser7265008

View User Profile

Send Message

Posted Oct 24, 2013
@Erwandir

This depends on your configuration: GZipCompressor just gzips it. NoCompressor does nothing at all.

The deprecated and quiete buggy JSONSerializer serialises with json. BukkitSerializer uses internal BukkitAPI to serialise stuff. (BukkitObjectOutputStream)

Rollback Post to Revision RollBack
_ForgeUser9323031
- Join Date: 7/31/2012
- Posts: 6
- Member Details
#519 _ForgeUser9323031

View User Profile

Send Message

Posted Oct 24, 2013
Okay, and how do I reverse this process ? ^^

Maybe you've got a guide around here ?

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

View User Profile

Send Message

Posted Oct 24, 2013
@Erwandir

You need to work with the Items in your database. First the Items are serialised, then compressed. You need to reverse this process in order to get your results.

Enderchests, Playerinventory and Armorinventory is saved in the database, so this is indeed stored.

Rollback Post to Revision RollBack
_ForgeUser9323031
- Join Date: 7/31/2012
- Posts: 6
- Member Details
#517 _ForgeUser9323031

View User Profile

Send Message

Posted Oct 24, 2013
Hello,

how can I read the .bin file which is stored in my database ? And are you going to set each item in the database ? So I can easily find items with ID xx showing me all the players having it etc ...

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

View User Profile

Send Message

Posted Oct 24, 2013
@NetherVillage

Create a ticket and provide more information..

Edit: Nevermind. I have found out, that i used content of player inventory twice... Thank god Bukkit did'nt change the ender inventory.. Will be fixed in 2nd preFinal release

Last edited by _ForgeUser7265008: Oct 24, 2013

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

63,635
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

About This Project

Categories

Members

Recent Files

Bukkit