InventorySQL

Logo
https://dl.dropbox.com/u/5496351/resources/logo-inventorysql.pnghttps://dl.dropboxusercontent.com/u/43938052/images/invsql-version.png

http://upload.wikimedia.org/wikipedia/commons/thumb/b/ba/Flag_of_Germany.svg/32px-Flag_of_Germany.svg.png 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 :)

You must login to post a comment. Don't have an account? Register to get one!

  • Avatar of manfie manfie Jul 26, 2014 at 16:58 UTC - 0 likes

    @WinFamSurv: Go

    I cannot confirm the Switch bug, disableling messages is pretty easy, just use language-node: '' in the config for the given node.

    @PrototypeII: Go

    Entferne mal die Kommentare in der create.sql

    @Wolf2323: Go

    Leben und Hunger sollten schon gespeichert werden in den neueren Versionen. XP sollte kein Problem sein. Verzauberungen müssen vom Serializer unterstützt werden.

    Fehler bei den Tickets bitte melden.

    @Mike2033: Go

    Nope, pendings is still under dev. Just graduated school, probably got some more time to work on that.

  • Avatar of TDB_South_Paw TDB_South_Paw Jul 16, 2014 at 03:49 UTC - 0 likes

    @Kopertje: Go

    For carrying inventories between servers?

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

  • Avatar of Mike2033 Mike2033 Jul 07, 2014 at 14:16 UTC - 0 likes

    Is 'pendings' already included / can you change the inventory from a website?

    Last edited Jul 07, 2014 by Mike2033
  • Avatar of SimbaZockt SimbaZockt Jun 29, 2014 at 17:47 UTC - 0 likes

    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 Jun 29, 2014 by SimbaZockt
  • Avatar of Wolf2323 Wolf2323 Jun 29, 2014 at 12:04 UTC - 0 likes

    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 Jun 29, 2014 by Wolf2323

    Follow my Server on Medoria.de

  • Avatar of Kopertje Kopertje Jun 19, 2014 at 08:31 UTC - 0 likes

    Is there a proper web/php page for this? Why else use it?

  • Avatar of PrototypeII PrototypeII May 19, 2014 at 14:30 UTC - 0 likes

    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

  • Avatar of WinFamSurv WinFamSurv May 17, 2014 at 19:57 UTC - 0 likes

    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 May 18, 2014 by WinFamSurv

    SafeCraft by Win Family Survival - Family Friendly Server I.P. playwfs.co.uk http://winfamilysurvival.co.uk for website and forum

  • Avatar of Ferocious_Ben Ferocious_Ben May 05, 2014 at 14:53 UTC - 0 likes

    @manfie: Go

    Yes but it does not work

  • Avatar of manfie manfie May 04, 2014 at 21:09 UTC - 0 likes

    @Ferocious_Ben: Go

    It's part of the Configuration.

    Last edited May 04, 2014 by manfie

Facts

Date created
Jan 25, 2012
Categories
Last update
Mar 31, 2014
Development stage
Release
License
zlib/libpng License
Curse link
InventorySQL
Downloads
31,054
Recent files

Authors