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
#289 _ForgeUser6935150

View User Profile

Send Message

Posted Sep 1, 2012
@netpy44o

Wow, and if the guy mined 848x64 of cobblestone?

Rollback Post to Revision RollBack
_ForgeUser9482478
- Join Date: 8/28/2012
- Posts: 7
- Member Details
#288 _ForgeUser9482478

View User Profile

Send Message

Posted Sep 1, 2012
I have a suggestion. I wanted this plugin very much and my dreams come to alive! :) It will be good if plugin could collect information about ALL crafted/mined/taked resources in all server cycle. For example: wipe on server, I can give all crafted or mined items/blocks to players :) it will be very well!!! :)

Trully yours

Last edited by _ForgeUser9482478: Sep 1, 2012

Rollback Post to Revision RollBack
_ForgeUser6484847
- Join Date: 2/21/2011
- Posts: 3
- Member Details
#287 _ForgeUser6484847

View User Profile

Send Message

Posted Sep 1, 2012
Can someone post a example php based system to send and remove items from users? have tested the web portal from github.

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

View User Profile

Send Message

Posted Sep 1, 2012
@rfsantos1996

The same version must be installed on both, and both must have mirror-mode: true Then login, a message should appear saying that inventories are syncing. And after, a second message when sync is done

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

View User Profile

Send Message

Posted Sep 1, 2012
@ThisIsAreku

When mirror mode is running, I join my server, edit inventory for tests, go to my 2nd server and its the same, i need wait to update or something like this?

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

View User Profile

Send Message

Posted Sep 1, 2012
@rfsantos1996

Yeah, I understand the word but I didn't understand why ;) but I've found, I forgot some debug code.. now it's fixed

It's a new feature, so there may be bugs.. Please fill up a ticket when you find errors

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

View User Profile

Send Message

Posted Aug 31, 2012
@ThisIsAreku

"flooded" is the same as flood, spam (spammed) Also, thanks for the update, and sorry for bad english. I need to setup my MySQL to accept connections (that arent from localhost), right? @EDIT: I get it, but when i edit my inventory on 2nd server, it dont update on 1st, and sometimes the console show some MySQL runs

Last edited by _ForgeUser6935150: Aug 31, 2012

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

View User Profile

Send Message

Posted Aug 31, 2012
@rfsantos1996

Yes, that's it :)

Edit: flooded ?

Edit 2 :OOOOh... debug switch :D pulling an updated

Edit 3 : fixed in v 2.2.2 ;)

Last edited by _ForgeUser7441906: Aug 31, 2012

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

View User Profile

Send Message

Posted Aug 31, 2012
@ThisIsAreku

Basicly, mirror mode is 1 inventory for 2 or more servers connected to 1 MySQL Server? Nice feature... (; @EDIT: Also, i tried this feature, InvSQL flooded me with MySQL runs ):

Last edited by _ForgeUser6935150: Aug 31, 2012

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

View User Profile

Send Message

Posted Aug 31, 2012
@RG_PankO

Unfortunately not, for the moment it's just the 'base system', you have to develop yourself a web script :/

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

View User Profile

Send Message

Posted Aug 31, 2012
@rfsantos1996

Error fixed in 2.2.1 :)

Rollback Post to Revision RollBack
_ForgeUser5793549
- Join Date: 10/10/2010
- Posts: 6
- Member Details
#278 _ForgeUser5793549

View User Profile

Send Message

Posted Aug 31, 2012
"allowing it to be displayed on a website, and edited to add/remove items" Can we get an example script? Is there a developed javascript manipulator or something that we could get from somewhere?

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

View User Profile

Send Message

Posted Aug 30, 2012
I got an error here http://pastebin.com/UuJxFD1d latest version of everything (; @EDIT: pastebin updated with more bugs

Last edited by _ForgeUser6935150: Aug 30, 2012

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

View User Profile

Send Message

Posted Aug 30, 2012
@BioBG

What version are you using ?

I have no time to do the webinterface, I'm already working on 3 websites, I'm a bit lost between 3 differents codes..

Rollback Post to Revision RollBack
_ForgeUser7556749
- Join Date: 9/16/2011
- Posts: 158
- Member Details
#275 _ForgeUser7556749

View User Profile

Send Message

Posted Aug 30, 2012
hi :)
i thing u know about this -> http://pastie.org/4616919

will it be soon update the web interface ?

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

View User Profile

Send Message

Posted Aug 30, 2012
@webshoptv

I have no time to make a script, but maybe later, when the plugin will be ready

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

View User Profile

Send Message

Posted Aug 30, 2012
@UltraMC

mirror-mode isn't ready yet, it's a feature to sync inventories across bukkit servers. check Configuration

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

View User Profile

Send Message

Posted Aug 30, 2012
@rfsantos1996

Yes, strange bug with bukkkit. I register for PlayerDeathEvent, and craftbukkit send to me EntityDeathEvent. Update is ready, 2.1.10 soon

Rollback Post to Revision RollBack
_ForgeUser8287664
- Join Date: 1/20/2012
- Posts: 61
- Member Details
#271 _ForgeUser8287664

View User Profile

Send Message

Posted Aug 30, 2012
Wtf is mirror mode etc? Post configuration instructions!

Rollback Post to Revision RollBack
Gamerboy59
- Join Date: 3/17/2012
- Posts: 156
- Member Details
#270 Gamerboy59

View User Profile

Send Message

Posted Aug 30, 2012
Would you be so nice and add a script, where I just have to fill out the DB_infos and upload it to my webspace?
Thx.

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