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

Slind14
- Join Date: 10/6/2012
- Posts: 70
- Member Details
#575 Slind14

View User Profile

Send Message

Posted Dec 4, 2013
@manfie is there any way to switch a server without your command and keep the inventory ?

Rollback Post to Revision RollBack
_ForgeUser6892606
- Join Date: 5/25/2011
- Posts: 156
- Member Details
#574 _ForgeUser6892606

View User Profile

Send Message

Posted Dec 3, 2013
@manfie

Awesome! Thank you! :)

Also, would it be possible to add a toggle for the messages, so if you set them empty to '', the messages wont display. Because right now I just get a bunch of empty lines with that set. :/ Or maybee just a boolean showMessages: true|false

Rollback Post to Revision RollBack
_ForgeUser1442379
- Join Date: 10/19/2008
- Posts: 103
- Member Details
#573 _ForgeUser1442379

View User Profile

Send Message

Posted Dec 1, 2013
@manfie

Any chance you could compile for 1.4.7 pretty please? ;)

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

View User Profile

Send Message

Posted Nov 28, 2013
@thernztrom

1) Should be fixed in final Version 3.3, which needs aproval 2) Currently you can only use this Command as a Player. I will change this in future Updates (after adding a new CommandHandling System) 3) Updated to easier format.

Rollback Post to Revision RollBack
_ForgeUser6892606
- Join Date: 5/25/2011
- Posts: 156
- Member Details
#571 _ForgeUser6892606

View User Profile

Send Message

Posted Nov 28, 2013
@manfie

1. Can we have a quickfix for the /switch issue? As it is quite a important feature to get it to work with several servers connected. :)

2. Does the switch command work from the console? It would be great so that we can move players with scripts etc.

3. In /switch [player] <target>, where is the target name defined? Is it what you define in BungeeCord?

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

View User Profile

Send Message

Posted Nov 27, 2013
@d24man

This may be a reason, because InventorySQL is disableing and People are still connected. Should be quiete easy to add a security, but you should just kick all people before shutting down. That'd be a good temporary solution.

@flungo

See #57

Rollback Post to Revision RollBack
_ForgeUser1349949
- Join Date: 10/15/2008
- Posts: 6
- Member Details
#569 _ForgeUser1349949

View User Profile

Send Message

Posted Nov 26, 2013
I am having a problem with larger servers of about 300 players not saving inventory data on a server restart. Do you have any idea why this may be and is there a way to fix it?

Rollback Post to Revision RollBack
_ForgeUser8018563
- Join Date: 12/4/2011
- Posts: 78
- Member Details
#568 _ForgeUser8018563

View User Profile

Send Message

Posted Nov 26, 2013
There is a problem with the plugin that is just spewing errors. The console log for an example error can be seen at http://pastebin.com/C4DUrkck

Is the plugin trying to save the inventories of mobs that are being killed? Could you tell me if I have something configured wrong or update if this is a plugin issue.

Rollback Post to Revision RollBack
_ForgeUser10779815
- Join Date: 3/18/2013
- Posts: 13
- Member Details
#567 _ForgeUser10779815

View User Profile

Send Message

Posted Nov 24, 2013
@OgStyle

I test the plugin on 1.5.2 and 1.6.2 are ok , not bukkit but spigot.. And all cant work with BUNGEE when changing server.. It seems BUNGEE will let the player connect to the target server before exiting the last server..

Sorry for my bad english..

Rollback Post to Revision RollBack
_ForgeUser10214673
- Join Date: 12/15/2012
- Posts: 9
- Member Details
#566 _ForgeUser10214673

View User Profile

Send Message

Posted Nov 24, 2013
@kxjhwbb

Can you tell what version of craftbukkit do you run and vers. of this plugin?

Rollback Post to Revision RollBack
_ForgeUser10779815
- Join Date: 3/18/2013
- Posts: 13
- Member Details
#565 _ForgeUser10779815

View User Profile

Send Message

Posted Nov 24, 2013
@manfie

thanks for reply.. What can I do to fix the database? realy a good plugin

