Z-DNA

Copyright (c) 2011, Zipper Software.  All rights reserved.
http://zippersoftware.com/
dennis@zippersoftware.com

Overview
--------

   Z-DNA is a set of PHP scripts that allow you to present Y-DNA test
   results on your DNA Project's website.

   For an example of Z-DNA's presentation, go to:

   http://zippersoftware.com/zdna/zdna_results.php

Requirements
------------

   The only requirements are a web host which supports:

	   a) PHP
	   b) MySQL
	   c) A MySQL Administration tool such as phpMyAdmin
	   d) FTP
	
Pre-Installation
----------------

   You must create a MySQL database on your web host prior to installing Z-DNA.

Installation
------------

1) Download ZDNA.exe.

2) Run ZDNA.exe. This will extract the Z-DNA files to a folder on your PC. You
   will be asked to supply a password, which was provided when you purchased
   Z-DNA.

   You should end up with a directory structure like:

   zdna
   ¦   license.rtf
   ¦   readme.txt
   ¦   zdna.css
   ¦   zdna_config_sample.php
   ¦   zdna_footer.php
   ¦   zdna_header.php
   ¦   zdna_results.php
   ¦
   +---charts
   ¦       charts.txt
   ¦
   +---images
   ¦       backdrop.png
   ¦       email.png
   ¦       help.ico
   ¦
   +---setup
           create.sql
           drop.sql
           zdna_create.php
           zdna_drop.php

3) Rename zdna_config_sample.php to zdna_config.php.

4) With any text editor, change zdna_config.php to suit your configuration. At
   the very least you will need to change:
   
     a) $zdna_db_server
     b) $zdna_db_name
     c) $zdna_db_login_id
     d) $zdna_db_login_pw

5) Use an FTP client to upload the entire zdna folder and all its contents to
   your web host.
   
6) Start your web browser and run the script:

   http://<yourdomainname>/.../zdna/setup/zdna_create.php
   
   The "..." represents additional path info that you may be required to
   provide (based on where you installed Z-DNA).
   
   This script will create the database table (default table name is 'zdna')
   that is used by zdna_results.php.
   
7) If you wish to drop (permanently delete) the database table, run the script:

   http://<yourdomainname>/.../zdna/setup/zdna_drop.php
   
   The "..." represents additional path info that you may be required to
   provide (based on where you installed Z-DNA).
   
Loading DNA Data
----------------

   Use a MySQL administration tool like phpMyAdmin to enter each DNA test
   result into the 'zdna' database table. Besides the loci, columns are:
   
  `Id`           - this is an auto-increment field (MySql will automatically
                   generate this value)
  `Visible`      - 1 to make show, 0 to hide (required)
  `DescendantOf` - text which describes this DNA test (required)
  `Link`         - URL to an external website where additional information
                   regarding this family line or DNA test is provided
                   (optional)
  `FamilyGroup`  - used to group related tests (optional)
  `TestedBy`     - names the testing company (optional)
  `TestedDate`   - date test was conducted (optional)
  `CaseNo`       - number/id of the test assigned by the testing company
                   (optional)
  `Email`        - email address of the contact for this test (optional)
  `Haplogroup`   - haplogroup (optional)
  
Support
-------

   You can contact the author of this software at dennis@zippersoftware.com if
   you have any questions or find any bugs.
   
   If you need some custom coding in connection with this software, I can do
   that at a rate of $25.00/hour.