Spigot PlayerSQL 2.12.3

Synchronize data between servers.

  1. please add player location too
    • Like Like x 1
  2. exp in 1.7.10 might have some bug.. it might cause people lost all the exp...
  3. any chance for an update for MC 1.11?
  4. You can try on 1.11 and feedback any issues to me.
  5. I tried in 1.11 this morning and inventory is empty on login :/
  6. Any console output?
  7. I'll test with this new version...

    With older the problem is juste on first load in 1.11 but database PlayerSQL inventories are on 1.10...
    I seen nothing on console after player login...
  8. I tested last spigot 1.11 + ProtocolLib last devbuild + PlayerSQL 2.4 and same result... on first login, inventories on database is loaded empty...
    [16:15:49] [Server thread/INFO]: Starting minecraft server version 1.11
    [16:15:49] [Server thread/INFO]: Loading properties
    [16:15:49] [Server thread/INFO]: Default game type: SURVIVAL
    [16:15:49] [Server thread/INFO]: This server is running CraftBukkit version git-Spigot-f950f8e-4d99fed (MC: 1.11) (Implementing API version 1.11-R0.1-SNAPSHOT)
    [16:15:49] [Server thread/INFO]: Debug logging is disabled
    [16:15:49] [Server thread/INFO]: Server Ping Player Sample Count: 12
    [16:15:49] [Server thread/INFO]: Using 4 threads for Netty based IO
    [16:15:49] [Server thread/INFO]: Generating keypair
    [16:15:49] [Server thread/INFO]: Starting Minecraft server on
    [16:15:49] [Server thread/INFO]: Using epoll channel type
    [16:15:49] [Server thread/INFO]: Set PluginClassLoader as parallel capable
    [16:15:49] [Server thread/INFO]: [NatSamTP] Loading NatSamTP v0.1-SNAPSHOT
    [16:15:49] [Server thread/INFO]: [NatProxyVote] Loading NatProxyVote v0.1-SNAPSHOT
    [16:15:49] [Server thread/INFO]: [Vault] Loading Vault v1.5.6-b49
    [16:15:49] [Server thread/INFO]: [ProtocolLib] Loading ProtocolLib v4.2.0-SNAPSHOT-b335
    [16:15:50] [Server thread/INFO]: [PlayerSQL] Loading PlayerSQL v2.4
    [16:15:50] [Server thread/INFO]: [Vault] Enabling Vault v1.5.6-b49
    [16:15:50] [Server thread/INFO]: [Vault] [Permission] SuperPermissions loaded as backup permission system.
    [16:15:50] [Server thread/INFO]: [Vault] Enabled Version 1.5.6-b49
    [16:15:50] [Server thread/INFO]: [ProtocolLib] Enabling ProtocolLib v4.2.0-SNAPSHOT-b335
    [16:15:50] [Server thread/INFO]: [ProtocolLib] Started structure compiler thread.
    [16:15:50] [Server thread/WARN]: **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
    [16:15:50] [Server thread/WARN]: The server will make no attempt to authenticate usernames. Beware.
    [16:15:50] [Server thread/WARN]: Whilst this makes it possible to use BungeeCord, unless access to your server is properly restricted, it also opens up the ability for hackers to connect with any username they choose.
    [16:15:50] [Server thread/WARN]: Please see http://www.spigotmc.org/wiki/firewall-guide/ for further information.
    [16:15:50] [Server thread/WARN]: To change this, set "online-mode" to "true" in the server.properties file.
    [16:15:50] [Server thread/INFO]: **** Beginning UUID conversion, this may take A LONG time ****
    [16:15:50] [Server thread/INFO]: Preparing level "amedur_backup"
    [16:15:50] [Server thread/INFO]: -------- World Settings For [amedur_backup] --------
    [16:15:50] [Server thread/INFO]: Mob Spawn Range: 4
    [16:15:50] [Server thread/INFO]: Entity Tracking Range: Pl 48 / An 48 / Mo 48 / Mi 32 / Other 64
    [16:15:50] [Server thread/INFO]: Hopper Transfer: 10 Hopper Check: 8 Hopper Amount: 1
    [16:15:50] [Server thread/INFO]: Random Lighting Updates: false
    [16:15:50] [Server thread/INFO]: Structure Info Saving: true
    [16:15:50] [Server thread/INFO]: Cactus Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Cane Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Melon Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Mushroom Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Pumpkin Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Sapling Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Wheat Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: NetherWart Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Vine Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Cocoa Growth Modifier: 100%
    [16:15:50] [Server thread/INFO]: Entity Activation Range: An 32 / Mo 32 / Mi 16
    [16:15:50] [Server thread/INFO]: Max TNT Explosions: 100
    [16:15:50] [Server thread/INFO]: Tile Max Tick Time: 20ms Entity max Tick Time: 25ms
    [16:15:50] [Server thread/INFO]: Item Despawn Rate: 1200
    [16:15:50] [Server thread/INFO]: Item Merge Radius: 2.5
    [16:15:50] [Server thread/INFO]: Arrow Despawn Rate: 1200
    [16:15:50] [Server thread/INFO]: Allow Zombie Pigmen to spawn from portal blocks: true
    [16:15:50] [Server thread/INFO]: View Distance: 10
    [16:15:50] [Server thread/INFO]: Experience Merge Radius: 3.0
    [16:15:50] [Server thread/INFO]: Zombie Aggressive Towards Villager: true
    [16:15:50] [Server thread/INFO]: Nerfing mobs spawned from spawners: false
    [16:15:50] [Server thread/INFO]: Preparing start region for level 0 (Seed: )
    [16:15:51] [Server thread/INFO]: Preparing spawn area: 61%
    [16:15:51] [Server thread/INFO]: [NatSamTP] Enabling NatSamTP v0.1-SNAPSHOT
    [16:15:51] [Server thread/INFO]: [NatSamTP] NatSamTP unabled
    [16:15:51] [Server thread/INFO]: [NatProxyVote] Enabling NatProxyVote v0.1-SNAPSHOT
    [16:15:51] [Server thread/INFO]: [NatProxyVote] NatProxyVote unabled
    [16:15:51] [pool-8-thread-1/INFO]: [NatProxyVote] Connected to MySQL!
    [16:15:51] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API.
    [16:15:52] [Server thread/INFO]: [PlayerSQL] Enabling PlayerSQL v2.4
    [16:15:52] [Server thread/INFO]: [PlayerSQL] Server version: null.
    [16:15:52] [Server thread/INFO]: [PlayerSQL] Warped util work well!
    [16:15:52] [Server thread/ERROR]: ebean.properties not found
    [16:15:52] [Server thread/INFO]: DataSourcePool [PlayerSQL] autoCommit[false] transIsolation[READ_COMMITTED] min[1] max[8]
    [16:15:52] [Server thread/INFO]: DatabasePlatform name:playerSQL platform:mysql
    [16:15:52] [Server thread/INFO]: SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    [16:15:52] [Server thread/INFO]: Entities enhanced[0] subclassed[1]
    [16:15:52] [Server thread/INFO]: [PlayerSQL] Tables already exists!
    [16:15:52] [Server thread/INFO]: Done (2,727s)! For help, type "help" or "?"
    [16:15:52] [Craft Scheduler Thread - 3/INFO]: [Vault] Checking for Updates ...
    [16:15:53] [Craft Scheduler Thread - 3/INFO]: [Vault] No new version available
    [16:16:30] [User Authenticator #1/INFO]: UUID of player natsimhan is ae4da7ac-441a-31d0-8d20-bfd620b06997
    [16:16:30] [Server thread/INFO]: [PlayerSQL] Lock user ae4da7ac-441a-31d0-8d20-bfd620b06997 done!
    [16:16:30] [Server thread/INFO]: natsimhan[/] logged in with entity id 212 at ([amedur_backup]193.42260066935518, 80.0, 193.779250702955)
    [16:16:31] [Craft Scheduler Thread - 3/INFO]: [PlayerSQL] Load user data ae4da7ac-441a-31d0-8d20-bfd620b06997 done.
    [16:16:31] [Craft Scheduler Thread - 3/INFO]: [PlayerSQL] Lock user data ae4da7ac-441a-31d0-8d20-bfd620b06997 done.
    [16:16:31] [Server thread/INFO]: [PlayerSQL] Scheduling daily save task for user ae4da7ac-441a-31d0-8d20-bfd620b06997.
    [16:16:45] [Server thread/INFO]: natsimhan lost connection: Disconnected
    [16:16:45] [Server thread/INFO]: natsimhan left the game
    [16:16:45] [Craft Scheduler Thread - 3/INFO]: [PlayerSQL] Save user data ae4da7ac-441a-31d0-8d20-bfd620b06997 done!
    [16:16:49] [Server thread/INFO]: Stopping the server
    [16:16:49] [Server thread/INFO]: Stopping server
    [16:16:49] [Server thread/INFO]: [PlayerSQL] Disabling PlayerSQL v2.4
    [16:16:49] [Server thread/INFO]: [ProtocolLib] Disabling ProtocolLib v4.2.0-SNAPSHOT-b335
    [16:16:49] [Server thread/INFO]: [Vault] Disabling Vault v1.5.6-b49
    [16:16:49] [Server thread/INFO]: [NatProxyVote] Disabling NatProxyVote v0.1-SNAPSHOT
    [16:16:49] [Server thread/INFO]: [NatProxyVote] NatProxyVote disabled
    [16:16:49] [Server thread/INFO]: [NatSamTP] Disabling NatSamTP v0.1-SNAPSHOT
    [16:16:49] [Server thread/INFO]: [NatSamTP] NatSamTP disabled
    [16:16:49] [Server thread/INFO]: Saving players
    [16:16:49] [Server thread/INFO]: Saving worlds
    [16:16:49] [Server thread/INFO]: Saving chunks for level 'amedur_backup'/Overworld
  9. How do I have to install this plugin?
  10. Maybe NBT format changed:-/
  11. The only idee that I have is to delete entire database and copy last PlayerData from each server on the hub so the conversion of the inventories is made by minecraft ... but it's a hard job of sorting with 1800 accounts and 6 servers where them had can logout from my bungee network ...
  12. Before I throw this plugin on my server and pray to god this doesn't fuck up things due to incompatibility... does this plugin works without issues in 1.8.8?
  13. Yes. It fully compatible with 1.8.8.
  14. How can I fix this?:

    Code (Text):
    [13:55:02] [Server thread/INFO]: [PlayerSQL] Enabling PlayerSQL v2.4.1
    [13:55:02] [Server thread/WARN]: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
    [13:55:02] [Server thread/WARN]: SLF4J: Defaulting to no-operation (NOP) logger implementation
    [13:55:02] [Server thread/WARN]: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
    [13:55:03] [Server thread/INFO]: [PlayerSQL] Server version: v1_11_R1.
    [13:55:03] [Server thread/INFO]: [PlayerSQL] Build-in item util work well!
    [13:55:03] [Server thread/ERROR]: Error occurred while enabling PlayerSQL v2.4.1 (Is it up to date?)
    com.mengcraft.playersql.PluginException: Failed connect to database
        at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:44) ~[?:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:271) ~[spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugin(CraftServer.java:375) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugins(CraftServer.java:325) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at net.minecraft.server.v1_11_R1.MinecraftServer.t(MinecraftServer.java:419) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at net.minecraft.server.v1_11_R1.MinecraftServer.l(MinecraftServer.java:380) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at net.minecraft.server.v1_11_R1.MinecraftServer.a(MinecraftServer.java:335) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at net.minecraft.server.v1_11_R1.DedicatedServer.init(DedicatedServer.java:272) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
        at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:542) [spigot-1.11.jar:git-Spigot-6f7aabf-c8ff651]
  15. caoli5288 updated PlayerSQL with a new update entry:

    Update to 2.4.2

    Read the rest of this update entry...
  16. Bug found:

    I am on main server with a potion.
    I am switching to farm(other) server potion and time transfers too.

    Potion runs out of time.
    I am connecting back to main server and get the whole time back which i have when i switched the server the first time.
  17. Can not reproduce that..Any console output in each server? or paste your data in database each server switch.THX
  18. Archangel


    Add player location? Or is this already a feature?