Changelog

Fixed issues with database connection pool management Security patches Security patches Added er...

Minor bug fixes Adjusted rate limit Added support to centralized database connection pool Use s...

Respect launch params when setting host, port and workers Switched to use https protocol for ste...

Added task plugin Added cancel user deletion request audit log Fixed boolean data in dlog export

Improved banner generator: Ability to choose whether to show division or rank as front row in ...

Fixed data inconsistency due to outdated transactions, see details below: Since we use connectio...

Updated dependencies

Added distance_note and bonus_note to PATCH /member/points Updated GET /member/bonus/history U...

Added audit log category attribute Available categories: announcement, application, auth, challe...

This update focus on stability and performance improvements and does not include feature updates....

Improved param validation and added error response when page, page_size, order, order_by is inva...

Fixed Internal Server Error caused by email validating (NoneType) This includes: accepting a us...

Fixed issue updating multiple account connections at the same time Renamed config.smtp_passwd to...

Reordered config keys Fixed error loading languages files with utf-8 encoding Fixed error handli...

Fixed minor issue with dlog statistics Added global MFA requirement to POST /user/mfa/disable A...

Added POST /status/database/restart to manually restart database pool There is no access contro...

Fixed Trucky job format conversion issues Added ?bypass_tracker_check=true|false to /trucky/impo...

Minor improvements on string table and apidoc.json Deduplicated roles and event attendees on up...

Fixed Trucky webhook handling issues Fixed update-connection failure when the provided connectio...

Added POST /trucky/import/{jobid} to import jobs from Trucky Added user_joined_company Trucky we...

Removed company_driver.detached tracksim event listening Added "update discord email" when user ...

Enforced deepcopy for most large dicts to prevent constants being changed Renamed config.deliver...

1.Blocked large logo and avatar (larger than 10MB or 3400x3400) 2.Added logo and avatar resizing ...

1.Added minimum_seconds_spent, maximum_seconds_spent, maximum_distance, minimum_detour_percentage...

1.Added customizable host, port, workers for banner generator 2.Improved banner generator to dele...

1.Removed secret data from GET /application/types 2.Removed config.application_types[].discord_ro...

1.[Internal code changes] 2.Fixed 500 error in challenge plugin when invalid job_requirements is ...

1.Renamed announcement_type to type 2.Renamed challenge_type to type 3.Removed ?after|before quer...

1.Added handling of autoPark field on dlog export -> This should be a TrackSim issue 2.Added retr...

Added user note (private / global) -> To remove the note, provide an empty string on note field w...

1.Improved discord embed handler -> Support any fields, so no update is needed to catch up with t...

1-2. [Internal code changes] 3.Removed percentage from config.ranks[].daily_bonus.streak_type to ...

1.Fixed update member points audit log 2.Added detailed description to specific errors

1-4. Internal code changes 5.Fixed 500 error on POST /member/bonus/claim when config.ranks[].dail...

1.Improved value size limit handling 2.Fixed inappropriate default query value 3.Added ?after and...

1.Minor bug fixes and improvements 2.Added algo to config.ranks[].daily_bonus.streak_type - A gen...

Added poll plugin

1.Added user role history 2.Added user ban history 3.Added config.ranks[].daily_bonus and bonus n...

1.Added order_id and is_pinned to announcement, challenges 2.Removed "forward to Discord" functio...

1.Fixed /user/profile returning incorrect ban data 2.Added config.privacy check to GET /dlog/stat...

1.Fixed inaccurate data of GET /dlog/statistics/chart|summary 2.Separated ETS2/ATS data of GET /d...

1.Added ?after to GET /audit/list 2.Added ?after_logid to GET /dlog/list 3.Added ?after_userid, ?...

Fixed issues related to Discord role connection Other internal changes and improvements

Internal changes

1.Fixed BannerGen app loading issue 2.Fixed rare issue of UpdateRoleConnection 3.Renamed myth_poi...

1.Improved /user/list to attach banned info when any connections match 2.Improved /user/profile t...

1.Fixed incorrect driver value in GET /dlog/statistics/chart 2.Fixed email connection validation ...

1.Moved add/remove member_welcome discord roles from when driver role is added to when member is ...

1.Fixed audit log on user resignation and when removing driver from tracker company 2.Fixed PATCH...

