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

_ForgeUser11865538
- Join Date: 7/15/2013
- Posts: 5
- Member Details
#409 _ForgeUser11865538

View User Profile

Send Message

Posted Jul 17, 2013
Great plugin - thank you!

The behavior I am seeing is when switching servers the inventory isn't synced properly. I don't always see the saved messages. I think the problem could be a timing issue with where the mysql db is, but I should still see the save messages, right?

I am using the -quit and -changeworld events using 3.0b.

Thoughts?

Further follow-up: I turned up debugging and what is happening is before the item is save I arrive at the new server/world and the previous inventory is refreshed. So, it is definitely a timing issue. It is almost like you have to prevent disconnect or connect from happening until the db transaction is finished.

Last edited by _ForgeUser11865538: Jul 17, 2013

Rollback Post to Revision RollBack
_ForgeUser8622945
- Join Date: 3/22/2012
- Posts: 23
- Member Details
#408 _ForgeUser8622945

View User Profile

Send Message

Posted Jul 17, 2013
@manfie

You are my hero. Realy, I was planning to set up a web-item-shop since december but it was impossible for me to set it up without a similar plugin like this one. Now I can finally get the designed css functionable, thanks to you.

Great work, I'm looking forward using this plugin very intensive.

Ichaelus

Rollback Post to Revision RollBack

cky2250

Location:
Join Date: 11/26/2011
Posts: 99
Member Details

#407 Posted Jul 17, 2013

Cannot add or update a child row: a foreign key constraint fails (`minecraft`.`inventory`, CONSTRAINT `fk_inventories_player` FOREIGN KEY (`playerID`) REFERENCES `mydb`.`player` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)

Only thing i changed was my database. Have fun fixing your code.

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

View User Profile

Send Message

Posted Jul 16, 2013
Any Feedback is appreciated. I already settled down some tests, but i think this is it for now.

@Nyqi

Yeah. My Reallife disturbed me a bit and i first tried to just update the Source, but the Way i choosed was to recreate anything for a much better API.

Rollback Post to Revision RollBack
_ForgeUser6858343
- Join Date: 5/21/2011
- Posts: 359
- Member Details
#405 _ForgeUser6858343

View User Profile

Send Message

Posted Jul 16, 2013
Hurray！

Rollback Post to Revision RollBack
_ForgeUser8660704
- Join Date: 3/29/2012
- Posts: 70
- Member Details
#404 _ForgeUser8660704

View User Profile

Send Message

Posted Jul 15, 2013
Thank u very much for update! :)

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

View User Profile

Send Message

Posted Jul 11, 2013
Nearly done most work of Version 3. This will feature an advanced API, but i removed all Commands for now. Actually Version 3 is a total rewrite of Version 2 and will not feature any original code, nor will it remain beeing released under Apache2 License and i gonna need to ask Areku for Manager acess.

Rollback Post to Revision RollBack
_ForgeUser11284273
- Join Date: 5/22/2013
- Posts: 6
- Member Details
#402 _ForgeUser11284273

View User Profile

Send Message

Posted Jul 3, 2013
@manfie

can't wait :D

Rollback Post to Revision RollBack
_ForgeUser9411073
- Join Date: 8/15/2012
- Posts: 11
- Member Details
#401 _ForgeUser9411073

View User Profile

Send Message

Posted Jun 15, 2013
Good Luck Manf ;)

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

View User Profile

Send Message

Posted Jun 10, 2013
Gonna publish an Updated Version soon :)

Rollback Post to Revision RollBack
_ForgeUser7143093
- Join Date: 7/5/2011
- Posts: 14
- Member Details
#399 _ForgeUser7143093

View User Profile

Send Message

Posted Jun 3, 2013
Out of date

Rollback Post to Revision RollBack
_ForgeUser7746350
- Join Date: 10/22/2011
- Posts: 551
- Member Details
#398 _ForgeUser7746350

View User Profile

Send Message

Posted May 21, 2013
Has anyone taken over this plugin yet?

Rollback Post to Revision RollBack
_ForgeUser9906776
- Join Date: 11/1/2012
- Posts: 18
- Member Details
#397 _ForgeUser9906776

View User Profile

Send Message

Posted May 4, 2013
Someone could resume this plugin because it's very nice and pratical. Thank's

Rollback Post to Revision RollBack
_ForgeUser7868881
- Join Date: 11/15/2011
- Posts: 27
- Member Details
#396 _ForgeUser7868881

View User Profile

Send Message

Posted Apr 24, 2013
Hello,

I see that the main dev will stop his job on this plugin. Is there something planed for minecraft 1.5 by another dev ?

And thanks for all the job you have done.

Sich

Rollback Post to Revision RollBack
_ForgeUser8174329
- Join Date: 12/30/2011
- Posts: 168
- Member Details
#395 _ForgeUser8174329

View User Profile

Send Message

