OnlinePlayersSQL-v1.6

Details

  • Filename
    OnlinePlayersSQL.jar
  • Uploaded by
  • Uploaded
    Jan 14, 2013
  • Size
    11.08 KB
  • Downloads
    224
  • MD5
    34491be0166532f8399edf71d21c9245

Supported Bukkit Versions

  • CB 1.4.6-R0.3

Changelog

 - 1.6
   - Compiled against CraftBukkit 1.4.6-R0.3 Beta build.
   - Have hopefully fixed issues when shutting down the server.

 - 1.5
   - Removed required dependency 'Sync'. Plugin is outdated, although it works on 1.4.5 it has timeout issues.
   - Refactored codebase to do stuff in a much more sane way, hopefully a lot more solid now too.
   - Everytime a query runs, it will open a connection, run the query, then close the connection, this should hopefully fix the timeout issues, since it isn't communicating with MySQL all the time anymore.

 - 1.4
   - Included a new table column called 'logout_time' which stores when the player logged out in seconds.
   - Included a new table column called 'first_login' which stores when the player first logged into the game
     - This will not update for existing players, i may be able to in the future, not sure though.
   - Fixed up the version of the plugin, 1.3 was still defined as 1.2 inside the plugin.

 - 1.3
   - Should update the permission_group field in the table whenever the player changes to a different world now. Servers that don't have per-world permissions groups shouldn't notice any difference, those that do, should see the difference.

 - 1.2
   - Recompiled against CB1.3.1-R1.0

 - 1.1
   - Changed from using the PatPeter SQL Library to using the Bukkit Plugin: Sync
   - Redone the SQL code to use the Sync plugin API, should hopefully be more reliable and not cause DB connection issues.

 - 1.0
   - New config option 'op_only_resync', when set to 'true' will require the player be OP in order to resync.

 - 0.9
   - Updated to use the latest RB of bukkit (1.2.5-R4)
   - Uses the new version of the SQL library which keeps the connection open for the entire time the plugin is enabled thus reducing the number of connections made to the SQL server.
 
 - 0.8beta3
   - Definitely fixes the SQL query error
   - Improves the addition of extra columns
   - No longer errors out if it tries to add a new column that already exists
   - Minor improvements in the SQL code

 - 0.8beta2
  - Fixes error in SQL query

 - 0.8beta1
  - Players are no longer removed from the database, they are instead flagged as online or offline (field in the table is called 'online', 1 = on, 0 = off).
  - a bit more restructuring of code

 - 0.7
  - New In-game command (/onl resync), currently can be used by anybody, didn't really see a reason to restrict it since it isn't all that harmful.
  - /onl resync - will resync all currently logged on players.

 - 0.6
  - You can now choose the name of the table by editing the config.yml files 'MySQLTable' value.
  - Now depends on the 'vault' plugin also being installed in order to deal with permission groups
  - If vault returns the permissions plugin you are using, the SQL tables 'permission_group' field for a player will now store what primary permission group they are in.
  - You can now turn debug info on and off by changing the config.yml files 'showDebug' value from 'false' to 'true' and vice-versa. debug info is nothing more than just showing some info on the console window such as 'player join' 'permission group', etc...

 - 0.5
  - Cleaning up of old code from when i first created it
  - Structuring the SQL side of the code a lot more
  - Storing all the SQL settings in a config.yml file
  - Renaming of old plugin 'OnlinePlayers' to 'OnlinePlayersSQL' to remove confusion about the storage mechanism used by the plugin.

 - 0.1 - 0.4
  - Changelog was never really tracked because it was only used on our server.

Marking this as beta for a reason, I've tested it a little bit, about as much as i can when you run a 1 person test server.

All the issues that popped up during my re-coding of the SQL side of it i have corrected and can say that it doesn't appear to have anything wrong with it.