Topic: change the date of a post
Hi,
A small question here.
How can I do to change the hour and the date of a post manually in the DB? Where is it?
Ludo,
Re: change the date of a post
posted in the posts table
It's a unix timestamp
Re: change the date of a post
just out of curiosity, why would you want to do that? 
4 2005-11-16 20:11 (edited by Ludo 2005-11-16 20:28)
Re: change the date of a post
Mark wrote:
just out of curiosity, why would you want to do that?
Well, imagine that sometime ago I did not use punbb to publish some documents. Now I do it with punbb.
I need my documents to be posted chronologically. I need to post my former document in punbb. If I do not want former document to be first in the list, I need to change their date...
I hope I'm clear enough 
5 2005-11-16 20:19 (edited by Ludo 2005-11-16 20:25)
Re: change the date of a post
Ok, I'm just trying.
Is it in the column 'posted'?
Can '1131568433' be a date for example?
I found the solution alone. Google was my friend http://www.davidtouvet.com/blog/archive … timestamp/
Ludo,
6 2005-11-16 20:27 (edited by Ludo 2005-11-16 20:32)
Re: change the date of a post
In fact, it seems that there is 2 date for a same post.
There is the date the post was posted which I modified.
There is also the date of the last post in the thread which is the same as the first I talked about when there is no reply. But this date is not affected when I change in the column 'posted'.
Any idea?
Ludo,
Re: change the date of a post
There is some redundancy in that respect (to increase performance). "posted" is when the post was created. This field exists for both posts and topics. Then there's last_post. This exists for both topics and forums.
"Programming is like sex: one mistake and you have to support it for the rest of your life."