Index

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

 

 

I. Project Infos

project:   Jax Guestbook (Visitors Book)
     
file:   jax_guestbook.php
     
version:   2.2 (optional database support)
     
interpreter:      PHP 4
     
code:   Andreas John
     
design:   Andreas John
     
homepage:   www.jtr.de/scripting/php/guestbook
     
license:  

Copyright (C) 2001, Andreas John (jack@jtr.de)

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

 

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?

 

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

Jax Guestbook is a script, that enriches your homepage with a little visitor's book. In a 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 to your website!

    After uploading the script to your webspace make sure (by changing the file attributes and owner) the script can full access the csv-files (normally "guestbook" und "ips2block")

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

 

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 (see "How to install Jax Guestbook on my website?")

  2. Run the guestbook administration programm 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` (
    `ip` varchar(16) NOT NULL default '0',
    `timestamp` varchar(10) NOT NULL default ''
    ) TYPE=MyISAM;

  5. If you already have a guestbook in CSV-format you can add it to your MySQL-database under "Import/Export Guestbook"...

 

4. How many entries Jax Guestbook can handle?

I tested the script with a realistic amount of entries (about 150 in CSV-file) and it did 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...

 

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, 09.09.2001 Jack (tR)