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

_ForgeUser9365300
- Join Date: 8/7/2012
- Posts: 16
- Member Details
#228 _ForgeUser9365300

View User Profile

Send Message

Posted Aug 26, 2012
great thx, it works now, but this happends to me now click me it happends when i put some new value to inventorysql_pendings table and after typing /ichk command with owner of pending item in game - or /invsql check thatPlayer - what should be id in inventorysql_pendings? can i add some value manually and leave id blank or it must be the same like some id in inventorysql_inventories table? (both of this are varchar 32)

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

View User Profile

Send Message

Posted Aug 26, 2012
@bladerik2

fixed in v 2.1.2, i've made a mistake on the sql.. missing parenthesis

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

View User Profile

Send Message

Posted Aug 26, 2012
hello, i have issue with mysql: click me tables inventorysql_inventories and inventorysql_pendings was created successfully but InventorySQL_enchantments throw mysql error

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

View User Profile

Send Message

Posted Aug 26, 2012
@Blackybecks

ok, redownload it (v 2.1.1) now it works :)

Rollback Post to Revision RollBack
_ForgeUser8863646
- Join Date: 5/8/2012
- Posts: 7
- Member Details
#224 _ForgeUser8863646

View User Profile

Send Message

Posted Aug 26, 2012
Sorry but I get same Errors with 2.0.0 and 2.0.1 and 2.1.0. Can somebody help?

Here the three errors: Click me

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

View User Profile

Send Message

Posted Aug 26, 2012
@Blackybecks

The error is caused by java, the plugin is compiled for java 7 and you have java 6 Download the version 2.1, it's for java6

Rollback Post to Revision RollBack
_ForgeUser8863646
- Join Date: 5/8/2012
- Posts: 7
- Member Details
#222 _ForgeUser8863646

View User Profile

Send Message

Posted Aug 26, 2012
Hello, I updated Bukkit and other Plugins. Then I updated SQLInventory and now I get an error :-/... Click me...

I hope someone can help?

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

View User Profile

Send Message

Posted Aug 26, 2012
@ThisIsAreku

Thanks, i will upload to my server when i restart (; If i find another bug, i will tell you, thanks for the fix <3

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

View User Profile

Send Message

Posted Aug 26, 2012
@rfsantos1996

First bug ;) It's when there is multiple enchantments for one item. Let me fix that.. EDIT: fixed in v 2.1

Last edited by _ForgeUser7441906: Aug 26, 2012

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

View User Profile

Send Message

Posted Aug 26, 2012
@ThisIsAreku

Oh, also, I got an error here, let me Pastebin. http://pastebin.com/ckmsqAK2 There we go (;

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

View User Profile

Send Message

Posted Aug 26, 2012
@rfsantos1996

I had a problem with Git, and the full changelog has disappear.. But mainly, all the mysql syntax has been reworked, and the support for the new xAuth was added. All the commands still the same

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

View User Profile

Send Message

Posted Aug 26, 2012
@ThisIsAreku

Where can I find the changelog? (;

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

View User Profile

Send Message

Posted Aug 25, 2012
@Keeper1975

the new v 2.0 fix this :)

Rollback Post to Revision RollBack

_ForgeUser8771655

Join Date: 4/20/2012
Posts: 10
Member Details

#215 Posted Aug 21, 2012

@ThisIsAreku :

I keep getting this errors when using xAuth 2.0.12+ (2.0.20 is the latest):

22.08 04:52:27 [Server] SEVERE at java.lang.Thread.run(Unknown Source)
22.08 04:52:27 [Server] SEVERE at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
22.08 04:52:27 [Server] SEVERE at alexoft.InventorySQL.database.SQLCheck.run(SQLCheck.java:112)
22.08 04:52:27 [Server] SEVERE at alexoft.InventorySQL.database.SQLCheck.checkPlayers(SQLCheck.java:138)
22.08 04:52:27 [Server] SEVERE at alexoft.InventorySQL.auth.OfflineMode.isPlayerLoggedIn(OfflineMode.java:78)
22.08 04:52:27 [Server] SEVERE java.lang.NoSuchMethodError: com.cypherx.xauth.xAuth.getPlyrMngr()Lcom/cypherx/xauth/PlayerManager;
22.08 04:52:27 [Server] SEVERE Exception in thread "Thread-16" 
22.08 04:52:27 [Server] SEVERE at java.lang.Thread.run(Unknown Source)
22.08 04:52:27 [Server] SEVERE at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
22.08 04:52:27 [Server] SEVERE at alexoft.InventorySQL.database.SQLBackup.run(SQLBackup.java:94)
22.08 04:52:27 [Server] SEVERE at alexoft.InventorySQL.auth.OfflineMode.isPlayerLoggedIn(OfflineMode.java:78)
22.08 04:52:27 [Server] SEVERE java.lang.NoSuchMethodError: com.cypherx.xauth.xAuth.getPlyrMngr()Lcom/cypherx/xauth/PlayerManager;
22.08 04:52:27 [Server] SEVERE Exception in thread "Thread-17" 
22.08 04:42:56 [Server] SEVERE at java.util.TimerThread.run(Unknown Source)
22.08 04:42:56 [Server] SEVERE at java.util.TimerThread.mainLoop(Unknown Source)
22.08 04:42:56 [Server] SEVERE at alexoft.InventorySQL.auth.OfflineMode.run(OfflineMode.java:100)
22.08 04:42:56 [Server] SEVERE at alexoft.InventorySQL.auth.OfflineMode.isPlayerLoggedIn(OfflineMode.java:78)
22.08 04:42:56 [Server] SEVERE java.lang.NoSuchMethodError: com.cypherx.xauth.xAuth.getPlyrMngr()Lcom/cypherx/xauth/PlayerManager;
22.08 04:42:56 [Server] SEVERE Exception in thread "Timer-0"

