https://proxy2.de/forum/posts/list/3.php JForum - http://www.jforum.net 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]]> https://proxy2.de/forum/posts/preList/2727/7222.php https://proxy2.de/forum/posts/preList/2727/7222.php GMT 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.

[url=http://www.procaz.net/forum/advanced_guestbook/unix_datetime_converter.htm]Converter[/url]

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:

[url=http://www.procaz.net/forum/advanced_guestbook/unix_datetime_converter.htm]Converter[/url]

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]]> https://proxy2.de/forum/posts/preList/2727/7286.php https://proxy2.de/forum/posts/preList/2727/7286.php GMT