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

_ForgeUser6935150
- Join Date: 5/31/2011
- Posts: 961
- Member Details
#269 _ForgeUser6935150

View User Profile

Send Message

Posted Aug 29, 2012
@ThisIsAreku

http://pastebin.com/BLx3p1kU - Another bug with EntityDeathEvent, i will sleep now, thanks for everything!

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

View User Profile

Send Message

Posted Aug 29, 2012
@ThisIsAreku

Oh! That explains everything, thanks :D

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

View User Profile

Send Message

Posted Aug 29, 2012
@rfsantos1996

it's because the required version of Authenticator for InventorySQL 2.1.9 is v 1.3. You need to update :)

EDIT: use this link, Authenticator 1.3 is still under validation by bukkitdev http://j.mp/authAPI

Last edited by _ForgeUser7441906: Aug 29, 2012

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

View User Profile

Send Message

Posted Aug 29, 2012
@ThisIsAreku

http://pastebin.com/9HBfBetP I got an error here - read the notes on the file, thanks for the support (; @EDIT: Ignore the notes, i saw that you already used "softdepend:", must be another error :/

Last edited by _ForgeUser6935150: Aug 29, 2012

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

View User Profile

Send Message

Posted Aug 29, 2012
@bladerik2

I'm adding a PlayerDeath event. releasing 2.1.9 soon

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

View User Profile

Send Message

Posted Aug 29, 2012
@ThisIsAreku

yes, and can be stored backup of inventory when player die? or this be done with respawn in config?

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

View User Profile

Send Message

Posted Aug 29, 2012
@bladerik2

By 'event' you mean PlayerBedEnter, PlayerLogin, etc .. ?

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

View User Profile

Send Message

Posted Aug 29, 2012
@HunterWolf105

No, this plugin can't mirror two servers, but since I haven't found any plugin that do this, I'll try to implement this.

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

View User Profile

Send Message

Posted Aug 29, 2012
@siOnzee

please use pastebin.com for looong logs ;) And your error is caused by a corrupted config.yml file. Try to delete it, and restart the server

Rollback Post to Revision RollBack

_ForgeUser8513123

Join Date: 3/1/2012
Posts: 70
Member Details

#259 Posted Aug 28, 2012

2012-08-29 02:30:41 [SEVERE] [InventorySQL] ---------------------------------------
2012-08-29 02:30:41 [SEVERE] [InventorySQL] --- an unexpected error has occured ---
2012-08-29 02:30:41 [SEVERE] [InventorySQL] -- please send line below to the dev --
2012-08-29 02:30:41 [SEVERE] [InventorySQL] InventorySQL version 2.1.5
2012-08-29 02:30:41 [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.3.2-R0.1-b2352jnks (MC: 1.3.2)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] Message: Unable to load config
2012-08-29 02:30:41 [SEVERE] [InventorySQL] java.lang.ClassCastException: java.util.ArrayList cannot be cast to org.bukkit.configuration.MemorySection : java.util.ArrayList cannot be cast to org.bukkit.configuration.MemorySection
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.Config.<init>(Config.java:82)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.Main.onEnable(Main.java:92)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:365)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:265)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:247)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.i(MinecraftServer.java:296)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.d(MinecraftServer.java:275)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.a(MinecraftServer.java:225)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.DedicatedServer.init(DedicatedServer.java:140)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.run(MinecraftServer.java:378)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] ---------------------------------------
2012-08-29 02:30:41 [INFO] [InventorySQL] Selected AuthMe as offline mode plugin
2012-08-29 02:30:41 [INFO] [InventorySQL] Starting Metrics
2012-08-29 02:30:41 [SEVERE] [InventorySQL] ---------------------------------------
2012-08-29 02:30:41 [SEVERE] [InventorySQL] --- an unexpected error has occured ---
2012-08-29 02:30:41 [SEVERE] [InventorySQL] -- please send line below to the dev --
2012-08-29 02:30:41 [SEVERE] [InventorySQL] InventorySQL version 2.1.5
2012-08-29 02:30:41 [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.3.2-R0.1-b2352jnks (MC: 1.3.2)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] Message: Unable to load config
2012-08-29 02:30:41 [SEVERE] [InventorySQL] java.lang.ClassCastException: java.util.ArrayList cannot be cast to org.bukkit.configuration.MemorySection : java.util.ArrayList cannot be cast to org.bukkit.configuration.MemorySection
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.Config.<init>(Config.java:82)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.Main.reload(Main.java:139)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	fr.areku.InventorySQL.Main.onEnable(Main.java:109)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:365)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:265)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:247)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.i(MinecraftServer.java:296)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.d(MinecraftServer.java:275)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.a(MinecraftServer.java:225)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.DedicatedServer.init(DedicatedServer.java:140)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.MinecraftServer.run(MinecraftServer.java:378)
2012-08-29 02:30:41 [SEVERE] [InventorySQL] 	net.minecraft.server.ThreadServerApplication.run(SourceFile:539)

