https://proxy2.de/forum/posts/list/5.php JForum - http://www.jforum.net
I have successfully installed and able to admin login to Advanced Guestbook v2.3.1 way back in Nov 2002.

Recently, when I tried to admin login using the same username and password that were configured in config.inc.php, I was not able to login, and got this error "Invalid username or password. Please try again."

I did not make any changes to the php scripts since Nov 2002 and I'm not sure why the unable to login problem exists now. Any idea on where to troubleshoot other than the below lines in config.inc.php?

$GB_DB["user"] = "myusername";
$GB_DB["pass"] = "mypassword";

There is a new v2.4.2 of the Advanced Guestbook. What are the changes made since v2.3.1?

What are files I need to reconfigure and upload to the webserver to update from v2.3.1 to v2.4.2? And what are the additional new v2.4.2 files to upload? And any redundant v2.3.1 files to remove from the webserver?

Can spammers/spambot make entries to the guestbook by bypassing the sign guestbook page and appending entries to the Advanced Guestbook database in either v2.3.1 to v2.4.2? What are the spam safeguards in v2.3.1 and v2.4.2?

TIA]]> https://proxy2.de/forum/posts/preList/5906/21461.php https://proxy2.de/forum/posts/preList/5906/21461.php GMT
- This thread has been moved to the correct forum.]]> https://proxy2.de/forum/posts/preList/5906/21462.php https://proxy2.de/forum/posts/preList/5906/21462.php GMT http://carbonize.co.uk/Lazarus/Forum/index.php?topic=8.0 - Topic: I can't remember my username or password

I reckon your reset script only make changes to MySQL database without amending any of the php scripts. I'm wondering why my previous simple troubleshooting step by just amending the following lines in config.inc.php did not work:

$GB_DB["user"] = "myusername";
$GB_DB["pass"] = "mypassword";

Anyway with the password issue resolved, I see that there is the other alternative Lazarus is v1.6.1 (latest version) which can be downloaded at http://carbonize.co.uk/Lazarus/downloads.php

Judging from the dates of the readme.txt, Lazarus v1.6.1 was updated in 7 July 2006 while Advanced Guestbook v2.4.2 was updated in 8 Oct 2006. What are the differences between these 2 versions; strengths and weaknesses?

I saw your post for updating from Advanced Guestbook v2.3.1 to v2.4.2 at http://proxy2.de/forum/viewtopic.php?t=5930
[quote="Carbonize"]download 2.4.2. Copy database information from old config.inc.php to new one. Upload new files to replace old ones. Run update_db.php by visiting it in your web browser.[/quote]

But I can't seem to find any post for updating from Advanced Guestbook v2.3.1 to Lazarus v1.6.1. Pls advise.]]> https://proxy2.de/forum/posts/preList/5906/21524.php https://proxy2.de/forum/posts/preList/5906/21524.php GMT
Lazarus is a fork of the Advanced Guestbook. This means I took the Advanced Guestbook code as my starting point and then started adding/changing things. Was it really July I released 1.6.1? Anyway I called it Lazarus because at the time Advanced Guestbook was a dead project that hadn't been updated in years.

Lazarus is always being worked on and at present 1.7 beta 5 is available to download.

You will find information on updating Advanced Guestbook to Lazarus in the FAQ section of http://lazarus.carbonize.co.uk

As to which is best. I cannot say as it's a matter of taste.]]> https://proxy2.de/forum/posts/preList/5906/21525.php https://proxy2.de/forum/posts/preList/5906/21525.php GMT
Would it be easy to update v1.7 betas to stable version?

http://carbonize.co.uk/Lazarus/index.php/
[quote]
I forgot to add the template.class.php file to beta 5 so if you are missing lines from your chosen language they will not appear in English. That plus the other relevant cock ups in the release of beta 5 make me feel like a total idiot .....
[/quote]]]> https://proxy2.de/forum/posts/preList/5906/21526.php https://proxy2.de/forum/posts/preList/5906/21526.php GMT https://proxy2.de/forum/posts/preList/5906/21527.php https://proxy2.de/forum/posts/preList/5906/21527.php GMT http://proxy2.de/forum/viewtopic.php?t=4678&postdays=0&postorder=asc&start=240

[quote="Carbonize"]You could also stop search engines spidering your guestbook using a robots.txt file.[/quote]

[quote="MarcoH"][quote="Carbonize"]Marcoh email me please.[/quote]

done..

p.s. renaming the addentry.php works ok here.. (no spam since i changed him)

