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 Feb 1, 2013So, another new issue:
In mirror mode, when you die, it doesn't sync your inventory. Then going to another server you have your inventory from before you died on that server. When you go back to the first server your inventory will be whatever it was before you switched to Server 2.
tl;dr if you die servers go out of sync.
-
View User Profile
-
Send Message
Posted Feb 1, 2013Can you have per world inventories only or can you also group worlds together to one inventory? I have a creative and a survival map and would not like to let'em share between them.
-
View User Profile
-
Send Message
Posted Jan 31, 2013<<reply 1225470="">>
Info of this issue can be found here
Anyone who wants to use mirror mode, disable backups and it'll work.
-
View User Profile
-
Send Message
Posted Jan 27, 2013@sebastian2443
I have this problem as well. i also use BungeeCord. I've used this before the last few updates when we converted over to bungeecord and it worked, dupe problems but it worked. was hoping to give it another shot since the update. kudos.
-
View User Profile
-
Send Message
Posted Jan 27, 2013@Northcodedotno
Most people on here downloading plugins for there server dont know any coding, other wise they would be making there own plugins. No where on the page does it say you have to program your own php for this. Thats kinda misleading. If someone who is acutally kind could make us the web portion to view this, that would be very appreciated by, im sure, more then just me.
-
View User Profile
-
Send Message
Posted Jan 26, 2013Salut, j'utilise la version beta build 1.4.7 r0.2 (la 2615) et la version Version 2.5.2 de votre plugins.
cette erreur apparaît :
http://pastebin.com/jhtHLCZd
Je suis repasser a la 2.5.1. Pas de soucis avec cette version.
Cordialement.
-
View User Profile
-
Send Message
Posted Jan 26, 2013Running latest InvSQL build (2.5.2) and CB 1.4.7-R0.1. I have take your recommendation (Multiworlds same names, mirrored: true) But nothing seems to work. No sync between the servers. The Servers running in offline mode. I also use BungeeCord. All invsql config's use the same SQL database and table. No exceptions in the server.log.
I've been looking quite a while for a plugin which is able to synchronize the inventory between servers.
Maybe u have a idee to fix the problem? :) Would be nice Have a nice day. greetz.
-
View User Profile
-
Send Message
Posted Jan 25, 2013Running latest InvSQL build and CB 1.4.6-R0.3. Nothing seems to sync between servers. Note: I run in offline mode as I use BungeeCord, would this cause an issue?
-
View User Profile
-
Send Message
Posted Jan 24, 2013@Ichaelus
@UbuntuFreak
clarification about players.txt : This small file is a cache to prevent the plugin from making useless queries on the mysql server. You can delete it, you won't loose anything.
the user id is a field in mysql which has the AUTO_INCREMENT option, so when a row is added, the id will be incremented regardless of the actual number of row
One solution would have been to re-add a user with the id and the name of the row which has been removed.
But deleting the tables (not TRUNCATE, but DROP) will often be the solution x)
-
View User Profile
-
Send Message
Posted Jan 19, 2013@Ichaelus
Two days for replying is not too late because I also have a lot to do :) Yesterday I connected the newest build of InventorySQL to an old (1.x) database and also has a problem. Then, after a short while of searching, I noticed there is a players.txt file in the plugins/InventorySQL directory. Maybe you will need to delete your name out of it. Otherwise and if the data in the database are not that important the easiest way is to delete everything excluding the config.yml file and to purge the database (all InvSQL databases)...
But 570 players, that's a lot - I have about 30 or so what reduces the database load a lot Hope I could help you :)
-
View User Profile
-
Send Message
Posted Jan 18, 2013@UbuntuFreak
I had realy a lot to do in the last two days, which made me answer this late. Thank you vor giving me hints for solving the problem, but it's still there. The 'easy way' with an relogin didn't worked, no changes where made in the database. I tried the second version too and deleted every content of each db table, but something really strange happened: After re-starting the server with the clean database, the plugin contiued to add new users to the database (starting with the numer 570, which was the last one of the old db) and it didn't took care about the users who where in the old database.
I know, it sounds really misterous..does your plugin use a local file to save the names of checked members? It would be the only solution which came in my mind.
Thanks again, Ichaelus
-
View User Profile
-
Send Message
Posted Jan 16, 2013@Ichaelus
That's strange. Maybe if you relogin to the server it'll check if there is an account with your name.
Otherwise you may try this (make a backup before modifing anything) : - Disable InvSQL to make sure there are no interactions with the database - Open up the player list table and write down the numbers. - Open up the other tables and delete the rows having an 'owner' number that's not in your list. - Enable InvSQL again :) I did not test this way because I did not have this problem in the past but please let me know if it worked or not
-
View User Profile
-
Send Message
Posted Jan 15, 2013Does this feature check their "Entire Iventory" including all the items they have stored in various chests? Anyone have a working solution to this?
Thanks
-
View User Profile
-
Send Message
Posted Jan 14, 2013Hey guys, I'm here again with a little problem. I've almost finished it to code a web-item-shop, but while I was doing some experimences with the Pending table I made a mistake by deleting the row of my account in the users table.
Everything I tried to re-add my character to the plugin failed totaly, manual adding and reloading the plugin or deleting the player.data from the local world didn't brang a solution. Is there any possibility to re-add me to the list of recordet players?
My second problem is the pending table. If I add some rows there manually, they won't get worked off when the selected user is loggin into the game or even with the /invsql check command.
I hope you understand my problem and can help me.
Thank you,
Ichaelus
-
View User Profile
-
Send Message
Posted Jan 13, 2013i can't get pass the password login on the first page, it wont accept.
-
View User Profile
-
Send Message
Posted Jan 8, 2013Hey The multiservers works great. Transporter lacks the ability and i need people to be able to walk through the portals with thier inventorys and this plugin as an addon is great! Sadly enough though i will need an addon for this and im searching for a plugin to prevent multilogging on both of my servers. With multilogging people can easily dupe with this plugin:/ If you could add this it would be Amazing. Only sad part is im not going to be able to use it as my bukkit is 1.2.5 and same with most other servers with multi server support since it has the mod built into tekkit.
-
View User Profile
-
Send Message
Posted Jan 4, 2013Is it possible to manage inventories per world or does it support MultiverseInventories?
-
View User Profile
-
Send Message
Posted Jan 4, 2013@vicente947
You have to make it by yourself :P. That's the point about SQL. If you can't program PHP and HTML then this is not for you.
-
View User Profile
-
Send Message
Posted Jan 3, 2013How i can see WebInterface?
Sorry if im that stupid question but i dont know how to see it.
-
View User Profile
-
Send Message
Posted Jan 3, 2013Salut ThisIsAreku J'utilisais la version 2.5 et cette erreur est apparu. Je ne sais pas si celle ci est importante mais je préfère vous la faire parvenir vue que la ligne "- please send line below to the dev -" est présente je fais donc ce que la console me dit :p Voila, merci a vous.
18:37:15 [SEVERE] [InventorySQL] an unexpected error has occured 18:37:15 [SEVERE] [InventorySQL] please send line below to the dev 18:37:15 [SEVERE] [InventorySQL] InventorySQL version 2.5 18:37:15 [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.4.6-R0.3-b2586jnks (MC: 1.4.6) 18:37:15 [SEVERE] [InventorySQL] Message: Cannot do backup 18:37:15 [SEVERE] [InventorySQL] java.lang.NullPointerException : null 18:37:15 [SEVERE] [InventorySQL] fr.areku.InventorySQL.database.CoreSQLProcess.getConnection(CoreSQLProcess.java:164) 18:37:15 [SEVERE] [InventorySQL] fr.areku.InventorySQL.database.SQLBackup.updateConn(SQLBackup.java:56) 18:37:15 [SEVERE] [InventorySQL] fr.areku.InventorySQL.database.SQLBackup.run(SQLBackup.java:67) 18:37:15 [SEVERE] [InventorySQL] org.bukkit.craftbukkit.v1_4_6.scheduler.CraftTask.run(CraftTask.java:53) 18:37:15 [SEVERE] [InventorySQL] org.bukkit.craftbukkit.v1_4_6.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) 18:37:15 [SEVERE] [InventorySQL] java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) 18:37:15 [SEVERE] [InventorySQL] java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 18:37:15 [SEVERE] [InventorySQL] java.lang.Thread.run(Unknown Source)