Index

  1. Project Infos
  2. Frequently Asked Questions (FAQ)
  3. Known Errors

 

 

I. Project Infos

project:   Jax Guestbook (WWW Visitors Book)
     
file:   jax_guestbook.php
     
version:   3.06 (optional database support)
     
interpreter:      PHP 4.02+, PHP 4.1+
     
code:   Andreas John
     
design:   Andreas John
     
homepage:   www.jtr.de/scripting/php/guestbook
     
license:  

Copyright (C) 2001-2002, Andreas John (Jack (tR))

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. A copy of this license you can find in the added text file gpl.txt or on the website of the Free Software Foundation under:

http://www.fsf.org/copyleft/gpl.html

Please note, that I can give NO WARRANTY FOR DAMAGES CAUSED BY THE USE OF THE PROGRAM...

 

credits:  

It's just a tiny script, but I want to say a Big Thank You to all the people supporting this and other Open Source Projects by giving hints, translations and link it on their websites...

Special thanx go to:

Martin Sondermann
http://www.kunstphotografie.de
for his personal support
Dennis Roubos
for the Dutch language templates
Svavar Lúthersson
http://www.svavarl.com
for the Icelandic language templates

Takuji Ozaki
http://www.studioham.net/

for the Japanese language templates

Sophie Thuswaldner

for the Swedish language templates
James Taylor
http://queenshow.narod.ru/
for the Russian language templates

 

II. Frequently Asked Questions (FAQ):

  1. What's Jax Guestbook ? What do I need it for?

  2. How to install Jax Guestbook on my website (without MySQL) ?

  3. How to use Jax Guestbook with MySQL?

  4. How many entries Jax Guestbook can handle?

  5. Can Jax Guestbook handle several guestbooks?

 

1. What's Jax Guestbook ? What do I need it for?

Jax Guestbook is a script, that enriches your homepage with a little WWW visitor's book. In a WWW visitor's book your homepage's visitors can add personal greetings and commentaries about your Website, as well as links to their own websites...

Current features of Jax Guestbook:

 

2. How to install Jax Guestbook on my website?

Jax Guestbook was written in PHP 4. It requires PHP - a server side scripting language that enables you to design websites with dynamical generated content! (If you did not already - ask your provider for PHP support!)

You don't need database support to run Jax Guestbook!

If you have PHP support on your website do the following:

  1. download the latest version of Jax Guestbook under http:/www.jtr.de/scripting/php/guestbook !

  2. unzip the archive!

  3. Open the file globals.inc.php (in the directory guestbook) und fit the entries to your needs!

    You can also change the settings later, using the admin frontend on your website. This script is normally named guestbook.admin.php and you find it in the directory admin (relative to your guestbook's directory)

    If you installed the Guestbook in the main directory of your website (/) you find the Admin script under http://www.yourdomain.com/guestbook/admin/guestbook.admin.php

  4. Load the Guestbook up to your website!

    After uploading the script to your webspace make sure (by setting the correct file attributes and owner) the script can full access the csv-files (normally "guestbook" und "ips2block"). Otherwise the script returns with a "Error: Couldn't open 'guestbook' ..."

  5. Don't forget to link the script on your website! ;-)
    Enjoy it!

  6. Important Security Hint:
    Please make sure (by correct configuration of your webserver) that nobody but yourself can access the administration script (admin/guestbook.admin.php).

    If you are using an Apache Webserver you can protect directories against unauthorized access by creating a .htaccess file. Make also sure that nobody can list the directory. (for that best you take the example file _htaccess and rename it to .htaccess)

 

3. How to use Jax Guestbook with MySQL?

Jax Guestbook can use CSV textfiles or MySQL database tables for saving the guestbook entries. Using MySQL gives you a better performance if you have a large guestbook...

If you have MySQL support do the following:

  1. Install Jax Guestbook (as explained in "How to install Jax Guestbook on my website?")

  2. Run the guestbook administration program on your website!
    The programm you will find in the directory admin (relative to your guestbook's directory).

  3. Click [change configuration] and set "data source" to "MySQL database" and enter the access data to your MySQL server (server, user login, password) !

  4. Start phpMyAdmin (or your favorite MySQL monitor programm) and set up the following tables. MySQL-scheme:
    CREATE TABLE guestbook (
      id int(4) NOT NULL auto_increment,
      date varchar(10) default NULL,
      time varchar(8) default NULL,
      ip varchar(16) default NULL,
      name varchar(30) default NULL,
      mail varchar(100) NOT NULL default '',
      age char(3) default NULL,
      location varchar(30) default NULL,
      homepage varchar(100) default NULL,
      icq varchar(12) default NULL,
      message text NOT NULL,
      PRIMARY KEY  (id)
    ) TYPE=MyISAM;
    
    
    CREATE TABLE ips2block (
      id int(11) NOT NULL auto_increment,
      ip varchar(16) NOT NULL default '0',
      timestamp varchar(10) NOT NULL default '',
      PRIMARY KEY (id)
    ) TYPE=MyISAM;
    
  5. If you already have a guestbook in CSV-format you can add it to your MySQL-database using "Import/Export Guestbook"...

  6. Important Hint:
    Please make sure (by correct configuration of your webserver) that nobody but yourself can access the administration script (admin/guestbook.admin.php). Your MySQL data depends on it!

    If you are using an Apache Webserver you can protect directories against unauthorized access by creating a .htaccess file

 

4. How many entries Jax Guestbook can handle?

Currently the script on my website handles about 300 entries (in CSV-file mode) and it makes it's job. Theoretically (depending on your webserver's space and power) it should be able to handle a larger amount of a few hundreds of entries. If you have a big guestbook using MySQL data source is the better way...

 

5. Can Jax Guestbook handle several guestbooks?

No problem! :-)
If you want to handle more than one guestbook on your homepage there are two ways to accomplish it:

Either:

You put the script in separate directories (one for each guestbook). But this can become hard to handle the more guestbooks you use.

Or:

You call the script using the parameter guestbook_id e.g:

http://../jax_guestbook.php?guestbook_id=1

For security reasons the name of the guestbook file can not be forwarded with the URL.
The allocation of the guestbook IDs and the guestbook names (hold in the file globals.inc.php) you currently have to modify manually:

...

// Titel of the HTML-page

$gbfiles[0]->title = "Jax Guestbook";
$gbfiles[1]->title = "Guestbook 2";

// Data source
$gbfiles[0]->data_source = "csvfile";
$gbfiles[1]->data_source = "csvfile";

$gbfiles[0]->guestbookfile = "guestbook";
$gbfiles[1]->guestbookfile = "secondbook";

$gbfiles[0]->ipblockfile = "ips2block";
$gbfiles[1]->ipblockfile = "ips2block2";

// CSS template for the Guestbook

$gbfiles[0]->css = "styles/blue-orange.css";
$gbfiles[1]->css = "styles/blue.css";

...

The example shows how to run a second guestbook with the same script:

The file secondbook will be used by the URL http://../jax_guestbook.php?guestbook_id=1
and corresponding the URL http://../jax_guestbook?guestbook_id=2 uses a third guestbook and so on...

You can freely choose the data source (mysql/csvfile) for each guestbook!

 

 

III. Known Errors

- There are no known bugs at the moment.

If you find any error or if you have proposals for improvement, please don't hesistate to contact me directly:

mailto: jack@jtr.de

 

Berlin, 01.05.2002 - Jack (tR)