Also the robots.txt solution must work.

Example if you dont know:
Put a robots.txt in the root of your site.
Put in the the robots.txt file, at least:

User-agent: *
Disallow: /guestbook/[/quote]

[quote="Carbonize"]The spammers find your site using Google or any other major search engine. This is why it's a good idea to block them from viewing the guestbook by using a robots.txt file.[/quote]

I have the below issues regarding the above posts:

If I have 2 guestbooks at http://mysite.com/guestbook1/index.php and http://mysite.com/guestbook2/index.asp

I will put the robot.txt at the root of my site which is at http://mysite.com

The robot.txt simply contains the below 3 lines only?

User-agent: *
Disallow: /guestbook1/
Disallow: /guestbook2/

How do search engines know that there is a robot.txt located at the root of my website since there is no link to robot.txt from any of my webpages?

Do spambots read robot.txt?

Suppose http://mysite.com/index.htm have links to http://mysite.com/guestbook1/index.php and http://mysite.com/guestbook2/index.asp - it would defeat the purpose of the robot.txt since search engines / spambots are able to find these 2 guestbooks.

Are there any other effective ways to combat spams other than CAPTCHAs and robot.txt?

Advanced Guesbook and Lazarus use MySQL database, suppose I have another script that also use MySQL database, that means to say I have to purchase a second MySQL database from my website service provider. Using the same databese for 2 different scripts will corrupt the entries on the fields as 2 different scripts may use the same fields for it's intended purpose. Correct me if I'm wrong.

From the Advanced Guesbook admin page, I can amend the entries from guestbook users. Is there any way I can amend the date/time of these entries?]]> https://proxy2.de/forum/posts/preList/5906/21532.php https://proxy2.de/forum/posts/preList/5906/21532.php GMT
2 - CAPTCHA is an attempt at a Turing test which is where you test for an intelligent response. Another good option is randomised input names but some spammers are just using api to fill forms in via a web browser.

3 - Most decent scripts let you change the prefix used for the database tables. By default Lazarus uses book_ the same as AG but you can change this easily in the config.inc.php file. I personally have four scripts using a single database despite the fact my host offers me unlimited databases.]]> https://proxy2.de/forum/posts/preList/5906/21534.php https://proxy2.de/forum/posts/preList/5906/21534.php GMT
Suppose I want a second AG v2.4.2 guestbook located in a different folder, each with its own guestbook entries, the below are the only configuration settings I need to amend in config.inc.php? For example:

Guesttbook 1:

/* tables */

$GB_TBL["data"] = "book_data";
$GB_TBL["auth"] = "book_auth";
$GB_TBL["cfg"] = "book_config";
$GB_TBL["com"] = "book_com";
$GB_TBL["ip"] = "book_ip";
$GB_TBL["words"] = "book_words";
$GB_TBL["ban"] = "book_ban";
$GB_TBL["priv"] = "book_private";
$GB_TBL["smile"] = "book_smilies";
$GB_TBL["pics"] = "book_pics";


Guesttbook 2:

/* tables */

$GB_TBL["data"] = "book2_data";
$GB_TBL["auth"] = "book2_auth";
$GB_TBL["cfg"] = "book2_config";
$GB_TBL["com"] = "book2_com";
$GB_TBL["ip"] = "book2_ip";
$GB_TBL["words"] = "book2_words";
$GB_TBL["ban"] = "book2_ban";
$GB_TBL["priv"] = "book2_private";
$GB_TBL["smile"] = "book2_smilies";
$GB_TBL["pics"] = "book2_pics";


All other AG v2.4.2 guestbook php, configuration and graphic files remain the same and copied to the other AG v2.4.2 guestbook2 folder on my website?]]> https://proxy2.de/forum/posts/preList/5906/21535.php https://proxy2.de/forum/posts/preList/5906/21535.php GMT https://proxy2.de/forum/posts/preList/5906/21537.php https://proxy2.de/forum/posts/preList/5906/21537.php GMT [/quote]

The above issue was resolved. I just received an email from my website service provider that "queeg.mywebsiteserviceprovider.com under went a full server move over the last few days, this migration has since completed....."

I tested with a guesbook entry and the AG v2.4.2 indeed showed my local ISP address and not my website host IP address.

After I downloaded AG v2.4.2.zip from http://proxy2.de, on extracting the zip file, I see that there is a .htaccess file in the admin folder. When I ftp this file to my website, I can't see the file on the admin folder on my website with my WS_FTP Pro 2006 client even though the ftp client indicated that it has finished uploading this file. Any idea why this is so?

