[INFO] OnlineUsers 1.7.0 - logged users in a file/mysql [BukkitDev]

Discussion in 'Archived: Plugin Releases' started by Brettflan, Jan 17, 2011.

  1. Offline

    Brettflan

  2. Offline

    Brettflan

    Download the MySQL driver JAR linked in the first post, extract it, rename it "mysql-connector-java-bin.jar", and stick it in your root Minecraft server folder alongside the Craftbukkit JAR.
    Then edit your online-users.properties file to configure this plugin to use MySQL and to have your database name and login info.
     
    Zerdux likes this.
  3. Offline

    Zerdux

    Thanks, it works already! :)
     
  4. Offline

    -FN-

    Just FYI - using this plugin with 1597 with no problems so far.
     
  5. Offline

    Brettflan

    Yeah, it shouldn't have any problems in the new release.
     
  6. Offline

    Brettflan

    Released 1.6.1.

    Primarily a compatibility release to support the upcoming CB 1.1-R5 and above.
    • Update to use the new Bukkit event system.
    • Fix for timestamps showing 12-based hour instead of 24-based as it was supposed to be.
    • Removed the plugin's "loading" and "shutting down" log messages since Bukkit now handles those itself.
     
  7. Offline

    -FN-

    Just FYI, I know there's no claim of 1.2.3-R0x compatibility yet, but when I fired up 1.2.3-R02, my server log spit this out:

    Code:
    2012-03-13 15:14:34 [INFO] This server is running CraftBukkit version git-Bukkit-1.2.3-R0.2-b2060jnks (MC: 1.2.3) (Implementing API version 1.2.3-R0.2)
    2012-03-13 15:14:35 [SEVERE] Could not load 'plugins/OnlineUsers.jar' in folder 'plugins'
    org.bukkit.plugin.InvalidPluginException: java.lang.NoClassDefFoundError: org/bukkit/event/player/PlayerListener
        at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:148)
        at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:287)
        at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:211)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:207)
        at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:183)
        at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:56)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:156)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:490)
    Caused by: java.lang.NoClassDefFoundError: org/bukkit/event/player/PlayerListener
        at java.lang.ClassLoader.defineClass1(Native Method)
        at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
        at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:41)
        at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:29)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
        at com.wimbli.onlineusers.OnlineUsers.<init>(OnlineUsers.java:24)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:144)
        ... 8 more
    Caused by: java.lang.ClassNotFoundException: org.bukkit.event.player.PlayerListener
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:41)
        at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:29)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
        ... 27 more
     
  8. Offline

    Brettflan

    Seriously? That would be because you're not running the latest release which is right above your post.
     
  9. Offline

    -FN-

    My bad. According to my notes, I thought I was running 1.6.1. I must've downloaded it but never updated it based on the file ctime.
     
  10. Offline

    Brettflan

    Release 1.6.2

    IMPORTANT: BREAKING CHANGE for MySQL users: the time_total column type is changed from TIME to INT. The new INT values refer to the number of seconds the user has been online. This was necessary due to TIME columns being limited to roughly 839 hours before being truncated and no longer working correctly.

    Any SQL queries you've written which reference the time_total column will likely need to be updated as a result. For a quick way to get a TIME value like before, you can use something like the SQL "SEC_TO_TIME(`time_total`)" or similar, but again you should note that SQL TIME values are limited to 839 hours before they stop working correctly.
     
  11. Offline

    Brettflan

    Release 1.6.3

    Single change for 1.6.3:
    • Fix for newly created MySQL database tables missing the 'online' column; thanks to AxxiD for pointing it out. MySQL tables which are missing that column will retroactively have it added.

    From 1.6.2:
    IMPORTANT: BREAKING CHANGE for MySQL users: the time_total column type is changed from TIME to INT. The new INT values refer to the number of seconds the user has been online. This was necessary due to TIME columns being limited to roughly 839 hours before being truncated.

    Any SQL queries you've written which reference the time_total column will likely need to be updated as a result. For a quick way to get a TIME value like before, you can use something like the SQL "SEC_TO_TIME(`time_total`)" or similar, but again you should note that SQL TIME values are limited to 839 hours before they stop working correctly.
    • For MySQL data storage, time_total column type is changed from TIME to INT
     
  12. Offline

    Wayno

    hi, i was using a older version of this. i deleted the user_online from mysql and updated to the latest version. now it will not insert the new fields/database. is there a issue somewhere on creating a new database?

    oh dw i see where i went wrong u goto start bukkit and then edit /plugins/OnlineUsers/online_users.settings

    might need to update the first post to see what to edit?
     
  13. Offline

    MisanthropX

    Hi!
    I wan't to convert the current stats to the new integer value,
    Is there some magical SQL Command to convert the old values to the new ones?

    Thanks in advance!

    //edit:

    I found out that your plugin is doing this on its own.
    very good!


    I have another issue:

    [SEVERE] OnlineUsers: could not execute the sql "UPDATE `users_online` SET `time_total` = IF(`online`=1, `time_total` + TIMESTAMPDIFF(SECOND, `time`, NOW()), `time_total`), `online`=0"

    my user/pass is the same as before... what else do I have to update/change?
     
  14. Offline

    digitalfiz

    For some reason the plugin is Enabled but it doesn't work. The tables are no created. No errors are thrown though so I have no clue what is wrong.

    Code:
    2012-08-29 11:57:18 [INFO] Preparing level "YMH"
    2012-08-29 11:57:18 [INFO] Preparing start region for level 0 (Seed: -144893390700462304)
    2012-08-29 11:57:19 [INFO] Preparing spawn area: 81%
    2012-08-29 11:57:19 [INFO] Preparing start region for level 1 (Seed: 3505096109183390536)
    2012-08-29 11:57:20 [INFO] Preparing spawn area: 52%
    2012-08-29 11:57:21 [INFO] Preparing start region for level 2 (Seed: 3505096109183390536)
    2012-08-29 11:57:21 [INFO] [OnlineUsers] Enabling OnlineUsers v1.6.3
    2012-08-29 11:57:21 [INFO] Server permissions file permissions.yml is empty, ignoring it
    2012-08-29 11:57:21 [INFO] Done (3.762s)! For help, type "help" or "?"
     

Share This Page