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

_ForgeUser12491117
- Join Date: 10/24/2013
- Posts: 7
- Member Details
#515 _ForgeUser12491117

View User Profile

Send Message

Posted Oct 23, 2013
Hi, i have an Error:

2013-10-24 07:50:57 [INFO] ray_67[/217.198.133.18:33890] logged in with entity id 3 at ([NVGame] -1235.6642962083251, 151.0, -452.0323638565829) 2013-10-24 07:50:57 [INFO] [InvSQL][DEBUG] Your Probelm was caused by: MySQLDatabaseHandler(connection=com.mysql.jdbc.JDBC4Connection@c326fdc) 2013-10-24 07:50:57 [INFO] null java.lang.IllegalArgumentException: Invalid inventory size; expected 27 or less at org.bukkit.craftbukkit.v1_6_R3.inventory.CraftInventory.setContents(CraftInventory.java:67) at tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler.loadPlayerInventory(MySQLDatabaseHandler.java:97) at tk.manf.InventorySQL.manager.DatabaseManager.loadPlayer(DatabaseManager.java:72) at tk.manf.InventorySQL.manager.DatabaseManager.onPlayerLogin(DatabaseManager.java:81) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:425) at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:478) at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:463) at net.minecraft.server.v1_6_R3.PlayerList.c(PlayerList.java:207) at net.minecraft.server.v1_6_R3.PlayerList.a(PlayerList.java:103) at net.minecraft.server.v1_6_R3.PendingConnection.e(PendingConnection.java:138) at net.minecraft.server.v1_6_R3.PendingConnection.d(PendingConnection.java:48) at org.spigotmc.netty.NettyServerConnection.b(NettyServerConnection.java:139) at net.minecraft.server.v1_6_R3.MinecraftServer.t(MinecraftServer.java:594) at net.minecraft.server.v1_6_R3.DedicatedServer.t(DedicatedServer.java:240) at net.minecraft.server.v1_6_R3.MinecraftServer.s(MinecraftServer.java:483) at net.minecraft.server.v1_6_R3.MinecraftServer.run(MinecraftServer.java:415) at net.minecraft.server.v1_6_R3.ThreadServerApplication.run(SourceFile:583)

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

View User Profile

Send Message

Posted Oct 23, 2013
@phoomin2012

the database will be created since 3.3

Rollback Post to Revision RollBack
_ForgeUser8658371
- Join Date: 3/29/2012
- Posts: 2
- Member Details
#513 _ForgeUser8658371

View User Profile

Send Message

Posted Oct 23, 2013
Where is mysql table file to download? What is die link?

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

View User Profile

Send Message

Posted Oct 21, 2013
@LordKainzo

I think this event may causes some Problems.

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#511 Kainzo

View User Profile

Send Message

Posted Oct 20, 2013
@manfie

Right, these events were tested with disconnect. Wasnt dying during them.

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

View User Profile

Send Message

Posted Oct 20, 2013
@LordKainzo

Could you trying to disable death? If that doesn't help can you just test quit (update events)

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#509 Kainzo

View User Profile

Send Message

Posted Oct 20, 2013
@manfie

http://pastie.org/private/sslpsz797nivda9uhrat4w

That's what happens

Last edited by Kainzo: Oct 20, 2013

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

View User Profile

Send Message

Posted Oct 20, 2013
@dweSheppard

I'm glad you found your solution :)

Rollback Post to Revision RollBack
Forge_User_18981711
- Join Date: 10/20/2013
- Posts: 12
- Member Details
#507 Forge_User_18981711

View User Profile

Send Message

Posted Oct 20, 2013
@manfie Okay, Thanks.

The inventory sync work with MyCommand. :)

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

View User Profile

Send Message

Posted Oct 20, 2013
@dweSheppard

You are using globalspawn, which is not included in inventorysql, but i don't think mycommand waits, till the command has been sucessfully executed and you don't have the error, which has been reported by Kainzo

