I copied all my old guestbook entries into the new advanced guestbook 2.3.1, but now all entries have the same date.
I would like to change them to the original date.
Anyone got an idea how to do this?

Thanks.

07/01/2003 18:53:32

Subject:

Anonymous

Yep been there done that... it is a pain. guestbook uses the UNIX time format. So you will have to convert each time separetly.

Open up your database in PHPMyAdmin, click on book_data, then click on browse. This will open up your guestbook inputs into colums. 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) You will go to the page [url]http://javascript.internet.com/equivalents/unix-date-time-converter.html
[/url] and place 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 is a long process if you have a lot of guestbook entries.

Have fun. took me a couple of hours doing that....but worth it in the end, because it appeared that my guestbook was a seamless upgrade from another gbook that sucked

The link for converting the time to Unix has a little bug it ads 2 hours to the time your insert.
Thus 12:00 becomes 14:00 (at least I had this Problem )

Jam'n

------------------------------------------------

Only the man who's truly educated
understands that he knows very little...

------------------------------------------------

28/02/2003 14:59:35

Subject:

Anonymous

I think I noticed the same thing, but I didn't care much about 2 hours. As far as the web surfer, or the original poster, they are not going to remember something like that. They might remember the day but that is about it.