Page 1 of 1

Suggestion for 1-Jan-1970 problem

PostPosted: Wed Dec 24, 2003 9:09 am
by MediumRare
This is probably just a zero in the time field, so that the times shown are 0:00 hours UTC on 1 Jan. 1970, the "epoch" for the Unix time system (they show up as 31 Dec. 1969 for me at UTC+1).

Although I'm not directly affected by this problem myself, I do look through old threads occasionally, where the time got wiped. Sometimes the posts are shown in the correct order, sometimes they end up reversed- which is rather disconcerting. Furthermore, there's an ongoing discussion on the "first post" in the Beer Garden right now.

Here's a suggestion to at least show the correct order of these posts:
Code: Select all
replace all 0-times with the post number

Most posts would still show as 1-Jan-1970 (post no. 36000 would be at 10 a.m. UTC), but the chronological order would be correct.

This should be possible with a simple SQL-command or a Perl 3-liner (depending on how the data is stored). The date joined could be processed similarly- assuming that the member nos. are assigned successively.

Of course it would be best to try this out on a copy of the data first! :wink:

G

Re: Suggestion for 1-Jan-1970 problem

PostPosted: Wed Dec 24, 2003 12:12 pm
by dodecahedron
MediumRare wrote:(they show up as 31 Dec. 1969 for me at UTC+1).

that depends if you're logged in or not, and on your GMT settings.

PostPosted: Wed Dec 24, 2003 12:56 pm
by cfitz
Good thinking, MediumRare. I agree that it would help when reading archive threads. I also have run into the problem you describe where the individual posts are sometimes out of order and very difficult to follow in old, yet still valuable, threads.

cfitz

PostPosted: Thu Dec 25, 2003 12:56 am
by dodecahedron
cfitz wrote:Good thinking, MediumRare. I agree that it would help when reading archive threads. I also have run into the problem you describe where the individual posts are sometimes out of order and very difficult to follow in old, yet still valuable, threads.

yeah, i've had that too.
it's very hilarious or very annoying. depending on your mood or how badly you need the info in that topic!

PostPosted: Tue Feb 08, 2005 8:33 am
by MediumRare
Hey! I just noticed that this has been implemented. :D :D =D> - don't know how long it's been active, but thank you socheat. It sure helps when navigating through old threads!

G

PostPosted: Tue Feb 08, 2005 9:09 pm
by socheat
I did it when we switched servers last week. :) Forgot to mention it, and I'm amazed you actually noticed. :o :wink:

PostPosted: Wed Feb 09, 2005 12:16 am
by cfitz
Socheat wrote:I'm amazed you actually noticed. :o :wink:

MediumRare notices everything, particularly when it comes to numbers. I think it is the "medium" in him that makes him that way... :)

cfitz

PostPosted: Wed Feb 09, 2005 5:02 pm
by MediumRare
Socheat wrote:I did it when we switched servers last week. :) Forgot to mention it, and I'm amazed you actually noticed. :o :wink:

I noticed it while doing some link-chasing when checking what I'd posted here (the same information showed up redundantly in that thread).

I landed at the original thread for this hack: Next tip: displaying the real burning-speed in Nero and found it was readable (which it wasn't the last time I looked)! Eureka!

Incidentally, the oldest post I've found on the forum is this one: http://www.cdrlabs.com/phpBB/viewtopic.php?p=304#304. But you guys with access to the database can fish out the real oldest one. :wink:

Thanks again for implementing the fix!

G