Rollback Post to Revision RollBack
Forge_User_18981711
- Join Date: 10/20/2013
- Posts: 12
- Member Details
#505 Forge_User_18981711

View User Profile

Send Message

Posted Oct 20, 2013
Hay, It works only If i add with a other Plugin, such as MyCommand a new Command that save the Players Inventory and than switch the Server.

Screen: http://s1.directupload.net/images/131020/wswvzzzj.png

Debug @1000: http://pastebin.com/fTVmh70t

command1: /markt type1: runcommand text1: - Du bist nun am Markt. runcmd1: - /invsql save - /globalspawn delaytimer1: 5
Last edited by Forge_User_18981711: Oct 20, 2013

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

View User Profile

Send Message

Posted Oct 20, 2013
@LordKainzo

Could you post a server.log with debug set on 1000, please? This is an error in my dynamic EventInitializer, which i cannot reproduce yet,

Last edited by _ForgeUser7265008: Oct 20, 2013

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#503 Kainzo

View User Profile

Send Message

Posted Oct 19, 2013
@manfie

K, the main issue I was seeing - was that the ServerID's were named differently - I resolved this by naming them the same thing.

I can say for 100% that the inventory sync does not functional correctly and /switch - despite being granted permissions still does not work.

00:11:04 [INFO] Kainzo[/86765323:60310] logged in with entity id 412 at ([beta] 225.5, 78.0, 245.5)
00:11:10 [INFO] Kainzo issued server command: /invsql save
00:11:13 [INFO] Kainzo lost connection: disconnect.quitting
00:11:13 [WARNING] Failed to save player data for Kainzo
00:11:13 [INFO] Kainzo left the game.

After disconnecting /idling on the server, I see this.
http://pastie.org/private/hvagfqbvynq7xs8mpizgva

Last edited by Kainzo: Oct 19, 2013

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

View User Profile

Send Message

Posted Oct 19, 2013
@LordKainzo

Did you used File 68?

Actually i can not reproduce you'r error. I did not tested bungee yet.

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#501 Kainzo

View User Profile

Send Message

Posted Oct 19, 2013
@manfie http://pastie.org/private/o8lr658yehg8llwyoe2jg << on disconnect still
Checking...

When doing switch, nothing comes up, I have granted the permission InventorySQL.* to my grp as well.
13:55:13 [INFO] Kainzo issued server command: /switch Kainzo beta
13:55:20 [INFO] Kainzo issued server command: /switch Kainzo beta.hc.to
13:55:31 [INFO] Kainzo issued server command: /switch Kainzo
13:56:03 [INFO] Kainzo issued server command: /switch Kainzo Beta
13:56:06 [INFO] Kainzo issued server command: /switch Kainzo Alpha
13:56:09 [INFO] Kainzo issued server command: /switch Kainzo creative
13:56:12 [INFO] Kainzo issued server command: /switch Kainzo creative.hc.to
13:56:31 [INFO] Kainzo issued server command: /invSQL reload
13:57:18 [INFO] Kainzo issued server command: /perm group founder set InventorySQL.*
13:57:23 [INFO] Kainzo issued server command: /invSQL reload
13:57:27 [INFO] Kainzo issued server command: /switch Kainzo alpha
13:58:09 [INFO] Kainzo issued server command: /invsql kainzo beta
14:00:16 [INFO] Kainzo issued server command: /perm group founder set InventorySQL.switch.self
14:00:18 [INFO] Kainzo issued server command: /switch
14:00:21 [INFO] Kainzo issued server command: /switch beta
14:00:24 [INFO] Kainzo issued server command: /switch Kainzo beta
14:00:34 [INFO] Kainzo issued server command: /perm group founder set InventorySQL.switch.other
14:00:35 [INFO] Kainzo issued server command: /switch Kainzo beta

Nothing worked^

