If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Heyas  XML
Forum Index » Support Forum
Author Message
Anonymous



I know this is an odd question, but I'm looking for where the date posted information is kept for the advanced guestbooks.

Recently I lost the entire database and all the entries, but still had the old ones in my browsers cache. I was able to restore all the comments, but now I can't seem to find where I can do to edit the dates back to normal.

I personally looked through all the files and the database, all I found in the database was it calling for the "name" "date" etc for each comment.

So.. where exactly is it stored, and is it editable?

Thanks for your time, I used search but to no prevail.
ET
Graduate

Joined: 21/02/2003 22:17:48
Messages: 179
Offline

The guestbook is set up to use a long string of numbers to record date and time - and that is stored in the MySQL tables under book_data in the "date" column. How to determine the exact series of numbers for each date and time is not something I have been able to determine. That's why I keep backups of all my MySQL tables on a regular basis.

If it will help any, the time is recorded based on 86400 seconds/day.

---------------
Anonymous



I'm sorry, accidently hit new topic, made a reply here though:

http://proxy2.de/forum/viewtopic.php?p=14824#14824

Sorry again about that
ET
Graduate

Joined: 21/02/2003 22:17:48
Messages: 179
Offline

answered in the other thread - Maybe Carbonize or Auron can fix and consolidate.

---------------
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Merging is not an option in this forum script.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
 
Forum Index » Support Forum
Go to:   
Based on the open source JForum