Spigot PlayerSQL 2.12.3

Synchronize data between servers.

  1. hello,i have a question,if it is that restore players' informations(item,hp,exp and so on) into world folder will cause some lag?
    is there some ways to restore them with mysql instead of using playerdate folder?
     
  2. Anyway to get support for ranks?
     
  3. Added latest version instead of 1.9 : iinventory empty and this in the console :
    Code (Text):
    [00:24:35] [Server thread/WARN]: [PlayerSQL] Task #6659 for PlayerSQL v1.10.1 generated an exception
    java.lang.NullPointerException
            at com.mengcraft.playersql.TimerSaveTask.run(CheckTask.java:84) ~[?:?]
            at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftTask.run(CraftTask.java:71) ~[spigot.jar:git-Spigot-870264a-0a645a2]
            at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350) [spigot.jar:git-Spigot-870264a-0a645a2]
            at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:720) [spigot.jar:git-Spigot-870264a-0a645a2]
            at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:368) [spigot.jar:git-Spigot-870264a-0a645a2]
            at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:651) [spigot.jar:git-Spigot-870264a-0a645a2]
            at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:554) [spigot.jar:git-Spigot-870264a-0a645a2]
            at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]
     
     
  4. This plugin doesn't directly modify the playerdata folder. It IS using MySQL for data storage.
     
  5. caoli5288 updated PlayerSQL with a new update entry:

    Update to 1.11

    Read the rest of this update entry...
     
  6. NotoriousNemo

    Supporter

    Im using version 1.10.3
    and it is working just fine. I havn't tried the 1.11 update
     
  7. NotoriousNemo

    Supporter

    I spoke too soon about no bugs.
    I have just installed this plugin today and it was working for about 30 minutes before this error spammed the console.

    [16:31:02] [Server thread/WARN]: [PlayerSQL] Task #12 for PlayerSQL v1.10.3 generated an exception
    java.lang.NullPointerException
    at com.mengcraft.playersql.task.TimerCheckTask.checkKick(TimerCheckTask.java:73) ~[?:?]
    at com.mengcraft.playersql.task.TimerCheckTask.run(TimerCheckTask.java:50) ~[?:?]
    at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftTask.run(CraftTask.java:71) ~[spigot.jar:git-Spigot-2ec6f06-7722428]
    at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350) [spigot.jar:git-Spigot-2ec6f06-7722428]
    at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:720) [spigot.jar:git-Spigot-2ec6f06-7722428]
    at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:368) [spigot.jar:git-Spigot-2ec6f06-7722428]
    at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:651) [spigot.jar:git-Spigot-2ec6f06-7722428]
    at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:554) [spigot.jar:git-Spigot-2ec6f06-7722428]
    at java.lang.Thread.run(Thread.java:745) [?:1.8.0_25]
    [16:31:02] [Server thread/WARN]: handleDisconnection() called twice
    [16:31:02] [Server thread/INFO]: [email protected][id=381949da-91c9-4986-bea1-0e8457d13448,name=sweetsuger123,properties={textures=[[email protected]]},legacy=false] (/47.16.85.109:43600) lost connection: Your data is locked, login later.


    The 2 servers using this plugin are still working and are still syncing items, it is still spamming the console of 1 server.
     
  8. Whats safer when updating this plugin...

    Delete the database or not? because i have lost many players inventories in the past because the data somehow didnt work after an update.... and I'm always afraid to update because users then complain about losing items and stuff
     
  9. The safer (for me) use of this plugin is to update it yourself and change it how you want it. For exemple i have removed few features that added bug, removed some things etc, and now i update it myself.
    Why ? Because I have tested it so i'm sure it work the way i want it, the dev here can't really test it trough all aspect and he is doing a free work, so you'll never be 100% sure with the output.
     
  10. The latest one build 1.11 always show [Server thread/WARN]: handleDisconnection() called twice when you logout then login within about 10 seconds
     
  11. Any suggestion which can prevent the bug ?
     
  12. @caoli5288
    is it possible to add the in-game command which could restore the player's inventory to last server close?
     
  13. Honestly i'm on an oldest build and made it compatible to 1.8.3 so i can't really say.
    I'm not a 'pro dev', so i can't really debug things easily.
    For exemple, to get this plugin to work great i had to remove the 'lock', BUT it's not a good idea, i'v done that cause i know what i do ! etc etc, lot of other change, but sticking caoli version is the best IMO.
     
  14. 'lock' section is good idea but need to do more test and optimize it.
    Big kudos to caoli and hope releasing the efficient plugin for us.
     
  15. Can't download the latest build. Could someone upload it?
     
  16. NotoriousNemo

    Supporter

    A player recently changed his name, and now its not letting him login, Im using version 1.10.3
    It says.
    Kicked whilst connecting to Vanilla: Your data is locked,login later.

    The player logged in, plugin makes the info.
    Then the player changes his name, and now can't login.

    Their uuid is: 7ec65a53-670f-41fe-8d91-50b6aca11d98

    Here is a pastebin of the mysql data of the player. Anything I can do to fix it?
    http://pastebin.com/yq7Bb8D1
     
    #660 NotoriousNemo, May 12, 2015
    Last edited: May 12, 2015