PDA

View Full Version : 1969



ninja
Tue 20th Mar '01, 1:16pm
when a user is deleted all their posts show that they were regsitered in december 1969, please fix this.

leadZERO
Tue 20th Mar '01, 4:22pm
This isn't a fix but this is an explanation.

All UNIX timestamps (the timestamp used for posts and threads and every 'dateline' member of the db) are based on seconds past Epoch which is (00:00:00 UTC, January 1, 1970. So what is most likely happening is when it goes to fetch the timestamp that the person registered it is getting nothing because the person has been removed from the database. When an uninstantiated variable is first created it is given the value of 0. The program will then be taking this 0 timestamp and converting it to the timezone offset the person has set (most likely taking it back before 1970), and then PHP will most likely pass it through ctime() to convert it to world readable text. I haven't looked at the code specifically for vB regarding this or the PHP source, but I am 80% sure that is the cause of it.

So to make a long story short it isn't a bug, it's the solution that is the easiest to work with, it's functional. The only downside is those 1969 values.

Freddie Bingham
Tue 20th Mar '01, 4:41pm
Actually the reg date should say "Not Yet".

Here is a thread on my forum with a user that was deleted (see the last post).

http://www.chins-n-quills.com/forums/showthread.php?s=&threadid=3710

chrispadfield
Tue 20th Mar '01, 5:50pm
freedie, one thing that person deleted still has "search" underneath which then lists all your threads i think (because it searches for userid=0. Guess this is a bug of some sort.

Freddie Bingham
Tue 20th Mar '01, 6:01pm
The search button will return all posts made by "Guests" (or deleted users) which make up ALOT of posts on my forum.

chrispadfield
Tue 20th Mar '01, 6:30pm
arr.. i see that makes sense.