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 TDB_South_Paw TDB_South_Paw Apr 18, 2014 at 10:36 UTC - 0 likes

    @manfie: Go

    Followed this, took a few attempts to get it right though.

    First time I deleted the whole contents of the file and that didn't work.

    Second I deleted all the 'comments' or lines starting with dashes still no luck.

    So I deleted only the ALTER lines beginning with dashes and left the rest of the CREATE.sql file as is. Added it back into the jar and loaded the server with this. Server loaded fine up fine!! Woohoo!

    @sync667: Go

    This has fixed the enderchest errors, thank you!

    Looks like you've both managed to fix the issues problems! You're both freaking awesome!! :3

    Last edited Apr 18, 2014 by TDB_South_Paw
  • Avatar of sync667 sync667 Apr 18, 2014 at 09:56 UTC - 0 likes

    @TDB_South_Paw: Go

    So at first get in to your config and change serializer to that

      serializer: 'tk.manf.InventorySQL.datahandling.serializer.BukkitSerializer'
    

    It will fix error with players. For second one i will look it too it and try help manfie, maybe its possibile to do auto fix. But at all this second one is not dangerous, for now i have it on all servers and everything is ok.

  • Avatar of manfie manfie Apr 18, 2014 at 08:54 UTC - 0 likes

    @TDB_South_Paw: Go

    The Startup-Error ( http://pastie.org/private/hqkwtfo7iywllfcw87lxua ) is pretty *easy* to fix. It's explained in issue 68: Open the Jar and search for the file CREATE.sql in the mysql folder. Delete all comments of the query and save the File. Restart your server then.

    I guess the second error is caused by echnanted items, which currently cause a bug too.

  • Avatar of TheLecturer TheLecturer Apr 18, 2014 at 08:51 UTC - 0 likes

    @TDB_South_Paw: Go

    Lol I'm not actually running it right now - I started setting it up on my test server, and then the whole UUID thing hit, so I've been trying to focus on that. Once I've got all my current plugins updated (or replaced, ugh) to UUID-compatible versions I'll come back to Inventory-SQL.

    Good luck with your issue / your players. I got hit by the Mojang inventory-wipe bug last weekend, so I know what you're going through!

  • Avatar of TDB_South_Paw TDB_South_Paw Apr 18, 2014 at 08:08 UTC - 0 likes

    @TheLecturer: Go

    Hi :D

    Might as well ask, what version of this plugin are you using and is it giving any errors?

    Last edited Apr 18, 2014 by TDB_South_Paw
  • Avatar of TheLecturer TheLecturer Apr 18, 2014 at 07:46 UTC - 0 likes

    @TDB_South_Paw: Go

    Nice to meet you TDB_South_Paw :)

  • Avatar of TDB_South_Paw TDB_South_Paw Apr 18, 2014 at 07:29 UTC - 0 likes

    @TheLecturer: Go

    That's totally fair and I totally agree with that statement.

    I was just really frustrated that information so vital was at the bottom of the page and it took 4 replies to get it sorted when it could've quite simply been one and saved me a huge headache. I do apologise though, cause I was really being a dick. Just frustrated that something so simple was made so hard.

    Regardless, I'm stuck on this next error and confused as all hell to what it means really. It appears whenever a player logs into the server.

    I spent some of today trying to jump back plugin versions (all the way back to v3.4.0) as I really need a version that works so I can get our server back up. Without InvSQL we're dead in the water as our whole server relies on the same inventory across 3 worlds.

    Meanwhile, I've got players being demanding at my heels as they always are *sigh* but sorry for passing that stress along the line... >_<

    Here's to hoping manfie can help me out here because java is out of my league. *raises glass*

  • Avatar of TheLecturer TheLecturer Apr 18, 2014 at 07:19 UTC - 1 like

    @TDB_South_Paw: Go

    You don't want to get into bitching yet you still throw an insult, so which is it?

    I am also not looking for a fight, it just winds me up when people complain on all these plugin pages. I think it's amazing that people give their stuff away for free and the whole community benefits from it, but we have no idea about people's personal circumstances and how much time they may or may not have to do stuff like this.

    Non-coding server owners (such as myself) should show some simple gratitude and acknowledgement of what we get for free. It's how I would like to be treated by the people who play for free on my server, doesn't happen that often. Sadly so much of what I see every day is "Your plugin sucks", "It's broke FIX IT" etc etc (and in know you didn't say that, just talking generally now).

    Anyway, don't know where I'm going with this, guess I'll go make some breakfast. Have a nice day everyone, and thanks manfie keep up the good work.

  • Avatar of TDB_South_Paw TDB_South_Paw Apr 18, 2014 at 02:20 UTC - 0 likes

    @TheLecturer: Go

    I'm not going to get into bitching with some random idiot off the internet about this. It's pathetic and beneath both of us. If you'd kindly mind your own business then I can get this issue fixed quicker and be outa manfies hair sooner.

    @manfie Apologies if you're pissed off with me, I just really think that message should be at the top, beside the download button, not the bottom. If it was then it would have saved us both a lot of frustration and wasted time.

    I'm being hounded by my players as to why their inventories are being constantly reset, this is my point of contact so I'd really appreciate it if you could help me out.

    I'm going to go wipe our inventory databases now and see if that fixes the issue.

    Edit: New error http://pastie.org/private/hqkwtfo7iywllfcw87lxua

    That error is from 3.4.0 SNAPSHOT 7 for reference.

    Last edited Apr 18, 2014 by TDB_South_Paw
  • Avatar of TheLecturer TheLecturer Apr 17, 2014 at 23:34 UTC - 0 likes

    @TDB_South_Paw: Go

    How about you stop whining like an ungrateful child for something you're getting for free and respect the fact that the dev might have more important things on his/her mind than your freeloading priorities? Everything on the Minecraft multiplayer community is offered and accepted "as is", take or leave it. If you don't like it, write your own, or take them to court for breach of contract, oh wait, you have no contract, best you shut up then or try saying "thank you" and "please", may you get further than "facepalm".

    Facepalm. Kids these days. No respect. No manners.

Facts

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

Authors