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

_ForgeUser8503632
- Join Date: 2/29/2012
- Posts: 34
- Member Details
#799 _ForgeUser8503632

View User Profile

Send Message

Posted Jul 15, 2014
@Kopertje

For carrying inventories between servers?

If you can't see a use for it, then you obviously don't need it lol.

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

View User Profile

Send Message

Posted Jul 7, 2014
Is 'pendings' already included / can you change the inventory from a website?

Last edited by _ForgeUser8103442: Jul 7, 2014

Rollback Post to Revision RollBack
_ForgeUser13588703
- Join Date: 2/18/2014
- Posts: 65
- Member Details
#797 _ForgeUser13588703

View User Profile

Send Message

Posted Jun 29, 2014
Kann mir irgendjemand helfen die 3 sachen in meiner datenbank einzufügen?

ALTER TABLE `[INVENTORY_DB]` ADD `min_health` DOUBLE NOT NULL DEFAULT 20; ALTER TABLE `[INVENTORY_DB]` ADD `max_health` DOUBLE NOT NULL DEFAULT 20; ALTER TABLE `[INVENTORY_DB]` ADD `food` INT NOT NULL DEFAULT 20;

weiß nicht wie verzweifel gerade..

<<code [20:22:51] [Server thread/INFO]: [InvSQL] Enabling InventorySQL v3.4.0 [20:22:51] [Server thread/INFO]: null com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'food -----------

ALTER TABLE `inve' at line 1>>

<</code>>

Last edited by _ForgeUser13588703: Jun 29, 2014

Rollback Post to Revision RollBack
Forge_User_76237229
- Join Date: 6/17/2012
- Posts: 38
- Member Details
#796 Forge_User_76237229

View User Profile

Send Message

Posted Jun 29, 2014
Hallo, ich benutze dein Plugin seit heute und mir sind gleich 2 Sachen aufgefallen

1. In der Craftbukkit 1.7.9-R0.3-Snapshop schmeist dein Plugin ein paar Errors

2. Kannst du zu deinem Plugin das übertragen von Health, Hunger, Effects,Exp, Enchants .... hinzufügen

ansonsten finde ich dein Plugin echt gut

Last edited by Forge_User_76237229: Jun 29, 2014

Rollback Post to Revision RollBack
_ForgeUser9903367
- Join Date: 10/31/2012
- Posts: 27
- Member Details
#795 _ForgeUser9903367

View User Profile

Send Message

Posted Jun 19, 2014
Is there a proper web/php page for this? Why else use it?

Rollback Post to Revision RollBack
_ForgeUser8080840
- Join Date: 12/15/2011
- Posts: 5
- Member Details
#794 _ForgeUser8080840

View User Profile

Send Message

Posted May 19, 2014
Hallo, hab ein kleines Problem: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'food

Verwende MySQL Server version 5.6 Build for Debian.

Greetz

Rollback Post to Revision RollBack
_ForgeUser12688420
- Join Date: 11/26/2013
- Posts: 68
- Member Details
#793 _ForgeUser12688420

View User Profile

Send Message

Posted May 17, 2014
Have this set up and running, Im using the switch command but no inventory moves with me to next server, items are being saved in MySQL database but nothing is appearing in my inventory at destination, despite reports that the inventory has saved/loaded

Also is there anyway to hide the inventory saving messages that appear every time your inventory is saved?

Any help would be appreciated.

Thank you.

Last edited by _ForgeUser12688420: May 18, 2014

Rollback Post to Revision RollBack
_ForgeUser11971889
- Join Date: 8/3/2013
- Posts: 7
- Member Details
#792 _ForgeUser11971889

View User Profile

Send Message

Posted May 5, 2014
@manfie

Yes but it does not work

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

View User Profile

Send Message

Posted May 4, 2014
@Ferocious_Ben

It's part of the Configuration.

Last edited by _ForgeUser7265008: May 4, 2014

Rollback Post to Revision RollBack
_ForgeUser11971889
- Join Date: 8/3/2013
- Posts: 7
- Member Details
#790 _ForgeUser11971889

View User Profile

Send Message

Posted May 4, 2014
@manfie

Okay. well if you manage to fix the enchant bug and not saving on quit that would be great. and it would be a amazing if you could log the players position on quit and tp on join.

btw. I don't know how to code Java so don't bother suggesting stuff like BukkitSerializer XD

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

View User Profile

Send Message

Posted May 4, 2014
@Ferocious_Ben

That's already an issue and i'm aware of it. Use BukkitSerializer to fix.

@Ferocious_Ben

Server Sync is the Problem. If used on multiple Server there are so many circumstances, which need to be handled. It's not a matter of a lack of possibility.

Rollback Post to Revision RollBack
_ForgeUser11971889
- Join Date: 8/3/2013
- Posts: 7
- Member Details
#788 _ForgeUser11971889

View User Profile

Send Message

Posted May 4, 2014
@manfie

Just get the player world and location then log it to the database and when they log in teleport the player?

Rollback Post to Revision RollBack
_ForgeUser11971889
- Join Date: 8/3/2013
- Posts: 7
- Member Details
#787 _ForgeUser11971889

View User Profile

Send Message

Posted May 4, 2014
Also, enchantments do not sync which is annoying.

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

View User Profile

Send Message

Posted May 4, 2014
@Ferocious_Ben

XP is something that can be added easily. Location is something that could be a problem, because the position can vary on different servers. Updating Inventory needs to be specified via update events.

Rollback Post to Revision RollBack
_ForgeUser11971889
- Join Date: 8/3/2013
- Posts: 7
- Member Details
#785 _ForgeUser11971889

View User Profile

Send Message

Posted May 4, 2014
can you also make it so it saves XP and the players location? perhaps enable an option which teleports a player to the last known location on login? Also. The inventory is not updated upon quiting :L

Thanks :D

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

View User Profile

Send Message

Posted May 4, 2014
@sync667

I'll definitely have a look.

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

View User Profile

Send Message

Posted May 4, 2014
manfie I done small Lib that give API with data etc transferring between bungge server. Maybe it will help for INVS? I will also put it on dev soon.

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

View User Profile

Send Message

Posted May 2, 2014
@MOR_IV

It's an open Issue. Currently there is no avaiable Solution to fix that without linking to NMS.

Rollback Post to Revision RollBack
_ForgeUser12711185
- Join Date: 11/28/2013
- Posts: 1
- Member Details
#781 _ForgeUser12711185

View User Profile

Send Message

Posted May 1, 2014
hello. I use applied energistics and bungeecord server. The problem is that your plugin does not save inventory on the disc: ME storage. Just want you to fix the problem.

Когда переходишь между серверами диск есть, но становится пустым. Вот в этом и печаль.

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

View User Profile

Send Message

Posted Apr 20, 2014
@Mysticforce12345

This is not designed for multiworld support right now.

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