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
#637 _ForgeUser7265008

View User Profile

Send Message

Posted Feb 1, 2014
@Nentify

You did not post the complete issue..

Rollback Post to Revision RollBack
Forge_User_12999323
- Join Date: 1/16/2012
- Posts: 99
- Member Details
#636 Forge_User_12999323

View User Profile

Send Message

Posted Feb 1, 2014
@manfie

I read it, I couldn't find my issue in the log though. Did you find something?

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

View User Profile

Send Message

Posted Feb 1, 2014
@Nentify

There's a log and you need to read it.

Rollback Post to Revision RollBack
Forge_User_12999323
- Join Date: 1/16/2012
- Posts: 99
- Member Details
#634 Forge_User_12999323

View User Profile

Send Message

Posted Feb 1, 2014
@manfie

I'm not sure I understand?

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

View User Profile

Send Message

Posted Feb 1, 2014
@Nentify

Just look the complete lock..

Rollback Post to Revision RollBack
Forge_User_12999323
- Join Date: 1/16/2012
- Posts: 99
- Member Details
#632 Forge_User_12999323

View User Profile

Send Message

Posted Feb 1, 2014
@manfie

The link you used is dead, but I couldn't find anything wrong from the docs. Even if I set it to BukkitSerializer and use the same ID, I still get the same error on startup? D:

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

View User Profile

Send Message

Posted Feb 1, 2014
@Nentify

View Docs I answered this dozens of times already..

Last edited by _ForgeUser7265008: Feb 1, 2014

Rollback Post to Revision RollBack
Forge_User_12999323
- Join Date: 1/16/2012
- Posts: 99
- Member Details
#630 Forge_User_12999323

View User Profile

Send Message

Posted Feb 1, 2014
@manfie

addons.yml:
addons:

config.yml:
update-events:
- quit
serverID: 'Main' (Other server is 'Rec')
database:
url: 'jdbc:mysql://~~:3306/~~?user=~~&password=~~'
handler: 'tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler'
data:
serializer: 'tk.manf.InventorySQL.datahandling.serializer.JSONSerializer'
compressor: 'tk.manf.InventorySQL.datahandling.compressor.GZipCompressor'
enable-metrics: true
save-interval: 60
auto-update: false

dbhandler.yml:
tables:
prefix: 'invsql_'
suffix: ''
player: 'player'
inventory: 'inventory'
enderchest: 'enderchest'

debug.yml:
debug-level: 100

langauge.yml:
command:
error: '&1Error while performing this Command!'
inventory:
saving: '&1Your Inventory is saving...'
saved: '&4Your Inventory has been saved!'
synced: '&1Your Inventory has successfully been synchronised!'
first-join: '&2Welcome on this Server!'
kick:
reload: 'Reloading Server... Please try again soon!'
Rollback Post to Revision RollBack
_ForgeUser7265008
- Join Date: 7/25/2011
- Posts: 191
- Member Details
#629 _ForgeUser7265008

View User Profile

Send Message

Posted Feb 1, 2014
@Kofeygames

No it does not and i really think you missconfigured your server OR you're players found a bug.

Rollback Post to Revision RollBack
_ForgeUser10882098
- Join Date: 4/1/2013
- Posts: 57
- Member Details
#628 _ForgeUser10882098

View User Profile

Send Message

Posted Feb 1, 2014
Hi,

a few of my players have been complaining about lost items when crafting so I'm looking for a plugin which may show their inventory 'history', so that I can see what is happening. Do this plugin have this feature?

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

View User Profile

Send Message

Posted Feb 1, 2014
@Nentify

You configured something wrong.

Rollback Post to Revision RollBack
Forge_User_12999323
- Join Date: 1/16/2012
- Posts: 99
- Member Details
#626 Forge_User_12999323

View User Profile

Send Message

Posted Jan 31, 2014
Hey,

Trying to use this on a 1.6.4 MCPC+ server, and the /switch command doesn't seem to work. I'm assuming I'm using it correctly with /switch Main Nentify. Main being the server name in the Bungee config, and Nentify being my player name.

Trying to get it to work at the moment.

Thanks!

Edit: Not getting any feedback for any commands, but getting no errors on startup.
Edit2: Getting this startup error? http://pastebin.com/uUpamqUG

Last edited by Forge_User_12999323: Jan 31, 2014

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

View User Profile

Send Message

Posted Jan 31, 2014
@LordKainzo

I'd test it in on an beta server. Any bug report is highly appreciated!

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#624 Kainzo

View User Profile

Send Message

Posted Jan 30, 2014
@manfie

I'll give it a go, still really antsy about putting this on a live-environment though. Wanting to make our hub more "rpg" feeling.

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

View User Profile

Send Message

Posted Jan 30, 2014
@LordKainzo

I'd say quit should be sufficient + auto-save. The new simple serializer uses bukkits own serialisation system, so i think it should save too.

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#622 Kainzo

View User Profile

Send Message

Posted Jan 30, 2014
@manfie

K so what events should be used? just the one that makes them swap servers?

Also I havent tested this - but are custom items / etc supported or would that not save properly?

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

View User Profile

Send Message

Posted Jan 29, 2014
@Mike2033

I'm in irc whenever i feel in the mood and i'm not in school :p Should be more often in the next time.

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

View User Profile

Send Message

Posted Jan 29, 2014
@manfie

I see, thank you! Are you sometimes still in your IRC? Haven't seen you there for a while.

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

View User Profile

Send Message

Posted Jan 29, 2014
@LordKainzo

/server ist NOT recommended. /switch saves before switching Server in contrast to /server.

Your error is caused by enabeling the death update event. There may be current issues with using that.

Rollback Post to Revision RollBack
Kainzo
- Join Date: 5/19/2011
- Posts: 1,174
- Member Details
#618 Kainzo

View User Profile

Send Message

Posted Jan 28, 2014
I also see this error on latest. http://pastie.org/private/r6yrjd9apqozrrekrljna

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