SQLPerms

Discussion in 'Archived: Plugin Requests' started by MinerMovies, Aug 11, 2014.

Thread Status:
Not open for further replies.
  1. Offline

    MinerMovies

    Hello,
    What I would like is a plugin that if you do /setgroup <player> <group> it will set the player to that group on PermissionsEX and save it to the MySQL database, set in the config. The database will have 3 tables, Player, Group, and UUID (UUID optional, whatever works best :p). Every 60 seconds, every server connected to that database using SQLPerms will update, and if the player has a new group then before, it will set them to the group set in the database using PEX. This will be used for donor ranks, so thanks very much!
    P.S.
    I've tried PEX's built in SQL features, and they didn't work, so please don't suggest that :p Thanks again.
     
    MinerMovies, Aug 11, 2014
    #1
  2. Offline

    timtower Administrator Administrator Moderator

    MinerMovies I have a plugin that will sync the group when the player joins, group will be get from mysql.
    No commands though to set it, and no 60 seconds timer. Not really a good idea with 200 players
     
    timtower, Aug 11, 2014
    #2
  3. Offline

    MinerMovies

    Can I have the plugin please?
     
    MinerMovies, Aug 12, 2014
    #3
  4. Offline

    timtower Administrator Administrator Moderator

    Signature link, mysqlgroupsync
     
    timtower, Aug 12, 2014
    #4
  5. Offline

    MinerMovies

    ok. thanks!

    It's not working....
    Pastebin config.yml: http://pastebin.com/Y8s0cDc5


    If anyone else can make the plugin, awesome!

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 9, 2016
    MinerMovies, Aug 12, 2014
    #5
  6. Offline

    timtower Administrator Administrator Moderator

    MinerMovies Please post your full server log. I made this plugin so it won't throw errors every minute.
    EDIT: Tested it with my own database / server. If you have a message from this plugin on startup then your settings are wrong.
     
    timtower, Aug 12, 2014
    #6
  7. Offline

    MinerMovies

    14.08 06:25:41 [Server] INFO [02:25:40 INFO]: CtrlAltDelMW issued mycmd command ID(2) /pyxes
    14.08 06:25:41 [Multicraft] Skipped 7 lines due to rate limit (30/s)
    14.08 06:25:39 [Server] INFO at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:39 [Server] INFO at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:62) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:67) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO Caused by: java.lang.ClassNotFoundException: net.minecraft.server.v1_7_R1.Packet
    14.08 06:25:39 [Server] INFO ... 14 more
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:39 [Server] INFO at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:39 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:39 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_45]
    14.08 06:25:39 [Server] INFO at me.jrneulight.doublejumper.Main.onFly(Main.java:66) ~[?:?]
    14.08 06:25:39 [Server] INFO Caused by: java.lang.NoClassDefFoundError: net/minecraft/server/v1_7_R1/Packet
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:482) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:576) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:283) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:713) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.ServerConnection.c(ServerConnection.java:77) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:162) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.PacketPlayInAbilities.handle(SourceFile:9) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.PacketPlayInAbilities.a(SourceFile:62) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at net.minecraft.server.v1_7_R3.PlayerConnection.a(PlayerConnection.java:1657) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:294) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:39 [Server] INFO org.bukkit.event.EventException
    14.08 06:25:39 [Server] INFO [02:25:39 ERROR]: Could not pass event PlayerToggleFlightEvent to DoubleJumper v0.1
    14.08 06:25:39 [Multicraft] Skipped 8 lines due to rate limit (30/s)
    14.08 06:25:38 [Server] INFO at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:38 [Server] INFO at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:62) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:67) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO Caused by: java.lang.ClassNotFoundException: net.minecraft.server.v1_7_R1.Packet
    14.08 06:25:38 [Server] INFO ... 14 more
    14.08 06:25:38 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:38 [Server] INFO at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:38 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_45]
    14.08 06:25:38 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_45]
    14.08 06:25:38 [Server] INFO at me.jrneulight.doublejumper.Main.onFly(Main.java:66) ~[?:?]
    14.08 06:25:38 [Server] INFO Caused by: java.lang.NoClassDefFoundError: net/minecraft/server/v1_7_R1/Packet
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:482) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:576) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:283) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:713) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.ServerConnection.c(ServerConnection.java:77) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:162) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.PacketPlayInAbilities.handle(SourceFile:9) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:38 [Server] INFO at net.minecraft.server.v1_7_R3.PacketPlayInAbilities.a(SourceFile:62) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:37 [Server] INFO at net.minecraft.server.v1_7_R3.PlayerConnection.a(PlayerConnection.java:1657) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:37 [Server] INFO at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:37 [Server] INFO at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:37 [Server] INFO at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:37 [Server] INFO at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:37 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:294) ~[minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:25:37 [Server] INFO org.bukkit.event.EventException
    14.08 06:25:37 [Server] INFO [02:25:37 ERROR]: Could not pass event PlayerToggleFlightEvent to DoubleJumper v0.1
    14.08 06:25:29 [02:25:29 INFO]: CtrlAltDelMW[CtrlAltDelMW] ran command Message of the Day
    14.08 06:25:29 [Connect] User [02:25:29 INFO]: CtrlAltDelMW[CtrlAltDelMW], IP
    14.08 06:25:28 [Server] INFO [02:25:27 INFO]: UUID of player CtrlAltDelMW is b7722843-0369-3844-ac15-481824e98c19
    14.08 06:25:23 [Server] INFO [02:25:23 INFO]: [-] CtrlAltDelMW
    14.08 06:25:23 [Disconnect] User [02:25:23 INFO]: CtrlAltDelMW has disconnected, reason: Internal Exception: net.minecraft.util.io.netty.handler.timeout.ReadTimeoutException
    14.08 06:25:06 [Server] INFO [02:25:06 INFO]: CtrlAltDelMW was slain by Zombie
    14.08 06:24:53 [02:24:53 INFO]: CtrlAltDelMW[CtrlAltDelMW] ran command Message of the Day
    14.08 06:24:53 [Connect] User [02:24:53 INFO]: CtrlAltDelMW[CtrlAltDelMW], IP
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: [Vault] No new version available
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: [Vault] Checking for Updates:
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: [Fe] [Fe] Fe is outdated! The latest version is 0.7.
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: UUID of player CtrlAltDelMW is b7722843-0369-3844-ac15-481824e98c19
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: {ChestRegen} RegenChest has been regenerated
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: {ChestRegen} RegenChest has been regenerated
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: {ChestRegen} RegenChest has been regenerated
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: [HolographicDisplays] dev.bukkit.org/bukkit-plugins/holographic-displays
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: [HolographicDisplays] Download it on Bukkit Dev:
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: [HolographicDisplays] Found a new version available: v1.8.5
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: Accepted EditSessionFactory of type net.coreprotect.worldedit.CoreProtectEditSessionFactory from net.coreprotect.worldedit
    14.08 06:24:52 [Server] INFO [02:24:52 INFO]: Done (53.939s)! For help, type "help" or "?"
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: Server permissions file permissions.yml is empty, ignoring it
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: [EssentialsChat] Enabling EssentialsChat v2.12.1
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: [Enjin Minecraft Plugin] Votifier plugin found, enabling Votifier support.
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: [EnjinMinecraftPlugin] MC 1.7.9 or below found, enabling version 1 player handling.
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: [EnjinMinecraftPlugin] MC 1.7.2 or above found, enabling version 2 log handling.
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: [EnjinMinecraftPlugin] MC 1.3 or above found, enabling version 2 XP handling.
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: [EnjinMinecraftPlugin] Enabling EnjinMinecraftPlugin v2.6.8
    14.08 06:24:51 [Server] INFO [02:24:51 INFO]: [MySQLGroupSynch] Connection tested, everything working like it should
    14.08 06:24:50 [Server] INFO [02:24:50 INFO]: [MySQLGroupSynch] Enabling MySQLGroupSynch v0.0.1
    14.08 06:24:50 [Server] INFO [02:24:50 INFO]: [FramePicture] Plugin enabled!
    14.08 06:24:50 [Server] INFO [02:24:50 INFO]: [FramePicture] Entity Tracker from world sg was replaced!
    14.08 06:24:50 [Server] INFO [02:24:50 INFO]: [FramePicture] Entity Tracker from world world_the_end was replaced!
    14.08 06:24:50 [Server] INFO [02:24:50 INFO]: [FramePicture] Entity Tracker from world world was replaced!
    14.08 06:24:50 [Server] INFO [02:24:50 INFO]: [FramePicture] Cached 0 frames!
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: [FramePicture] Caching frames ...
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: [FramePicture] Loaded 0 Frames!
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: [FramePicture] Configuration loaded!
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: [FramePicture] Enabling FramePicture v1.7
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: [EssentialsSpawn] Enabling EssentialsSpawn v2.12.1
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: [Essentials] Payment method found (Vault - Economy: Fe version: 1.4.1-b436)
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: Essentials: Using PermissionsEx based permissions.
    14.08 06:24:49 [Server] INFO [02:24:49 INFO]: [Vault][Economy] Essentials Economy hooked.
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: 1.7.8-R0.1-SNAPSHOT
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: git-Spigot-1402 (MC: 1.7.8)
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: Bukkit version format changed. Version not checked.
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: [Essentials] Enabling Essentials v2.12.1
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: [ScoreboardBalance] Enabling ScoreboardBalance v1.1
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: [DoubleJumper] Enabling DoubleJumper v0.1
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: [BasePlace] Enabling BasePlace v1.0
    14.08 06:24:47 [Server] INFO [02:24:47 INFO]: [Votifier] Votifier enabled.
    14.08 06:24:45 [Server] INFO [02:24:45 INFO]: [Votifier] Enabling Votifier v1.9
    14.08 06:24:45 [Server] INFO [02:24:45 INFO]: [HolographicDisplays] Loaded animation 'example.txt', speed 10.
    14.08 06:24:43 [Server] INFO [02:24:43 INFO]: [HolographicDisplays] Enabling HolographicDisplays v1.7
    14.08 06:24:43 [Server] INFO [02:24:43 INFO]: [HubGadgets] enabled
    14.08 06:24:43 [Server] INFO [02:24:43 INFO]: [HubGadgets] Enabling HubGadgets vBETA 1.0
    14.08 06:24:42 [Server] INFO [02:24:42 INFO]: [SpawnTP] Enabling SpawnTP v1.5.7
    14.08 06:24:42 [Server] INFO at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [minecraft_optimized.jar:git-Spigot-1402]
    14.08 06:24:42 [Server] INFO at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:450) [minecraft_optimized.jar:git-Spigot-1402]
     
    MinerMovies, Aug 13, 2014
    #7
  8. Offline

    JaguarJo

    Locked. You are not running a CraftBukkit server. Please seek support where you acquired your server build.
     
    JaguarJo, Aug 13, 2014
    #8
Thread Status:
Not open for further replies.

Share This Page