When i open .htaccess file with notepad, it only contains this line:
deny from all

Does AG need this .htaccess file? What is the function of this file?]]> https://proxy2.de/forum/posts/preList/5906/21538.php https://proxy2.de/forum/posts/preList/5906/21538.php GMT https://proxy2.de/forum/posts/preList/5906/21539.php https://proxy2.de/forum/posts/preList/5906/21539.php GMT
I did a search on the help file in the WS_FTP Pro 2006 client and the only thing I can find about hidden file is this:
Hidden files
You can transfer a hidden file if you know its name. To transfer a hidden file, make sure nothing is selected, and then click the Upload or Download arrow. You will be prompted for the file name.

I brought down an ASP guestbook due to spams. I intend to manually port some non-spammed guestbook entries to the AG v2.4.2 by manually entering them on the signed guestbook page. Caveat: the ported entries reflect the present date and time when these entries are entered. There is no facility in the AG v2.4.2 admin page to change the Guesbook entry date. Is there a workaround to solve this date issue?]]> https://proxy2.de/forum/posts/preList/5906/21540.php https://proxy2.de/forum/posts/preList/5906/21540.php GMT
2 - You would need to manually edit the date in phpmyadmin and use www.unixtimestamp.com to get the correct stamp.]]> https://proxy2.de/forum/posts/preList/5906/21541.php https://proxy2.de/forum/posts/preList/5906/21541.php GMT
[quote="Carbonize"]Yes the changes you specified will do the trick.[/quote]

Following the earlier discussion on creating another guestbook using the same database, I created a second guestbook with the following amendments to the config.inc.php on the guestbook2 folder:

/* tables */

$GB_TBL["data"] = "book2_data";
$GB_TBL["auth"] = "book2_auth";
$GB_TBL["cfg"] = "book2_config";
$GB_TBL["com"] = "book2_com";
$GB_TBL["ip"] = "book2_ip";
$GB_TBL["words"] = "book2_words";
$GB_TBL["ban"] = "book2_ban";
$GB_TBL["priv"] = "book2_private";
$GB_TBL["smile"] = "book2_smilies";
$GB_TBL["pics"] = "book2_pics";
$GB_TBL["cap"] = "book2_captcha";


Upon accessing this second guestbook, I received the following error:

Query Error
--------------------------------------------------------------------------------

MySQL Error : Query Error
Error Number: 1146 Table 'myguestbookdatabase.book2_config' doesn't exist
....
....
....


Kindly advise on all the necessary steps.]]> https://proxy2.de/forum/posts/preList/5906/21597.php https://proxy2.de/forum/posts/preList/5906/21597.php GMT https://proxy2.de/forum/posts/preList/5906/21598.php https://proxy2.de/forum/posts/preList/5906/21598.php GMT
Advanced Guestbook
Tables were created successfully!

When I tried to input entry into this second guestbook, the CAPTCHA randomized codes did not appear on top of the Submit, Preview and Reset buttons, therefore I was not able to know what the generated codes are and key them in. When I hit the Submit button, the below error msg appears:

Guestbook - Error
One of the input fields does not seem to be valid.

My first guestbook was able to generate the CAPTCHA randomized codes though.

I have placed robots.txt in the root folder of my website: http://mywebsite.com/

Correct me if I'm wrong; robots.txt contains only these 3 lines:

User-agent: *
Disallow: /guestbook/
Disallow: /folder2/guestbook/

where the 2 guestbooks are located in:
http://mywebsite.com/guestbook/
http://mywebsite.com/folder2/guestbook/]]> https://proxy2.de/forum/posts/preList/5906/21601.php https://proxy2.de/forum/posts/preList/5906/21601.php GMT https://proxy2.de/forum/posts/preList/5906/21604.php https://proxy2.de/forum/posts/preList/5906/21604.php GMT https://proxy2.de/forum/posts/preList/5906/21605.php https://proxy2.de/forum/posts/preList/5906/21605.php GMT https://proxy2.de/forum/posts/preList/5906/21629.php https://proxy2.de/forum/posts/preList/5906/21629.php GMT https://proxy2.de/forum/posts/preList/5906/21640.php https://proxy2.de/forum/posts/preList/5906/21640.php GMT https://proxy2.de/forum/posts/preList/5906/21713.php https://proxy2.de/forum/posts/preList/5906/21713.php GMT