OnlineUsers

1.6.3

Change log

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

Known caveats

As above, existing MySQL users will likely need to update any queries referencing that column.

Facts

Uploaded on
May 10, 2012
Game version
  • CB 1.5.1-R0.2
  • CB 1.4.7-R1.0
  • CB 1.2.5-R1.0
Filename
OnlineUsers.jar
Size
15.5 KiB
MD5
053f5f1fab22eddba44957fe1b6a8369
Type
Release
Status
Semi-normal
Downloads
3,854

Authors