I know that it's not your code fault(*), but since i can't get in touch with this new xAuth author, could you please patch your v0.8.8 so to be compatible with this new xAuth plugin brand? or could you try and get in touch with him? or at least, could you put your pom.xml in your git source so that i could compare both codes and try to patch them myself? (btw...isn't your plugin project, a maven one? i ask you this because there's no pom.xml anywhere in your git...)

(*)Since CypherX left, luricos took control of xAuth plugin code 10 days ago and he has been changing quite a few things in its source...

EDIT: i've modified your source code, more precisely the getPlyrMngr() method, and renamed it to getPlayerManager(). By simply doing this, the problem was sorted out. If possible, update your git with that change.

Thank you

Regards,

Keeper

Last edited by _ForgeUser8771655: Aug 24, 2012

_ForgeUser41579
- Join Date: 9/30/2005
- Posts: 538
- Member Details
#214 _ForgeUser41579

View User Profile

Send Message

Posted Aug 16, 2012
"I've putted here a link" should be "I've put here a link" (sorry hehe).

Rollback Post to Revision RollBack
_ForgeUser9136945
- Join Date: 7/4/2012
- Posts: 60
- Member Details
#213 _ForgeUser9136945

View User Profile

Send Message

Posted Aug 9, 2012
@bladerik2

can u share with ur script? its pretty nice. I like the way how inventory is displayed. And btw, u can add user Equipment also ;) If u dont want to share it with us, can u just tell me how u made this data field readable? is this unserialize ?

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

View User Profile

Send Message

Posted Aug 7, 2012
if is something in mysql, everything is possible for my website :) thank u very much for great work! - here is example of user inventory http://www.mine-craft.sk/hraci/traktor/ - i'm currently worked on online quest for players on my server, script just check what player have in inventory and if his complete the rules he's automaticaly awarded - i see in config some update-events, it is possible to set auto interval for update? or even better, when player complete an online quest i can save a value to some db table and some listener update sql data of player when corresponding data is findet in that table? now is the data updated after user is logged out

Rollback Post to Revision RollBack
_ForgeUser8413476
- Join Date: 2/12/2012
- Posts: 261
- Member Details
#211 _ForgeUser8413476

View User Profile

Send Message

Posted Aug 6, 2012
@ThisIsAreku

I'm thinking of making a web gui for you (nice idea =D) but I am not sure if I have enough time and energy because of school and my little server :D and all these things. But I'm optimistic there is someone (mabye me when I'm bored) who could do that.

Rollback Post to Revision RollBack
_ForgeUser8413476
- Join Date: 2/12/2012
- Posts: 261
- Member Details
#210 _ForgeUser8413476

View User Profile

Send Message

Posted Aug 6, 2012
@Cackbone @ThisIsAreku

Thanks for your reply :)

Last edited by _ForgeUser8413476: Aug 6, 2012

Rollback Post to Revision RollBack

_ForgeUser9058764

Join Date: 6/19/2012
Posts: 197
Member Details

#209 Posted Aug 6, 2012

@ThisIsAreku How do i setup the mysql portion of the plugin, it keeps failing to connect to the database. user: InvList pass: is correct in spelling and capitalization, just not in your need to know basis db: InvList table: InventorySQL

here is the config:

check-interval: 600
after-login-delay: 1
check-plugin-updates: true
no-creative: true
multiworld: true
lightweight-mode: false
allow-unsafe-ench: false
debug: false
mysql:
  host: localhost:3306
  user: InvList
  db: InvList
  table: InventorySQL
backup:
  enabled: true
  interval: 600
  cleanup-days: 5
messages:
  no-modif: No modifications
  modif: '%s items added, %s items removed, %s items pendings'
  no-online: None of these players were online..
  check-n-players: Checking %s player(s)
  check-all-players: Checking all players...
  check-yourself: Checking yourself...
update-events:
- join
- quit
- changeworld
- respawn
- bedenter
- bedleave

Last edited by _ForgeUser9058764: Aug 6, 2012

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