$val) { if (!is_array($val)) { $in[$k][$key] = stripslashes($val); continue; } $in[] =& $in[$k][$key]; } } unset($in); } } if (!empty($_POST['action']) && $_POST['action']=='download') { header('Content-Type: text/plain'); header('Content-Disposition: attachment; filename="'.WT_CONFIG_FILE.'"'); echo '; DO NOT DELETE THIS LINE'."\r\n"; echo 'dbhost="', addcslashes($_POST['dbhost'], '"').'"'."\r\n"; echo 'dbport="', addcslashes($_POST['dbport'], '"').'"'."\r\n"; echo 'dbuser="', addcslashes($_POST['dbuser'], '"').'"'."\r\n"; echo 'dbpass="', addcslashes($_POST['dbpass'], '"').'"'."\r\n"; echo 'dbname="', addcslashes($_POST['dbname'], '"').'"'."\r\n"; echo 'tblpfx="', addcslashes($_POST['tblpfx'], '"').'"'."\r\n"; exit; } header('Content-Type: text/html; charset=UTF-8'); if (version_compare(PHP_VERSION, '5.2')<0) { // Our translation system requires PHP 5.2, so we cannot translate this message :-( echo '', '', '', '', 'webtrees setup wizard', '

Sorry, the setup wizard cannot start.

', '

This server is running PHP version ', PHP_VERSION, '

', '

webtrees requires PHP 5.2 or later. PHP 5.3 is recommended.

'; if (version_compare(PHP_VERSION, '5.0')<0) { echo '

Many servers offer both PHP4 and PHP5. You may be able to change your default to PHP5 using a control panel or a configuration setting.

'; } exit; } // This script (uniquely) does not load session.php. // session.php won't run until a configuration file exists... // This next block of code is a minimal version of session.php define('WT_WEBTREES', true); define('WT_ROOT', ''); define('WT_GED_ID', 0); define('WT_USER_ID', 0); // Invoke the Zend Framework Autoloader, so we can use Zend_XXXXX and WT_XXXXX classes set_include_path(WT_ROOT.'library'.PATH_SEPARATOR.get_include_path()); require_once 'Zend/Loader/Autoloader.php'; Zend_Loader_Autoloader::getInstance()->registerNamespace('WT_'); require 'includes/functions/functions.php'; require 'includes/functions/functions_edit.php'; $WT_SESSION=new Zend_Session_Namespace('WEBTREES'); define('WT_LOCALE', WT_I18N::init(safe_POST('lang', '[@a-zA-Z_]+'))); echo '', '', '', 'webtrees setup wizard', '', '', '

', WT_I18N::translate('Setup wizard for webtrees'), '

'; if (file_exists(WT_DATA_DIR.WT_CONFIG_FILE)) { $error=false; $warning=false; echo '

', WT_I18N::translate('The configuration file has been successfully uploaded to the server.'), '

'; echo '

', WT_I18N::translate('Checking the access permissions...'), '

'; if (!is_readable(WT_DATA_DIR)) { echo '

', WT_I18N::translate('The directory %s does not have read permission. You must change this.', WT_DATA_DIR), '

'; $error=true; } elseif (!is_writable(WT_DATA_DIR)) { echo '

', WT_I18N::translate('The directory %s does not have write permission. You must change this.', WT_DATA_DIR), '

'; $error=true; } else { echo '

', WT_I18N::translate('The directory %s has read-write permission. Good.', WT_DATA_DIR), '

'; } if (!is_writable(WT_MEDIA_DIR)) { echo '

', WT_I18N::translate('The directory %s does not have write permission. You must change this.', WT_MEDIA_DIR), '

'; $error=true; } elseif (!is_readable(WT_MEDIA_DIR)) { echo '

', WT_I18N::translate('The directory %s does not have read permission. You must change this.', WT_MEDIA_DIR), '

'; $error=true; } else { echo '

', WT_I18N::translate('The directory %s has read-write permission. Good.', WT_MEDIA_DIR), '

'; } if (!is_readable(WT_DATA_DIR.WT_CONFIG_FILE)) { echo '

', WT_I18N::translate('The file %s does not have read permission. You must change this.', WT_DATA_DIR.WT_CONFIG_FILE), '

'; $error=true; } elseif (is_writable(WT_DATA_DIR.WT_CONFIG_FILE) && DIRECTORY_SEPARATOR=='/') { echo '

', WT_I18N::translate('The file %s has write permission. This will work, but for better security, you should make it read only.', WT_DATA_DIR.WT_CONFIG_FILE), '

'; $warning=true; } else { echo '

', WT_I18N::translate('The file %s has read-only permission. Good.', WT_DATA_DIR.WT_CONFIG_FILE), '

'; } if ($error || $warning) { echo '

'; } if (!$error) { echo '

'; } // The config file exists - do not go any further. // This is an important security feature, to protect existing installations. exit; } echo '
'; echo ''; //////////////////////////////////////////////////////////////////////////////// // Step one - choose language and confirm server configuration //////////////////////////////////////////////////////////////////////////////// if (empty($_POST['lang'])) { echo '

', WT_I18N::translate('Change language'), ' ', edit_field_language('change_lang', WT_LOCALE, 'onChange="parent.location=\''.WT_SCRIPT_NAME.'?lang=\'+this.value;">'), '

', '

', WT_I18N::translate('Checking server configuration'), '

'; $warnings=false; $errors=false; // Mandatory extensions foreach (array('pcre', 'pdo', 'pdo_mysql', 'session', 'iconv') as $extension) { if (!extension_loaded($extension)) { echo '

', WT_I18N::translate('PHP extension "%s" is disabled. You cannot install webtrees until this is enabled. Please ask your server\'s administrator to enable it.', $extension), '

