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

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

View User Profile

Send Message

Posted Apr 4, 2014
@sync667

It's under review. I cannot do anything until then. It won''t help sending tho, because it wont import the projects i'm afraid. You can add the dependency manually. In Netbeans open the dependencies and right click, importing the compiled jar.

Rollback Post to Revision RollBack
_ForgeUser8295270
- Join Date: 1/21/2012
- Posts: 66
- Member Details
#738 _ForgeUser8295270

View User Profile

Send Message

Posted Apr 4, 2014
Can you send me on PW, link for pack from NetBeans or Eclipse with project, because i still have problem with settings and with pack it will be quicker, because I want to add exp share support, and compile you fixed version of last problem with lock, its still not available on b dev.

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

View User Profile

Send Message

Posted Apr 4, 2014
@sync667

i know that, but InventorySQL uses vanilla Bungee and the switch server channel. Teleportation via other plugin needs to utilise third party anyway.

Rollback Post to Revision RollBack
_ForgeUser8295270
- Join Date: 1/21/2012
- Posts: 66
- Member Details
#736 _ForgeUser8295270

View User Profile

Send Message

Posted Apr 3, 2014
@manfie

But you can send custom message to plugin on other bungee server, so you send switch and data with location, and after that other server recive this location data and do normal tp func.

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

View User Profile

Send Message

Posted Apr 3, 2014
@sync667

Bungeecord does not Support any destination teleportation. Bungeecords mirrors a client, so Bungeecord can just switch Servers. Of course a cluster could solve that problem, but pretty overkill too. It's not just a little Plugin that could solve that and definitely not in the Scope of InventorySQL itself.

Anyway i'll work on a Bungeecord Plugin in order to make this work fine.

Last edited by _ForgeUser7265008: Apr 3, 2014

Rollback Post to Revision RollBack
_ForgeUser8295270
- Join Date: 1/21/2012
- Posts: 66
- Member Details
#734 _ForgeUser8295270

View User Profile

Send Message

Posted Apr 2, 2014
@manfie

Yea API etc. ok but say that to all this server owners who don't have idea, about re-programing plugins, or writing new ones that're useing your api. Try to say 5 or more developers of plugins for warps, homes etc. to rewrite they plugin, only because your plugin have an api and they must use it... impossible :) and your API is too simple to use it in that way.. its should handle location arguments for not only tp to spawn, but for warps for example to specific dest. That why we're saying about solving this problem on your plugin site, or by writing little addon.

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

View User Profile

Send Message

Posted Apr 2, 2014
@sync667

Using quit to save Inventories is not advisable, because you cannot delay the server switching. InventorySQL offers an API to teleport between bungeecord Servers. Plugins just need to use that.

Rollback Post to Revision RollBack
_ForgeUser8295270
- Join Date: 1/21/2012
- Posts: 66
- Member Details
#732 _ForgeUser8295270

View User Profile

Send Message

Posted Apr 2, 2014
@ChengZi368

It will clean invs all new server who stats useing invsql :) so its not good idea, now manfie add quit event unlock, so i think it will work like should.

I will do bungee plugin :) it's important manfie, because its not that only portals won't work correct, the same is with global warps plugins, tp, tpa and all that important commands, but maybe it's better to do auto save on quit event?

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

View User Profile

Send Message

Posted Apr 2, 2014
@madtomic

i don't see any problems, just TEST it. It's not pretty hard ;)

@ChengZi368

you can use TeleportSigns too. There is an addon released. I don't think it is neeeded to make a Bungeecord Plugin.

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#730 chengzi

View User Profile

Send Message

Posted Apr 2, 2014
@manfie

Thanks, do you have any plan to make a bungeecord plugin like

http://dev.bukkit.org/bukkit-plugins/shared-inventories/

it? It will be awesome! It is bad that players can only travel though portals(which do /switch xxx)..

Thanks :)

Rollback Post to Revision RollBack
madtomic
- Location: Rehoboth Beach
- Join Date: 3/29/2014
- Posts: 1,204
- Member Details
#729 madtomic

View User Profile

Send Message

Posted Apr 2, 2014
Can i use this on cb1.7.2-r0.3?

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

View User Profile

Send Message

Posted Mar 31, 2014
@sync667

@ChengZi368

Should be fixed in latest Snapshot anyway.

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#727 chengzi

View User Profile

Send Message

Posted Mar 31, 2014
Maybe you can use inventory.clear() after saved inv to sql and before read from sql ?

Rollback Post to Revision RollBack
_ForgeUser8295270
- Join Date: 1/21/2012
- Posts: 66
- Member Details
#726 _ForgeUser8295270

View User Profile

Send Message

Posted Mar 29, 2014
@manfie

Yea I import it too :) but something wasn't fine, i will try again.

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

View User Profile

Send Message

Posted Mar 29, 2014
@sync667

That's called Lombok. Using something like Netbeans should automatically import methodcommand into your Buildpath, so it can be found by maven. Im too busy with school and personal sickness, i cannot look into it right now. Feel free to publish any fix to github. Although im pretty sure it's sufficient to drop the locking after actually leaving.

Last edited by _ForgeUser7265008: Mar 29, 2014

Rollback Post to Revision RollBack
_ForgeUser8295270
- Join Date: 1/21/2012
- Posts: 66
- Member Details
#724 _ForgeUser8295270

View User Profile

Send Message

Posted Mar 29, 2014
So when you will do it? I try test my way of fix, but you plugin is that hard to compile. One dependency is unavailable and maven can't build it. I try to do manual build after compiling methodcommand and adding it to build all code have problem with getInstance(), because its not exists.

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

View User Profile

Send Message

Posted Mar 29, 2014
@sync667

That's odd. I think i know how to fix that probably.

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#722 chengzi

View User Profile

Send Message

Posted Mar 28, 2014
@sync667

I have the same problem. :(

Rollback Post to Revision RollBack
_ForgeUser8295270
- Join Date: 1/21/2012
- Posts: 66
- Member Details
#721 _ForgeUser8295270

View User Profile

Send Message

Posted Mar 28, 2014
Switching by /switch command its not safe too. I don't know why, but on my server, code that lock inv when command is proceed not works and player can quick drop something, after enter command and double amount of it.

EDIT: I don't know but maybe its good fix for this. Remove unlock from command and add it to playerloginevent with lock and remove after 5 of less seconds delay ?

Last edited by _ForgeUser8295270: Mar 28, 2014

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#720 chengzi

View User Profile

Send Message

Posted Mar 28, 2014
@manfie

Hum, so will you make a bungeecord plugin that handle this?

Without this, players can travel between two servers and get many many diamonds.Thats bad

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,446
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