Location: PHPKode > projects > PHP Booking Calendar > booking_calendar/setup.txt
###########################################################

phpBookingCalendar - Booking Calendar
Copyright (C) 2004 Jeffrey James Walters

Licensed under the terms of the GNU Lesser General Public License:
http://www.opensource.org/licenses/lgpl-license.php

For further information visit:
http://www.jjwdesign.com/
hide@address.com

Version:  1.0 Beta 1
Modified: 2004-08-26
Apache/1.3.31, PHP/5.0.0, MySQL/3.23.57

###########################################################

Setup:

Setup information & variables can be found in:

includes/application_top.php

The first thing you will notice about this file is the "testing"
server settings.  These can be left alone, unless you wish to setup
a testing server on your Win32 machine.  In that case I would 
suggest looking towards WAMP5 to accomplish that task.  Otherwise,
setup the Web server settings where appropriate.

http://www.en.wampserver.com/

Much of the 'application_top.php' file is setup constants, which
are already defined properly.  Web server and file server paths 
are defined and PHP include paths are extended.

MAIL_MYNAME and MAIL_MYEMAIL must be set for the Web server to 
allow Sendmail to function properly.

Make sure to properly set the SQL database connection constants:
DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE
Check with your ISP if you are not sure of your database connection.

Towards the bottom of the 'application_top.php' file are the 
majority of the booking calendar settings.

BOOKING_TIME_INTERVAL:

This is an extremely important setting!!!!!!!
Once set, it can not be modified.  I recommend setting the interval
to either '30' or '15' (seconds).  This should suffice for most
booking calendar situations.

MIN_BOOKING_HOUR and MAX_BOOKING_HOUR

These two settings are also extremely important! Once set, you can
expand the range, but it has not been fully tested yet.  Reducing the
range would be more challenging and is not yet supported.

location_db_name

This array provides the mapping between location key and the schedule
MySQL DB table field name.  Is you add additional keys, make sure to 
add the columns to the 'booking_schedule' table.

location_display

This array provides the mapping between location keys and the 
display text to be used by the Booking Calendar.

Requirements for authentication (login) and user settings can
also be found at the end of this script.


MySQL:

Once you've defined the basic setup parameters it's time to 
setup your MySQL tables.  MySQL SQL setup can be found in

includes/sql/mysql.sql

I would recommend using phpMyAdmin or some other MySQL tool
to execute the setup query.  Make sure to add columns for
additional locations in the 'booking_schedule' table, if needed.

http://www.phpmyadmin.net/home_page/


FCK Editor 2.0 Beta 1:

The booking calendar takes full advantage of one of the best 
WYSIWYG text editors available, FCK Editor.  Now in version 2.0, 
it supports Internet Explorer, Mozilla and Netscape browsers.

http://www.fckeditor.net/

FCK Editor directory: editor
Setup file for the FCK Editor:  fckconfig.js
CSS for the FCK Editor:  editor/skins/office2003/fck_editor.css

The FCK Editor distribution has been trimmed down.  For additional
skins and languages, please visit the FCK Editor download page.


overLIB 4.00:

Also integrated into the calendar is the overLIB javascript 
which handles the creation of the popup information boxes.

http://www.bosrup.com/web/overlib/

CSS/Fonts can be found in the setup file:  overlib.js


Session Directory:

The includes/sessions/ directory must be made writable for the 
user sessions to be stored.  This script is setup not to use the 
PHP default sessions directory, because of security issues.

chmod 0775 sessions


Log Files and Logs Directory:

The Logs Directory and the included files need to also be set
to writable and executable.

chmod 0775 logs
chmod 0664 parse_time_log.txt


Beta Warning:

While this is the first official release of the phpBookingCalendar - 
booking calendar script, I can not guarantee that future versions will
be backwards compatible.  Indeed, the database location mapping will
most likely be integrated into a future administration section.

Thank you for reading all the way down here ;)
Jeff Walters

Feel free to send bugs/comments/corrections/wishes to:
hide@address.com


Return current item: PHP Booking Calendar