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

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

  1. Offline

    tha d0ctor

    please release the php ;)
     
  2. Offline

    pandapipino

    can anyone verify if this works on rb 1185?
     
  3. It works with 1185...

    I cant add items to any inventory :S
    I can look from website into inventories, but cant add items there.
    But when I wrote sth in the pendings column, it works.
     
  4. Offline

    rbos

    On 1185, I tried various values of stuff (trying to dump LocalShop's old database to players).

    Giving myself 65 cobble gives me .. a stack of 65 cobble.

    Giving myself 2000 cobble gives me no cobble at all.
     
  5. Offline

    rbos

    If you ever read this again, inventorySQL could be improved with a different SQL schema.

    Two tables: inventory, and pending.

    Inventory and pending should have 'player', 'id', 'meta', and 'qty' as fields. Qty can be negative. If you want, you can have a "stacks" field.

    This way a player doesn't have to have to have been logged in to have entries in the "pending" table, they'll just get it when they're around.

    Also, this lets you have as many stacks as you want in the pending table, not limited to 1024 characters in a text field.

    It'd simplify the program logic too.

    If I ever have a good reason to, I'll rewrite it myself. It's got a lot of promise.
     
    ShadowDrakken likes this.
  6. Offline

    MaMaxGER

    pls someone upgrade it :)
     
  7. Offline

    ShadowDrakken

    I believe the game has a hard limit of 128 in a stack
     
  8. The whole freakin server should be database based, inventory, entities, players. Too bad this plugin's a bit old, I'll try to update it but going further, with real sql schemes.
     
  9. Offline

    Pr07o7yp3

    Please, update this for 1.0.1 :)
    Thanks.
     
  10. Offline

    deregudegu

    Hi,

    Could you update this plugin for 1.0.1 or 1.1.

    Thank you.
     
  11. Offline

    Stumblinbear

    Oh... My... Porking... God...
    WHERE'S THE DOWNLOAD LINK!
     
  12. Offline

    DragonWerewolf

  13. Offline

    Stumblinbear

    can you please re-upload the php example...
     
  14. okay, soon :)
    EDIT: download here : http://j.mp/AgkXUZ
     
  15. Offline

    bonani

    @ThisIsAreku, keep getting the error "plugin.yml does not exist". Is it something i need to create by myself?
     
  16. I've tested, the file is automatically created. what is your OS ?
     
  17. Offline

    bonani

    @ThisIsAreku, I'm using Windows 7.
     
  18. strange.. For me it is working..
     
  19. Offline

    bonani

    Can you please submit the folder-structure and a default-file for me instead? To try it out.
     
  20. into 'plugins', make a folder 'InventorySQL', and in this folder, a file name 'config.yml' :
    Code:
    check-interval: 600
    verbosity: 3
    mysql:
      host: localhost
      user: root
      pass: ''
      db: test
      table: InventorySQL
     
  21. Offline

    bonani

    @ThisIsAreku, thanks but it doesnt solve the problem. The error is "Could not load InventorySQL.jar. The jar-file doesnt contain a plugin.yml".
     
  22. Oh.. I see.. Compilation error ^^' I'll solve it tomorrow (it is 0:13 for me xD)
     
  23. Offline

    bonani

    @ThisIsAreku, thanks! Please mark me in your next comment when you solved it, so I dont miss out on your reply :)
     
  24. It works now ! ;)
     
  25. Offline

    bonani

  26. Offline

    DragonWerewolf

    Where can i get inventrySQL for 1.0.0?
     
  27. Offline

    blackhawk185

    You'r English is ok :D
     
  28. Offline

    bladerik

    if you need to log inventory you can do this easily with this great plugin and mysql triggers
    first you need to create new table for example some like this
    http://pastebin.com/6xHVZcga
    then just create 2 triggers in table of plugin (propably InventorySQL or table u set in config)
    http://pastebin.com/8AgN9T2y
    http://pastebin.com/z1FMnuU8
    hope it helps and sry for my english :)
    if something bad happends, you can restore player inventory with this plugin http://forums.bukkit.org/threads/ad...conomy-money-from-mysql-to-player-1000.24525/
    i'm just working on script that converts data from log table to redeem syntax and paste it to redeem table and after this can user easily restore his inventory with /redeem command . user just select some date from web and pay with iconomy $ (/money) from /jobs for restoring inventory to any date :)
     
    ThisIsAreku likes this.
  29. Thank you ! I didn't know this trick. It will be very useful for the new version.. ;)
     
  30. Offline

    Varocarrascosa

    Hi, I would like to talk to you by Skype: Add Alfyelen
    Thanks.
     

Share This Page