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

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

  1. Offline

    ThisIsAreku

  2. Offline

    Plague

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

    Lolmewn Retired Staff

    Like plague said, use build 953. It's recommended (in both ways).
     
  4. Offline

    ThisIsAreku

    Ok. Sorry. I've corrected
     
  5. Offline

    gamingvortex

    is there a web portal to read and edit?
     
  6. Offline

    ThisIsAreku

    Not for the moment, but I'm working on it
     
  7. Offline

    h0us3cat

    multiworld?
     
  8. Offline

    ThisIsAreku

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

    MaMaxGER

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

    tha d0ctor

    Awesome! I can't wait!
     
  11. Offline

    MaMaxGER

    ErroR
    Code:
    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
     
  12. Offline

    ThisIsAreku

  13. Offline

    o0AzzA0o

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

    MaMaxGER

    I dont finde the small php example.
     
  15. Offline

    ThisIsAreku

  16. Offline

    MaMaxGER

    I have this Error
    Code:
    [InventorySQL] Error at SQL INSERT Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'MSzymanskisql4.inventorysql' doesn't exist
    although the daatabase was created
     
  17. Offline

    ThisIsAreku

    hum, What you put in the 'table' option in the config file ?
     
  18. Offline

    Dec64

    Brilliant plugin, works perfect for me. Would be even more amazing when/if the web portal gets more features.
     
  19. Offline

    ThisIsAreku

    Thank you :)
    I'm still improving the web portal, as my minecraft server will use it too ;)
     
  20. Offline

    MaMaxGER

    Here is the config
    Code:
    db: MSz...
    host: localhost
    check-interval: 600
    table: InventorySQL
    user: MSz...
    pass: Pw...
    
     
  21. Offline

    ThisIsAreku

    @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
     
  22. Offline

    MaMaxGER

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

    noahwhygodwhy

  24. 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?
     
  25. Offline

    piousminion

    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?
     
  26. Offline

    DylanP

    This.

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

    Thanks!
     
  27. Offline

    ThisIsAreku

    @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
     
  28. Offline

    stirkage

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

    Code:
    [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
  29. Offline

    phito

    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...
     
  30. Offline

    ThisIsAreku

    @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