Posted Apr 4, 2013
13:56:23 CONSOLE: [SEVERE] Exception in thread "Thread-21"
13:56:23 CONSOLE: [SEVERE] java.util.ConcurrentModificationException
13:56:23 CONSOLE: [SEVERE] at java.util.ArrayList$Itr.checkForComodification(ArrayList.java:819)
13:56:23 CONSOLE: [SEVERE] at java.util.ArrayList$Itr.next(ArrayList.java:791)
13:56:23 CONSOLE: [SEVERE] at fr.areku.InventorySQL.database.ConnectionManager.reapConnections(ConnectionManager.java:130)
13:56:23 CONSOLE: [SEVERE] at fr.areku.InventorySQL.database.ConnectionManager.access$0(ConnectionManager.java:122)
13:56:23 CONSOLE: [SEVERE] at fr.areku.InventorySQL.database.ConnectionManager$ConnectionReaper.run(ConnectionManager.java:159)

Rollback Post to Revision RollBack
_ForgeUser4881631
- Join Date: 8/20/2010
- Posts: 42
- Member Details
#394 _ForgeUser4881631

View User Profile

Send Message

Posted Mar 30, 2013
@Partiz

I'd LIKE to try and get it going via Jenkins as I really don't like compiling via export. I'll see what I can do and get back to y'all soon. Will try and fix the SQL issues while I'm at it.

Disclaimer: The code I committed to my copy may not necessarily be feature-complete. When I fix stuff in-house I usually end up removing a load of unnecessary stuff if it gets in my way (external libs...).

Rollback Post to Revision RollBack
_ForgeUser10812259
- Join Date: 3/24/2013
- Posts: 1
- Member Details
#393 _ForgeUser10812259

View User Profile

Send Message

Posted Mar 29, 2013
@Cueball61

I see you forked and fixed some bugs of InventorySQL at github. can you commit compiled .jar there?

Rollback Post to Revision RollBack
_ForgeUser4881631
- Join Date: 8/20/2010
- Posts: 42
- Member Details
#392 _ForgeUser4881631

View User Profile

Send Message

Posted Mar 19, 2013
@cancabron

It's due to how it's stored. It picks it up as not having an update when you login so doesn't sync.

A _lot_ of this plugin needs a big rewrite, including the lack of parameterised queries. Seriously Areku, you need to learn parameterised queries if you want to develop SQL-based plugins. Right now someone could potentially cause an SQL injection via this plugin.

I'm gonna do some modifications, I'll post up the code when I'm done for people to poke around with. Need to hunt down the other resources for it first though.

Rollback Post to Revision RollBack
_ForgeUser7090777
- Join Date: 6/29/2011
- Posts: 151
- Member Details
#391 _ForgeUser7090777

View User Profile

Send Message

Posted Mar 15, 2013
When you dead and your inventory is empty, if you desconect and enters in another server (mirror mode) you will have the inventory before your dead!!! Please fix this!

Rollback Post to Revision RollBack

_ForgeUser10516581

Join Date: 2/5/2013
Posts: 17
Member Details

#390 Posted Mar 13, 2013

Conflict!

http://ci.mcmmo.info/job/mcMMO/1800/ and

2013-03-13 23:08:14 [SEVERE] [InventorySQL] ---------------------------------------
2013-03-13 23:08:14 [SEVERE] [InventorySQL] --- an unexpected error has occured ---
2013-03-13 23:08:14 [SEVERE] [InventorySQL] -- please send line below to the dev --
2013-03-13 23:08:14 [SEVERE] [InventorySQL] InventorySQL version 2.5.3
2013-03-13 23:08:14 [SEVERE] [InventorySQL] Bukkit version git-MCPC-Plus-jenkins-MCPC-Plus-222 (MC: 1.4.7)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] Message: exception in playerlogic - check all
2013-03-13 23:08:14 [SEVERE] [InventorySQL] java.lang.ArrayIndexOutOfBoundsException: 340 : 340
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.v1_4_R1.inventory.CraftItemFactory.getItemMeta(CraftItemFactory.java:48)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.v1_4_R1.inventory.CraftItemFactory.getItemMeta(CraftItemFactory.java:44)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.v1_4_R1.inventory.CraftItemStack.getItemMeta(CraftItemStack.java:300)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.v1_4_R1.inventory.CraftItemStack.getItemMeta(CraftItemStack.java:295)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	org.bukkit.inventory.ItemStack.serialize(ItemStack.java:481)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.PlayerManager.computePlayerInventoryHash(PlayerManager.java:119)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.database.methods.PlayerCheck.doAction(PlayerCheck.java:253)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.database.SQLMethod.run(SQLMethod.java:56)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftTask.run(CraftTask.java:53)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] 	java.lang.Thread.run(Thread.java:722)
2013-03-13 23:08:14 [SEVERE] [InventorySQL] ---------------------------------------

Last edited by _ForgeUser10516581: Mar 13, 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

Conflict!

About This Project

Categories

Members

Recent Files

Bukkit