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

View User Profile

Send Message

Posted Mar 28, 2014
@ChengZi368

I'm not familiar with Bungeesuite, but if Bungeecord handles the Command (if it is a Bungeecord Plugin) then InventorySQL cannot intercept between the command.

Other Bukkit Plugins allow Command Programming already, so there is no need to do that for Bukkit.

Last edited by _ForgeUser7265008: Mar 28, 2014

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#718 chengzi

View User Profile

Send Message

Posted Mar 28, 2014
Also, maybe you can let we config that save players' inv before run that command.

For example, I configed "/home" in config file. And when a player use /home, it save his inv before do /home.

Im running a bungeecord server with bungeesuite. players can /home between servers... and I can only let players use /switch when ther using portals.

Last edited by chengzi: Mar 28, 2014

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#717 chengzi

View User Profile

Send Message

Posted Mar 27, 2014
@manfie

Okay it works now. Thanks! :D

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

View User Profile

Send Message

Posted Mar 23, 2014
@ChengZi368

The reasons for the fail has been ellaborated pretty often. Look at the FAQ for more infos. Did you already look at the Issue #68? There is currently an related issue to the mysql file.

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#715 chengzi

View User Profile

Send Message

Posted Mar 23, 2014
I had manually added missing columns to mysql. Still getting errors, and works wrongly.

Here is it: http://pastebin.com/VrHzZE2x

Also, why not add players' xp, level, gamemode...etc

Rollback Post to Revision RollBack
chengzi
- Location: Shenzhen
- Join Date: 11/24/2012
- Posts: 506
- Member Details
#714 chengzi

View User Profile

Send Message

Posted Mar 23, 2014
Somtimes players teleport by bungeesuite portals and them lose items.

Any fixes?

EDIT:Also got some errors after updated

http://pastebin.com/0AyAS9zh

Last edited by chengzi: Mar 23, 2014

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

View User Profile

Send Message

Posted Mar 22, 2014
@TheChiz @ZeroErrors

My mistake forget a little thing in my local Version. The new file is uploading.

Rollback Post to Revision RollBack
_ForgeUser7713135
- Join Date: 10/16/2011
- Posts: 1
- Member Details
#712 _ForgeUser7713135

View User Profile

Send Message

Posted Mar 21, 2014
The current version does not even start.

Current version:

if (DataHandlingManager.getInstance().initialise(getClassLoader()))

Previous version:

if (!DataHandlingManager.getInstance().initialise(getClassLoader()))

Line 62 in InventorySQLPlugin.java
Last edited by _ForgeUser7713135: Mar 21, 2014

Rollback Post to Revision RollBack
_ForgeUser13074691
- Join Date: 1/23/2014
- Posts: 23
- Member Details
#711 _ForgeUser13074691

View User Profile

Send Message

Posted Mar 21, 2014
@manfie

Alright I have resolved that issue. But now I have this going on.....

[17:45:38] [Server thread/INFO]: [InvSQL][DEBUG] [Developer Message from manf] You did not specify proper a proper Handler. Please specify a correct Classname for the missing $ [17:45:38] [Server thread/INFO]: [InvSQL] Disabling InventorySQL v3.4.0 [17:45:38] [Server thread/ERROR]: Error occurred while disabling InventorySQL v3.4.0 (Is it up to date?) java.lang.NullPointerException

And.... I didn't touch the handler, like it says not to in the config. So I don't know what the deal is, help is much appreciated good sir :)

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

View User Profile

Send Message

Posted Mar 21, 2014
@TheChiz

Look at Issue #68

Last edited by _ForgeUser7265008: Mar 21, 2014

Rollback Post to Revision RollBack
_ForgeUser13074691
- Join Date: 1/23/2014
- Posts: 23
- Member Details
#709 _ForgeUser13074691

View User Profile

Send Message

Posted Mar 20, 2014
Hey there, Trying to use your plugin and when loading it on my server and starting it. I get a syntax error, when trying to build the db. This is the exception that gets thrown.

"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 `i' at line 1"

I was hoping you could help or perhaps look into the issue, we're using the latest build that you just threw up a couple of days ago.

Thank you, much appreciated.

Last edited by _ForgeUser13074691: Mar 20, 2014

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

View User Profile

Send Message

Posted Mar 20, 2014
@marubal21

InventorySQL has a ItemPipe WIP, so its not able to do that. It's core function is to sync InventorySQL.

Rollback Post to Revision RollBack
Penturt
- Location: Florida
- Join Date: 5/14/2012
- Posts: 524
- Member Details
#707 Penturt

View User Profile

Send Message

Posted Mar 20, 2014
is there a way to control/manage which server players items will follow/transfer from? ex. we have 3 servers, towny, factions, and minigames, i would like to let players take their rewards from the minigames server to either towny or factions server, but not be able to bring items from the towny server into factions or minigames server.

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

View User Profile

Send Message

Posted Mar 16, 2014
@BIO620