Last edited by Kainzo: Oct 19, 2013

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

View User Profile

Send Message

Posted Oct 19, 2013
@LordKainzo

Could you use /switch instead of /server?

I'll inspect your error tho.

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#499 Kainzo

View User Profile

Send Message

Posted Oct 19, 2013
Testing InvSQL 3.3.3d

I am now getting messages taht the inv is saving, etc - but whenever I use /invsql save Kainzo
and then do /server beta (from alpha) the inventory is different.

I think I'm doing something wrong or not configuring something.

Saw this...
http://pastie.org/private/iziem6nhcnuoa35dkz7g

Last edited by Kainzo: Oct 19, 2013

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#498 Kainzo

View User Profile

Send Message

Posted Oct 18, 2013
http://pastie.org/private/kyy4vml1mn0ybqrssh16ta

I resolved the issue with the serializer - it was entered correctly.

Rollback Post to Revision RollBack
MonroeTT
- Join Date: 10/27/2012
- Posts: 178
- Member Details
#497 MonroeTT

View User Profile

Send Message

Posted Oct 17, 2013
I get the same error as below

Rollback Post to Revision RollBack

_ForgeUser3779634

Join Date: 1/4/2010
Posts: 2
Member Details

#496 Posted Oct 17, 2013

Hey, i try your plugin because i just love this idea. When i start server plugin dont say anything special just it enable with no problems but when i type /invsql save nick it throw me this error. Can you look at it?

02:35:42 [INFO] Andurit issued server command: /invsql save Andurit
02:35:42 [SEVERE] java.lang.IllegalArgumentException: wrong number of arguments
02:35:42 [SEVERE]       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M
ethod)
02:35:42 [SEVERE]       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet
hodAccessorImpl.java:57)
02:35:42 [SEVERE]       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg
atingMethodAccessorImpl.java:43)
02:35:42 [SEVERE]       at java.lang.reflect.Method.invoke(Method.java:606)
02:35:42 [SEVERE]       at se.ranzdo.bukkit.methodcommand.RegisteredCommand.exec
uteMethod(RegisteredCommand.java:108)
02:35:42 [SEVERE]       at se.ranzdo.bukkit.methodcommand.RegisteredCommand.exec
ute(RegisteredCommand.java:65)
02:35:42 [SEVERE]       at se.ranzdo.bukkit.methodcommand.RegisteredCommand.exec
ute(RegisteredCommand.java:70)
02:35:42 [SEVERE]       at se.ranzdo.bukkit.methodcommand.CommandHandler.onComma
nd(CommandHandler.java:250)
02:35:42 [SEVERE]       at org.bukkit.command.PluginCommand.execute(PluginComman
d.java:44)
02:35:42 [SEVERE]       at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCo
mmandMap.java:192)
02:35:42 [SEVERE]       at org.bukkit.craftbukkit.v1_6_R3.CraftServer.dispatchCo
mmand(CraftServer.java:523)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.PlayerConnection.handleC
ommand(PlayerConnection.java:959)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.PlayerConnection.chat(Pl
ayerConnection.java:877)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.PlayerConnection.a(Playe
rConnection.java:834)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.Packet3Chat.handle(Sourc
eFile:49)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.NetworkManager.b(Network
Manager.java:296)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.PlayerConnection.e(Playe
rConnection.java:116)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.ServerConnection.b(Sourc
eFile:37)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.DedicatedServerConnectio
n.b(SourceFile:30)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.MinecraftServer.t(Minecr
aftServer.java:592)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.DedicatedServer.t(Dedica
tedServer.java:227)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.MinecraftServer.s(Minecr
aftServer.java:488)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.MinecraftServer.run(Mine
craftServer.java:421)
02:35:42 [SEVERE]       at net.minecraft.server.v1_6_R3.ThreadServerApplication.
run(SourceFile:583)

Last edited by _ForgeUser3779634: Oct 17, 2013

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