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

_ForgeUser8924331
- Join Date: 5/21/2012
- Posts: 16
- Member Details
#452 _ForgeUser8924331

View User Profile

Send Message

Posted Sep 4, 2013
Temporary work around for anyone using bungee cord and is desperate: use http://www.spigotmc.org/resources/bungeesuiteportals.67/bungeesuite as the only way to teleport between servers (remove all commands to do so) and then make players pass through http://dev.bukkit.org/bukkit-plugins/portalcommands/ set to force player to run /invsql save command before going through the bungeesuite portal

I know its not ideal but as a temporary fix it works.

If your wanting to allow command tp's etc though you'll have to wait and see if manfie can resolve the bungeecord issue.

Rollback Post to Revision RollBack
_ForgeUser9423444
- Join Date: 8/17/2012
- Posts: 51
- Member Details
#451 _ForgeUser9423444

View User Profile

Send Message

Posted Sep 4, 2013
useful fix is.......bungeecord API [if have]

Last edited by _ForgeUser9423444: Sep 4, 2013

Rollback Post to Revision RollBack
_ForgeUser8924331
- Join Date: 5/21/2012
- Posts: 16
- Member Details
#450 _ForgeUser8924331

View User Profile

Send Message

Posted Sep 4, 2013
@anime5167

I'm having the same problem
(the plugin works perfectly with bungeecord so long as all your players run /invsql save before they tp cross server, however you cant always trust players to do that and worse some players will exploit the issue to duplicate items)

@manfie

I'd like to suggest/request some possible options to fix the bungeecord server switch issue:

new update event:
item-transfer: called when a new item enters/exits a players inventory (max every:30 seconds)
(to include items being transferred from chest <-> player, ground<->player or being spawned<->player etc)

Or

Make each player run the command /invsql save every 30 seconds, however that would mean the player being spammed that their inventory is being saved.

This next request would be handy if using either of the previous requests

Ability to hide the messages that inform the players their inventory's have been saved so maybe a config option like:
broadcast inventory save = [true/false]
or

max broadcast interval = seconds
max broadcast interval = 300

I'm not sure how easy any of this would be to implement but at the moment switching servers seems to be an issue that can result in items vanishing or duplicating and these are the only ways I can think to fix that.

Edit: obviously if you have a better way to fix it ignore me :p

Edit: Edit: Just read ticket 41 to see you are already working on this issue with bungeecord, so i'm sorry if this wasted your time. i look forward to your bungeecord full working release
Last edited by _ForgeUser8924331: Sep 4, 2013

Rollback Post to Revision RollBack
_ForgeUser9423444
- Join Date: 8/17/2012
- Posts: 51
- Member Details
#449 _ForgeUser9423444

View User Profile

Send Message

Posted Sep 4, 2013
test for BungeeCord tool

save speed too slow

switch the server will be load the old Inventory

new Inventory save after loaded the old Inventory

player can be copy item

how to fix?

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

View User Profile

Send Message

Posted Sep 4, 2013
@Nithlus

Oh yes! I added this to the main page..

Rollback Post to Revision RollBack
_ForgeUser8924331
- Join Date: 5/21/2012
- Posts: 16
- Member Details
#447 _ForgeUser8924331

View User Profile

Send Message

Posted Sep 4, 2013
Hi you mention there is a command for saving now but don't list the command anywhere that i can see, could you tell us what it is please?

Edit: opened plugin yml to see it is /invsql save and the permissions is InventorySQL.save.[*/self/other] for anyone that was also wondering

Last edited by _ForgeUser8924331: Sep 4, 2013

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

View User Profile

Send Message

Posted Aug 30, 2013
@Hypehr

My or may be not related to #41.

Rollback Post to Revision RollBack
_ForgeUser9549313
- Join Date: 9/2/2012
- Posts: 2
- Member Details
#445 _ForgeUser9549313

View User Profile

Send Message

Posted Aug 27, 2013
Maybe... But if I'll wear armor and immediately go out from server, armor has been duplicated...

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

View User Profile

Send Message

Posted Aug 27, 2013
@Hypehr

I don't think this is related to logging.

Rollback Post to Revision RollBack
_ForgeUser9549313
- Join Date: 9/2/2012
- Posts: 2
- Member Details
#443 _ForgeUser9549313

View User Profile

Send Message

Posted Aug 25, 2013
I found mistake.. If i don't log, my inventory is lost...

Rollback Post to Revision RollBack
_ForgeUser10692212
- Join Date: 3/7/2013
- Posts: 119
- Member Details
#441 _ForgeUser10692212

View User Profile

Send Message

Posted Aug 17, 2013
@manfie

Thanks...I will wait your next version I think player can wait several seconds to sync inventory when cross server

Last edited by _ForgeUser10692212: Aug 17, 2013

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

View User Profile

Send Message

Posted Aug 17, 2013
@PassWordE

I'm working on a solution. My first idea was fastly implemented into Bungee, but slowed Bc too much. So it was removed by md_5 again. Currently i'm thinking to implement something different.

Rollback Post to Revision RollBack
_ForgeUser10692212
- Join Date: 3/7/2013
- Posts: 119
- Member Details
#439 _ForgeUser10692212

View User Profile

Send Message

Posted Aug 16, 2013
can't support bungeecord now?

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

View User Profile

Send Message

Posted Aug 15, 2013
@JohnyK9

[You can change the database name 'mydb' to whatever you want] As stated in the installation page, but im happy you managed it.

Rollback Post to Revision RollBack
_ForgeUser10363393
- Join Date: 1/10/2013
- Posts: 60
- Member Details
#437 _ForgeUser10363393

View User Profile

Send Message

Posted Aug 15, 2013
@manfie

Awesome i got it! Thank you so very much for the help!

I had to edit the database name in the create.sql to my own database.

Last edited by _ForgeUser10363393: Aug 15, 2013

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

View User Profile

Send Message

Posted Aug 15, 2013
@JohnyK9

Just import the SQL to your Database.

Rollback Post to Revision RollBack
_ForgeUser10363393
- Join Date: 1/10/2013
- Posts: 60
- Member Details
#434 _ForgeUser10363393

View User Profile

Send Message

Posted Aug 15, 2013
@manfie

I dont understand that part. I create my databases from using cpanel or zpanel..

Last edited by _ForgeUser10363393: Aug 15, 2013

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

View User Profile

Send Message

Posted Aug 15, 2013
@JohnyK9

InvSQL does not auto create SQL in current builds. Please use this SQL as stated in the documentation:

https://github.com/ExoNetwork/InventorySQL/blob/master/src/main/resources/sql/CREATE.sql

Rollback Post to Revision RollBack
_ForgeUser10363393
- Join Date: 1/10/2013
- Posts: 60
- Member Details
#432 _ForgeUser10363393

View User Profile

Send Message

Posted Aug 15, 2013
@manfie

after removing combatlog now i get this:

pastebin.com

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

View User Profile

Send Message

Posted Aug 15, 2013
@JohnyK9

i don't see why invsql is throwing errors. Could you please provide a better log?

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