Readme Version 4

From PGVWiki
Jump to navigation Jump to search
=======================================================
PhpGedView

Version 4.0
Copyright 2005 John Finlay and others

This and other information can be found online at
http://www.PhpGedView.net

# $Id: readme.txt,v 1.109.2.21 2005/11/03 18:43:16 yalnifj Exp $

=======================================================

CONTENTS
     1.  LICENSE
     2.  INTRODUCTION
     3.  SYSTEM REQUIREMENTS
     4.  QUICK INSTALL
     5.  INSTALLATION
     6.  UPGRADING
     7.  UPDATING GEDCOMS
     8.  THEMES
     9.  MULTIMEDIA OBJECTS
    10.  RSS FEED
    11.  DATABASE TABLE LAYOUT
    12.  MANUAL CONFIGURATION
    13.  SECURITY
    14.  LANGUAGES
    15.  NON-STANDARD GEDCOM CODES
    16.  LANGUAGE EXTENSION FILES
    17.  MIGRATING FROM SQL TO INDEX MODE AND VICE VERSA
    18.  POSTNUKE AND PHPNUKE INTEGRATION
    19.  BACKUP

-------------------------------------------------------
LICENSE

PhpGedView: Genealogy Viewer
Copyright (C) 2002 to 2004  John Finlay and Others

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.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

See the file GPL.txt included with this software for more
detailed licensing information.

-------------------------------------------------------
INTRODUCTION

PhpGedView is a revolutionary genealogy program which allows you to view 
and edit your genealogy on your website.  PhpGedView has full editing 
capabilities, full privacy functions, and supports multimedia like photos 
and document images.  PhpGedView also simplifies the process of 
collaborating with others working on your family lines.  Your latest 
information is always on your web site and available for others to see.  
For more information and to see working demos, visit 
http://www.PhpGedView.net/

PhpGedView is Open Source software that has been produced by people from 
many countries freely donating their time and talents to the project.  All 
service, support, and future development is dependent on the time 
developers are willing to donate to the project, often at the expense of 
work, recreation, and family.  Beyond the few donations received from 
users, developers receive no compensation for the time they spend working 
on the project.  There is also no outside source of revenue to support the 
project.

-------------------------------------------------------
SYSTEM REQUIREMENTS

PhpGedView requires a web server with at least PHP v4.3 and around 20MB of
web space.  The default installations of PHP on most servers should provide
you with all of the PHP functionality you should need.

To use the reporting engine, PHP needs to be compiled with XML support.  
This is compiled into PHP by default unless it is specifically disabled.  
See http://us3.php.net/manual/en/ref.xml.php

Some features of PhpGedView require the GD library and that PHP be compiled
with GD support.  Most precompiled versions of PHP include GD support.  If 
you are compiling PHP yourself you will need to configure it with the 
    --with-gd 
option.  See http://us3.php.net/manual/en/ref.image.php

The advanced calendar features of PhpGedView for converting Gregorian dates 
to the Hebrew or Jewish calendars require that PHP be compiled with the
    --enable-calendar 
configuration option.  See http://us2.php.net/manual/en/ref.calendar.php 
for more information.

For GEDCOMs larger than 2MB, you will likely need to research different
hosting options and find one that will accept a request to modify the
default memory and time limits built into PHP.  See the FAQ at
http://www.phpgedview.net/faq.php for more information about large GEDCOMs.

-------------------------------------------------------
QUICK INSTALLATION