'; $errors=true; } } // Recommended extensions foreach (array( 'calendar'=>/* I18N: a program feature */ WT_I18N::translate('jewish calendar'), 'gd' =>/* I18N: a program feature */ WT_I18N::translate('creating thumbnails of images'), 'xml' =>/* I18N: a program feature */ WT_I18N::translate('reporting'), ) as $extension=>$features) { if (!extension_loaded($extension)) { echo '

', WT_I18N::translate('PHP extension "%1$s" is disabled. Without it, the following features will not work: %2$s. Please ask your server\'s administrator to enable it.', $extension, $features), '

'; $warnings=true; } } // Settings foreach (array( 'file_uploads'=>/* I18N: a program feature */ WT_I18N::translate('file upload capability'), // Do not include this check. The consequences are minimal, but many users are worried by the message. //'date.timezone'=>/* I18N: a program feature */ WT_I18N::translate('the correct date and time in logs and messages'), ) as $setting=>$features) { if (!ini_get($setting)) { echo '

', WT_I18N::translate('PHP setting "%1$s" is disabled. Without it, the following features will not work: %2$s. Please ask your server\'s administrator to enable it.', $setting, $features), '

'; $warnings=true; } } if (!$warnings && !$errors) { echo '

', WT_I18N::translate('The server configuration is OK.'), '

'; } echo '

', WT_I18N::translate('Checking server capacity'), '

'; // Previously, we tried to determine the maximum value that we could set for these values. // However, this is unreliable, especially on servers with custom restrictions. // Now, we just show the default values. These can (hopefully!) be changed using the // site settings page. $maxmem=to_mb(ini_get('memory_limit')); $maxcpu=ini_get('max_execution_time'); echo '

', WT_I18N::translate('The memory and CPU time requirements depend on the number of individuals in your family tree.'), '
', WT_I18N::translate('The following list shows typical requirements.'), '

', WT_I18N::translate('Small systems (500 individuals): 16-32MB, 10-20 seconds'), '
', WT_I18N::translate('Medium systems (5000 individuals): 32-64MB, 20-40 seconds'), '
', WT_I18N::translate('Large systems (50000 individuals): 64-128MB, 40-80 seconds'), '

', ($maxmem<32 || $maxcpu<20) ? '

' : '

', WT_I18N::translate('This server\'s memory limit is %dMB and its CPU time limit is %d seconds.', $maxmem, $maxcpu), '

', WT_I18N::translate('If you try to exceed these limits, you may experience server time-outs and blank pages.'), '

', WT_I18N::translate('If your server\'s security policy permits it, you will be able to request increased memory or CPU time using the webtrees administration page. Otherwise, you will need to contact your server\'s administrator.'), '

'; if (!$errors) { echo ''; echo ''; echo '
'; } echo '
'; exit; } else { // Copy these values through to the next step echo ''; echo ''; } //////////////////////////////////////////////////////////////////////////////// // Step two - Database connection. //////////////////////////////////////////////////////////////////////////////// if (empty($_POST['dbhost'])) $_POST['dbhost']='localhost'; if (empty($_POST['dbport'])) $_POST['dbport']='3306'; if (empty($_POST['dbuser'])) $_POST['dbuser']=''; if (empty($_POST['dbpass'])) $_POST['dbpass']=''; try { $db_version_ok=false; if (substr($_POST['dbhost'], 0, 1)=='/') { $dbh=new PDO('mysql:unix_socket='.$_POST['dbhost'], $_POST['dbuser'], $_POST['dbpass'], array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_OBJ, PDO::ATTR_CASE=>PDO::CASE_LOWER, PDO::ATTR_AUTOCOMMIT=>true)); } else { $dbh=new PDO('mysql:host='.$_POST['dbhost'].';port='.$_POST['dbport'], $_POST['dbuser'], $_POST['dbpass'], array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_OBJ, PDO::ATTR_CASE=>PDO::CASE_LOWER, PDO::ATTR_AUTOCOMMIT=>true)); } $dbh->exec("SET NAMES 'utf8'"); foreach ($dbh->query("SHOW VARIABLES LIKE 'VERSION'") as $row) { if (version_compare($row->value, WT_REQUIRED_MYSQL_VERSION, '<')) { echo '

', WT_I18N::translate('This database is only running MySQL version %s. You cannot install webtrees here.', $row->value), '

'; } else { $db_version_ok=true; } } } catch (PDOException $ex) { $dbh=null; if ($_POST['dbuser']) { // If we've supplied a login, then show the error echo '

