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

_ForgeUser7758748
- Join Date: 10/25/2011
- Posts: 69
- Member Details
#124 _ForgeUser7758748

View User Profile

Send Message

Posted May 2, 2012
@ThisIsAreku

Fantastic, I will try it now! Thank you very much, really appreciate it.

Rollback Post to Revision RollBack
_ForgeUser7485515
- Join Date: 9/2/2011
- Posts: 173
- Member Details
#123 _ForgeUser7485515

View User Profile

Send Message

Posted May 2, 2012
@ThisIsAreku

Nice man :)

Thanks. 1 question for what is the inventorysql_user table?

Rollback Post to Revision RollBack
_ForgeUser6941066
- Join Date: 6/1/2011
- Posts: 343
- Member Details
#122 _ForgeUser6941066

View User Profile

Send Message

Posted May 2, 2012
Hope you can add a feature to OP that can restore all players items with a command. Thanks

Rollback Post to Revision RollBack
_ForgeUser8653134
- Join Date: 3/27/2012
- Posts: 6
- Member Details
#121 _ForgeUser8653134

View User Profile

Send Message

Posted May 1, 2012
I'm a little confused as to how the inventories can be edited, as it says in the features section. Is there an in-game command for this? I would like to use this for my voting system, like Thisnamewilldo.

Rollback Post to Revision RollBack
_ForgeUser7441906
- Join Date: 8/25/2011
- Posts: 139
- Member Details
#120 _ForgeUser7441906

View User Profile

Send Message

Posted May 1, 2012
In version 0.8;

@Schlumpf9

you can disable multiworld :) (verbosity is an old unused config..)

@Qentus @Qentus @Thisnamewilldo (and others)

performances issues fixed !

I've been away for some time, and I could barely read the comments with my old phone .. But I have noted the problems, and I think now everything works again (at least) as good as before! :)

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

View User Profile

Send Message

