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

BONNe1704
- Location: Riga
- Join Date: 2/25/2012
- Posts: 333
- Member Details
#103 BONNe1704

View User Profile

Send Message

Posted Apr 19, 2012
What mean??? 2012-04-19 15:40:05 [INFO] [InventorySQL] eq:false

It is spamming all time in consule

Rollback Post to Revision RollBack
_ForgeUser7719430
- Join Date: 10/17/2011
- Posts: 136
- Member Details
#102 _ForgeUser7719430

View User Profile

Send Message

Posted Apr 18, 2012
@EszesBence92

I would say its better at online inventory management. I don't think I would use it for that purpose. You may want to find a plugin that saves the world state upon log out.

I'm sure you may be able to do that with this plugin, but I'm no expert :<

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

View User Profile

Send Message

Posted Apr 16, 2012
@Wilkinsocks

I connected the MySQL server in the config and created the to open.

The tables have been created by invsql.

If it really dosen't work, I oder any other can send you a sql file that creates the database and the tables on it's own. This means InvSQL only has to use the tables.

Rollback Post to Revision RollBack
_ForgeUser8745507
- Join Date: 4/14/2012
- Posts: 1
- Member Details
#100 _ForgeUser8745507

View User Profile

Send Message

Posted Apr 15, 2012
I dont get how you create the mysql table :/

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

View User Profile

Send Message

Posted Apr 14, 2012
That plugin is awesome! Thanks alot, i really need it. Please promise, that you will always update it :D

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

View User Profile

Send Message

Posted Apr 13, 2012
@try5u6u:

This plugin doesn't seem to have permissions, it is for probably op-only use.

Rollback Post to Revision RollBack
_ForgeUser8040817
- Join Date: 12/8/2011
- Posts: 4
- Member Details
#97 _ForgeUser8040817

View User Profile

Send Message

Posted Apr 13, 2012
im an admin with a '*' node and im getting i dont have permission ti use it

Rollback Post to Revision RollBack
_ForgeUser3002290
- Join Date: 8/6/2009
- Posts: 93
- Member Details
#96 _ForgeUser3002290

View User Profile

Send Message

Posted Apr 12, 2012
when a player relogg sometime loose him inventory. This plugin good for that bug ?:S

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

View User Profile

Send Message

Posted Apr 11, 2012
@gnorbsl

I think the cpu load is normal even if I donÄt know why I think this :)

@ThisIsAreku: Can you please add permissions?

Rollback Post to Revision RollBack
_ForgeUser6969934
- Join Date: 6/6/2011
- Posts: 64
- Member Details
#94 _ForgeUser6969934

View User Profile

Send Message

Posted Apr 8, 2012
Can you make compatible with Openinv? Link: http://dev.bukkit.org/server-mods/openinv/

I use that on my Server and can't open Inventory when player is offline.

Openinv Author: You should ask the other plugin to make it compatible with this plugin. Openinv taps into the game's data, and it would be messy to add a bunch of code that taps into another plugin. The other plugin however can simply save its data back to the game, resulting in clean and safe environment.

Rollback Post to Revision RollBack
_ForgeUser8316193
- Join Date: 1/25/2012
- Posts: 38
- Member Details
#93 _ForgeUser8316193

View User Profile

Send Message

Posted Apr 6, 2012
This Plugin caused a very high cpu load and crashed my server on first start.

is this normal?

Rollback Post to Revision RollBack
_ForgeUser6983114
- Join Date: 6/8/2011
- Posts: 3
- Member Details
#92 _ForgeUser6983114

View User Profile

Send Message

Posted Apr 4, 2012
A pre-configured website page I can just throw on my host would be nice :)

Rollback Post to Revision RollBack
_ForgeUser8316193
- Join Date: 1/25/2012
- Posts: 38
- Member Details
#91 _ForgeUser8316193

View User Profile

Send Message

Posted Apr 4, 2012
`Nice plugin thanks!

Could you do the same plugin with all chests in the world, please?

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

View User Profile

Send Message

Posted Apr 4, 2012
@KinkCraft

It only copy the items for players inventories to mysql, never the contrary

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

View User Profile

Send Message

Posted Apr 4, 2012
@CTapblu

I always update the files

Rollback Post to Revision RollBack
_ForgeUser3300558
- Join Date: 9/22/2009
- Posts: 15
- Member Details
#88 _ForgeUser3300558

View User Profile

Send Message

Posted Apr 4, 2012
Update "recent files" links pls...

Rollback Post to Revision RollBack
_ForgeUser8632620
- Join Date: 3/24/2012
- Posts: 8
- Member Details
#87 _ForgeUser8632620

View User Profile

Send Message

Posted Apr 4, 2012
Hey this plugin seems to be exactly what I'm after but I am still quite confused. Please correct me if I'm wrong but what I believe this plugin will do is copy all items from every single players inventory into a MySQL Database, updating it every now and then.

So say if I have a map called world_survival and this plugin backups up all the players inventories from this map into a database, and I decide to delete this world and create a new map called world_survival so its a new map, will this plugin backup players new inventories which will be empty, or can it restore everyone's inventories from the database?

Last edited by _ForgeUser8632620: Apr 4, 2012

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

View User Profile

Send Message

Posted Apr 4, 2012
@Thisnamewilldo

try to delete the table, and reload the plugin with latest version (0.6.10)

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

View User Profile

Send Message

Posted Apr 4, 2012
@sgcsim

reload command added!

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

View User Profile

Send Message

Posted Apr 4, 2012
Latest version seems to have messed everything up for me and now I can't remember which one worked :/

For some reason it doesn't add all users to database and also won't update pendings in their inventory. Also it duplicates some users.

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