1.Fixed BannerGen 500 error 2.Added thousands separator to distance in banners

Added Discord Role Connection Hints i) POST /discord/role-connection/enable must be called to ena...

1.Added economy-merch Hint The company owns all the merch. Member will transfer balance to the co...

1.Improved /dlog/statistics/summary query performance Note Cache expiry for this endpoint was red...

Backend v2.4.4 [Internal code changes]

1.Fixed redirect route for downloads plugin 2.Fixed issue banning user who has NULL connection(s)...

1.Renamed start_time/end_time in query param to after/before 2.Added after/before query param to ...

1.Fixed notifications not being sent to uid = 0 2.Fixed errors with MFA (due to auth_ticket) 3.[C...

Mainly backend code changes, in preparation of v2.4.1

1.Created a tool to automatically fix ultra-high User ID / UID 2.Removed support of navio due to ...

1.Added economy plugin 2.Bug fixes and improvements

1.Fixed db creating ratelimit TABLE with ip COLUMN rather than identifier COLUMN 2.Fixed Discord ...

1.Fixed banner generator 2.Fixed application permission control

1.Fixed POST /auth/register not checking config.register_methods 2.Fixed in-Discord-guild check b...

Added support to Email/Password registration and updating email -> Added smtp_server, smtp_port, ...

1.Automated discord_callback_url and discord_oauth_url generation, hence removed it from config 2...

1.Added support to custom avatar and name (Updated PATCH /user/profile) -> Disabled automatic syn...

1.Fixed issue preventing status update of all notifications 2.Improved ratelimit to identify sess...

1.Fixed challenge system required_roles validation 2.Updated routes, request json data format, re...

1.Fixed steam/truckersmp connection validation when adding driver role 2.Fixed error when sending...

1.Fixed AutoMessage cannot be sent when using webhook 2.Removed member_leave on driver role remov...

1.Fixed upgrader failure due to ./upgrades/ does not exist by removing file log 2.Fixed applicati...

Breaking changes ⚠️ Note: This is a release focusing on updating the user system, to allow every ...

1.Fixed user activity caching issue 2.Added user language cache

Breaking changes ⚠️ Note: This is a pre-release focusing on request and response formats, major f...

1.Increased database connection timeout by 1 second (to 2 seconds) 2.Fixed traceback log corrupts...

1.Improved error formatter to prevent corrupted results 2.Fixed error when adding/removing a role...

1.Fixed point2rank seires functions going wrong when there's only one rank 2.Fixed error not bein...

1.Removed 50 session limit 2.Improved application token to allow multiple applications 3.Fixed th...

[BannerGen] 1.Changed Since YYYY/(M)M/(D)D to Joined: YYYY/MM/DD 2.Replaced license fonts with op...

1.Prevented restarting database connection pool for multiple times when it is already restarting ...

1.Removed wait_timeout that closes connections Note Closed connections are not released to pool 2...

1.Added legacy database connection pool management solution back 2.Added timeout when acquiring c...

1.Merged 500 error handler into middleware 2.Added database connection close on request fail

1.Fixed Unknown Error on Discord callback when email is not provided in form data 2.[Internal Upd...

1.Fixed TrackSim setup webhook 2.Added allowed_tracker_ips update on TrackSim setup

1.Removed try / except when adding job to database 2.Improved delivery rule block handling

1.Removed exit on restart and left the restart job to systemctl 2.Fixed error when a navio / trac...

1.Fixed has_police_enabled error when exporting dlog 2.Fixed database connection timeout due to s...

1.Renamed config.navio_* to config.tracker_* 2.Added async requests 3.Added full role management ...

1.Improved restart handler 2.Added config.mysql_pool_size 3.Changed config.allowed_navio_ips to c...

1.Improved error handler 2.Prevented index to connect to database when Authorization header is no...

1.Converted database error to 503 error 2.Fixed 500 error handler exception 3.Added 422 error han...

1.Added 500 Internal Server Error handler 2.Added auto-restart on too many errors 3.Added wait_ti...

1.Fixed file encoding error 2.Fixed duplicate ID issue

Optimized database connection management

Implemented database connection pool for better stability

1.Added asyncio support to database operation 2.Added shutdown event handler 3.Removed dependency...

1.Fixed database connection issue caused by v1.21.13 2.Fixed bug navio_api_error not declared 3.C...

Improved database connection management and reduced resource consumption

1.Prevented crash on certain types of invalid config 2.Fixed GET /downloads/redirect 500 error wh...

Added end_time request param to GET /dlog/statistics/chart

1.Fixed manually-added distance leading to inaccurate result of leaderboard division point 2.Fixe...

Removed unncessary convert_quotation that led to \' visible by user

1.Improved internal / external API handling to prevent 500 errors when request failed 2.Added con...

1.Fixed POST /user/tip 500 error 2.Fixed GET /division returns incorrect data

1.Fixed the bug being unable to parse 204 response which led to errors 2.Added numeric value chec...

[BannerGen] 1.Prevented sending request to BannerGen when cache exists 2.Improved avatar caching ...

1.Improved Discord Notification to send batched embeds (less messages, more embeds) 2.Added dista...

[BannerGen] 1.Merged ConsolaBold with SansSerif to support a larger character set 2.Added unicode...

Improved GET /dlog/statistics/chart, removed scale param, added ranges and interval params for be...

[Bug fixes] 1.Fixed the bug that PATCH /member/roles/rank is always returning discord_integration...

1.Fixed GET /config 500 error when content related to disabled plugins are not in config 2.Fixed ...

Fixed the bug that program cannot shut down fully

[Bug fixes] 1.[Auth] Fixed the bug that ban check is not performed on steam & password login 2.[A...

Hard-coded English String Table

1.Fixed the bug that GET /dlog/list returns same delivery for multiple times due to challenge rec...

[BanerGen] 1.Reduced workers to 1 worker 2.Reduced resolution to 1700x300 3.General improvements ...

[Challenge] Added new challenge type Personal (Recurring) (original Personal type renamed to Pers...

1.Fixed the bug that is_private is not updated when PATCH /announcement 2.Fixed GET /dlog/list an...

[Minor changes] 1.[Dlog] Improved dlog to support empty delivery log data (detail) 2.[Auth] Updat...

1.Fixed GET /challenge/list param must_have_completed not working correctly 2.Changed order of ch...

1.[Event] Separated single-event query from event-list query 2.[Announcement] Separated single-an...

[Minor changes] 1.[Challenge] Added multiple item support to source_city_id, source_company_id, d...

[Bug fixes] 1.[Member] Fixed PATCH /member/roles/rank giving highest role when there is no point ...

1.Fixed application setting user[userid=0] as last_update_staff when nobody updated the applicati...

1.Removed detailed per-user statistics from GET /division 2.Updated GET /dlog/leaderboard respons...

1.Fixed speed limit not working for /dlog/list and /dlog/leaderboard 2.Added status parameter (0:...

1.Fixed announcement plugin 500 error 2.Added avatar to announcement and audit log embed

Moved Steam & TruckersMP connection check to when adding driver role instead of when accepting us...

Improved response format GET /audit - Added detailed user info GET /auth/tip - Added detailed use...

1.Improved TOTP function to accept OTP of bigger time range 2.Added MFA secret base32 check 3.Add...

Fixed leaderboard skipping rank due to deleted users

Fixed GET /config returning malformed roles data

Fixed bannergen showing username as company name

1.Fixed POST /reload 500 error when MFA is not enabled 2.Changed tip form field to token for POST...

Added Multiple Factor Authentication i) New endpoints: PUT, POST, DELETE /auth/mfa ii) Endpoint t...

1.Removed 'vtc' element 2.Added points field to GET /event response 3.Added config.discord_bot_dm...

1.Fixed isdivision (boolean) response being stringified to "True" / "False" 2.Added Unknown Error...

Improved role & config update validator to prevent admin users removing their own admin permission

Added steam login

1.Improved config validation on PATCH /config 2.Removed automatic reload on PATCH /config 3.Added...

1.Added 400 response when required form data is not provided 2.Added "real deletion" for announce...

1.Added ability to edit meta elements of automated embeds in Discord (Welcome, Team Update, Rank ...

1.Fixed the bug that updating event point without updating attendee doesn't work 2.Added DELETE /...

1.Fixed 500 error when submitting division validation request 2.Fixed 500 error when Drivers Hub ...

Improved endpoint path and response format for better readability

Improved Banner Generator: i) Fixed 500 error when image is invalid ii) Fixed transparent logo ba...

1.Fixed 500 error on /user when config.privacy = false and no authorization header is provided 2....

1.Fixed 500 error on /dlog/stats when config.privacy = true 2.Added Discord Login requirement to ...

Improved leaderboard ordering

1.Added cache for /dlog/stats (5min), /dlog/leaderboard (5min), /user/banner (1hr) 2.Removed stat...

1.Added cache for /dlog/stats (5min), /dlog/leaderboard (5min), /user/banner (1hr) 2.Removed stat...

1.Fixed the bug that leaderboard is not loading 2.Improved authentication system 3.Removed possib...

Improved Banner Generator to save memory

1.Merged /member and /user to /user for both member and public user, added discordid, steamid, tr...

Added requirement to login with discord to revoke specific / all token

1.Improved application plugin: i) Added support to per-type webhook ii) Added support to per-type...