', WT_I18N::translate('Unable to connect using these settings. Your server gave the following error.'), '

', '
', $ex->getMessage(), '
', '

', WT_I18N::translate('Check the settings and try again.'), '

'; } } if (empty($_POST['dbuser']) || !$dbh || !$db_version_ok) { echo '

', WT_I18N::translate('Connection to database server'), '

', '

', WT_I18N::translate('webtrees needs a MySQL database, version %s or later.', WT_REQUIRED_MYSQL_VERSION), '

', '

', WT_I18N::translate('Your server\'s administrator will provide you with the connection details.'), '

', '
', WT_I18N::translate('Database connection'), '', '
', WT_I18N::translate('Server name'), '', '', WT_I18N::translate('Most sites are configured to use localhost. This means that your database runs on the same computer as your web server.'), '
', WT_I18N::translate('Port number'), '', '', WT_I18N::translate('Most sites are configured to use the default value of 3306.'), '
', WT_I18N::translate('Database user account'), '', '', WT_I18N::translate('This is case sensitive.'), '
', WT_I18N::translate('Database password'), '', '', WT_I18N::translate('This is case sensitive.'), '
', '
', '
', '
', '', "\n\n", ''; exit; } else { // Copy these values through to the next step echo ''; echo ''; echo ''; echo ''; } //////////////////////////////////////////////////////////////////////////////// // Step three - Database connection. //////////////////////////////////////////////////////////////////////////////// if (empty($_POST['dbname'])) $_POST['dbname']=''; if (empty($_POST['tblpfx'])) $_POST['tblpfx']='wt_'; // The character "`" is not valid in database or table names (even if escaped). // By removing it, we can ensure that our SQL statements are quoted correctly. // // Other characters may be invalid (objects must be valid filenames on the // MySQL server's filesystem), so block the usual ones. $DBNAME =str_replace(array('`', '"', '\'', ':', '/', '\\', '\r', '\n', '\t', '\0'), '', $_POST['dbname']); $TBLPREFIX=str_replace(array('`', '"', '\'', ':', '/', '\\', '\r', '\n', '\t', '\0'), '', $_POST['tblpfx']); // If we have specified a database, and we have not used invalid characters, // try to connect to it. $dbname_ok=false; if ($DBNAME && $DBNAME==$_POST['dbname'] && $TBLPREFIX==$_POST['tblpfx']) { try { // Try to create the database, if it does not exist. $dbh->exec("CREATE DATABASE IF NOT EXISTS `{$DBNAME}` COLLATE utf8_unicode_ci"); } catch (PDOException $ex) { // If we have no permission to do this, there's nothing helpful we can say. // We'll get a more helpful error message from the next test. } try { $dbh->exec("USE `{$DBNAME}`"); $dbname_ok=true; } catch (PDOException $ex) { echo '

', WT_I18N::translate('Unable to connect using these settings. Your server gave the following error.'), '

', '
', $ex->getMessage(), '
', '

', WT_I18N::translate('Check the settings and try again.'), '

'; } } // If the database exists, check whether it is already used by another application. if ($dbname_ok) { try { // PhpGedView (4.2.3 and earlier) and many other applications have a USERS table. // webtrees has a USER table $dummy=$dbh->query("SELECT COUNT(*) FROM `{$TBLPREFIX}users`"); echo '

', WT_I18N::translate('This database and table-prefix appear to be used by another application. If you have an existing PhpGedView system, you should create a new webtrees system. You can import your PhpGedView data and settings later.'), '

'; $dbname_ok=false; } catch (PDOException $ex) { // Table not found? Good! } } if ($dbname_ok) { try { // PhpGedView (4.2.4 and later) has a site_setting.site_setting_name column. // [We changed the column name in webtrees, so we can tell the difference!] $dummy=$dbh->query("SELECT site_setting_value FROM `{$TBLPREFIX}site_setting` WHERE site_setting_name='PGV_SCHEMA_VERSION'"); echo '

', WT_I18N::translate('This database and table-prefix appear to be used by another application. If you have an existing PhpGedView system, you should create a new webtrees system. You can import your PhpGedView data and settings later.'), '

'; $dbname_ok=false; } catch (PDOException $ex) { // Table/column not found? Good! } } if (!$dbname_ok) { echo '

', WT_I18N::translate('Database and table names'), '

', '

', WT_I18N::translate('A database server can store many separate databases. You need to select an existing database (created by your server\'s administrator) or create a new one (if your database user account has sufficient privileges).'), '

