Change date in messages.

Deleted recently the database of my guestbook.
Made a new one, now I replace all the messages, no problem.
Only I want to change the dates to their original time they were posted.
Any idea??
Thanks

Here is a how to change the time and date of your guestbook entries.
The only problem is that you will have to convert each time separately and depending on how much entries you have it can take a while.

You can find a UNIX time converter at this page.

Converter

You will have to edit the mysql database field for each time you want to change.
Open up your database in PHPMyAdmin, click on book_data, and then click on browse. This will open up your guestbook inputs into columns.
Click edit on each guestbook entry.
Look in the date field and your will see a number like this 991795727. (UNIX time format for the date of 6 June 2001, 02:48:47GMT)
Now go to the converter:

Converter

Now place the dates into the box and it will spit out the UNIX format which you will then put into the data field in the mysql book_data.
It’s a long process if you have a lot of guestbook entries.
But worth it in the end, because it appeared that your guestbook was a seamless upgrade from another guestbook.

It might be possible that there is a small time differents with this converter.
In my case it added 2 hours to the time I inserted.
Thus 12:00 becomes 14:00 just subtract 2 hours of the time you want.
So if you want to have 12:00 fill in 10:00