InventorySQL
  |
|
|---|
I n v e n t o r y S Q L
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
- Addons
- Installation
- Configuration
- Localisation
- Frequently Asked Questions (FAQ)
- For Developers (API)
- Special Thanks
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
Links
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 Owner
-
_ForgeUser7441906 Former Author
-
View User Profile
-
Send Message
Posted Aug 15, 2013@manfie
I dont get these errors when mysql inventory is not installed
I removed mysql inventory and everything is fine.
Is it maybe not compatible with combatlog?
On both servers with mysql inventory i get the same errors and one of those servers dosnt have combatlog
-
View User Profile
-
Send Message
Posted Aug 15, 2013@JohnyK9
I don't think this is related to InventorySQL, although this is a bad log. Lots of unknown commands. at com.jackproehl.plugins.CombatLog$3.publish(CombatLog.java:594)
-
View User Profile
-
Send Message
Posted Aug 15, 2013This is what i get as soon as i move to another server with the plugin:
pastebin.com
-
View User Profile
-
Send Message
Posted Aug 15, 2013@JohnyK9
You do not acess the Database from the Web. You just give InvSQL the connection information.
The Server ID is just any ID you wish it cannot be 'found'. The Instruction itself are quite clear.
Just use the exactly same ID to enable syncronisation between these particular servers.
-
View User Profile
-
Send Message
Posted Aug 15, 2013jdbc:mysql://[HOST]:[PORT]/[DATABASENAME]?user=[USER]&password=[PASS]
A little confused about this part. I know im suppose to put my database info here, i got that much. But i dont know how to access it from the web. And one other thing im not clear on is this part:
serverID: The ID of the ServerNetwork, which are using the same syncronisation. (Will be md5-hashed) Just use the exactly same ID(case-sensitive) to enable syncronisation between these particular servers.
Where exactly do i find my serverID?
The instructions arent very clear.
-
View User Profile
-
Send Message
Posted Aug 15, 2013@riking
@Tendrid
3.0c includes the latest fixxes.
-
View User Profile
-
Send Message
Posted Aug 15, 2013-
View User Profile
-
Send Message
Posted Aug 14, 2013I dont know if this is a known bug, but InventorySQL does not attempt to reconnect on a failed query when the server "goes away". I have a forced timeout on my mysql server which is killing the plugins connection due to inactivity of login / logout events. Once a user logs out, in the console i see a SQL error stating that the connect was lost, and its reestablishing the connect, but it never re-fires the query. This results in inventory changes not being logged, and the ability to dupe items. I am forced to disable this plugin until this problem is fixed :(.
-
View User Profile
-
Send Message
Posted Aug 2, 2013@Phyore
Currently this does not support Multi Worlds, as of synchronizing different Worlds is not possible yet. You can only set one Server ID yet. A Backup feature is not yet implemented, but you can backup the entire database yourself.
-
View User Profile
-
Send Message
Posted Aug 2, 2013Also is theree any chance for a backup feature?
-
View User Profile
-
Send Message
Posted Aug 2, 2013Does this support multi world? As on one of my servers 3 of the worlds have different inventories?
-
View User Profile
-
Send Message
Posted Jul 31, 2013@Tendrid
The new Version uses prepared Statements, which should basically escape any single quote given.
-
View User Profile
-
Send Message
Posted Jul 30, 2013Does this new version fix the SQL Injection errors in the old 2.x version? ie: having an item called "My fight'n sword" breaks the SQL because the single quote isnt escaped.
-
View User Profile
-
Send Message
Posted Jul 22, 2013@dfdgsdfg
http://dev.bukkit.org/bukkit-plugins/inventorysql/tickets/37-saving-the-contents-of-enderchest/
-
View User Profile
-
Send Message
Posted Jul 22, 2013@manfie
can you support ender chest?
-
View User Profile
-
Send Message
Posted Jul 22, 2013@PassWordE
If you have problems with synchornizating inventories please create a ticket. /edit: Please dont forget to add as much information as possible.
-
View User Profile
-
Send Message
Posted Jul 22, 2013when I cross server, the inventory not synchronization...I tried many times...
-
View User Profile
-
Send Message
Posted Jul 18, 2013@cky2250
You should give me more detail. This error seems to be an error, while you try to create your database? Actually those databases are connected through foreign keys. My Plugin does not create or link those databases. YOU are supposed to create the database. You have an error in your script you had applied to the database and please create a TICKET for issues, comments are not for bugs.
-
View User Profile
-
Send Message
Posted Jul 18, 2013@manfie
That is for you to find out. Have you used your plugin with a different database? It is like you have "REFERENCES `mydb`.`player` (`id`)" as a static database.
-
View User Profile
-
Send Message
Posted Jul 17, 2013@cky2250
If you changed the database, why's there still
@jobject
The first save-message is send before saving the other afterwards. This timing issue has caused me alot of trouble, but i think i'll add a API to prevent this. Just all Servers should know this instantly. (eg. forwarding a direct Message to the plugin, by using your proxy) I'll add this to 3.1's roadmap.
@Ichaelus
Thanks ;)