', '
', WT_I18N::translate('Database name'), '', '
', WT_I18N::translate('Database name'), '', '', WT_I18N::translate('This is case sensitive. If a database with this name does not already exist webtrees will attempt to create one for you. Success will depend on permissions set for your web server, but you will be notified if this fails.'), '
', WT_I18N::translate('Table prefix'), '', '', WT_I18N::translate('The prefix is optional, but recommended. By giving the table names a unique prefix you can let several different applications share the same database. "wt_" is suggested, but can be anything you want.'), '
', '
', '
', '', "\n\n", ''; exit; } else { // Copy these values through to the next step echo ''; echo ''; } //////////////////////////////////////////////////////////////////////////////// // Step four - site setup data //////////////////////////////////////////////////////////////////////////////// if (empty($_POST['wtname' ])) $_POST['wtname' ]=''; if (empty($_POST['wtuser' ])) $_POST['wtuser' ]=''; if (empty($_POST['wtpass' ])) $_POST['wtpass' ]=''; if (empty($_POST['wtpass2' ])) $_POST['wtpass2' ]=''; if (empty($_POST['wtemail' ])) $_POST['wtemail' ]=''; if (empty($_POST['smtpuse' ])) $_POST['smtpuse' ]='internal'; if (empty($_POST['smtpserv' ])) $_POST['smtpserv' ]='localhost'; if (empty($_POST['smtpport' ])) $_POST['smtpport' ]='25'; if (empty($_POST['smtpusepw' ])) $_POST['smtpusepw' ]=1; if (empty($_POST['smtpuser' ])) $_POST['smtpuser' ]=''; if (empty($_POST['smtppass' ])) $_POST['smtppass' ]=''; if (empty($_POST['smtpsecure'])) $_POST['smtpsecure']='none'; if (empty($_POST['smtpfrom' ])) $_POST['smtpfrom' ]='webmaster@localhost'; if (empty($_POST['smtpsender'])) $_POST['smtpsender']=$_POST['smtpfrom']; if (empty($_POST['wtname']) || empty($_POST['wtuser']) || strlen($_POST['wtpass'])<6 || strlen($_POST['wtpass2'])<6 || empty($_POST['wtemail']) || $_POST['wtpass']<>$_POST['wtpass2']) { if (strlen($_POST['wtpass'])>0 && strlen($_POST['wtpass'])<6) { echo '

', WT_I18N::translate('The password needs to be at least six characters long.'), '

'; } elseif ($_POST['wtpass']<>$_POST['wtpass2']) { echo '

', WT_I18N::translate('The passwords do not match.'), '

'; } elseif ((empty($_POST['wtname']) || empty($_POST['wtuser']) || empty($_POST['wtpass']) || empty($_POST['wtemail'])) && $_POST['wtname'].$_POST['wtuser'].$_POST['wtpass'].$_POST['wtemail']!='') { echo '

', WT_I18N::translate('You must enter all the administrator account fields.'), '

'; } echo '

', WT_I18N::translate('System settings'), '

', '

', WT_I18N::translate('Administrator account'), '

', '

', WT_I18N::translate('You need to set up an administrator account. This account can control all aspects of this webtrees installation. Please choose a strong password.'), '

', '
', WT_I18N::translate('Administrator account'), '', '
', WT_I18N::translate('Your name'), '', '', WT_I18N::translate('This is your real name, as you would like it displayed on screen.'), '
', WT_I18N::translate('Login ID'), '', '', WT_I18N::translate('You will use this to login to webtrees.'), '
', WT_I18N::translate('Password'), '', '', WT_I18N::translate('This must to be at least six characters. It is case-sensitive.'), '
', ' ', '', '', WT_I18N::translate('Type your password again, to make sure you have typed it correctly.'), '
', WT_I18N::translate('Email address'), '', '', WT_I18N::translate('This email address will be used to send you password reminders, site notifications, and messages from other family members who are registered on the site.'), '
', '
', '
', '

', '

', WT_I18N::translate('Email'), '

', '

', WT_I18N::translate('webtrees needs to send emails, such as password reminders and site notifications. To do this, it can use this server\'s built in PHP mail facility (which is not always available) or an external SMTP (mail-relay) service, for which you will need to provide the connection details.'), '

', '

', WT_I18N::translate('To use a Google mail account, use the following settings: server=smtp.gmail.com, port=587, security=tls, username=xxxxx@gmail.com, password=[your gmail password]'), '

', '

', WT_I18N::translate('If you do not know these settings, leave the default values. They may work. You can change them later.'), '