_ForgeUser8750818
- Join Date: 4/15/2012
- Posts: 22
- Member Details
#258 _ForgeUser8750818

View User Profile

Send Message

Posted Aug 28, 2012
Hello :)

I'm unsure if this plugin can do it, but if I install this plugin on 2 servers, and set them to read/write from the same database/table, can it sync the inventories between 2 servers? Basically, I'm hosting a zombie apocalypse server, and I have a PvP-enabled and a PvP-disabled server. I'm trying to get it to sync the inventories between each server. Can this plugin do it?

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

View User Profile

Send Message

Posted Aug 28, 2012
i have new feature idea: it will be usefull for me to log with backup of inventory the event :) sometimes happends, that some player die because of bug and backup of inventory will be with this feature finded simplest as possible :)

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

View User Profile

Send Message

Posted Aug 28, 2012
@ThisIsAreku

thx, this is the best choice to manage / backup inventories! :) i will use the sql query, but be aware of multiple enchantment - the item with multiple enchant will be showed multiple times on your site, who don't need to show enchants, use group by statement or remove the parts of query with enchantmens :) otherwise php will help with output easily :)

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

View User Profile

Send Message

Posted Aug 28, 2012
@bladerik2

v 2.1.7 is ready, with a backups table ;) (use the link, the approval process of bukkitdev is slow..)

Rollback Post to Revision RollBack
Nichiatu
- Join Date: 2/22/2010
- Posts: 27
- Member Details
#254 Nichiatu

View User Profile

Send Message

Posted Aug 28, 2012
How about a little preview on the web interface?

Looks like a really great plugin, keep it up

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

View User Profile

Send Message

Posted Aug 28, 2012
@bladerik2

Yeah, I added a table *_backup. in version 2.1.7 (wip) you can retrieve the inventory with this : http://pastebin.com/1yJFrL1i

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

View User Profile

Send Message

Posted Aug 28, 2012
@AuraRob

Cool (bootstrap is great, isn't it ? :D)

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

View User Profile

Send Message

Posted Aug 28, 2012
@ThisIsAreku

hello, thanks for great work :) i suggest to write backups to another table (if allowed) or create new column (for example is_backup or something like that with value 0 or 1) because of this example: i take 2 x 64 of signs, then i type /ichk... after that i take 64 of wool and i type /ichk again... now i'm used this mysql command and i get just the wool... in suggested case will this issue dissapear (backup table or new collumn), i think it will simplify the query to get inventory too - query when backups are in another table and query with column is_backup. or i'm wrong? thanks for all :)

Rollback Post to Revision RollBack
_ForgeUser9460985
- Join Date: 8/24/2012
- Posts: 12
- Member Details
#250 _ForgeUser9460985

View User Profile

Send Message

Posted Aug 28, 2012
Working on a web interface for this now, including all the code (well, using bootstrap so lets say all back end code)

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

View User Profile

Send Message

Posted Aug 28, 2012
@konradmm

v 2.1.5 support xAuth, AuthMe, CrazyLogin and AuthDB

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