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

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

  1. Offline

    Jonchun

    I'll make sure to post here when I'm done!
     
  2. Offline

    asterious

    Hi. This really great plugin, but i have some problems. When i put in "pendings" column [+(264:0)x10] - its ok, BUT when u put in same column [-(264:0)x5] - its dont work. I tried it on 2 servers...

    Have an ideas?
     
  3. Offline

    olimoli123

    21.08 01:57:08 [Server] SEVERE at java.lang.Thread.run(Thread.java:636)
    21.08 01:57:08 [Server] SEVERE at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    21.08 01:57:08 [Server] SEVERE at alexoft.InventorySQL.UpdateDatabase.run(UpdateDatabase.java:199)
    21.08 01:57:08 [Server] SEVERE at alexoft.InventorySQL.UpdateDatabase.playerLogic(UpdateDatabase.java:119)
    21.08 01:57:08 [Server] SEVERE java.lang.NullPointerException
    21.08 01:57:08 [Server] WARNING [InventorySQL] Error at SQL Query: No operations allowed after connection closed.Connection was implicitly closed by the driver.
    21.08 01:57:08 [Server] SEVERE at net.minecraft.server.NetworkWriterThread.run(SourceFile:116)
    21.08 01:57:08 [Server] SEVERE at java.io.DataOutputStream.flush(DataOutputStream.java:123)
    21.08 01:57:08 [Server] SEVERE at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
    21.08 01:57:08 [Server] SEVERE at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
    21.08 01:57:08 [Server] SEVERE at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
    21.08 01:57:08 [Server] SEVERE at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:116)
    21.08 01:57:08 [Disconnect] User benman97 has disconnected, reason: disconnect.quitting
    21.08 01:57:08 [Server] SEVERE java.net.SocketException: Socket closed
     
  4. Yes, I forgot to uncomment a line ...
    I think now it works.

    fixed (I think)
     
  5. Offline

    asterious

    Again problems...

    http://178.171.83.20:280/mysql.png

    As u can see, there show me that Connection successfull, but when any player login - new error
    18:16:36 [SEVERE] [InventorySQL] MySQL Connection error..
     
  6. Offline

    DylanP

    Hey,

    Just a question :)

    Is this going to give me any performance increase or decrease?

    I'm thinking of using this plugin, but, does it still save to the player.dat files? If so, what's the point in using this plugin?
     
  7. Offline

    _Hayleigh_

    I waited 2 weeks for reply so Im going to ask again hehe,

    Is there any way to make it load the inventory to the flat file when the server starts so that if the server crashes the invetorys are not rolled back to the old flat file but instead to the up to date SQL ?
     
  8. Offline

    Vairen

    (#1060) With version 0.3.3 was ok.. But with 0.3.3.4
    2011-08-23 16:42:50 [SEVERE] [InventorySQL] MySQL Connection error..
     
  9. Offline

    Adrenaline

    11:31:53 [SEVERE] [InventorySQL] MySQL Connection error..
    omg ...
     
  10. Offline

    Minecraft4all

    Xarias09 likes this.
  11. Offline

    Vairen

  12. Offline

    Adrenaline

  13. Offline

    Minecraft4all

    Great, im glad i can help you:D

    No problem mate. Just help eachother;)

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

    Schlumpf

    Hi,
    in the new Version, did you changed something on the web interface or is it still the same?
     
  15. The webinterface will not be improved. It's not my aim.
     
  16. Offline

    Schlumpf

    Ok, thats good :) Then I don't must update it
     
  17. Offline

    _Hayleigh_

    Any way to make inventorys load from the sql and save to the flat file when the server starts?
     
  18. Offline

    olimoli123

    25.08 02:48:40 [Server] SEVERE at java.lang.Thread.run(Thread.java:636)
    25.08 02:48:40 [Server] SEVERE at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    25.08 02:48:40 [Server] SEVERE at alexoft.InventorySQL.UpdateDatabase.run(UpdateDatabase.java:202)
    25.08 02:48:40 [Server] SEVERE at alexoft.InventorySQL.UpdateDatabase.playerLogic(UpdateDatabase.java:122)
    25.08 02:48:40 [Server] SEVERE java.lang.NullPointerException
    25.08 02:48:40 [Server] WARNING [InventorySQL] Error at SQL Query: No operations allowed after connection closed.Connection was implicitly closed by the driver.
    25.08 02:48:40 [Disconnect] User geko014 has disconnected, reason: disconnect.endOfStream
    25.08 02:48:40 [Server] SEVERE at net.minecraft.server.NetworkWriterThread.run(SourceFile:116)
    25.08 02:48:40 [Server] SEVERE at java.io.DataOutputStream.flush(DataOutputStream.java:123)
    25.08 02:48:40 [Server] SEVERE at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
    25.08 02:48:40 [Server] SEVERE at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
    25.08 02:48:40 [Server] SEVERE at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
    25.08 02:48:40 [Server] SEVERE at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:116)
    25.08 02:48:40 [Server] SEVERE java.net.SocketException: Socket closed



    Same error?

    Btw, ill be implementing paypal with inventory sql quite soon, ill post an example for you to use if you wish

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 17, 2016
  19. and ? I said that the web part is just an EXAMPLE, not for production use
     
  20. Offline

    olimoli123

    Just wondering, what does this error mean? sorry for being a pain

    25.08 02:48:40 [Server] SEVERE at java.lang.Thread.run(Thread.java:636)
    25.08 02:48:40 [Server] SEVERE at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    25.08 02:48:40 [Server] SEVERE at alexoft.InventorySQL.UpdateDatabase.run(UpdateDatabase.java:202)
    25.08 02:48:40 [Server] SEVERE at alexoft.InventorySQL.UpdateDatabase.playerLogic(UpdateDatabase.java:122)
    25.08 02:48:40 [Server] SEVERE java.lang.NullPointerException
    25.08 02:48:40 [Server] WARNING [InventorySQL] Error at SQL Query: No operations allowed after connection closed.Connection was implicitly closed by the driver.
    25.08 02:48:40 [Disconnect] User geko014 has disconnected, reason: disconnect.endOfStream
    25.08 02:48:40 [Server] SEVERE at net.minecraft.server.NetworkWriterThread.run(SourceFile:116)
    25.08 02:48:40 [Server] SEVERE at java.io.DataOutputStream.flush(DataOutputStream.java:123)
    25.08 02:48:40 [Server] SEVERE at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
    25.08 02:48:40 [Server] SEVERE at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
    25.08 02:48:40 [Server] SEVERE at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
    25.08 02:48:40 [Server] SEVERE at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:116)
    25.08 02:48:40 [Server] SEVERE java.net.SocketException: Socket closed
     
  21. Offline

    vinny8978

    hi I am trying to use an external mysql database, which is on another pc on the same network (192.168.0.10)

    my config:
    server error:
     
  22. Offline

    tinez

    Hello ThisIsAreku,

    This plugins works great with mysql. But i want to share inventory between 2 servers.
    When i join the first, my inventory is actually store in the DB, but when i join the other, no update. i finally keep different inventory on each server :( .
    (Same config, same db, both server have the plugins)

    Is it normal or i need to do something?

    thx
     
  23. It's normal, because the plugin doesn't load the inventory from mysql. It copy the minecraft flatfile to mysql, and not the reverse
     
  24. Offline

    decoycatfish

    I'm *very* interested in this, would it be difficult to do?
     
  25. it's absolutely not the aim of the plugin, but maybe later, why not.. ;)
     
  26. Offline

    olimoli123

    Keeping this updated?
     
  27. Offline

    forceserver

    is this plugin change data in config.inc.php only ??
    in case this plugin change mysql.inc.php??



    --------------------------------------------------------------------------
    mysql plugin folder
    inventorySQL/config.yml
    db: linux
    host: localhost
    check-interval: 600
    table: InventorySQL
    user: root
    pass: **************
    ------------------------------------------------------------------------------------
    my web folder var/www/web/config.inc.php
    <?php
    /* configuration */
    $host = 'localhost';
    $user = 'root';
    $pass = '**************';
    $database = 'linux';
    $table = 'inventorysql';
    ?>

    i changed
    am i change that more ?


    -----------------------------------------------------------------------

    66666666666666.png



    is this worked ??​
     
  28. Offline

    LaZzA

    Just thought the creator of this mod might like to see what the Front-End is capable of with some proper HTML formatting and PHP coding :)

    Inventory.jpg
     
  29. Offline

    themradamus

    pls make a tutorial i hate sql ;D
     
  30. Offline

    tyrantelf

    I'm going to try to make a much more extensive frontend so peple can buy blocks from our website and then money will be taken off their iconomy account from the iconomy database. I'f I get it working right, I'll toss a link onto your thread here
     

Share This Page