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

_ForgeUser7441906
- Join Date: 8/25/2011
- Posts: 139
- Member Details
#248 _ForgeUser7441906

View User Profile

Send Message

Posted Aug 28, 2012
@konradmm

Only AuthDB and xAuth is supported, I have to add code for AuthMe. soon ;) :p

Rollback Post to Revision RollBack
_ForgeUser9136945
- Join Date: 7/4/2012
- Posts: 60
- Member Details
#247 _ForgeUser9136945

View User Profile

Send Message

Posted Aug 27, 2012
found a glitch ;( using it with authme (but it would be same with every auth plugins) and when someone is logged out, and via sql ill add him an item... When this guy logs in he got it added in quickslot inventory (before logging in), and just after loggin in, this item disappears.. ;( Hope u got any solution for that ;D

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

View User Profile

Send Message

Posted Aug 27, 2012
@Dinastya

I haven't tested it on very large server, but with 20 players there's no performance losses.

The interval is configurable, by default it's 600 sec, but you can add events, like when player enter/leave bed, login, logout,...

The plugin looks stable, and I have enough time to fix bugs quickly :)

if the server crash and erase inventories, you can roll back with mysql

Rollback Post to Revision RollBack
_ForgeUser8115646
- Join Date: 12/20/2011
- Posts: 518
- Member Details
#245 _ForgeUser8115646

View User Profile

Send Message

Posted Aug 27, 2012
@ThisIsAreku

Could you answer my questions 1 page back?

Rollback Post to Revision RollBack
_ForgeUser9449912
- Join Date: 8/22/2012
- Posts: 9
- Member Details
#244 _ForgeUser9449912

View User Profile

Send Message

Posted Aug 27, 2012
Now it works properly. Thank you very much :>

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

View User Profile

Send Message

Posted Aug 27, 2012
@Poisonedcraft

so try to delete the tables from your server, and restart

Rollback Post to Revision RollBack
_ForgeUser9449912
- Join Date: 8/22/2012
- Posts: 9
- Member Details
#242 _ForgeUser9449912

View User Profile

Send Message

Posted Aug 27, 2012
I've updated it, but it still gives me this errors.

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

View User Profile

Send Message

Posted Aug 27, 2012
@Poisonedcraft @bladerik2

update to 2.1.4 with the link "Latest jar", I've fixed this

Last edited by _ForgeUser7441906: Aug 27, 2012

Rollback Post to Revision RollBack
_ForgeUser9449912
- Join Date: 8/22/2012
- Posts: 9
- Member Details
#240 _ForgeUser9449912

View User Profile

Send Message

Posted Aug 27, 2012
Hi, I'm using bukkit 1.3.2 R0.2 and i'm getting errors like this: http://pastebin.com/e0Vb4x5r

Could you help me?

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

View User Profile

Send Message

Posted Aug 27, 2012
@bladerik2

The inventory is updated on the table if there is a modification. if not, the table still unchanged. I am uploading a v2.1.4, which fix these bugs ;)

Rollback Post to Revision RollBack

_ForgeUser7441906

Join Date: 8/25/2011
Posts: 139
Member Details

#238 Posted Aug 27, 2012

@Blackybecks

And if you want to get the latest inventory for one player with backup enabled, here is a sql :

SELECT `inventories`.`id` AS `id`,
`inventories`.`item` AS `item`,
`inventories`.`data` AS `data`,
`inventories`.`damage` AS `damage`,
`inventories`.`count` AS `count`,
`inventories`.`slot` AS `slot`,
`inventories`.`date` AS `date`,
`enchantments`.`ench_index` AS `ench_index`,
`enchantments`.`ench` AS `ench`,
`enchantments`.`level` AS `level`
FROM `invsql_inventories` as `inventories`
LEFT JOIN `invsql_enchantments` AS `enchantments` ON `inventories`.`id` = `enchantments`.`id`
WHERE (`inventories`.`owner` = 1 AND `inventories`.`world` = 'world')
AND `date` = (SELECT MAX(`date`) FROM `invsql_inventories` WHERE (`inventories`.`owner` = 1 AND `inventories`.`world` = 'world'));

Last edited by _ForgeUser7441906: Aug 27, 2012