Posted May 1, 2012
same here, big performance issue :(

I come back on what I say.... Apparently there were problem with my nether world.... I have rebuild the nether and now all my server seems to come back alive...

This was not inventorysql reason...

Last edited by _ForgeUser7868881: May 1, 2012

Rollback Post to Revision RollBack
_ForgeUser7485515
- Join Date: 9/2/2011
- Posts: 173
- Member Details
#118 _ForgeUser7485515

View User Profile

Send Message

Posted Apr 30, 2012
Could you add a config option to disable the multiworld feature?

Because I have 4 worlds but in all worlds the same inventory, so I don't really need it :) Would be nice if you could add an option to turn this off :p

Anotehr question I have is what means this config options: verbosity: 2?

Rollback Post to Revision RollBack
_ForgeUser7286718
- Join Date: 7/28/2011
- Posts: 26
- Member Details
#117 _ForgeUser7286718

View User Profile

Send Message

Posted Apr 28, 2012
2012-04-28 09:51:30 [INFO] [InventorySQL] Enabling InventorySQL v0.7-3 2012-04-28 09:51:30 [INFO] [InventorySQL] ThisIsAreku present INVENTORYSQL, v0.7-3 2012-04-28 09:51:30 [INFO] [InventorySQL] = http://alexoft.x10.mx/ = 2012-04-28 09:51:30 [SEVERE] [InventorySQL] ------- ~~2012-04-28 09:51:30 [SEVERE] [InventorySQL]~~ - an unexpected error has occured ~~- 2012-04-28 09:51:30 [SEVERE] [InventorySQL]~~ please send line below to the dev 2012-04-28 09:51:30 [SEVERE] [InventorySQL] InventorySQL version 0.7-3 2012-04-28 09:51:30 [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.2.5-R1.2-6-g45ec64f-b2172jnks (MC: 1.2.5) 2012-04-28 09:51:30 [SEVERE] [InventorySQL] Message: mysql init 2012-04-28 09:51:30 [SEVERE] [InventorySQL] SQLState: null 2012-04-28 09:51:30 [SEVERE] [InventorySQL] Error Code: 0

Rollback Post to Revision RollBack
_ForgeUser7758748
- Join Date: 10/25/2011
- Posts: 69
- Member Details
#116 _ForgeUser7758748

View User Profile

Send Message

Posted Apr 28, 2012
@Qentus

No, you are not doing anything wrong. Since being updated, for some reason, the whole plugin has gone wrong. I am having the exact same problems, it works fine for a short while, perhaps an hour if lucky, then all of a sudden inventories stop updating and it also causes some functions on most of my plugins to stop working. I hope ThisIsAreku fixes this soon as all voting websites reset in 2 days and I use this plugin for my voting system!

Last edited by _ForgeUser7758748: Apr 28, 2012

Rollback Post to Revision RollBack
_ForgeUser7245936
- Join Date: 7/22/2011
- Posts: 70
- Member Details
#115 _ForgeUser7245936

View User Profile

Send Message

Posted Apr 28, 2012
@UbuntuFreak

No it doesnt because some inventories are updated

Rollback Post to Revision RollBack
_ForgeUser8413476
- Join Date: 2/12/2012
- Posts: 261
- Member Details
#114 _ForgeUser8413476

View User Profile

Send Message

Posted Apr 27, 2012
@Qentus

Does the plugin disable itself in the plugin list? When typing /plugins, enabled plugins are green and disabled plugins are red.

Rollback Post to Revision RollBack
_ForgeUser7245936
- Join Date: 7/22/2011
- Posts: 70
- Member Details
#113 _ForgeUser7245936

View User Profile

Send Message

Posted Apr 27, 2012
I dont know why, but this plugin isnt working for me. What about you? Data in MySQL table are updated for the first 2 hours after restart. Then more and more invetories of online players arent updated (even after login/quit). In addition it causes extra RAM usage even while it isnt updating MySQL table. Why?

without plugin - 60 players - 1.9GB ram used with plugin - 42 players - 2.5GB used

Am I doing anything wrong? This is my config:

verbosity: 2 check-interval: 120 after-login-delay: 2 check-plugin-updates: false no-creative: true check-chest: false
Rollback Post to Revision RollBack
_ForgeUser7485515
- Join Date: 9/2/2011
- Posts: 173
- Member Details
#112 _ForgeUser7485515

View User Profile

Send Message

Posted Apr 26, 2012
@Thisnamewilldo

You can find the donation Button always on Bukkit DEV in the top right corner of this site!

Rollback Post to Revision RollBack
_ForgeUser7245936
- Join Date: 7/22/2011
- Posts: 70
- Member Details
#111 _ForgeUser7245936

View User Profile

Send Message

Posted Apr 25, 2012
This plugin causes hardcore laggs on our server (60-80 online). Server is OK for about 3 hours but then something strange happens and one of our CPU core´s usage is 100% and server is sometimes shutting down longer than 6 minutes.

Last edited by _ForgeUser7245936: Apr 25, 2012

Rollback Post to Revision RollBack
_ForgeUser7758748
- Join Date: 10/25/2011
- Posts: 69
- Member Details
#110 _ForgeUser7758748

View User Profile

Send Message

Posted Apr 23, 2012
This plugin seems to break all my other plugins and comes up with this:

[WARNING] pending items for player or something like that and won't give them the items. So if it's add 39 diamonds, it says pending items in the console if I do /invsql check but won't actually give them. Can you please try to figure out why this is causing all the other plugins to break and why it has stopped working? Also, do you have a donation button somewhere? I can't see it. Thanks!

Rollback Post to Revision RollBack
_ForgeUser7485515
- Join Date: 9/2/2011
- Posts: 173
- Member Details
#109 _ForgeUser7485515

View User Profile

Send Message

Posted Apr 23, 2012
You have more than 3000 Downloads :D

Last edited by _ForgeUser7485515: Apr 23, 2012

Rollback Post to Revision RollBack
BONNe1704
- Location: Riga
- Join Date: 2/25/2012
- Posts: 333
- Member Details
#108 BONNe1704

View User Profile

Send Message

Posted Apr 22, 2012
ThisIsAreku, could you add Inventory Slots 100, 101, 102, 103 for armor?

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

View User Profile

Send Message

Posted Apr 21, 2012
@ThisIsAreku

Hello ThisIsAreku. Can I have some contact details from you, perhaps?

I have some questions.. Thanks :)

Rollback Post to Revision RollBack
_ForgeUser7441906
- Join Date: 8/25/2011
- Posts: 139
- Member Details
#105 _ForgeUser7441906

View User Profile

Send Message

Posted Apr 20, 2012
@DARK_BASS_LORD

@BONNe1704

Sorry, this is some debug code.. fixed in 0.7-3

Rollback Post to Revision RollBack
_ForgeUser8769004
- Join Date: 4/19/2012
- Posts: 3
- Member Details
#104 _ForgeUser8769004

View User Profile

Send Message

Posted Apr 19, 2012
@BONNe1704

please let me know when you sort the problem as i am having the same one! thanks.

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

56,447
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