Creating your own site
----------------------
Extract the files from the zip file keeping the files in their proper directories. The root
directory has a demo.sql file which contains the database tables. Instructions
for importing these tables are included in the section entitled, "Setting up your MySQL database".
These tables must be imported for your system to work.

There is a preferances file named prefs.php. This file contains configuration values 
you must modify to donfigure your site.

There is a connections.php file in the root directory. This file contains info about the
database, the user and password used to access your site. You should change the password
in the database and in the connections.php file.

For multi unit support your main page needs to pass in the unit. This html snipet accomplishes
this by providing a drop down with the unit numbers.
<select name="unit">
	<option value="1211">Troop 1211</option>
	<option value="447">Troop 447</option>
	<option value="">All Troops</option>
</select>

*****IMPORTANT NOTE ********
After your database is set up, run http://yoursite/php/setup.php. From here you can test the 
system and init the database.

For

Setting up your MySQL database
------------------------------
Connect to the MySql database by running from a command prompt "mysql -h <hostname> -u <username> -p".

The following paragraph explains how to set up your access control to your database using the default 
password. For increased security you really should create your own password and use your password in
the place of "powell". You will also need to change it in connection.php.

Once you get access to your MySQL database you need to add a user and give him the proper 
priveleges. At a MySQL prompt enter the following commands:
     GRANT USAGE ON *.* TO 'scoutuser'@'localhost' IDENTIFIED BY PASSWORD 'powell';
     GRANT SELECT, INSERT, UPDATE, DELETE ON scouts.* TO 'scoutuser'@'localhost';

To import the Scout Trak tables run the following at a command prompt, 
"mysql -h <hostname> -u <username> -p <password> scouts < demo.sql".

If you have any questions feel free to contact me at scoutmaster@codewurks.com.


Enhancements and bug fixes made to ScoutTrak project
----------------------------------------------------

ScoutTrak1_0_0.zip
Initial system rollout


ScoutTrak1_0_1.zip
-----------------------------------------------------
12/01/2001	Fixed bug when listing scouts with no birthdate entered.
12/09/2001	Added support for different calendars. If you add a new calendar to the calendars database it will be accessable in the UI. There is still no calendar manager UI.
01/10/2002	Added position table and UI.
01/10/2002	Added UI and security so scribe could edit position and patrol.
01/10/2002	Added administration, account management, logging.
02/01/2002	Added rank eligibility on scout list.
03/07/2002	Added Numbering on merit badge list.
03/07/2002	Added copy on calendar.
03/07/2002	Added sort by rank elgibility. Makes is easy to see who's up forboard of review.


ScoutTrak1_0_2.zip
-----------------------------------------------------
04/06/2002	Finally added the ability for advancement chair to edit merit badgecounselor list.
04/06/2002	Added account admin edit page.
04/07/2002	Added $ST_ROOT pref variable. If you can't put your scout site at the root directory of your website you should set this variable to the root of the Scout Trak directory.
04/07/2002	Added $backgroundTag variable to prefs.php file. This allows you to set the background tag for the entire site. You may have to set the background tag in the index.html file in the root directory depending on how you have set up your system.
08/30/2002	Fixed all the casing problems so it would run on Linux. Sorry this took so long.


ScoutTrak1_0_3.zip
-----------------------------------------------------
11/15/2003	Created UI to view multiple schedules on one calendar
02/10/2003	fixed several casing bugs. It's really working on Linux servers now :-)

ScoutTrak1_0_4.zip
-----------------------------------------------------
2/15/03		Fixed more casing errors.

ScoutTrak1_0_5.zip
-----------------------------------------------------
5/16/06		Fixed more casing errors, Arrrgh!
			Added camping tracking