', '
', WT_I18N::translate('SMTP mail server'), '', '
', WT_I18N::translate('Messages'), '', '', WT_I18N::translate('If you don\'t want to send mail, for example when running webtrees with a single user or on a standalone computer, you can disable this feature.'), '
', WT_I18N::translate('Server'), '', '', WT_I18N::translate('This is the name of the SMTP server. \'localhost\' means that the mail service is running on the same computer as your web server.'), '
', WT_I18N::translate('Port'), '', '', WT_I18N::translate('By default, SMTP works on port 25.'), '
', WT_I18N::translate('Use password'), '', '', WT_I18N::translate('Most SMTP servers require a password.'), '
', WT_I18N::translate('Username'), '', '', ' ', '
', WT_I18N::translate('Password'), '', '', ' ', '
', WT_I18N::translate('Security'), '', '', WT_I18N::translate('Most servers do not use secure connections.'), '
', /* I18N: the "From:" header in an email */ WT_I18N::translate('From email address'), '', '', WT_I18N::translate('This is used in the "From:" header when sending mails.'), '
', /* I18N: the "Sender:" header in an email */ WT_I18N::translate('Sender email address'), '', '', WT_I18N::translate('This is used in the "Sender:" header when sending mails. It is often the same as the "From:" header.'), '
', '
', '
', '
', '', "\n\n", ''; exit; } else { // Copy these values through to the next step echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } //////////////////////////////////////////////////////////////////////////////// // Step five - We have a database connection. Create the tables. //////////////////////////////////////////////////////////////////////////////// try { // These shouldn't fail. $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}gedcom` (". " gedcom_id INTEGER AUTO_INCREMENT NOT NULL,". " gedcom_name VARCHAR(255) NOT NULL,". " sort_order INTEGER NOT NULL DEFAULT 0,". " PRIMARY KEY (gedcom_id),". " UNIQUE KEY ux1 (gedcom_name),". " KEY ix1 (sort_order)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}site_setting` (". " setting_name VARCHAR(32) NOT NULL,". " setting_value VARCHAR(255) NOT NULL,". " PRIMARY KEY (setting_name)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}gedcom_setting` (". " gedcom_id INTEGER NOT NULL,". " setting_name VARCHAR(32) NOT NULL,". " setting_value VARCHAR(255) NOT NULL,". " PRIMARY KEY (gedcom_id, setting_name),". " FOREIGN KEY fk1 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}user` (". " user_id INTEGER AUTO_INCREMENT NOT NULL,". " user_name VARCHAR(32) NOT NULL,". " real_name VARCHAR(64) NOT NULL,". " email VARCHAR(64) NOT NULL,". " password VARCHAR(128) NOT NULL,". " PRIMARY KEY (user_id),". " UNIQUE KEY ux1 (user_name),". " UNIQUE KEY ux2 (email)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}user_setting` (". " user_id INTEGER NOT NULL,". " setting_name VARCHAR(32) NOT NULL,". " setting_value VARCHAR(255) NOT NULL,". " PRIMARY KEY (user_id, setting_name),". " FOREIGN KEY fk1 (user_id) REFERENCES `{$TBLPREFIX}user` (user_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}user_gedcom_setting` (". " user_id INTEGER NOT NULL,". " gedcom_id INTEGER NOT NULL,". " setting_name VARCHAR(32) NOT NULL,". " setting_value VARCHAR(255) NOT NULL,". " PRIMARY KEY (user_id, gedcom_id, setting_name),". " FOREIGN KEY fk1 (user_id) REFERENCES `{$TBLPREFIX}user` (user_id) /* ON DELETE CASCADE */,". " FOREIGN KEY fk2 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}log` (". " log_id INTEGER AUTO_INCREMENT NOT NULL,". " log_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,". " log_type ENUM('auth', 'config', 'debug', 'edit', 'error', 'media', 'search') NOT NULL,". " log_message TEXT NOT NULL,". " ip_address VARCHAR(40) NOT NULL,". " user_id INTEGER NULL,". " gedcom_id INTEGER NULL,". " PRIMARY KEY (log_id),". " KEY ix1 (log_time),". " KEY ix2 (log_type),". " KEY ix3 (ip_address),". " FOREIGN KEY fk1 (user_id) REFERENCES `{$TBLPREFIX}user` (user_id) /* ON DELETE SET NULL */,". " FOREIGN KEY fk2 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE SET NULL */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}change` (". " change_id INTEGER AUTO_INCREMENT NOT NULL,". " change_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,". " status ENUM('accepted', 'pending', 'rejected') NOT NULL DEFAULT 'pending',". " gedcom_id INTEGER NOT NULL,". " xref VARCHAR(20) NOT NULL,". " old_gedcom MEDIUMTEXT NOT NULL,". " new_gedcom MEDIUMTEXT NOT NULL,". " user_id INTEGER NOT NULL,". " PRIMARY KEY (change_id),". " KEY ix1 (gedcom_id, status, xref),". " FOREIGN KEY fk1 (user_id) REFERENCES `{$TBLPREFIX}user` (user_id) /* ON DELETE RESTRICT */,". " FOREIGN KEY fk2 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}message` (". " message_id INTEGER AUTO_INCREMENT NOT NULL,". " sender VARCHAR(64) NOT NULL,". // username or email address " ip_address VARCHAR(40) NOT NULL,". // long enough for IPv6 " user_id INTEGER NOT NULL,". " subject VARCHAR(255) NOT NULL,". " body TEXT NOT NULL,". " created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,". " PRIMARY KEY (message_id),". " FOREIGN KEY fk1 (user_id) REFERENCES `{$TBLPREFIX}user` (user_id) /* ON DELETE RESTRICT */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}default_resn` (". " default_resn_id INTEGER AUTO_INCREMENT NOT NULL,". " gedcom_id INTEGER NOT NULL,". " xref VARCHAR(20) NULL,". " tag_type VARCHAR(15) NULL,". " resn ENUM ('none', 'privacy', 'confidential', 'hidden') NOT NULL,". " comment VARCHAR(255) NULL,". " updated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,". " PRIMARY KEY (default_resn_id),". " UNIQUE KEY ux1 (gedcom_id, xref, tag_type),". " FOREIGN KEY fk1 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id)". ") ENGINE=InnoDB COLLATE=utf8_unicode_ci" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}individuals` (". " i_id VARCHAR(20) NOT NULL,". " i_file INTEGER NOT NULL,". " i_rin VARCHAR(20) NOT NULL,". " i_sex ENUM('U', 'M', 'F') NOT NULL,". " i_gedcom MEDIUMTEXT NOT NULL,". " PRIMARY KEY (i_id, i_file),". " UNIQUE KEY ux1 (i_file, i_id)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}families` (". " f_id VARCHAR(20) NOT NULL,". " f_file INTEGER NOT NULL,". " f_husb VARCHAR(20) NULL,". " f_wife VARCHAR(20) NULL,". " f_gedcom MEDIUMTEXT NOT NULL,". " f_numchil INTEGER NOT NULL,". " PRIMARY KEY (f_id, f_file),". " UNIQUE KEY ux1 (f_file, f_id),". " KEY ix1 (f_husb),". " KEY ix2 (f_wife)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}places` (". " p_id INTEGER AUTO_INCREMENT NOT NULL,". " p_place VARCHAR(150) NULL,". " p_level INTEGER NULL,". " p_parent_id INTEGER NULL,". " p_file INTEGER NOT NULL,". " p_std_soundex TEXT NULL,". " p_dm_soundex TEXT NULL,". " PRIMARY KEY (p_id),". " KEY ix1 (p_place),". " KEY ix2 (p_level),". " KEY ix3 (p_parent_id),". " KEY ix4 (p_file)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}placelinks` (". " pl_p_id INTEGER NOT NULL,". " pl_gid VARCHAR(20) NOT NULL,". " pl_file INTEGER NOT NULL,". " PRIMARY KEY (pl_p_id, pl_gid, pl_file),". " KEY ix1 (pl_p_id),". " KEY ix2 (pl_gid),". " KEY ix3 (pl_file)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}dates` (". " d_day TINYINT NOT NULL,". " d_month CHAR(5) NULL,". " d_mon TINYINT NOT NULL,". " d_year SMALLINT NOT NULL,". " d_julianday1 MEDIUMINT NOT NULL,". " d_julianday2 MEDIUMINT NOT NULL,". " d_fact VARCHAR(15) NOT NULL,". " d_gid VARCHAR(20) NOT NULL,". " d_file INTEGER NOT NULL,". " d_type ENUM ('@#DGREGORIAN@', '@#DJULIAN@', '@#DHEBREW@', '@#DFRENCH R@', '@#DHIJRI@', '@#DROMAN@', '@#DJALALI@') NOT NULL,". " KEY ix1 (d_day),". " KEY ix2 (d_month),". " KEY ix3 (d_mon),". " KEY ix4 (d_year),". " KEY ix5 (d_julianday1),". " KEY ix6 (d_julianday2),". " KEY ix7 (d_gid),". " KEY ix8 (d_file),". " KEY ix9 (d_type),". " KEY ix10 (d_fact, d_gid)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}media` (". " m_id INTEGER AUTO_INCREMENT NOT NULL,". " m_media VARCHAR(20) NOT NULL,". " m_ext VARCHAR(6) NULL,". " m_titl VARCHAR(255) NULL,". " m_file VARCHAR(512) NULL,". " m_gedfile INTEGER NOT NULL,". " m_gedrec MEDIUMTEXT NULL,". " PRIMARY KEY (m_id),". " KEY ix1 (m_media, m_gedfile)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}media_mapping` (". " mm_id INTEGER AUTO_INCREMENT NOT NULL,". " mm_media VARCHAR(20) NOT NULL,". " mm_gid VARCHAR(20) NOT NULL,". " mm_order INTEGER NOT NULL DEFAULT '0',". " mm_gedfile INTEGER NOT NULL,". " mm_gedrec MEDIUMTEXT NOT NULL,". " PRIMARY KEY (mm_id),". " KEY ix1 (mm_media, mm_gedfile),". " KEY ix2 (mm_gid, mm_gedfile),". " KEY ix3 (mm_gedfile)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}next_id` (". " gedcom_id INTEGER NOT NULL,". " record_type VARCHAR(15) NOT NULL,". " next_id DECIMAL(20) NOT NULL,". " PRIMARY KEY (gedcom_id, record_type),". " FOREIGN KEY fk1 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}other` (". " o_id VARCHAR(20) NOT NULL,". " o_file INTEGER NOT NULL,". " o_type VARCHAR(15) NOT NULL,". " o_gedcom MEDIUMTEXT NULL,". " PRIMARY KEY (o_id, o_file),". " UNIQUE KEY ux1 (o_file, o_id)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}sources` (". " s_id VARCHAR(20) NOT NULL,". " s_file INTEGER NOT NULL,". " s_name VARCHAR(255) NOT NULL,". " s_gedcom MEDIUMTEXT NOT NULL,". " PRIMARY KEY (s_id, s_file),". " UNIQUE KEY ux1 (s_file, s_id),". " KEY ix1 (s_name)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}link` (". " l_file INTEGER NOT NULL,". " l_from VARCHAR(20) NOT NULL,". " l_type VARCHAR(15) NOT NULL,". " l_to VARCHAR(20) NOT NULL,". " PRIMARY KEY (l_from, l_file, l_type, l_to),". " UNIQUE INDEX ux1 (l_to, l_file, l_type, l_from)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}name` (". " n_file INTEGER NOT NULL,". " n_id VARCHAR(20) NOT NULL,". " n_num INTEGER NOT NULL,". " n_type VARCHAR(15) NOT NULL,". " n_sort VARCHAR(255) NOT NULL,". // e.g. "GOGH,VINCENT WILLEM" " n_full VARCHAR(255) NOT NULL,". // e.g. "Vincent Willem van GOGH" // These fields are only used for INDI records " n_surname VARCHAR(255) NULL,". // e.g. "van GOGH" " n_surn VARCHAR(255) NULL,". // e.g. "GOGH" " n_givn VARCHAR(255) NULL,". // e.g. "Vincent Willem" " n_soundex_givn_std VARCHAR(255) NULL,". " n_soundex_surn_std VARCHAR(255) NULL,". " n_soundex_givn_dm VARCHAR(255) NULL,". " n_soundex_surn_dm VARCHAR(255) NULL,". " PRIMARY KEY (n_id, n_file, n_num),". " KEY ix1 (n_full, n_id, n_file),". " KEY ix2 (n_surn, n_file, n_type, n_id),". " KEY ix3 (n_givn, n_file, n_type, n_id)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}module` (". " module_name VARCHAR(32) NOT NULL,". " status ENUM('enabled', 'disabled') NOT NULL DEFAULT 'enabled',". " tab_order INTEGER NULL, ". " menu_order INTEGER NULL, ". " sidebar_order INTEGER NULL,". " PRIMARY KEY (module_name)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}module_setting` (". " module_name VARCHAR(32) NOT NULL,". " setting_name VARCHAR(32) NOT NULL,". " setting_value TEXT NOT NULL,". " PRIMARY KEY (module_name, setting_name),". " FOREIGN KEY fk1 (module_name) REFERENCES `{$TBLPREFIX}module` (module_name) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}module_privacy` (". " module_name VARCHAR(32) NOT NULL,". " gedcom_id INTEGER NOT NULL,". " component ENUM('block', 'chart', 'menu', 'report', 'sidebar', 'tab', 'theme') NOT NULL,". " access_level TINYINT NOT NULL,". " PRIMARY KEY (module_name, gedcom_id, component),". " FOREIGN KEY fk1 (module_name) REFERENCES `{$TBLPREFIX}module` (module_name) /* ON DELETE CASCADE */,". " FOREIGN KEY fk2 (gedcom_id ) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}block` (". " block_id INTEGER AUTO_INCREMENT NOT NULL,". " gedcom_id INTEGER NULL,". " user_id INTEGER NULL,". " xref VARCHAR(20) NULL,". " location ENUM('main', 'side') NULL,". " block_order INTEGER NOT NULL,". " module_name VARCHAR(32) NOT NULL,". " PRIMARY KEY (block_id),". " FOREIGN KEY fk1 (gedcom_id ) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id ), /* ON DELETE CASCADE */". " FOREIGN KEY fk2 (user_id ) REFERENCES `{$TBLPREFIX}user` (user_id ), /* ON DELETE CASCADE */". " FOREIGN KEY fk3 (module_name) REFERENCES `{$TBLPREFIX}module` (module_name) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}block_setting` (". " block_id INTEGER NOT NULL,". " setting_name VARCHAR(32) NOT NULL,". " setting_value TEXT NOT NULL,". " PRIMARY KEY (block_id, setting_name),". " FOREIGN KEY fk1 (block_id) REFERENCES `{$TBLPREFIX}block` (block_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}hit_counter` (". " gedcom_id INTEGER NOT NULL,". " page_name VARCHAR(32) NOT NULL,". " page_parameter VARCHAR(32) NOT NULL,". " page_count INTEGER NOT NULL,". " PRIMARY KEY (gedcom_id, page_name, page_parameter),". " FOREIGN KEY fk1 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}ip_address` (". " ip_address VARCHAR(40) NOT NULL,". // long enough for IPv6 " category ENUM('banned', 'search-engine', 'allowed') NOT NULL,". " comment VARCHAR(255) NOT NULL,". " PRIMARY KEY (ip_address)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}session` (". " session_id CHAR(128) NOT NULL,". " session_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,". " user_id INTEGER NOT NULL,". " ip_address VARCHAR(32) NOT NULL,". " session_data MEDIUMBLOB NOT NULL,". " PRIMARY KEY (session_id),". " KEY ix1 (session_time),". " KEY ix2 (user_id, ip_address)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}gedcom_chunk` (". " gedcom_chunk_id INTEGER AUTO_INCREMENT NOT NULL,". " gedcom_id INTEGER NOT NULL,". " chunk_data MEDIUMBLOB NOT NULL,". " imported BOOLEAN NOT NULL DEFAULT FALSE,". " PRIMARY KEY (gedcom_chunk_id),". " KEY ix1 (gedcom_id, imported),". " FOREIGN KEY fk1 (gedcom_id) REFERENCES `{$TBLPREFIX}gedcom` (gedcom_id) /* ON DELETE CASCADE */". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); //$dbh->exec( // "CREATE TABLE IF NOT EXISTS `{$TBLPREFIX}language` (". // " language_tag VARCHAR(16) NOT NULL,". // " iso15924_code CHAR(4) NOT NULL,". // " cldr_code VARCHAR(16) NOT NULL,". // " launchpad_code VARCHAR(16) NOT NULL,". // " collation VARCHAR(16) NOT NULL,". // " language_name VARCHAR(64) NOT NULL,". // " language_name_base VARCHAR(64) NOT NULL,". // " enabled ENUM ('yes', 'no') DEFAULT 'yes' NOT NULL,". // " PRIMARY KEY (language_tag),". // " INDEX (language_name_base, language_name)". // ") COLLATE utf8_unicode_ci ENGINE=InnoDB" //); $dbh->prepare( "INSERT IGNORE INTO `{$TBLPREFIX}user` (user_id, user_name, real_name, email, password) VALUES ". " (1, ?, ?, ?, ?)" )->execute(array( $_POST['wtuser'], $_POST['wtname'], $_POST['wtemail'], crypt($_POST['wtpass']) )); $dbh->prepare( "INSERT IGNORE INTO `{$TBLPREFIX}user_setting` (user_id, setting_name, setting_value) VALUES ". " (1, 'canadmin', ?),". " (1, 'language', ?),". " (1, 'verified', ?),". " (1, 'verified_by_admin', ?),". " (1, 'editaccount', ?),". " (1, 'auto_accept', ?),". " (1, 'visibleonline', ?)" )->execute(array( 1, WT_LOCALE, 1, 1, 1, 0, 1 )); $dbh->prepare( "INSERT IGNORE INTO `{$TBLPREFIX}site_setting` (setting_name, setting_value) VALUES ". "('WT_SCHEMA_VERSION', '-1'),". "('INDEX_DIRECTORY', 'data/'),". "('STORE_MESSAGES', '1'),". "('USE_REGISTRATION_MODULE', '1'),". "('REQUIRE_ADMIN_AUTH_REGISTRATION', '1'),". "('ALLOW_USER_THEMES', '1'),". "('ALLOW_CHANGE_GEDCOM', '1'),". "('SESSION_TIME', '7200'),". "('SMTP_ACTIVE', ?),". "('SMTP_HOST', ?),". "('SMTP_HELO', ?),". "('SMTP_PORT', ?),". "('SMTP_AUTH', ?),". "('SMTP_AUTH_USER', ?),". "('SMTP_AUTH_PASS', ?),". "('SMTP_SSL', ?),". "('SMTP_FROM_NAME', ?)" )->execute(array( $_POST['smtpuse'], $_POST['smtpserv'], $_POST['smtpsender'], $_POST['smtpport'], $_POST['smtpusepw'], $_POST['smtpuser'], $_POST['smtppass'], $_POST['smtpsecure'], $_POST['smtpfrom'] )); echo '

