promotional bannermobile promotional banner

OnlineUsers

track online users in a flatfile or MySQL database
Back to Files

1.6.3

File nameOnlineUsers.jar
Uploader
BrettflanBrettflan
Uploaded
May 10, 2012
Downloads
4.3K
Size
15.5 KB
File ID
592925
Type
R
Release
Supported game versions
  • CB 1.4.7-R1.0
  • CB 1.5.1-R0.2
  • CB 1.2.5-R1.0

What's new

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

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

This mod has no additional files