Added revoke-all-token when updating password

Removed regex email validation

Fixed the bug that application webhook contains words in applicant's language

1.Removed GET /dlog/newdrivers 2.Removed sort_by_highest_role parameter from GET /members 3.Added...

1.Added support to email & password login 2.Added time-range query for /dlog/stats 3.Added more d...

1.Removed staff_of_the_month and drivers_of_the_month 2.Added roles and sort_by_highest_role para...

1.Added data compression for dlog.detail and application.detail 2.Added upgrade plugin 3.Added ve...

1.Fixed admin.py bug overwriting original tconfig which causes 500 on GET /admin/config 2.Improve...

1.Fixed minor bugs 2.Added pagelimit parameter for all list response

1.Config format update (Use config_upgrade.py in release to upgrade config to v1.10.1) a) Item na...

1.Added expense, net_profit column in exported .csv table 2.Updated delivery webhook post

Added zlib compression for telemetry data (saving ~40% storage)

1.Changed config.telemetry_innodb_dir to mysql_ext 2.Moved announcement, dlog, division, event, a...

1.Fixed the bug that User ID replaced User Name on /dlog 2.Updated telemetry data encoding method

1.Updated IP check mechanism 2.Allowed admin roles to be updated with API 3.Added response status...

Added config.perms.hrm who has higher permission than config.perms.hr

