Messages posted by: Anonymous

Other than these guestbook notifications, I'm not aware of a single other email that I have ever failed to get. Surely if this were a problem, SOMEBODY who sent me an email that I didn't react to would have somehow inquired about it.

And let's not forget -- the Advanced Guestbook is an informally supported freeware application that has a lot of problems with people hacking it. It's a great application, but we (or at least I) can't get too upset when a big dog like AOL doesn't uncritically accept its output.

I just don't understand the people who knock AOL. I've tried many online services since the mid-80s, and most of them are no longer around. In this century, I haven't found any that make it worthwhile to switch away from AOL. There are less expensive services, but in my experience, they (and AOL) give you just what you pay for. And when AOL falls behind in any area, they catch up pretty quickly with whomever might be ahead of them.

Anyway you can explain to me how it would work, if it would? Can i install it and find a way to edit the dates easily? if you know a guide I would appriciated a link to it.. but doubt theres one for fixing advanced guestbooks dates.. if its complicated just say and I'll try the .txt to .gz conversion.. I'm just skeptical to tryit and have it not work at the moment, don't want to lose it all again :\

Is that the administration on the guestbook?

Or something different? I'm new to php sorry..

I did use the guestbooks form to enter them all in, but the administration menu only lets you edit everything (including ip) except the date and time...

There were no previous backups that I could find..

But that link is perfect!! just what I was looking for, thank you.

Not too sure how I'm going to correct it once I fix the problem though, I can download the backup database (the new one with the March 2nd dates), change the .gz to .txt, edit the timestamps, change it from .txt to .gz and upload it over the old database...

Least I hope that could work

Ok, basically I lost all my comments yesterday, with no backups at all.

But I turned my browser offline and made my way to the guestbook in the cache. With the comments there. One by one I put them back as they were, only now the dates are from today, not whenever they were originally.

So I'm trying to find where I can go to edit the dates back to the original. The guestbook is hosted on a cpanel based root directory. Only way I know how to access the database is through the "download backup database", which gives you a .gz file of the information I posted.

I guess after I edit it I can just re-upload it, but other then that I don't know where this information is normally kept.

thanks it worked fine!!!

Thing is I dont know exactly where book_data is, the file I got was the guestbook backup off cpanel (the one from today, there wasent a earlier), it gave me a .gz file with all this information in it, I don't know where I would go to find the real database or where cpanel stores it

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

Yea, where can I find the file with the book data infomation in it?
All I found in the main database was this for example, for an entry:

INSERT INTO book_data (id, name, gender, email, url, date, location, host, browser, comment, icq, aim) VALUES (25,'(Name)','(Genger)','(email)','(url)',1109797430,'(location)','(ip address)','(browser)','(messege)',0,'');

Name, gender, email, url, location, ip, browser and messege of the specific comment edited out.

I guess the 1109797430 is the date?

The entry was made today so how can that be interpreted?

Exact date and time was Wednesday, March 2, 2005 04:03 PM

Anyone have any ideas?

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.

Looks good to me, too, using IE6.

RELATED SUBJECT: I notice that the text color in the "comments to comments" is different than that in the comments themselves. I've got the same situation, and it's not very compatible with the rest of my colour scheme. Does anybody know how to fix it?

Lou Sander
Pittsburgh, Pennsylvania
USA

I need to adjust the font size, color, etc., and maybe add some stuff. The english.php seems only to contain the canned text for the screen.

Auron wrote:All guess work mind you, why don't you try it for yourself?

I have, but I'm not comfortable enough with PHP to have confidence that I've tried everything possible!

Auron wrote:
edit; even if you did collect the addy and store it in the db it would only display if you edited the files and templates to display it. Unless you made them put the addy in the comments field.

I stashed it in the comments field. I just changed the template to say enter address, trying to avoid changing the code and db structure which would make upgrading ap more of a hassle in the future.

Thanks for the reply!

I tried all those other thing -_-, but it won't work. Well guess nobody bothers to reply anyways so :/.

Are there other people with this problem? ~_~