[MISC] InventorySQL - (copy) Player inventory on MySQL table [BukkitDev]

Discussion in 'Archived: Plugin Releases' started by ThisIsAreku, Jul 14, 2011.

  1. Offline


    title is missing description
    if you do not need 990 for some API , use a latest recommended build, not development one
  2. Offline


    Like plague said, use build 953. It's recommended (in both ways).
  3. Ok. Sorry. I've corrected
  4. Offline


    is there a web portal to read and edit?
  5. Not for the moment, but I'm working on it
  6. Offline


  7. hum, in facts I don't know.. I think no, but I can make it multiworld-compatible
  8. Offline


    thanks That I need for my userCP Thanks i would test it ;)
  9. Offline

    tha d0ctor

    Awesome! I can't wait!
  10. Offline


    org.bukkit.command.CommandException: Unhandled exception executing command 'invsql' in plugin InventorySQL v0.1
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:298)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:711)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:676)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:669)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:84)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
        at alexoft.InventorySQL.InventorySQLCommandListener.onCommand(InventorySQLCommandListener.java:35)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
  11. Offline


    very smart plugin hmm i guess i could hook this up for vip to buy ingame items
  12. Offline


    I dont finde the small php example.
  13. Offline


    I have this Error
    [InventorySQL] Error at SQL INSERT Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'MSzymanskisql4.inventorysql' doesn't exist
    although the daatabase was created
  14. hum, What you put in the 'table' option in the config file ?
  15. Offline


    Brilliant plugin, works perfect for me. Would be even more amazing when/if the web portal gets more features.
  16. Thank you :)
    I'm still improving the web portal, as my minecraft server will use it too ;)
  17. Offline


    Here is the config
    db: MSz...
    host: localhost
    check-interval: 600
    table: InventorySQL
    user: MSz...
    pass: Pw...
  18. @MaMaxGER : Ok, I've found the error. It's not your fault, I forgot to replace a variable in the code. Download the new version to fix it
  19. Offline


    Thank you. Now it is saved to the database, only if I will give it to me via the webinterfaceitems I get nothing ...
  20. Offline


  21. Code:
    at alexoft.InventorySQL.UpdateDatabase.UpdatePendings(UpdateDatabase.java:111)
    at alexoft.InventorySQL.UpdateDatabase.playerLogic(UpdateDatabase.java:87)
    at alexoft.InventorySQL.UpdateDatabase.run(UpdateDatabase.java:150)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Thread.java:636)
    What's the problem?
  22. Offline


    I'm a little unclear on how this works.

    Does it just load the inventories 1 way from .dat files to mysql and not from mysql to dat?
    Does it change the server where it ONLY reads and writes to mysql and skips *.dat files?
  23. Offline



    Developer, please @DylanP -msg- me in a post when you've answered this question.

  24. @DylanP @piousminion :

    This plugin write the contents of the inventory of each players into a mysql table, in a column named 'inventory'
    simultaneously, it reads the column 'pendings' of the same table and adds the items to the player's inventory.
    after that, the column 'Pending' is cleared

    But the server still use *.dat file to manage inventories, my plugin just "copy" the content of this dat files in the table, in a more exploitable way

    In my server, this plugin is used with iConomy for provide a "web store" of blocks
  25. Offline


    Nice plugin but just noticed the below in my server log.

    [SEVERE] Nag author: '<NoAuthorGiven>' of 'InventorySQL' about the following: This plugin is not properly shutting down its async tasks when it is being reloaded.  This may cause conflicts with the newly loaded version of the plugin
    For some reason I am also unable to give items. I can read inventory fine but when trying to give no items appear.

    Looking at the console I can see the plugin is reading the db and displays "[INFO] [InventorySQL] Pending items for stirkage". It then clears the pending column but no items are added.

    I have tried adding through the web and manually - same result.

    Running latest recommended bukkit. 953

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 17, 2016
  26. Offline


    Hi (sorry for my bad english, i'm french)

    I've no password on MYsql, and when I set 'pass: ' i've an error in the CMD console and it put 'pass: pass' into the config.
    15:55:47 [INFO] [MobBounty] Payment plugin was disabled.
    15:55:47 [INFO] [Citizens] Payment method disabled.
    15:55:47 [INFO] [iConomyChestShop] version 2.75 distabled!
    15:55:47 [INFO] [InventorySQL] Disabling...
    15:55:47 [INFO] [InventorySQL] Disabled !

    I hope you understand what i said...
  27. @phito
    (je suis français aussi :D)
    Essayez de mettre pass: '' (deux ' ) dans la configuration

    try to put pass: '' (two ' ) in the configuration

Share This Page