The Server specifies the Size of the EnderChest, InventorySQL is just saving the Inventory.

Rollback Post to Revision RollBack
_ForgeUser10856835
- Join Date: 3/28/2013
- Posts: 47
- Member Details
#705 _ForgeUser10856835

View User Profile

Send Message

Posted Mar 16, 2014
Is there any way to disble enderchest?, because i have another plugin to do that, or with this plugin you can change the enderchest size?

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

View User Profile

Send Message

Posted Mar 15, 2014
@ChengZi368

I added player health and feed value to the latest snapshot, including an Addon for Portals using TeleportSigns.

Rollback Post to Revision RollBack

chengzi

Location: Shenzhen
Join Date: 11/24/2012
Posts: 506
Member Details

#703 Posted Mar 15, 2014

Why not also save players' health and feed values?

EDIT: Got some errors, but seems work fine.

16:51:10 [INFO] [InvSQL][DEBUG] EntityDeathEvent
16:51:10 [INFO] null
java.lang.IllegalArgumentException: argument type mismatch
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at tk.manf.InventorySQL.manager.UpdateEvent$1.execute(UpdateEventManager.java:113)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
        at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:478)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:463)
        at org.bukkit.craftbukkit.v1_6_R3.event.CraftEventFactory.callEntityDeathEvent(CraftEventFactory.java:344)
        at net.minecraft.server.v1_6_R3.EntityInsentient.dropDeathLoot(EntityInsentient.java:202)
        at net.minecraft.server.v1_6_R3.EntityLiving.die(EntityLiving.java:765)
        at net.minecraft.server.v1_6_R3.EntityLiving.damageEntity(EntityLiving.java:717)
        at net.minecraft.server.v1_6_R3.EntityMonster.damageEntity(EntityMonster.java:39)
        at net.minecraft.server.v1_6_R3.EntityZombie.damageEntity(EntityZombie.java:127)
        at net.minecraft.server.v1_6_R3.Entity.y(Entity.java:325)
        at net.minecraft.server.v1_6_R3.EntityLiving.y(EntityLiving.java:152)
        at net.minecraft.server.v1_6_R3.EntityInsentient.y(EntityInsentient.java:111)
        at net.minecraft.server.v1_6_R3.Entity.l_(Entity.java:245)
        at net.minecraft.server.v1_6_R3.EntityLiving.l_(EntityLiving.java:1250)
        at net.minecraft.server.v1_6_R3.EntityInsentient.l_(EntityInsentient.java:150)
        at net.minecraft.server.v1_6_R3.EntityMonster.l_(EntityMonster.java:24)
        at net.minecraft.server.v1_6_R3.EntityZombie.l_(EntityZombie.java:185)
        at net.minecraft.server.v1_6_R3.World.entityJoinedWorld(World.java:1493)
        at net.minecraft.server.v1_6_R3.World.playerJoinedWorld(World.java:1468)
        at net.minecraft.server.v1_6_R3.World.tickEntities(World.java:1337)
        at net.minecraft.server.v1_6_R3.WorldServer.tickEntities(WorldServer.java:517)
        at net.minecraft.server.v1_6_R3.MinecraftServer.t(MinecraftServer.java:573)
        at net.minecraft.server.v1_6_R3.DedicatedServer.t(DedicatedServer.java:240)
        at net.minecraft.server.v1_6_R3.MinecraftServer.s(MinecraftServer.java:483)
        at net.minecraft.server.v1_6_R3.MinecraftServer.run(MinecraftServer.java:415)
        at net.minecraft.server.v1_6_R3.ThreadServerApplication.run(SourceFile:583)

EDIT2: After I removed death event it works fine.

Last edited by chengzi: Mar 15, 2014

_ForgeUser7265008
- Join Date: 7/25/2011
- Posts: 191
- Member Details
#702 _ForgeUser7265008

View User Profile

Send Message

Posted Mar 14, 2014
@killerchris25

That is pretty harsh. I simply stated, that you need to state additional informations. Going to a doctor and saying i feel ill won't resolve the Problem. I can only speculate based on the evidence you provided. There is no offense at all, just clarifiing the requirements.

Anyway your chat is not 'spammed' you are informed, but the message does not change? This is odd, because the message should change. If you really want help, provide me with a more detailed ticket. The comments section is not for Issues, it's for general questions. ;)

Rollback Post to Revision RollBack
_ForgeUser10070451
- Join Date: 11/28/2012
- Posts: 13
- Member Details
#701 _ForgeUser10070451

View User Profile

Send Message

Posted Mar 13, 2014
i tried that man this is not a description my ass my servers not getting errors its just my chat is getting spammed with saving inventory inventory saved really would u die if you are a little nicer i simply asked how to disable a dam file/messages and u get on my case about not a dam description try being nicer and actually help for once!!!

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

View User Profile

Send Message

Posted Mar 13, 2014
@killerchris25

this is a yml file. so just testnode: '' This should work or make a more detailed error report. This is NOT a description.

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