Suggestions for online activity charts

[Minecraft0122]

I would like to be able to..

When the server is offline, show a gray indicator for offline in 'Online Activity'.

Is your feature request related to a problem? Please describe.

Now it will skip this offline period and just show the last online time.

[AuroraLS3]

Does the Show_gaps_in_data setting in the config suffice?

[Minecraft0122]

配置里的Show_gaps_in_data设置够用吗？

It seems like I haven't enabled it

[Minecraft0122]

Oh no, my server has an error

https://mclo.gs/PB9TUVw

[Minecraft0122]

Hmm, when I turn on this option, it says it can't get a valid connection.
But when I turn it off, it works.

[AuroraLS3]

I would try again, error is deadlock which occurs only sometimes

[Minecraft0122]

我建议你再试一次，错误是死锁，这种情况只偶尔发生

This might be an issue with my database's performance.

My AI tells me that the database keeps getting locked because there are a lot of nested queries.
UPDATE plan_user_info SET banned=0 WHERE (user_id=(SELECT ... FROM plan_users ...))

My AI came up with an optimization plan, which is to split it into two statements to execute.

If you think this is my problem, you can close it. Because I don't understand these things :)

[Minecraft0122]

Oh right, #4512 needs your reply :(
I found that if I want to modify an existing file, I need to try making changes in the repository of the person who opened the pull request.
Or rather, you can't directly edit the files in an existing pull request.