Rollback Post to Revision RollBack
_ForgeUser10214673
- Join Date: 12/15/2012
- Posts: 9
- Member Details
#564 _ForgeUser10214673

View User Profile

Send Message

Posted Nov 24, 2013
Hi! i'm running latest bukkit build r2.1. Tried to install your amazing plugin, but nothing success. in logs i read Server Error about "is it up to date?" i downloaded your LATEST build 3.3.5. Can you help to solve this prpblam? I realy need your plugin

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

View User Profile

Send Message

Posted Nov 22, 2013
@kxjhwbb

Caused by your database and i am aware of the switch issue for some people.

Rollback Post to Revision RollBack
_ForgeUser10779815
- Join Date: 3/18/2013
- Posts: 13
- Member Details
#562 _ForgeUser10779815

View User Profile

Send Message

Posted Nov 22, 2013
@manfie

I have been try on bungee with 2 servers , can not use /switch command , /server command is ok but the inventory doesnt follow

Rollback Post to Revision RollBack
_ForgeUser10779815
- Join Date: 3/18/2013
- Posts: 13
- Member Details
#561 _ForgeUser10779815

View User Profile

Send Message

Posted Nov 22, 2013
@pilotdan85

Try and get the same problem, I try to add a delay for example 3 seconds before sync but failed..

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

View User Profile

Send Message

Posted Nov 21, 2013
@shadvalentine

This really depends on the Teleport System you are using. A different project currently uses all my freetime, so i can't really test. I was working on an Addon to support TeleportSigns for example, so that it's using the /switch command system. (This was tested on some Systems to provide a more secure way of transfering players)

@pilotdan85

InventorySQL is designed to be as customisable as possible. We cannot transfer Users to different Servers without a buffer for the database to save all data. This could be done by a 'temp server' or by locking the user's inventory and transfering his items alike. I don't know why some users can not use /switch yet.

Rollback Post to Revision RollBack
shadvalentine
- Location: Norwich
- Join Date: 4/15/2012
- Posts: 491
- Member Details
#559 shadvalentine

View User Profile

Send Message

Posted Nov 21, 2013
@pilotdan85

thank you for the reply ... I was hoping there would be a way to make this work without sending them through a "hub" .. the reason I was hoping it would work this way is I have a tpa plugin that teleports cross servers .. if it cant then I guess I will have to try to find another way

Rollback Post to Revision RollBack
_ForgeUser7432462
- Join Date: 8/23/2011
- Posts: 24
- Member Details
#558 _ForgeUser7432462

View User Profile

Send Message

Posted Nov 21, 2013
@shadvalentine

Read all of my posts. There is a problem with this plugin when using bungeecord. Bungee switches servers faster than inventorysql can save and reload. (make sure you have your trigger events set correctly)

I have found a workaround for this. I have a hub type server setup. Meaning I have one server that acts as a lobby between servers. I force people to travel to different servers through my lobby, then just dont use inventorysql on the lobby server. What this does is provides a slight delay between the ammount of time the inventory is saved, then reloaded.

You might also be able to fix this without a lobby server like me, if you can find a plugin that can make a delay in the amount of time it takes for people to leave one server and go to another.

I don't think its the fault of the developer, I believe he coded this to work with servers that aren't running bungee... meaning you have to log out then back in... which gives inventorysql time to load and save.

Rollback Post to Revision RollBack
shadvalentine
- Location: Norwich
- Join Date: 4/15/2012
- Posts: 491
- Member Details
#557 shadvalentine

View User Profile

Send Message

Posted Nov 20, 2013
I am having a problem getting this to work correctly .. I have bungee cord set up on 2 different servers and when I switch between the servers it tells me "your inventory has successfully been synchronized" however it does not carry the inventory over .. if I type the command "/invsql save" before I change servers my inventory follows.

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

View User Profile

Send Message

Posted Nov 7, 2013
@pilotdan85

I'll test it and look to get a fix for your Problem..

BukkitDev offers a donation Button on the right site of this page in the Navigation ;)

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