', WT_I18N::translate('Your system is almost ready for use. The final step is to download a configuration file %1$s and copy this to the %2$s directory on your webserver. This is a security measure to ensure only the website\'s owner can configure it.', WT_CONFIG_FILE, realpath(WT_DATA_DIR)), '

'; if (DIRECTORY_SEPARATOR=='/') { // These hints only apply to UNIX based servers. // For Windows/XAMPP, defaults are fine // For Windows/IIS, the defaults are probably fine. Anyone confirm? echo '

', WT_I18N::translate('You should set the directory %s so that the webserver has read-write access.
This normally means setting the permissions to "777" or "drwxrwxrwx".', WT_DATA_DIR), '

', '

', WT_I18N::translate('You should set the file %s so that the webserver has read-only access.
This normally means setting the permissions to "444" or "-r--r--r--".', WT_DATA_DIR.WT_CONFIG_FILE), '

', '

', WT_I18N::translate('webtrees will check the permissions in the next step.'), '

'; } echo '', '', '', '

', WT_I18N::translate('After you have copied this file to the webserver and set the access permissions, click here to continue'), '

', '
', '', '', '
'; exit; } catch (PDOException $ex) { echo '

', WT_I18N::translate('An unexpected database error occured.'), '

', '
', $ex->getMessage(), '
', '

', WT_I18N::translate('The webtrees developers would be very interested to learn about this error. If you contact them, they will help you resolve the problem.'), '

'; } echo ''; echo ''; echo ''; function to_mb($str) { if (substr($str, -1, 1)=='K') { return floor(substr($str, 0, strlen($str)-1)/1024); } if (substr($str, -1, 1)=='M') { return floor(substr($str, 0, strlen($str)-1)); } if (substr($str, -1, 1)=='G') { return floor(1024*substr($str, 0, strlen($str)-1)); } }