Posted x ago section in comments is incorrect for new comments

[minusQuantumNeko]

If new comment is created, it will say it was posted 59 minutes ago, when it's actually not true, and tooltip shows actual post time (in GMT)

[Tanza3D]

on local servers it's even more wonky, on my local test it says 3 hours. i think it's because on the database side the date is stored as whatever timezone the server's in, but on the local side it reads it as UTC or something

[minusQuantumNeko]

on local servers it's even more wonky, on my local test it says 3 hours. i think it's because on the database side the date is stored as whatever timezone the server's in, but on the local side it reads it as UTC or something

But the thing is even like that, the time will be incorrect if we count difference between timezones

[Tanza3D]

hm right i gotcha, hmm, gotta think abot that some more

[FujiwaraSatomi]

Why not implement it in JavaScript

[Tanza3D]

it is https://github.com/Osekai/osekai/blob/main/global/js/comment_system.js#L143

the issue i think at this point is the server is sending a time in UTC+1, but then the code is interpreting it as simply UTC so it thinks it's posted an hour in the future. shouldn't be too impossible to fix

[FujiwaraSatomi]

If the server always sending a time in UTC+1, you can use the setHours function in JavaScript to set it to UTC like this

[Tanza3D]

the better way to do it is to just store dates in UTC instead.

[FujiwaraSatomi]

ic😅

[Tanza3D]

this is fixed... temporarily...
in a few months, the timezone will change again, and the dates will go back to being horribly wrong...
maybe, i don't know with the new server at this point...
we will see...