Guestbook plugin - importing entries - date editing

[vian]

Hi. I am just testing the guestbook plugin. I have succesfuly imported all entries from my old guestbook. The only problem is that there is no option for editing the entries date.
For example: an original entry was added on November 16, 2006; I can import its text, sender's email, even the admin's reply, but cannot edit its date (there is today's date at every entry).
I tried to download the mysql database backup via "Plugin DB administration" to edit it manually, but I do not see any "human format" of the entries date. Any idea how to get it sorted?

Thanks, Ivan

[vian]

Well.. It looks like the only way is to edit all timestamps directly on the server (in mysql database) . I'm just a bit confused with the strange timestamp format. Need to study a little bit (not very familiar with mysql), but I believe it will work

[Timbalu]

Hi Ivan

I dont really understand your question.

1. You made a dump (via guestbook admin panel) and imported it via PhpMyAdmin?
2. after import, all old entries have the same timestamp of today? This should not happen!
3. Yes, I never needed to set back the timestamp datetime of a guestbook entry, that is why there is no editable option for this.
4. The strange looking timestamp format is a UNIX_TIMESTAMP == seconds since January 1 1970 00:00:00 GMT eg 1158774883. They get converted via $entry['timestamp'] = strftime($this->get_config('dateformat'), $entry['timestamp']); in the guestbook plugin.
The get_config('dateformat') is the format you have set in the guestbook config.
5. in PhpMyAdmin you can see a readable format, if you do
SELECT *, FROM_UNIXTIME(timestamp) AS ts FROM `YOURPREFIX_guestbook`

Ian

[vian]

Hi Ian. Probably I didn't describe my situation completely: the problem with the incorrectly dated entries was, that I could not import them from a database via PhpMyAdmin, but only manually from a text file, since the guestbook I use on my webpage stores them in .xml format. So I used the copy & paste method (actually I only have a few comments there, so it wasn't so bad).
Thanks for your explanation of the timestamp format, it makes sense to me now - I will give it a try.

Thanks again,
Ivan

EDIT: I got it worked. Btw - there is an online unix timestamp converter as well.