_ForgeUser7441906
- Join Date: 8/25/2011
- Posts: 139
- Member Details
#237 _ForgeUser7441906

View User Profile

Send Message

Posted Aug 27, 2012
@Blackybecks

You can disable backup in the config ;)

Rollback Post to Revision RollBack
_ForgeUser9365300
- Join Date: 8/7/2012
- Posts: 16
- Member Details
#236 _ForgeUser9365300

View User Profile

Send Message

Posted Aug 27, 2012
hello, in 2.1.3 is pendings fixed, but inventory is generated just one time and not anymore (i try /ichk, /invsql reload, /invsql check all and events and nothings work for me) and if i try to use /ichk when if in table some item with multiple enchant it gives to me that item 3x times with separated enchant and not one item with 3 enchants :) i don't wanna be bothersome, u will hate me now :) and here is some new exception - and thank you very much for really quick fixes :)

Rollback Post to Revision RollBack
_ForgeUser8863646
- Join Date: 5/8/2012
- Posts: 7
- Member Details
#235 _ForgeUser8863646

View User Profile

Send Message

Posted Aug 26, 2012
So now I have a Problem... I want to show the Items you have ingame on my website! It works, but if the inventory change, I only want to show the items you have in this moment in your inventory, but also the ols Items will be shown! Then I have tryed with "WHERE date = xyz" but the only the Items will be shown, you have changed since last syncronisation?

How can I show only the Items you have in this moment in your Inventory but all?

Why the Old Items are saved? Can you drop the old Items ?

Last edited by _ForgeUser8863646: Aug 26, 2012

Rollback Post to Revision RollBack
_ForgeUser8863646
- Join Date: 5/8/2012
- Posts: 7
- Member Details
#234 _ForgeUser8863646

View User Profile

Send Message

Posted Aug 26, 2012
I'm fucked :) Okay, then I rewrite it... But I want to say thanks for upload v2.1.3 And want to say, that you be a real nice developer... Thumbs up ;)

Oh my god, rewrite 2000 rows -.- Okay, my holiday are now ending :P

Rollback Post to Revision RollBack
_ForgeUser6935150
- Join Date: 5/31/2011
- Posts: 961
- Member Details
#233 _ForgeUser6935150

View User Profile

Send Message

Posted Aug 26, 2012
@Dinastya

I use this plugin because my players was having inventories wiped, now its normal

Rollback Post to Revision RollBack
_ForgeUser8115646
- Join Date: 12/20/2011
- Posts: 518
- Member Details
#232 _ForgeUser8115646

View User Profile

Send Message

Posted Aug 26, 2012
If we add this plugin and the server would crash then inventories wont roll back?

How often are inventories saved? and how stable is it?

And will it affect server performance?

Rollback Post to Revision RollBack

_ForgeUser7441906

Join Date: 8/25/2011
Posts: 139
Member Details

#231 Posted Aug 26, 2012

@Blackybecks

i'm sorry you will have to rewrite all.. But now, it's easier, with a mysql like:

SELECT `inventory`.`id` AS `p_id`, `inventory`.`item` AS `item`, `inventory`.`data` AS `data`, `inventory`.`damage` AS `damage`, `inventory`.`count` AS `count`, `enchantments`.`ench` AS `ench`, `enchantments`.`level` AS `level` FROM `inv_table` as `inventory` LEFT JOIN `ench_table` AS `enchantments` ON `inventory`.`id` = `enchantments`.`id` WHERE (`inventory`.`owner` = ? AND `inventory`.`world` = ?);

Last edited by _ForgeUser7441906: Aug 26, 2012

_ForgeUser8863646
- Join Date: 5/8/2012
- Posts: 7
- Member Details
#230 _ForgeUser8863646

View User Profile

Send Message

Posted Aug 26, 2012
Now the inventory saveing is no more in this format: [x[y:z]xcount] ? Only with once row a Item?

Because then i must rewrite my complete Website -.- or is there a other way?

Rollback Post to Revision RollBack
_ForgeUser8863646
- Join Date: 5/8/2012
- Posts: 7
- Member Details
#229 _ForgeUser8863646

View User Profile

Send Message

Posted Aug 26, 2012
Big Thanks too you :)

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