Added config.perms.announcement for announcement permission control

Added limituser argument for /dlog/leaderboard

1.Fixed the issue that delivery webhook post would fail when config.delivery_gifs = [] 2.Added au...

1.Added PATCH /user/unbind endpoint to unbind connections 2.Added DELETE /user/delete endpoint to...

1.Fixed bugs with role detection 2.Updated driver detection mechanism for application

1.Added Rate Limiter 2.Added response status code for 401 and 404 errors 3.Updated delivery webho...

1.Removed function to not create database table for disabled plugins 2.Updated delivery webhook p...

Fixed bug of navio webhook not accepting WoT jobs due to non-int meta distance

Fixed bug of welcome_roles failing to remove roles

Fixed bug of welcome_roles failing to remove roles

API 1.Removed intcolor from config.json and calculate it with hexcolor on start 2.Removed /versio...

Fixed Discord and Steam ID JSON precision lose

1.Fixed apis/navio config.external_plugins mistaked for external_plugins 2.Fixed apis/member to u...

1.Added custom team update message, accept {mention} {vtcname} variable 2.Added custom welcome me...

1.Added option to remove TruckersMP Account requirement 2.Fixed bug that translate function does ...

1.Fixed bugs of config editing and improved data check 2.Fixed bugs that delivery embed cannot be...

Fixed bugs of config editing

1.Fixed bug allowing user to edit telemetry_innodb_dir and language_dir from API 2.Added Spanish ...

1.Supported multiple language 2.Improved division to support certain point for each division 3.Re...

1.Added telemetry_innodb_dir config option to store telemetry table on external storage 2.Bug fix...

1.Added permission control for audit log 2.Removed non-driver (but member) from leaderboard

Initial version code since public release

Added TruckersMP user info in applications Added export member list (csv) Added login screen tip...

Added inputable page number in tables Added debounce in table page change to reduce unnecessary ...

Replaced vars.users with Context API users, and reworked UserCard component, thus: Supported us...