Follow the instructions in this section to install PhpGedView if you are
already familiar with the program or are familiar with installing other PHP 
web applications.

 1.  Upload the files to your web server.
 2.  Set Write permissions on config.php and the "index" directory.  For 
     optimal security, you should move the "index" directory to a location 
     where it is not accessible from the Internet.
 3.  Point your browser to the directory where you uploaded your PhpGedView 
     files (for example, http://www.yourserver.com/PhpGedView/).
 4.  Enter your configuration settings.  If you moved the index directory, 
     be sure to specify the correct location to it on this page.  Save the 
     configuration parameters.
 5.  Enter the default administrator user.
 6.  Login as this user and upload your GEDCOM file.
 7.  Save the GEDCOM configuration settings.
 8.  Import the GEDCOM.

Optional Steps
 9.  If you want to use the language editing features you will need to set 
     Write permissions for all of the files in the ./languages folder.
10.  If you want to upload media files using the Upload Media section of 
     the Admin menu then you need to set Write permissions for your ./media 
     and ./media/thumbs directories.
11.  If you want to edit your GEDCOM file online, the GEDCOM file must have
     Write permissions set for the PHP user.
12.  If you want to use the Backup feature of the Upgrade utility in 
     PhpGedView you will need to either set Write permission on the 
     PhpGedView folder itself or create a folder named "backup" with Write 
     permissions.  Write permissions for the PhpGedView folder can be 
     removed as soon as the backup folder is in place and has the 
     appropriate permissions.
13.  For security you should set the permissions back to Read-only when you 
     are done editing or uploading files.

-------------------------------------------------------
INSTALLATION

Follow these instructions if you are not familiar with PhpGedView or 
installing PHP applications.

*A.  Upload Program Files:
To install PhpGedView, unzip the compressed package and upload the files to 
a directory on your web server.  If you have limited space on your server, 
you can save space in the following ways:
1.  Do not upload the "docs" folder.
2.  Delete the themes from the themes folder that you do not plan to use.
3.  Delete some of the language files that you do not want.  English files 
    are named configure_help.en.php, countries.en.php, facts.en.php, 
    help_text.en.php and lang.en.php.  French files, for example, are named 
    with ".fr." in place of ".en.".  Hebrew files use ".he." in place of 
    ".en.", and so on.  
    The English language files cannot be deleted.  They are always loaded 
    before the files for the selected language are loaded.  This ensures 
    that all language variables are defined, and that the English version 
    will be used when a given variable is missing in the new language.
4.  Do not upload the "places" folder.  This folder contains maps for some
    countries.  It also contains text files containing state, county, and 
    place names.  Its purpose is to allow you to enter place names by 
    picking them from lists.    

For optimal security, you may want to move the "index" directory to a 
different location outside of your Internet accessible space.  You will 
specify the location of this directory during the online configuration.  
See the SECURITY section for more information.

*B.  Required File Permissions:
PhpGedView requires that Read permissions be set for all files in the
PhpGedView directory tree.  Some hosts also require Execute permissions
(chmod 755).  PhpGedView requires full Write permissions on the index 
directory (chmod 777 under most hosting configurations).  PhpGedView also 
requires that Write permissions (chmod 777) be set temporarily for the 
config.php file.

To help with the setting of permissions a file called setpermissions.php 
has been included with the project.  This file will attempt to set 777 
permissions to the config.php, ./index, and all of the files inside the 
./index directory.  Because host settings vary on the ability of PHP 
programs to set file permissions, you have to run this file manually.

If at any time you have trouble during configuration, check your 
permissions again.

There are some advanced features that require more Write permissions to be 
set.  If you want to use the language editing features you will need to set 
Write permissions for all of the files in the ./languages folder (chmod 
777).  If you want to upload media files using the Upload Media section of 
the Admin menu then you need to set Write permissions (chmod 777) for your 
./media and ./media/thumbs directories.  If you want to edit your GEDCOM 
file online, the GEDCOM file must have Write permissions set to the PHP 
user (chmod 777).

*C.  Configuration:
Next point your web browser to the PhpGedView folder
(for example, http://www.yourserver.com/PhpGedView/) to automatically 
begin the online configuration process.  Information about each of the 
configuration options can be found online by clicking on the question mark 
(?) near each label.

PhpGedView has support for importing your GEDCOMs into a PEAR:DB supported 
database like MySQL or PostgreSQL.  Currently, MySQL is the only fully tested 
database.  Using a database requires that an existing user, password, and database already
exist.

You may reconfigure PhpGedView at any time by going to PhpGedView/admin.php 
and logging in as an administrator user and clicking on the "Configuration" 
link.

*D.  Create Admin User
After you click the Save button, you will be asked to create an 
administrator user and login as this user.  Then click on the link labelled 
"Click here to continue" where you will be taken to the "Manage GEDCOMs" 
area.  In the "Manage GEDCOMs" area you can add GEDCOMs to your site, edit 
the GEDCOM configuration, edit Privacy settings, and import the GEDCOM into 
the data store.

*E.  Add GEDCOM file
To add GEDCOM files to the system, you can upload your GEDCOM file using 
the "Upload GEDCOM" option from the Admin menu.  All files uploaded using 
the "Upload GEDCOM" page are saved in your index directory.  You can also 
upload your GEDCOM manually using FTP or any other file upload method.  
Most hosts limit the size of files that can be uploaded from a web form for 
security reasons, so you may be forced to use a manual method.  You may 
also upload your GEDCOM in ZIP format, either manually or using the 
"Upload GEDCOM" option.  Make sure to enter the filename of the ZIP file.  
PhpGedView will automatically unpack the ZIP file and use the GEDCOM file 
inside it.  Be sure to create the ZIP file to contain only one GEDCOM file.

*F.  Set GEDCOM Configuration Settings
After uploading your GEDCOM, you will be asked to set the configuration
parameters for it.  There are too many parameters to list all of their 
options in this document.  Please use the online Help documentation to 
guide you through the configuration process.

*G.  Validate GEDCOM
After you save the GEDCOM configuration PhpGedView will validate your 
GEDCOM and automatically fix any errors that it can.  If any errors found 
in the GEDCOM require user input, you will be prompted to choose how to 
proceed.  Again use the online Help ? for more information.

*H.  Import GEDCOM
You are almost done.  This is the final step before you can begin viewing 
your data.  After validating the GEDCOM and fixing any errors, you will 
need to import the GEDCOM into the data store.  During the Import you will 
see a lot of processing statistics printed on the screen.  If the Import 
completed successfully you will see a blue "Import Complete" message.  
Everything is now set up and you can begin using PhpGedView with your 
GEDCOM.

*I.  Deleting GEDCOMs
You may delete GEDCOMs from your site from the "Manage GEDCOMs" area.
Deleting a GEDCOM from the site will remove it from the database but will 
not delete the original GEDCOM file that you imported.  It will also not
delete any of the cache or privacy files related to this GEDCOM.  These 
retained files, which are no longer required by PhpGedView, are all located 
in the "index" directory.

*J.  Reset config.php Permissions
For security you should set the permissions of config.php back to Read-only
(chmod 755) when you have finished configuring for the first time.  Write
permissions will only need to be set for config.php when you use the
Admin->Configuration link.  Everything else will be stored in the index
directory.

*K.  Custom Themes
You can customize the look and feel of PhpGedView by modifying one of the
provided themes.  See the THEMES section of this readme file for more
information.

*L.  HTTP Compression
Pages generated by PhpGedView can be large and use up a lot of bandwidth.
Compression of the data between the server and browser using GZip 
compression can compress the bandwidth by up to 90% (usually 80% - 90% for 
PhpGedView that were tested) If your web server is Apache, configuring this 
is very easy.  Add the following 2 lines to your php.ini file:
    php_flag zlib.output_compression On
    php_value zlib.output_compression_level 5

If you have no access to the php.ini file, create a blank file named 
.htaccess (including the dot) and add the lines to that file (or add them 
to an existing .htaccess file and upload the file to your PhpGedView 
directory.

Note: If your host is using mod_gzip or an other compression method, using 
this technique can cause problems.  Compression will have no effect on 
browsers that do not support it.  You can test the compression at
http://leknor.com/code/gziped.php

If you need help or support visit  http://www.PhpGedView.net/support.php

-------------------------------------------------------
UPGRADING

Use the following steps to upgrade to v4.0.  These steps assume that you 
are familiar with PhpGedView and have successfully installed it before.

Version 4.0 no longer includes support for index files.  If you do not have 
PHP 5 with built-in SQLite support or a database account then you should not 
upgrade to PhpGedView 4.0.  Maintenance releases will continue for the 3.3.x 
version.

**Note to SQLite users: Unfortunately SQLite does not support the ALTER TABLE
  SQL command.  This means that we must first drop the tables and recrate
  them.  It is highly reccomended that you run the backup before upgrading.

1.  Upload the new 4.0 files to your server replacing the old files with the 
	new files.  Do not replace the config.php file or the index directory.
2.  Go to upgrade33-40.php in your browser.
3.  SQLite users will need to reimport their GEDCOM files.
4.  You can now use your upgraded site.  One change with this version splits
    user's full names into first and last name fields.  If you have users
    who only entered a single name then their first and last name will be the
    same and it will appear doubled on some screens.  You may want to review 
    your user list and check your user's names.
5.  If you are using a customized theme you will need to update your theme
    with new stylesheets and variables.  An excellent tool that can help 
    you to merge themes is the WinMerge project 
    http://winmerge.sourceforge.net/
    
-------------------------------------------------------
UPDATING GEDCOMS

When you change your genealogy data outside of PhpGedView, it is not 
necessary to delete your GEDCOMs from PhpGedView and start over.  Follow 
these steps to update a GEDCOM that has already been imported:

1.  The first step is to replace your old GEDCOM on the site with your new
    GEDCOM.  You can do this using FTP, or by going to the "Upload GEDCOM" 
    page and uploading a new GEDCOM with the same filename as the old one.  
    Please remember that file names are case sensitive.
2.  Re-import the GEDCOM file by going to 
    Admin->Manage GEDCOMs->Import GEDCOM.  The GEDCOM will be validated 
    again before importing.
3.  The Import script will detect that the GEDCOM has already been imported 
    and will ask if you want to replace the old data.  Click the "Yes" 
    button.
4.  You will again see the Import statistics and the Import Complete 
    message at the bottom of the page when the Import is complete.

If you use a ZIP file to upload the GEDCOM, the only way to do it is by 
either using the "Upload GEDCOM" option, or the "Add GEDCOM" option.  The 
GEDCOM file in the zipped file has to have exactly the same name as the 
already existing GEDCOM.  This way existing GEDCOM settings will be 
preserved.

-------------------------------------------------------
THEMES

PhpGedView uses a theme based architecture allowing you to have greater
flexibility over the appearance of the site.  The "themes" directory 
contains the standard themes that come packaged with PhpGedView.  You may 
customize any of these themes to your liking or create your own theme by 
copying any of the standard themes to a new folder and modifying it.  When 
you configure PhpGedView, you should tell it to look in your new theme 
directory.

A theme directory must contain at least the following 6 files:
  footer.html        # PHP/HTML for the bottom of every page
  header.html        # PHP/HTML for the top of every page
  print_footer.html  # PHP/HTML for the bottom of every print preview page
  print_header.html  # PHP/HTML for the top of every print preview page
  style.css          # A CSS stylesheet containing all styles
  sublinks.html      # PHP/HTML to print the links to other places
  theme.php          # The PHP design variables that you may customize
  toplinks.html      # PHP/HTML that appears just below the header.html

For a guide to building your own custom PhpGedView theme, go to:
http://www.PhpGedView.net/styleguide.php

If you really like a theme that you have done and would like it included 
with the project, you should send your theme files to the developers at
yalnifj@users.sourceforge.net.

-------------------------------------------------------
MULTIMEDIA OBJECTS

The GEDCOM 5.5 standard supports multimedia files of all types.  Currently
PhpGedView supports multimedia objects only as external files.  Multimedia
embedded in the GEDCOM file itself will be ignored.  To use the multimedia
support in PhpGedView you must copy the multimedia files external to your
GEDCOM to the "media" directory in the folder where you installed 
PhpGedView.

In choosing which picture to show on charts, PhpGedView will choose the 
first one with the _PRIM Y marker.  If there are no _PRIM tags in your 
media object records then the first object found will be used.  You can 
disable all photos on charts for a particular person by setting _PRIM N on 
all media objects.  Most genealogy programs will do this for you 
automatically.

You can find all of the images referenced in your file by opening your 
GEDCOM in a text editor and looking for the OBJE or FILE tags.

PhpGedView includes a "media/thumbs" directory where you can place 
thumbnails of your media files for display in lists and on other pages.  
PhpGedView allows you to create your own thumbnails so that you can 
maintain artistic control over your media and to avoid the installation of 
other server side software.  Make a copy your images and reduce them to an 
appropriate thumbnail size somewhere around 100px width and upload them to 
the "media/thumbs" directory.  Keep the filename the same as the original.  
Thumbnails can be created for non-image media files as well.  To do this 
create a thumbnail image in either gif, jpeg, png or bmp formats and name 
them the same name as the media file including the file extension (even if 
the media is a non image such as a PDF or an AVI file, name the thumbnail 
IMAGE with the PDF or AVI file extension).

You can configure PhpGedView to recognize subdirectories in your media 
folder.  The subdirectories must be the same names as the subdirectories in 
your media file paths pointed to in your GEDCOM file.  For example, if you 
have the following media references in your GEDCOM file:
    C:\Pictures\Genealogy\photo.jpg
    C:\Pictures\Scans\scan1.jpg
    scan2.jpg

With the media depth set to 1 you need to set up your directory structure 
like this:
    media/Genealogy/photo.jpg
    media/Scans/scan1.jpg
    media/scan2.jpg
    media/thumbs/Genealogy/photo.jpg
    media/thumbs/Scans/scan1.jpg
    media/thumbs/scan2.jpg

With the media depth set to 2 you need to set up your directory structure 
like this:
    media/Pictures/Genealogy/photo.jpg
    media/Pictures/Scans/scan1.jpg
    media/scan2.jpg
    media/thumbs/Pictures/Genealogy/photo.jpg
    media/thumbs/Pictures/Scans/scan1.jpg
    media/thumbs/scan2.jpg

-------------------------------------------------------
RSS FEED

PGV now includes an RSS feed.  RSS is an XML format that allows other sites
to get news and other data from your site.  The language used is the 
default language of the site.  The language of the feed can be set to any 
language supported by PGV by changing the URL that your RSS aggregator uses 
from the default /phpGedView/rss.php to /phpGedView/rss.php?lang=english 
(or any language supported by PGV such as rss.php?lang=french).  

Currently only the default site GEDCOM is supported for the feed info.  
Other options available in the RSS feed are the ability to specify the feed 
type via the rssStyle parameter.  The PGV default is "RSS1.0".  Passing any 
supported type including "PIE0.1", "mbox","RSS0.91", "RSS1.0", "RSS2.0", 
"OPML", "ATOM0.3", "HTML", "JS" will change the feed type.  

For example, calling  /phpGedView/rss.php?rssStyle=HTML will create HTML 
output suitable for inclusion in an other page via an iFrame.  The JS 
option will output JavaScript that can be included in an other page without 
using an iFrame.  

You can also specify a module that you want to output (only 1) so that only 
that module will be output.  This is done via the module parameter.  For 
example, /phpGedView/rss.php?module=GEDCOMStats will only output the GEDCOM 
Stats block.  

These parameters can be chained so that
/phpGedView/rss.php?lang=hebrew&module=GEDCOMStats&rssStyle=HTML 
will output the GEDCOM Stats module in Hebrew in HTML.


-------------------------------------------------------
DATABASE TABLE LAYOUT

PhpGedView uses a very simple database table layout because it operates
primarily on the GEDCOM data and only needs the database for search and
retrieval.  There are only a few tables in the database:
  pgv_blocks        # Description of each user's Portal page
  pgv_dates         # Stores decoded date information from GEDCOM records
  pgv_families      # All the families in the GEDCOM
  pgv_favorites     # Stores users favorites
  pgv_individuals   # All the individuals in the GEDCOM
  pgv_messages      # Messages to and from users
  pgv_names         # Stores decoded name information from GEDCOM records
  pgv_news          # Stores news items for the Index and Portal pages
  pgv_other         # All other level 0 GEDCOM records (i.e., repositories, 
                    #   media objects, notes, etc.)
  pgv_placelinks    # Cross-reference between places and individuals and
                    #   families
  pgv_places        # Place hierarchy
  pgv_sources       # All the sources in the GEDCOM
  pgv_users         # Table for user data (only exists if using default 
                    #   mysql authentication module)


The tables are all very similar.  They each have a field for the GEDCOM ID, 
a field to tell which GEDCOM file the record was imported from, a few 
fields for things like quick retrieval of name information, and a field for
the raw GEDCOM record data.

Following is a more detailed description of each table:
  pgv_individuals:
    i_id VARCHAR(255)      # GEDCOM individual ID
    i_file INT             # ID number of the GEDCOM file the record is from
    i_rin VARCHAR(30)      # Individual's RIN number
    i_name VARCHAR(255)    # Person's primary name taken from the first
                           #   1 NAME line stored in GEDCOM name format
    i_isdead int(1)        # Alive/dead status of individual
                           #   -1 = not calculated yet 0 = alive 1 = dead
    i_GEDCOM TEXT          # Raw GEDCOM record for this individual
    i_letter VARCHAR(5)    # First letter of the individual's surname
    i_surname VARCHAR(100) # Person's surname

  pgv_families:
    f_id VARCHAR(255)      # GEDCOM family ID
    f_file INT             # ID number of the GEDCOM file the record is from
    f_husb VARCHAR(255)    # ID of the husband
    f_wife VARCHAR(255)    # ID of the wife
    f_chil TEXT            # List of children IDs, semi-colon (;) delimited
    f_GEDCOM TEXT          # Raw GEDCOM record for this family
    f_numchil INT          # Number of children in this family

  pgv_sources:
    s_id VARCHAR(255)      # GEDCOM source ID
    s_file INT             # ID number of the GEDCOM file the record is from
    s_name VARCHAR(255)    # Abbreviated title of the source
    s_GEDCOM TEXT          # Raw GEDCOM record for this source

  pgv_other:
    o_id VARCHAR(255)      # GEDCOM record ID
    o_file INT             # ID number of the GEDCOM file the record is from
    o_type VARCHAR(20)     # Type of GEDCOM record
                           #    (REPO, ADDR, NOTE, OBJE, etc)
    o_GEDCOM TEXT          # Raw GEDCOM record for this item

  pgv_names:
    n_gid VARCHAR(255)     # Individual ID that this name corresponds to
    n_file INT             # ID number of the GEDCOM file the record is from
    n_name VARCHAR(255)    # Name in GEDCOM format,
                           #   with / / around the surname
    n_letter VARCHAR(5)    # First letter of the surname
    n_surname VARCHAR(100) # Surname for this name record
    n_type VARCHAR(10)     # Type of name,
                           #   P = primary, A = additional, C=calculated

  pgv_blocks:
    b_id INT(11)           # Record ID
    b_username VARCHAR(100) # User name whom block belongs to
    b_location VARCHAR(30) # Location of the block.  
                           #   Main column or right column
    b_order INT(11)        # Position of the block within the column
    b_name VARCHAR(255)    # Name of the block
    b_config TEXT          # Configuration settings for this block

  pgv_favorites:
    fv_id INT(11)          # Record ID
    fv_username VARCHAR(30) # User name whom the favorite belongs to
    fv_gid VARCHAR(10)     # ID of the favorite
    fv_type VARCHAR(10)    # Type of favorite (currently only INDI)
    fv_file VARCHAR(100)   # File that this favorite belongs to
    fv_url VARCHAR(255)    # The URL for this favorite if it is not one of 
                           # the basic types
    fv_title VARCHAR(255)  # A title for URL based favorites
    fv_note TEXT           # Optional descriptive information about this favorite

  pgv_messages:
    m_id INT(11)           # Record ID
    m_from VARCHAR(255)    # Name or email address of the sender
    m_to VARCHAR(30)       # Destination user name
    m_subject VARCHAR(255) # Subject of the message
    m_body TEXT            # Body text of the message
    m_created VARCHAR(255) # Time stamp when the message was created
            
  pgv_news:
    n_id INT(11)           # Unique identifier
    n_username VARCHAR(100) # User name or GEDCOM the News item belongs to
    n_date INT(11)         # Time stamp of last update
    n_title VARCHAR(255)   # Title of the article
    n_text TEXT            # Body text of the article

  pgv_places:
    p_id INT(11)           # Unique identifier
    p_place VARCHAR(150)   # Place name
    p_level INT(11)        # Level of the place in the hierarchy,
                           #   0 is the country or state
    p_parent_id INT(11)    # ID of this item's parent place in the 
                           #   hierarchy.  A city's parent would be the 
                           #   county it is in, a county's parent would be 
                           #   a state or province, and a state or province
                           #   would have a country as parent.
    p_file INT             # ID number of the GEDCOM file the record is from

  pgv_placelinks:
    pl_p_id INT(11)        # Unique identifier
    pl_gid VARCHAR(30)     # Family or individual ID referencing this place
    pl_file INT            # ID number of the GEDCOM file the record is from

  pgv_users:
    u_username VARCHAR(30) # User name
    u_password VARCHAR(255) # Encrypted password
    u_fullname VARCHAR(255) # User's full name
    u_GEDCOMid TEXT        # Serialized array representing the GEDCOM IDs
                           #   for this user
    u_rootid TEXT          # Serialized array representing the root IDs 
                           #   for this user
    u_canadmin ENUM('Y','N') # Is the user an admin or not
    u_canedit TEXT         # Serialized array indicating the editing 
                           #   privileges a user has for each GEDCOM
    u_email TEXT           # Email addres
    u_verified VARCHAR(20) # User self verified
    u_verified_by_admin VARCHAR(20)  # User has been verified by the admin
    u_language VARCHAR(50) # User's preferred language
    u_pwrequested VARCHAR(20)   # User requested a new password
    u_reg_timestamp VARCHAR(50) # Registration timestamp
    u_reg_hashcode VARCHAR(255) # Self-registration hash key
    u_theme VARCHAR(50)         # User's preferred theme
    u_loggedin ENUM('Y','N')    # User's login status
    u_sessiontime INT(14)       # User's last login time stamp
    u_contactmethod VARCHAR(20) # User's preferred method of contact
    u_visibleonline ENUM('Y','N')  # Whether or not the user is visible in
                                   #   the logged on users block
    u_editaccount ENUM('Y', 'N')   # Whether or not the user can edit his
                                   #   own account information
    u_defaulttab INT(10)           # Default tab on the individual page
                                   #   for this user
    u_comment VARCHAR(255)         # Admin's comments on this user
    u_comment_exp VARCHAR(20)      # Alert date for the admin, for instance 
                                   #   for temporary accounts.
    u_sync_gedcom VARCHAR(2)    # If the user has a GEDCOM record ID, then 
                                #   should some of the data for the user (name,
                                #   email) be synchronized with the GEDCOM data.
    u_relationship_privacy VARCHAR(2)  # Should this user use relationship privacy
    u_max_relation_length INT   # The maximum path that the user is allowed to see
    u_auto_accept VARCHAR(2)    # Are changes made by this user automatically 
                                #   accepted into the database

This table layout has received criticism from some for its simplicity, 
size, and because it does not follow a genealogy model like GENTECH.  
We admit that these tables can be hard to interface to because the code has 
to understand GEDCOM in order to get information out of them.  We also 
admit that storing the raw GEDCOM data could make the tables very large.

Fortunately the GEDCOM standard is not a very complex or large format; it 
only requires 6 characters per line, which is very good compared to 
something like XML.  However, there are some very compelling reasons why 
this table structure was chosen:
1.  Simpler tables mean fewer and simpler database queries.  This takes a
    large load off the database and makes the program run faster.
2.  Nothing is lost in the Import.  Even though GEDCOM is a standard, each
    genealogy program interprets the standard a bit differently and adds 
    its own tags.  Creating a database model that conforms to all the 
    GEDCOM outputs of different genealogy software programs would be very 
    difficult.

-------------------------------------------------------
MANUAL CONFIGURATION

Advanced users who understand PHP may want to configure manually by editing 
the configuration file config.php  When you have finished editing 
config.php make sure that the variable $CONFIGURED=true; so that the 
program does not try to forward you to the configuration.php script when 
you launch it for the first time.

You can manually add GEDCOMS to the system by adding them to the $GEDCOMS 
array in the index/GEDCOMs.php file.  The GEDCOM array looks like this:
  $gedarray = array();
  $gedarray["GEDCOM"] = "surname.ged";
  $gedarray["config"] = "./index/surname.ged_conf.php";
  $gedarray["privacy"] = "./index/surname.ged_priv.php";
  $gedarray["title"] = "Surname Genealogy";
  $gedarray["path"] = "./surname.ged";
  $GEDCOMS["surname.ged"] = $gedarray;
"surname" above could be anything, for example, "johnson" or "private".  
You must pay attention to the case of what you enter.  PhpGedView is case 
sensitive.

Each GEDCOM will need a configuration file.  You can copy the 
config_GEDCOM.php file which has all of the default values for each GEDCOM 
you add manually.  Then set the "config" item of the GEDCOMS array to point 
to the file you copied.

Each GEDCOM also needs a Privacy file.  Make a copy the privacy.php file 
for each GEDCOM and set the "privacy" item of the GEDCOMS array to the 
location of the new privacy.php file.

-------------------------------------------------------
SECURITY

Even though PhpGedView gives you the ability to hide the details of living
individuals, whenever you post the personal details of living individuals 
on the Internet, you should first obtain the permission of EACH living 
person you plan to include.  There are many people who would not even want 
their name linked with their family history made public on the Internet and 
their wishes should be respected and honored.  Most family history programs 
allow you to choose the people who are exported when you create your GEDCOM 
file.  The most secure option is to deselect all living people in your 
genealogy program when you export your genealogical data to a GEDCOM file.

If you wish to protect your GEDCOM file itself from being downloaded over 
the Internet you should place it outside the root directory of your web 
server or virtual host and set the value of the $GEDCOM variable to point 
to that location.  For example, if your home directory is something like
"/home/username" and if the root directory for your web site is
"/home/username/public_html" and you have installed PhpGedView in the
"public_html/PhpGedView" directory then you would place your GEDCOM file in
your home directory at the same level as your "public_html" directory.  You
would then set the file path to "/home/username/GEDCOM.ged" by editing the
GEDCOM configuration.

You can also manually set the location by changing the "path" line in
index/GEDCOMs.php:
    $gedarray["path"] = "../../GEDCOM.ged";
or
    $gedarray["path"] = "/home/username/GEDCOM.ged";

Since your GEDCOM file resides in a directory outside of your web server's 
root directory, your web server will not be able to fullfill requests to 
download it.  However, PhpGedView will still be able to read and display 
its contents.

In the end it is YOUR responsibility to guarantee that there has been no
violation of an individual's privacy and YOU could be held liable should
private information be made public on the web sites that you administer.

For more privacy options visit:
http://www.PhpGedView.net/privacy.php

-------------------------------------------------------
LANGUAGES

PhpGedView has built-in support for multiple languages.  PHP does not 
support unicode (UTF-16).  It does support UTF-8 and that is the 
recommended character encoding for GEDCOMs with PhpGedView.  If you have 
characters in your GEDCOM outside the standard ASCII alphabet, you should 
probably use the UTF-8 encoding.  There are many differences between UTF-8 
and UTF-16, but anything that you can encode in UTF-16 you should be able 
to encode in UTF-8.  It is also quite easy to convert from Unicode to 
UTF-8.  Simply open your Unicode GEDCOM file in Windows Notepad and select 
"File->Save As.." from the menu and choose UTF-8 as the encoding option.  
You shouldn't lose any of the characters in the translation.

You should check the Patches section of
http://sourceforge.net/projects/PhpGedView to get the latest language 
files.

Discussion and questions about the multiple language features of PhpGedView
including translations, should be posted in the Translations forum 
available from the PhpGedView project page here:
http://sourceforge.net/forum/forum.php?forum_id=294245

To translate PhpGedView into another language that is not currently 
supported you must first login to PhpGedView as an administrator and go to 
the Language Edit Utility by clicking on "Admin-> Translator Tools".  At 
the bottom of that page is an option to Add a new language.  Choose your l
anguage from the dropdown list and click on the "Add new Language" button.  
A popup window will appear that allows you to edit the default settings for 
your language.  Each of the settings has online help available by clicking 
on the "?".  You might want to look at the settings for some of the other 
languages on the edit language page to see how they are set up.  When you 
have finished editing the settings, click the Save button.  This will 
create a new lang_settings.php file in the index directory.  You will 
notice that your language now appears in the supported languages list.

Next create a copy of the "configure_help.en.php", "facts.en.php", 
"help_text.en.php", and "lang.en.php" files located in the "./languages/" 
and change the "en" part to match the two letter language code of your 
language.  

The "facts" file contains all of the translations for the various GEDCOM 
tags such as BIRT = Birth.  The "lang" file contains all of the language 
variables used throughout the site.  The "configure_help.en.php" and
"help_text.en.php" provide configuration and help instructions.

You can translate these files using the online Language File Edit utility.
Just select your language from the drop-down list and then select the file 
you want to edit and click the Edit button.  Your file will be compared to 
the English language file so that you can easily translate the files 
online.

You can also translate these files manually by opening them in any text 
editor.  If you manually edit the files, you must be sure to save them in 
the UTF-8 character set.  Some text editors like Windows Notepad add a 
3-byte Byte-Order-Mark (BOM) to files they save in UTF-8.  PHP does not 
like the BOM and it should be removed before testing the files in 
PhpGedView.  PhpGedView's Translator Tools section has a utility program
for removing these BOMs.

You should obtain a flag file from http://w3f.com/gifs/index.html and size 
it to match the other flags in the images/flags directory.

To help maintain languages, a language change log is provided in the 
languages directory.  This change log is named LANG_CHANGELOG.txt.  All 
changes to the English language files are recorded here.

If you make a new translation of PhpGedView or update another translation, 
and would like to contribute it to the community please post your language 
files and your index/lang_settings.php file to the Patches section of the 
SourceForge project site at http://www.sourceforge.net/projects/phpgedview

-------------------------------------------------------
NON-STANDARD GEDCOM CODES

The GEDCOM 5.5 standard has a defined set of codes.  You can read the
specification online at http://www.PhpGedView.net/ged551-5.pdf  Part of the
standard allows for genealogy software to define their own codes, and 
requests that they begin with an "_" underscore.  

When PhpGedView comes across a tag that is not defined it will display an 
error message.  You can disable these error messages by setting 
$HIDE_GEDCOM_ERRORS=true; in the config.php file.  PhpGedView can also be 
customized to work with these codes by adding them to the facts array in a 
new language file named facts.en.extra.php.  If you add it to the English 
facts file you should also add it to the other facts language files you are 
using on your site if you want other languages to translate the tag 
correctly.

The format of the facts file is a PHP associative array.  Each tag requires 
one line in the array.  The following line defines the label "Abbreviation" 
for the ABBR GEDCOM tag.
    $factarray["ABBR"] = "Abbreviation";

As an example, if you use a genealogy program that generates the tag 
"_ZZZZ" you can customize PhpGedView to accept this code by adding the 
following lines to the facts.en.extra.php file:
    <?php
    $factarray["_ZZZZ"] = "Tag Label goes here";
    ?>

-------------------------------------------------------
LANGUAGE EXTENSION FILES

Language extension files are custom PHP files that you can use to make your 
own language specific extensions to PhpGedView.  To add a language file 
extension, create a new PHP file called lang.xx.extra.php replacing the 
"xx" with the code for the language you want to extend.  These files are 
not automatically included with the package so that when you upgrade, your 
extensions are not overwritten.

If this file exists for the language that is chosen, it is the very last 
thing that is loaded before the display starts.  These files were designed 
to be language file extensions, but you could easily use them to make 
settings changes based on the chosen language.

What sort of things can you do with language extensions?
 - Customize any of the text that appears on the site,
 - Change configuration options based on language,
 - Change to a different GEDCOM when someone views your site in a different
   language.

The only settings that you should not override in this file are the Privacy
settings.

If, for example, you wanted to change the GEDCOM title when you changed the
language, you could change the title for each language by adding the 
following line to your lang.xx.extra.php:
    $GEDCOMS["surname.ged"]["title"] = "Title in Chinese";

In this file you could also change the text on the buttons:
    $pgv_lang["view"]="Show";

With this file you could also change the GEDCOM that is displayed when the 
language is selected.  Suppose you had a GEDCOM that was in German and one 
that was in English.  In the lang.de.extra.php file you could add the 
following lines:
    if ($GEDCOM=="english.ged") {
      header("Location: $SCRIPT_NAME?$QUERY_STRING&ged=german.ged");
      exit;
    }

These lines say that if we are using the German language files, but are 
using the English GEDCOM, then we need to reload the page with the German 
GEDCOM.  You need to reload the page so that the configuration settings for 
the GEDCOM get loaded.  This assumes that you have both "english.ged" and 
"german.ged" imported into the database and that the english.ged and the 
german.ged have the same people in them, just in a different language.  
Thus I0001 in english.ged should refer to the same I0001 in german.ged.


-------------------------------------------------------
MIGRATING FROM DATABASE TO INDEX MODE AND VICE VERSA

Basically it's possible to switch a PhpGedView installation from Index to 
DATABASE mode or vice-versa without losing any settings.  The following 
steps have to be made:

DATABASE to Index
--------------
 1.  Make sure you have all rights in the ./index/ folder on your web site 
     and on the file ./config.php
 2.  Copy the file config.php to configsql.php (or any other name) to 
     backup the old configuration.  You may also use the Backup function 
     from the Admin menu to backup all vital files before switching mode.
 3.  DO NOT remove any files from your index directory, as some of them 
     (Privacy and GEDCOM settings) will also be used in Index mode.
 4.  In DATABASE mode, log in to PhpGedView with Admin rights.
 5.  Go to the Administration page and select the User Information 
     Migration tool.
 6.  Choose the Export function.
 7.  User Migrate will try to create the following files:
       - authenticate.php  - user accounts and settings
       - favorites.dat     - user and GEDCOM favorites
       - blocks.dat        - block layout of Welcome and MyGedView pages
       - news.dat          - User and GEDCOM news
       - messages.dat      - User messages
     If any of the files already exist in your index directory, you will be 
     prompted to overwrite them.  If there are problems creating the files, 
     when, for instance, you don't have sufficient rights, you can always 
     correct the problem and run the Export function again, as nothing 
     irreversible has happened.
 8.  Check that the above files exist in your index directory.
 9.  Go to Admin, Configuration, change mode to Index and save the 
     configuration.
10.  As all Index mode related files are already present, you should be 
     able to use your web site in Index mode immediately.
10.  Import your GEDCOM files again to build the Index database.  You don't 
     need to change any GEDCOM settings, as they still exist in the index 
     directory and will be used again.
11.  Test all settings and functions thoroughly before you remove your SQL
     database from your web site.

Index to DATABASE
--------------
 1.  Make sure you have all rights in the ./index/ folder on your web site 
     and on the file ./config.php
 2.  Copy the file config.php to configindex.php (or any other name) to 
     backup the old configuration.  You can also use the Backup function 
     from the Admin menu to backup all vital files before switching mode.
 3.  DO NOT remove any files from your index directory, as all of them 
     (Privacy and GEDCOM settings) will also be used in DATABASE mode, or 
     will be used to migrate the information to DATABASE mode.
 4.  Connect to your SQL DBMS with your regular administration tool, and 
     define a database, without any tables.
 5.  Create a user in your SQL-DBMS with the following rights on the 
     database:
         SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER.
 6.  In PhpGedView, go to Admin, Configuration, and change mode to 
     DATABASE, fill in the appropriate SQL-DBMS and database name, user and 
     user password and save the configuration.
 7.  PhpGedView will ask you to create an admin user.  Create one.  This 
     user will be overwritten later with the migrated information.
 8.  From the admin menu, choose the User Information Migration tool, then 
     choose Import.
 9.  PhpGedview will now import all settings from Index mode to DATABASE 
     mode.
10.  Go to Admin, Manage GEDCOMs and Edit Privacy, and then import all your 
     GEDCOM files again.  There is no need to change GEDCOM settings and 
     Privacy settings, as all settings made in Index mode will be used.
11.  Test all settings and functions thoroughly before you remove Index 
     related files (.\index\*.dat and .\index\authenticate.php) from your 
     web site.

-------------------------------------------------------
POSTNUKE AND PHPNUKE INTEGRATION

PhpGedView can integrate with PostNuke and phpNuke so that your users do 
not have to login twice.

After you have PhpGedView up and running, you should follow the 
instructions in the readme.txt file in the pgvnuke folder.

The files that make the integration magic happen were donated by Jim Carey.

===========================================================
BACKUP

With the Backup function in the administration menu, you can make a simple 
backup of all important PhpGedview files.  With this backup, it's possible 
to rebuild your PhpGedView site to the situation at backup time.

The backup can contain the following files, as selected on the Backup page:
  - config.php with all configuration settings of your installation
  - all GEDCOM files that were present in your installation
  - all GEDCOM options and privacy settings for the above files
  - counters, PhpGedView- and search-logfiles
  - user definitions and options (block definitions, favorites, messages 
    and news)

The files will be gathered into a ZIP file, which can be downloaded by 
clicking the link on the page.

Note: The database itself will not be included in the backup, since it can 
be rebuilt using the files in the backup.

Note: All pending changes (not approved or rejected yet by the 
administrator) will be present in the GEDCOM files but can no longer be 
identified as changes.  If the database is rebuilt using the GEDCOMs, these 
changes therefore can no longer be rejected.

The Backup function uses the PclZip library, which is written by Vincent 
Blavet and can be found at http://www.phpconcept.net/pclzip.