Added batch role update (advanced staff function) Added batch tracker update (advanced staff fun...

Fixed permission issues on displaying user management buttons Fixed api config editing issues by...

1.Added Steam Sign Up 2.Added Connect Discord 3.Added QRCode when enabling MFA 4.Fixed extension

v2.6.6 Added update custom profile v2.6.5 Updated to be compatible with API v2.1.5 v2.6.4 Updated...

1.Replaced UniSans with OpenSans 2.Fixed name/role display 3.Added support to multiple applicatio...

1.Added shortcut button to update division status 2.Fixed sigfig showing undefined suffix for num...

1.Removed lazy load 2.Downgraded SimpleBar 3.Changed mini leaderboard in overview tab to monthly ...

1.Added TSR Card (Removable) -> If you want it back after removing it, Clear Cache in Settings 2....

1.Added pending application count badge

1.Updated Turkish Translation 2.Added application min-length attribute

1.Added 2022 Wrapped 2.Added tab title 3.Changed default chart scale to 360d

1.Fixed chart stretching endlessly when resizing window 2.Fixed user profile tab some title / but...

0.Changed CDN domain to cdn.chub.page 1.Updated to be compatible with API v1.21.7 2.Fixed HR cann...

0.Added nighty release 1.Fixed the bug that dropup banner does not display on regular / premium p...

1.Fixed the issue that <td> are not in <tr> 2.Fixed profile dropup stuck visible when disabled 3....

1.[Announcement] Fixed announcement editing showing original content 2.[Application] Fixed defaul...

Brand new design / Increased usability / General Improvements

Added partial MFA support

1.Removed Dark Mode transition 2.Added SimpleBar for menu 3.Improved svg icons - Genuine FontAwes...

1.Fixed staff controls not showing up 2.Fixed staff positions not showing up 3.Fixed event detail...

Templatized all tables

1.Fixed LoadCache() is not called which made entire website not loading 2.Fixed User Profile does...

1.Fixed the bug that event details are not loading 2.Updated endpoint paths / methods to catch up...

1.Fixed the bug that event details are not loading 2.Updated endpoint paths / methods to catch up...

Updates to catch up with API v1.12.7

1.Fixed staff application "Agree to terms" not working 2.Added button to save downloads content

1.Added redirect for /banner/{userid} 2.Improved <a> text color in dark mode 3.Added load timeout...

Updates to catch up with API v1.12.2

Updates to catch up with API v1.12.1

Updates to catch up with API v1.11.3

1.Fixed the bug that announcement is sending test as message content 2.Fixed the bug that applica...

1.Updated note under "Update Member Points" 2.Updated ETS2 ProMods settings to support latest map...

Updated API config wizard to support API v1.11.1

Added custom style (css)

Added custom application

Delivery Tab 1.Resumed Driver of the Day (Counting from 0:00 UTC instead of using relative -24h c...

Updates to catch up to API v1.10.6

1.Added support to editing web config 2.Added better redirect for /images (to drivershub-cdn.char...

1.Added support to editing web config 2.Added better redirect for /images (to drivershub-cdn.char...

Updated footer

Various bug fixes, including: Application submission error showing "UNHANDLED" even if there's e...

Added telemetry data decoder for v5 (API v1.9.9)

Updates to catch up to API v1.9.4

1.Added Unbind Account Connection function 2.Added Delete User function 3.Added Export Delivery L...

1.Fixed <select> doesn't work with translations 2.Removed guest login and redirect to /login when...

1.Removed "Manager" / "Lead" role name detection for higher role 2.Updated Profile Page 3.Added f...

1.Updated font 2.Updated login page title & subtitle 3.Removed Detail button for delivery table a...

1.Fixed overview incorrect data display 2.Added more administrator config fields

1.Load .js plugins based on enabled_plugins by .php 2.Fixed leaderboard not showing today's stati...

1.Load .js plugins based on enabled_plugins by .php 2.Fixed leaderboard not showing today's stati...

Bug fixes

Bug fixes

1.Bug fixes 2.Added admin functions

Restructured code

Basic templatization

The CHub Utility bot is primarily deployed in three rollout stages: Alpha - the Alpha release w...

v2.0.1 - Changelog Adds /ping, which pings for message reply latency and API latency to your pro...