diff options
| -rw-r--r-- | admin_pgv_to_wt.php | 1137 | ||||
| -rw-r--r-- | app/Http/Controllers/AdminController.php | 1 | ||||
| -rw-r--r-- | app/Http/Controllers/AdminPhpGedViewController.php | 1199 | ||||
| -rw-r--r-- | resources/views/admin/phpgedview/steps.php | 35 | ||||
| -rw-r--r-- | resources/views/admin/phpgedview/wizard.php | 60 | ||||
| -rw-r--r-- | resources/views/admin/trees.php | 2 | ||||
| -rw-r--r-- | resources/views/admin/upgrade/steps.php | 25 | ||||
| -rw-r--r-- | resources/views/admin/upgrade/wizard.php | 60 | ||||
| -rw-r--r-- | routes/web.php | 2 | ||||
| -rw-r--r-- | themes/_administration/css-2.0.0/style.css | 10 |
10 files changed, 1393 insertions, 1138 deletions
diff --git a/admin_pgv_to_wt.php b/admin_pgv_to_wt.php deleted file mode 100644 index 5ad917b2c0..0000000000 --- a/admin_pgv_to_wt.php +++ /dev/null @@ -1,1137 +0,0 @@ -<?php -/** - * webtrees: online genealogy - * Copyright (C) 2018 webtrees development team - * 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 3 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. - * You should have received a copy of the GNU General Public License - * along with this program. If not, see <http://www.gnu.org/licenses/>. - */ -namespace Fisharebest\Webtrees; - -use Fisharebest\Webtrees\Controller\PageController; -use PDO; -use PDOException; -use Throwable; - -/** @global Tree $WT_TREE */ -global $WT_TREE; - -require 'includes/session.php'; - -// We can only import into an empty system, so deny access if we have already created a gedcom or added users. -if ($WT_TREE || count(User::all()) > 1) { - header('Location: index.php'); - - return; -} - -$controller = new PageController; -$controller - ->restrictAccess(Auth::isAdmin()) - ->setPageTitle(I18N::translate('PhpGedView to webtrees transfer wizard')); - -$error = false; -$PGV_PATH = Filter::post('PGV_PATH'); - -// We read these variables from PhpGedView's config.php, and set them here in case any are missing. -$INDEX_DIRECTORY = ''; -$DBHOST = ''; -$DBNAME = ''; -$TBLPREFIX = ''; -$PGV_SCHEMA_VERSION = ''; -$USE_REGISTRATION_MODULE = ''; -$ALLOW_USER_THEMES = ''; -$ALLOW_CHANGE_GEDCOM = ''; -$PGV_SESSION_TIME = ''; -$PGV_SMTP_ACTIVE = ''; -$PGV_SMTP_HOST = ''; -$PGV_SMTP_HELO = ''; -$PGV_SMTP_PORT = ''; -$PGV_SMTP_AUTH = ''; -$PGV_SMTP_AUTH_USER = ''; -$PGV_SMTP_AUTH_PASS = ''; -$PGV_SMTP_SSL = ''; -$PGV_SMTP_FROM_NAME = ''; - -if ($PGV_PATH) { - if (!is_dir($PGV_PATH) || !is_readable($PGV_PATH . '/config.php')) { - FlashMessages::addMessage('The specified folder does not contain an installation of PhpGedView.', 'danger'); - $PGV_PATH = null; - } else { - // Load the configuration settings - $config_php = file_get_contents($PGV_PATH . '/config.php'); - // The easiest way to do this is to exec() the file - but not lines containing require or PHP tags - $config_php = preg_replace( - [ - '/^\s*(include|require).*/m', - '/.*<\?php.*/', - '/.*\?>.*/', - ], '', $config_php - ); - eval($config_php); - // $INDEX_DIRECTORY can be either absolute or relative to the PhpGedView root. - if (preg_match('/^(\/|\\|[A-Z]:)/', $INDEX_DIRECTORY)) { - $INDEX_DIRECTORY = realpath($INDEX_DIRECTORY) . DIRECTORY_SEPARATOR; - } else { - $INDEX_DIRECTORY = realpath($PGV_PATH . '/' . $INDEX_DIRECTORY) . DIRECTORY_SEPARATOR; - } - $wt_config = parse_ini_file(WT_ROOT . 'data/config.ini.php'); - if ($DBHOST != $wt_config['dbhost']) { - FlashMessages::addMessage(I18N::translate('PhpGedView must use the same database as webtrees.', 'danger')); - $PGV_PATH = null; - unset($wt_config); - } else { - unset($wt_config); - try { - $PGV_SCHEMA_VERSION = Database::prepare( - "SELECT site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting` WHERE site_setting_name='PGV_SCHEMA_VERSION'" - )->fetchOne(); - if ($PGV_SCHEMA_VERSION < 10) { - FlashMessages::addMessage(I18N::translate('The version of %s is too old.', 'PhpGedView'), 'danger'); - $PGV_PATH = null; - } elseif ($PGV_SCHEMA_VERSION > 14) { - FlashMessages::addMessage(I18N::translate('The version of %s is too new.', 'PhpGedView'), 'danger'); - $PGV_PATH = null; - } - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - FlashMessages::addMessage( - /* I18N: %s is a database name/identifier */ - I18N::translate('webtrees cannot connect to the PhpGedView database: %s.', $DBNAME . '@' . $DBHOST) . - '<br>' . - /* I18N: %s is an error message */ - I18N::translate('MySQL gave the error: %s', $ex->getMessage()), 'danger'); - $PGV_PATH = null; - } - } - } -} - -if ($PGV_PATH) { - // The account we are using is about to be deleted. - Session::forget('wt_user'); -} - -$controller->pageHeader(); - -echo Bootstrap4::breadcrumbs([ - route('admin-control-panel') => I18N::translate('Control panel'), - route('admin-trees') => I18N::translate('Manage family trees'), -], $controller->getPageTitle()); -?> - -<h1><?= $controller->getPageTitle() ?></h1> - -<?php - -if (!$PGV_PATH) { - // Look for PhpGedView in some nearby directories - $pgv_dirs = []; - $dir = opendir(realpath('..')); - while (($subdir = readdir($dir)) !== false) { - // Exclude '..' as ascending too many levels can trigger open_basedir_restriction errors. - if ($subdir !== '..' && is_dir('../' . $subdir) && file_exists('../' . $subdir . '/config.php')) { - $pgv_dirs[] = '../' . $subdir; - } - } - closedir($dir); - - if (count($pgv_dirs) > 1) { - $html = I18N::translate('PhpGedView might be installed in one of these folders:'); - foreach ($pgv_dirs as $pgv_dir) { - $html .= '<div onclick="$(\'#PGV_PATH\').val(\'' . e($pgv_dir) . '\')">' . e($pgv_dir) . '</div>'; - } - - echo Theme::theme()->htmlAlert($html, 'info', true); - } - ?> - - <form class="form-horizontal" method="post"> - <div class="row form-group"> - <label class="col-sm-3 col-form-label" for="PGV_PATH"> - <?= I18N::translate('Where is your PhpGedView installation?') ?> - </label> - <div class="col-sm-9"> - <input - type="text" - class="form-control" - dir="ltr" - id="PGV_PATH" - name="PGV_PATH" - size="40" - placeholder="<?= I18N::translate('Installation folder') ?>" - value="<?= count($pgv_dirs) === 1 ? e($pgv_dirs[0]) : '' ?>" - required - > - </div> - </div> - - <div class="row form-group"> - <div class="offset-sm-3 col-sm-9"> - <button type="submit" class="btn btn-primary"> - <?= I18N::translate('continue') ?> - </button> - </div> - </div> - </form> - <?php - - return; -} - -// Run in a transaction -Database::beginTransaction(); - -// Delete the existing user accounts, and any information associated with it -Database::exec("UPDATE `##log` SET user_id=NULL"); -Database::exec("DELETE FROM `##change`"); -Database::exec("DELETE `##block_setting` FROM `##block_setting` JOIN `##block` USING (block_id) WHERE user_id>0 OR gedcom_id>0"); -Database::exec("DELETE FROM `##block` WHERE user_id>0 OR gedcom_id>0"); -Database::exec("DELETE FROM `##message`"); -Database::exec("DELETE FROM `##user_gedcom_setting` WHERE user_id>0"); -Database::exec("DELETE FROM `##user_setting` WHERE user_id>0"); -Database::exec("DELETE FROM `##user` WHERE user_id>0"); - -//////////////////////////////////////////////////////////////////////////////// - -echo '<p>', $INDEX_DIRECTORY, 'config.php => wt_site_setting…</p>'; - -Site::setPreference('USE_REGISTRATION_MODULE', $USE_REGISTRATION_MODULE); -Site::setPreference('ALLOW_USER_THEMES', $ALLOW_USER_THEMES); -Site::setPreference('ALLOW_CHANGE_GEDCOM', $ALLOW_CHANGE_GEDCOM); -Site::setPreference('SESSION_TIME', $PGV_SESSION_TIME); -Site::setPreference('SMTP_ACTIVE', $PGV_SMTP_ACTIVE ? 'external' : 'internal'); -Site::setPreference('SMTP_HOST', $PGV_SMTP_HOST); -Site::setPreference('SMTP_HELO', $PGV_SMTP_HELO); -Site::setPreference('SMTP_PORT', $PGV_SMTP_PORT); -Site::setPreference('SMTP_AUTH', $PGV_SMTP_AUTH); -Site::setPreference('SMTP_AUTH_USER', $PGV_SMTP_AUTH_USER); -Site::setPreference('SMTP_AUTH_PASS', $PGV_SMTP_AUTH_PASS); -Site::setPreference('SMTP_SSL', $PGV_SMTP_SSL); -Site::setPreference('SMTP_FROM_NAME', $PGV_SMTP_FROM_NAME); - -//////////////////////////////////////////////////////////////////////////////// - -echo '<p>pgv_site_setting => wt_site_setting…</p>'; - -Database::prepare( - "REPLACE INTO `##site_setting` (setting_name, setting_value)" . - " SELECT site_setting_name, site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting`" . - " WHERE site_setting_name IN ('DEFAULT_GEDCOM', 'LAST_CHANGE_EMAIL')" -)->execute(); - -//////////////////////////////////////////////////////////////////////////////// - -if ($PGV_SCHEMA_VERSION >= 12) { - echo '<p>pgv_gedcom => wt_gedcom…</p>'; - - Database::prepare( - "INSERT INTO `##gedcom` (gedcom_id, gedcom_name)" . - " SELECT gedcom_id, gedcom_name FROM `{$DBNAME}`.`{$TBLPREFIX}gedcom`" - )->execute(); - - echo '<p>pgv_gedcom_setting => wt_gedcom_setting…</p>'; - - Database::prepare( - "INSERT INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value)" . - " SELECT gedcom_id, setting_name," . - " CASE setting_name" . - " WHEN 'THEME_DIR' THEN" . - " CASE setting_value" . - " WHEN '' THEN ''" . - " WHEN 'themes/cloudy/' THEN 'clouds'" . - " WHEN 'themes/minimal/' THEN 'minimal'" . - " WHEN 'themes/simplyblue/' THEN 'colors'" . - " WHEN 'themes/simplygreen/' THEN 'colors'" . - " WHEN 'themes/simplyred/' THEN 'colors'" . - " WHEN 'themes/xenea/' THEN 'xenea'" . - " ELSE 'themes/webtrees/'" . // ocean, simplyred/blue/green, standard, wood - " END" . - " WHEN 'LANGUAGE' THEN" . - " CASE setting_value" . - " WHEN 'arabic' THEN 'ar'" . - " WHEN 'catalan' THEN 'ca'" . - " WHEN 'chinese' THEN 'zh_CN'" . - " WHEN 'croatian' THEN 'hr'" . - " WHEN 'danish' THEN 'da'" . - " WHEN 'dutch' THEN 'nl'" . - " WHEN 'english' THEN 'en_US'" . - " WHEN 'english-uk' THEN 'en_GB'" . // PhpGedView once had the config for this, but no language files - " WHEN 'estonian' THEN 'et'" . - " WHEN 'finnish' THEN 'fi'" . - " WHEN 'french' THEN 'fr'" . - " WHEN 'german' THEN 'de'" . - " WHEN 'greek' THEN 'el'" . - " WHEN 'hebrew' THEN 'he'" . - " WHEN 'hungarian' THEN 'hu'" . - " WHEN 'indonesian' THEN 'id'" . - " WHEN 'italian' THEN 'it'" . - " WHEN 'lithuanian' THEN 'lt'" . - " WHEN 'norwegian' THEN 'nn'" . - " WHEN 'polish' THEN 'pl'" . - " WHEN 'portuguese' THEN 'pt'" . - " WHEN 'romainian' THEN 'ro'" . - " WHEN 'russian' THEN 'ru'" . - " WHEN 'serbian-la' THEN 'sr@Latn'" . - " WHEN 'slovak' THEN 'sk'" . - " WHEN 'slovenian' THEN 'sl'" . - " WHEN 'spanish' THEN 'es'" . - " WHEN 'spanish-ar' THEN 'es'" . // webtrees does not yet have this variant - " WHEN 'swedish' THEN 'sv'" . - " WHEN 'turkish' THEN 'tr'" . - " WHEN 'vietnamese' THEN 'vi'" . - " ELSE 'en_US'" . - " END" . - " ELSE setting_value" . - " END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}gedcom_setting`" . - " WHERE setting_name NOT IN ('HOME_SITE_TEXT', 'HOME_SITE_URL')" - )->execute(); - - echo '<p>pgv_user => wt_user…</p>'; - - try { - // "INSERT IGNORE" is needed to allow for PhpGedView users with duplicate emails. Only the first will be imported. - Database::prepare( - "INSERT IGNORE INTO `##user` (user_id, user_name, real_name, email, password)" . - " SELECT user_id, user_name, CONCAT_WS(' ', us1.setting_value, us2.setting_value), us3.setting_value, password FROM `{$DBNAME}`.`{$TBLPREFIX}user`" . - " LEFT JOIN `{$DBNAME}`.`{$TBLPREFIX}user_setting` us1 USING (user_id)" . - " LEFT JOIN `{$DBNAME}`.`{$TBLPREFIX}user_setting` us2 USING (user_id)" . - " JOIN `{$DBNAME}`.`{$TBLPREFIX}user_setting` us3 USING (user_id)" . - " WHERE us1.setting_name='firstname'" . - " AND us2.setting_name='lastname'" . - " AND us3.setting_name='email'" - )->execute(); - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // Ignore duplicates - } - - echo '<p>pgv_user_setting => wt_user_setting…</p>'; - - Database::prepare( - "INSERT INTO `##user_setting` (user_id, setting_name, setting_value)" . - " SELECT user_id, setting_name," . - " CASE setting_name" . - " WHEN 'language' THEN " . - " CASE setting_value" . - " WHEN 'arabic' THEN 'ar'" . - " WHEN 'catalan' THEN 'ca'" . - " WHEN 'chinese' THEN 'zh_CN'" . - " WHEN 'croatian' THEN 'hr'" . - " WHEN 'danish' THEN 'da'" . - " WHEN 'dutch' THEN 'nl'" . - " WHEN 'english' THEN 'en_US'" . - " WHEN 'english-uk' THEN 'en_GB'" . // PhpGedView once had the config for this, but no language files - " WHEN 'estonian' THEN 'et'" . - " WHEN 'finnish' THEN 'fi'" . - " WHEN 'french' THEN 'fr'" . - " WHEN 'german' THEN 'de'" . - " WHEN 'greek' THEN 'el'" . - " WHEN 'hebrew' THEN 'he'" . - " WHEN 'hungarian' THEN 'hu'" . - " WHEN 'indonesian' THEN 'id'" . - " WHEN 'italian' THEN 'it'" . - " WHEN 'lithuanian' THEN 'lt'" . - " WHEN 'norwegian' THEN 'nn'" . - " WHEN 'polish' THEN 'pl'" . - " WHEN 'portuguese' THEN 'pt'" . - " WHEN 'romainian' THEN 'ro'" . - " WHEN 'russian' THEN 'ru'" . - " WHEN 'serbian-la' THEN 'sr@Latn'" . - " WHEN 'slovak' THEN 'sk'" . - " WHEN 'slovenian' THEN 'sl'" . - " WHEN 'spanish' THEN 'es'" . - " WHEN 'spanish-ar' THEN 'es'" . // webtrees does not yet have this variant - " WHEN 'swedish' THEN 'sv'" . - " WHEN 'turkish' THEN 'tr'" . - " WHEN 'vietnamese' THEN 'vi'" . - " ELSE 'en_US'" . - " END" . - " WHEN 'theme' THEN" . - " CASE setting_value" . - " WHEN '' THEN ''" . - " WHEN 'themes/cloudy/' THEN 'clouds'" . - " WHEN 'themes/minimal/' THEN 'minimal'" . - " WHEN 'themes/simplyblue/' THEN 'colors'" . - " WHEN 'themes/simplygreen/' THEN 'colors'" . - " WHEN 'themes/simplyred/' THEN 'colors'" . - " WHEN 'themes/xenea/' THEN 'xenea'" . - " ELSE 'themes/webtrees/'" . // ocean, simplyred/blue/green, standard, wood - " END" . - " ELSE" . - " CASE" . - " WHEN setting_value IN ('Y', 'yes') THEN 1 WHEN setting_value IN ('N', 'no') THEN 0 ELSE setting_value END" . - " END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}user_setting`" . - " JOIN `##user` USING (user_id)" . - " WHERE setting_name NOT IN ('email', 'firstname', 'lastname', 'loggedin')" - )->execute(); - - echo '<p>pgv_user_gedcom_setting => wt_user_gedcom_setting…</p>'; - - Database::prepare( - "INSERT INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value)" . - " SELECT user_id, gedcom_id, setting_name, setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}user_gedcom_setting`" . - " JOIN `##user` USING (user_id)" - )->execute(); -} else { - // Copied from PhpGedView's db_schema_11_12 - if (file_exists($INDEX_DIRECTORY . 'gedcoms.php')) { - require_once $INDEX_DIRECTORY . 'gedcoms.php'; - echo '<p>', $INDEX_DIRECTORY . 'gedcoms.php', ' => wt_gedcom…</p>'; - - if (isset($GEDCOMS) && is_array($GEDCOMS)) { - foreach ($GEDCOMS as $array) { - try { - Database::prepare("INSERT INTO `##gedcom` (gedcom_id, gedcom_name) VALUES (?,?)") - ->execute([$array['id'], $array['gedcom']]); - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // Ignore duplicates - } - // insert gedcom - foreach ($array as $key => $value) { - if ($key != 'id' && $key != 'gedcom' && $key != 'commonsurnames') { - try { - Database::prepare("INSERT INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value) VALUES (?,?, ?)") - ->execute([$array['id'], $key, $value]); - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // Ignore duplicates - } - } - } - } - } - } - - // Migrate the data from pgv_users into pgv_user/pgv_user_setting/pgv_user_gedcom_setting - echo '<p>pgv_users => wt_user…</p>'; - - try { - // "INSERT IGNORE" is needed to allow for PhpGedView users with duplicate emails. Only the first will be imported. - Database::prepare( - "INSERT IGNORE INTO `##user` (user_name, real_name, email, password)" . - " SELECT u_username, CONCAT_WS(' ', u_firstname, u_lastname), u_email, u_password FROM `{$DBNAME}`.`{$TBLPREFIX}users`" - )->execute(); - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // This could only fail if; - // a) we've already done it (upgrade) - // b) it doesn't exist (new install) - } - echo '<p>pgv_users => wt_user_setting…</p>'; - - try { - Database::prepare( - "INSERT INTO `##user_setting` (user_id, setting_name, setting_value)" . - " SELECT user_id, 'canadmin', " . - " CASE WHEN u_canadmin IN ('Y', 'yes') THEN 1 WHEN u_canadmin IN ('N', 'no') THEN 0 ELSE u_canadmin END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'verified', " . - " CASE WHEN u_verified IN ('Y', 'yes') THEN 1 WHEN u_verified IN ('N', 'no') THEN 0 ELSE u_verified END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'verified_by_admin', " . - " CASE WHEN u_verified_by_admin IN ('Y', 'yes') THEN 1 WHEN u_verified_by_admin IN ('N', 'no') THEN 0 ELSE u_verified_by_admin END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'language', " . - " CASE u_language" . - " WHEN 'catalan' THEN 'ca'" . - " WHEN 'danish' THEN 'da'" . - " WHEN 'dutch' THEN 'nl'" . - " WHEN 'english' THEN 'en_US'" . - " WHEN 'english-uk' THEN 'en_GB'" . // PhpGedView had the config for en_GB, but no language files - " WHEN 'estonian' THEN 'et'" . - " WHEN 'finnish' THEN 'fi'" . - " WHEN 'french' THEN 'fr'" . - " WHEN 'german' THEN 'de'" . - " WHEN 'hebrew' THEN 'he'" . - " WHEN 'hungarian' THEN 'hu'" . - " WHEN 'italian' THEN 'it'" . - " WHEN 'norwegian' THEN 'nn'" . - " WHEN 'polish' THEN 'pl'" . - " WHEN 'portuguese' THEN 'pt'" . - " WHEN 'russian' THEN 'ru'" . - " WHEN 'slovak' THEN 'sk'" . - " WHEN 'slovenian' THEN 'sl'" . - " WHEN 'spanish' THEN 'es'" . - " WHEN 'swedish' THEN 'sv'" . - " WHEN 'turkish' THEN 'tr'" . - " ELSE 'en_US'" . // PhpGedView supports other languages that webtrees does not (yet) - " END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'reg_timestamp', u_reg_timestamp" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'reg_hashcode', u_reg_hashcode" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'theme', " . - " CASE u_theme" . - " WHEN '' THEN ''" . - " WHEN 'themes/cloudy/' THEN 'clouds'" . - " WHEN 'themes/minimal/' THEN 'minimal'" . - " WHEN 'themes/simplyblue/' THEN 'colors'" . - " WHEN 'themes/simplygreen/' THEN 'colors'" . - " WHEN 'themes/simplyred/' THEN 'colors'" . - " WHEN 'themes/xenea/' THEN 'xenea'" . - " ELSE 'themes/webtrees/'" . // ocean, simplyred/blue/green, standard, wood - " END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'sessiontime', u_sessiontime" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'contactmethod', u_contactmethod" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'visibleonline', " . - " CASE WHEN u_visibleonline IN ('Y', 'yes') THEN 1 WHEN u_visibleonline IN ('N', 'no') THEN 0 ELSE u_visibleonline END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'comment', u_comment" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'relationship_privacy', " . - " CASE WHEN u_relationship_privacy IN ('Y', 'yes') THEN 1 WHEN u_relationship_privacy IN ('N', 'no') THEN 0 ELSE u_relationship_privacy END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'max_relation_path', u_max_relation_path" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . - " UNION ALL" . - " SELECT user_id, 'auto_accept', " . - " CASE WHEN u_auto_accept IN ('Y', 'yes') THEN 1 WHEN u_auto_accept IN ('N', 'no') THEN 0 ELSE u_auto_accept END" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" - )->execute(); - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // This could only fail if; - // a) we've already done it (upgrade) - // b) it doesn't exist (new install) - } - // Some PhpGedView installations store the u_reg_timestamp in the format "2010-03-07 21:41:07" - Database::prepare( - "UPDATE `##user_setting` SET setting_value=UNIX_TIMESTAMP(setting_value) WHERE setting_name='reg_timestamp' AND setting_value LIKE '____-__-__ __:__:__'" - )->execute(); - // Some PhpGedView installations have empty/invalid values for reg_timestamp - Database::prepare( - "UPDATE `##user_setting` SET setting_value=CAST(setting_value AS UNSIGNED) WHERE setting_name='reg_timestamp'" - )->execute(); - echo '<p>pgv_users => wt_user_gedcom_setting…</p>'; - - $user_gedcom_settings = Database::prepare( - "SELECT user_id, u_gedcomid, u_rootid, u_canedit" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . - " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" - )->fetchAll(); - - foreach ($user_gedcom_settings as $setting) { - try { - $array = unserialize($setting->u_gedcomid); - foreach ($array as $gedcom => $value) { - $tree = Tree::findByName($gedcom); - if ($tree !== null) { - Database::prepare( - "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value) VALUES (?, ?, ?, ?)" - )->execute([$setting->user_id, $tree->getTreeId(), 'gedcomid', $value]); - } - } - } catch (Throwable $ex) { - DebugBar::addThrowable($ex); - - // Invalid serialized data? - } - - try { - $array = unserialize($setting->u_rootid); - foreach ($array as $gedcom => $value) { - $tree = Tree::findByName($gedcom); - if ($tree !== null) { - Database::prepare( - "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value) VALUES (?, ?, ?, ?)" - )->execute([$setting->user_id, $tree->getTreeId(), 'rootid', $value]); - } - } - } catch (Throwable $ex) { - DebugBar::addThrowable($ex); - - // Invalid serialized data? - } - - try { - $array = unserialize($setting->u_canedit); - foreach ($array as $gedcom => $value) { - $tree = Tree::findByName($gedcom); - if ($tree !== null) { - Database::prepare( - "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value) VALUES (?, ?, ?, ?)" - )->execute([$setting->user_id, $tree->getTreeId(), 'canedit', $value]); - } - } - } catch (Throwable $ex) { - DebugBar::addThrowable($ex); - - // Invalid serialized data? - } - } -} - -define('PGV_PHPGEDVIEW', true); -define('PGV_PRIV_PUBLIC', Auth::PRIV_PRIVATE); -define('PGV_PRIV_USER', Auth::PRIV_USER); -define('PGV_PRIV_NONE', Auth::PRIV_NONE); -define('PGV_PRIV_HIDE', Auth::PRIV_HIDE); -$PRIV_PUBLIC = Auth::PRIV_PRIVATE; -$PRIV_USER = Auth::PRIV_USER; -$PRIV_NONE = Auth::PRIV_NONE; -$PRIV_HIDE = Auth::PRIV_HIDE; - -// Old versions of PhpGedView used a $GEDCOMS[] array. -// New versions used a database. -$GEDCOMS = Database::prepare( - "SELECT" . - " gedcom_id AS id," . - " gedcom_name AS gedcom," . - " gs1.setting_value AS config," . - " gs2.setting_value AS privacy" . - " FROM `##gedcom`" . - " JOIN `##gedcom_setting` AS gs1 USING (gedcom_id)" . - " JOIN `##gedcom_setting` AS gs2 USING (gedcom_id)" . - " WHERE gedcom_id>0" . - " AND gs1.setting_name='config'" . - " AND gs2.setting_name='privacy'" -)->fetchAll(PDO::FETCH_ASSOC); - -foreach ($GEDCOMS as $GEDCOM => $GED_DATA) { - // We read these variables from PhpGedView's index/*_conf.php, and set them here in case any are missing. - $ADVANCED_NAME_FACTS = ''; - $ADVANCED_PLAC_FACTS = ''; - $ALLOW_THEME_DROPDOWN = ''; - $CALENDAR_FORMAT = ''; - $CHART_BOX_TAGS = ''; - $CONTACT_EMAIL = ''; - $DEFAULT_PEDIGREE_GENERATIONS = ''; - $EXPAND_NOTES = ''; - $EXPAND_RELATIVES_EVENTS = ''; - $EXPAND_SOURCES = ''; - $FAM_FACTS_ADD = ''; - $FAM_FACTS_QUICK = ''; - $FAM_FACTS_UNIQUE = ''; - $FULL_SOURCES = ''; - $GENERATE_UIDS = ''; - $HIDE_GEDCOM_ERRORS = ''; - $HIDE_LIVE_PEOPLE = ''; - $INDI_FACTS_ADD = ''; - $INDI_FACTS_QUICK = ''; - $INDI_FACTS_UNIQUE = ''; - $LANGUAGE = ''; - $MAX_ALIVE_AGE = ''; - $MAX_DESCENDANCY_GENERATIONS = ''; - $MAX_PEDIGREE_GENERATIONS = ''; - $MAX_RELATION_PATH_LENGTH = ''; - $META_DESCRIPTION = ''; - $META_TITLE = ''; - $MULTI_MEDIA = ''; - $NOTE_FACTS_ADD = ''; - $NOTE_FACTS_QUICK = ''; - $NOTE_FACTS_UNIQUE = ''; - $NO_UPDATE_CHAN = ''; - $PEDIGREE_LAYOUT = ''; - $PEDIGREE_ROOT_ID = ''; - $PEDIGREE_SHOW_GENDER = ''; - $PREFER_LEVEL2_SOURCES = ''; - $QUICK_REQUIRED_FACTS = ''; - $QUICK_REQUIRED_FAMFACTS = ''; - $REPO_FACTS_ADD = ''; - $REPO_FACTS_QUICK = ''; - $REPO_FACTS_UNIQUE = ''; - $REQUIRE_AUTHENTICATION = ''; - $SHOW_AGE_DIFF = ''; - $SHOW_COUNTER = ''; - $SHOW_DEAD_PEOPLE = ''; - $SHOW_EST_LIST_DATES = ''; - $SHOW_FACT_ICONS = ''; - $SHOW_GEDCOM_RECORD = ''; - $SHOW_HIGHLIGHT_IMAGES = ''; - $SHOW_LDS_AT_GLANCE = ''; - $SHOW_LEVEL2_NOTES = ''; - $SHOW_LIST_PLACES = ''; - $SHOW_LIVING_NAMES = ''; - $SHOW_MEDIA_DOWNLOAD = ''; - $SHOW_PARENTS_AGE = ''; - $SHOW_PEDIGREE_PLACES = ''; - $SHOW_PRIVATE_RELATIONSHIPS = ''; - $SHOW_RELATIVES_EVENTS = ''; - $SOUR_FACTS_ADD = ''; - $SOUR_FACTS_QUICK = ''; - $SOUR_FACTS_UNIQUE = ''; - $SUBLIST_TRIGGER_I = ''; - $SURNAME_LIST_STYLE = ''; - $SURNAME_TRADITION = ''; - $THEME_DIR = ''; - $USE_RELATIONSHIP_PRIVACY = ''; - $WEBMASTER_EMAIL = ''; - $WORD_WRAPPED_NOTES = ''; - - $config = str_replace(['$INDEX_DIRECTORY', '${INDEX_DIRECTORY}'], $INDEX_DIRECTORY, $GED_DATA['config']); - if (substr($config, 0, 1) === '.') { - $config = $PGV_PATH . '/' . $config; - } - if (is_readable($config)) { - echo '<p>Reading configuration file ', $config, '</p>'; - require $config; - } else { - echo '<p>Error - could not read configuration file ', $config, '</p>'; - } - - $stmt_default_resn = Database::prepare("INSERT INTO `##default_resn` (gedcom_id, xref, tag_type, resn) VALUES (?, ?, ?, CASE ? WHEN -1 THEN 'hidden' WHEN 0 THEN 'confidential' WHEN 1 THEN 'privacy' ELSE 'none' END)"); - $stmt_gedcom_setting = Database::prepare("INSERT INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value) VALUES (?,?,?)"); - - $privacy = str_replace(['$INDEX_DIRECTORY', '${INDEX_DIRECTORY}'], $INDEX_DIRECTORY, $GED_DATA['privacy']); - if (substr($config, 0, 1) == '.') { - $privacy = $PGV_PATH . '/' . $privacy; - } - if (is_readable($privacy)) { - // initialise this, in case it is missing from the file - $person_privacy = []; - $person_facts = []; - $global_facts = []; - - echo '<p>Reading privacy file ', $privacy, '</p>'; - require $privacy; - - foreach ($global_facts as $key => $value) { - if (isset($value['details'])) { - $stmt_default_resn->execute([$GED_DATA['id'], null, $key, $value['details']]); - } - } - - foreach ($person_privacy as $key => $value) { - $stmt_default_resn->execute([$GED_DATA['id'], $key, null, $value['details']]); - } - - foreach ($person_facts as $key1 => $array) { - foreach ($array as $key2 => $value) { - if (isset($value['details'])) { - $stmt_default_resn->execute([$GED_DATA['id'], $key1, $key2, $value['details']]); - } - } - } - } else { - echo '<p>Could not read privacy file ', $privacy, '</p>'; - } - - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'ADVANCED_NAME_FACTS', $ADVANCED_NAME_FACTS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'ADVANCED_PLAC_FACTS', $ADVANCED_PLAC_FACTS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'ALLOW_THEME_DROPDOWN', $ALLOW_THEME_DROPDOWN]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'CALENDAR_FORMAT', $CALENDAR_FORMAT]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'CHART_BOX_TAGS', $CHART_BOX_TAGS]); - $user = User::findByIdentifier($CONTACT_EMAIL); - if ($user) { - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'CONTACT_USER_ID', $user->getUserId()]); - } - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'DEFAULT_PEDIGREE_GENERATIONS', $DEFAULT_PEDIGREE_GENERATIONS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'EXPAND_NOTES', $EXPAND_NOTES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'EXPAND_SOURCES', $EXPAND_SOURCES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FAM_FACTS_ADD', $FAM_FACTS_ADD]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FAM_FACTS_QUICK', $FAM_FACTS_QUICK]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FAM_FACTS_UNIQUE', $FAM_FACTS_UNIQUE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FULL_SOURCES', $FULL_SOURCES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'GENERATE_UIDS', $GENERATE_UIDS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'HIDE_GEDCOM_ERRORS', $HIDE_GEDCOM_ERRORS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'HIDE_LIVE_PEOPLE', $HIDE_LIVE_PEOPLE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'INDI_FACTS_ADD', $INDI_FACTS_ADD]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'INDI_FACTS_QUICK', $INDI_FACTS_QUICK]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'INDI_FACTS_UNIQUE', $INDI_FACTS_UNIQUE]); - switch ($LANGUAGE) { - case 'catalan': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'ca']); - break; - case 'english-uk': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'en-GB']); - break; - case 'polish': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'pl']); - break; - case 'italian': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'it']); - break; - case 'spanish': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'es']); - break; - case 'finnish': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'fi']); - break; - case 'french': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'fr']); - break; - case 'german': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'de']); - break; - case 'danish': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'da']); - break; - case 'portuguese': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'pt']); - break; - case 'hebrew': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'he']); - break; - case 'estonian': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'et']); - break; - case 'turkish': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'tr']); - break; - case 'dutch': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'nl']); - break; - case 'slovak': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'sk']); - break; - case 'norwegian': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'nn']); - break; - case 'slovenian': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'sl']); - break; - case 'hungarian': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'hu']); - break; - case 'swedish': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'sv']); - break; - case 'russian': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'ru']); - break; - default: - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'en-US']); - break; - } - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_ALIVE_AGE', $MAX_ALIVE_AGE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_DESCENDANCY_GENERATIONS', $MAX_DESCENDANCY_GENERATIONS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_PEDIGREE_GENERATIONS', $MAX_PEDIGREE_GENERATIONS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_RELATION_PATH_LENGTH', $MAX_RELATION_PATH_LENGTH]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MEDIA_DIRECTORY', 'media/']); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'META_DESCRIPTION', $META_DESCRIPTION]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'META_TITLE', $META_TITLE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MEDIA_UPLOAD', $MULTI_MEDIA]); // see schema v12-13 - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NOTE_FACTS_ADD', $NOTE_FACTS_ADD]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NOTE_FACTS_QUICK', $NOTE_FACTS_QUICK]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NOTE_FACTS_UNIQUE', $NOTE_FACTS_UNIQUE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NO_UPDATE_CHAN', $NO_UPDATE_CHAN]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PEDIGREE_LAYOUT', $PEDIGREE_LAYOUT]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PEDIGREE_ROOT_ID', $PEDIGREE_ROOT_ID]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PEDIGREE_SHOW_GENDER', $PEDIGREE_SHOW_GENDER]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PREFER_LEVEL2_SOURCES', $PREFER_LEVEL2_SOURCES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'QUICK_REQUIRED_FACTS', $QUICK_REQUIRED_FACTS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'QUICK_REQUIRED_FAMFACTS', $QUICK_REQUIRED_FAMFACTS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REPO_FACTS_ADD', $REPO_FACTS_ADD]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REPO_FACTS_QUICK', $REPO_FACTS_QUICK]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REPO_FACTS_UNIQUE', $REPO_FACTS_UNIQUE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REQUIRE_AUTHENTICATION', $REQUIRE_AUTHENTICATION]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_COUNTER', $SHOW_COUNTER]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_DEAD_PEOPLE', $SHOW_DEAD_PEOPLE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_EST_LIST_DATES', $SHOW_EST_LIST_DATES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_FACT_ICONS', $SHOW_FACT_ICONS]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_GEDCOM_RECORD', $SHOW_GEDCOM_RECORD]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_HIGHLIGHT_IMAGES', $SHOW_HIGHLIGHT_IMAGES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_LDS_AT_GLANCE', $SHOW_LDS_AT_GLANCE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_LIST_PLACES', $SHOW_LIST_PLACES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_LIVING_NAMES', $SHOW_LIVING_NAMES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_MEDIA_DOWNLOAD', $SHOW_MEDIA_DOWNLOAD]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_PARENTS_AGE', $SHOW_PARENTS_AGE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_PEDIGREE_PLACES', $SHOW_PEDIGREE_PLACES]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_PRIVATE_RELATIONSHIPS', $SHOW_PRIVATE_RELATIONSHIPS]); - - // Update these - see db_schema_5_6.php - $SHOW_RELATIVES_EVENTS = preg_replace('/_(BIRT|MARR|DEAT)_(COUS|MSIB|FSIB|GGCH|NEPH|GGPA)/', '', $SHOW_RELATIVES_EVENTS); - $SHOW_RELATIVES_EVENTS = preg_replace('/_FAMC_(RESI_EMIG)/', '', $SHOW_RELATIVES_EVENTS); - $SHOW_RELATIVES_EVENTS = preg_replace('/_MARR_(MOTH|FATH|FAMC)/', '_MARR_PARE', $SHOW_RELATIVES_EVENTS); - $SHOW_RELATIVES_EVENTS = preg_replace('/_DEAT_(MOTH|FATH)/', '_DEAT_PARE', $SHOW_RELATIVES_EVENTS); - preg_match_all('/[_A-Z]+/', $SHOW_RELATIVES_EVENTS, $match); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_RELATIVES_EVENTS', implode(',', array_unique($match[0]))]); - - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SOUR_FACTS_ADD', $SOUR_FACTS_ADD]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SOUR_FACTS_QUICK', $SOUR_FACTS_QUICK]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SOUR_FACTS_UNIQUE', $SOUR_FACTS_UNIQUE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SUBLIST_TRIGGER_I', $SUBLIST_TRIGGER_I]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SURNAME_LIST_STYLE', $SURNAME_LIST_STYLE]); - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SURNAME_TRADITION', $SURNAME_TRADITION]); - switch ($THEME_DIR) { - case '': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', '']); - break; - case 'themes/cloudy/': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'clouds']); - break; - case 'themes/minimal/': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'minimal']); - break; - case 'themes/simplyblue/': - case 'themes/simplygreen/': - case 'themes/simplyred/': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'colors']); - break; - case 'themes/xenea/': - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'xenea']); - break; - default: - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'webtrees']); - break; - } - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'USE_RELATIONSHIP_PRIVACY', $USE_RELATIONSHIP_PRIVACY]); - $user = User::findByIdentifier($WEBMASTER_EMAIL); - if ($user) { - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'WEBMASTER_USER_ID', $user->getUserId()]); - } - $stmt_gedcom_setting->execute([$GED_DATA['id'], 'WORD_WRAPPED_NOTES', $WORD_WRAPPED_NOTES]); -} -Database::prepare("DELETE FROM `##gedcom_setting` WHERE setting_name IN ('config', 'privacy', 'path', 'pgv_ver', 'imported')")->execute(); - -// webtrees 1.0.5 combines user and gedcom settings for relationship privacy -// into a combined user-gedcom setting, for more granular control -Database::exec( - "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value)" . - " SELECT u.user_id, g.gedcom_id, 'RELATIONSHIP_PATH_LENGTH', LEAST(us1.setting_value, gs1.setting_value)" . - " FROM `##user` u" . - " CROSS JOIN `##gedcom` g" . - " LEFT JOIN `##user_setting` us1 ON (u.user_id =us1.user_id AND us1.setting_name='max_relation_path')" . - " LEFT JOIN `##user_setting` us2 ON (u.user_id =us2.user_id AND us2.setting_name='relationship_privacy')" . - " LEFT JOIN `##gedcom_setting` gs1 ON (g.gedcom_id=gs1.gedcom_id AND gs1.setting_name='MAX_RELATION_PATH_LENGTH')" . - " LEFT JOIN `##gedcom_setting` gs2 ON (g.gedcom_id=gs2.gedcom_id AND gs2.setting_name='USE_RELATIONSHIP_PRIVACY')" . - " WHERE us2.setting_value AND gs2.setting_value" -); - -Database::exec( - "DELETE FROM `##gedcom_setting` WHERE setting_name IN ('MAX_RELATION_PATH_LENGTH', 'USE_RELATIONSHIP_PRIVACY')" -); - -Database::exec( - "DELETE FROM `##user_setting` WHERE setting_name IN ('relationship_privacy', 'max_relation_path_length')" -); - -//////////////////////////////////////////////////////////////////////////////// -// The PhpGedView blocks don't migrate easily. -// Just give everybody and every tree default blocks -//////////////////////////////////////////////////////////////////////////////// - -Database::prepare( - "INSERT INTO `##block` (user_id, location, block_order, module_name)" . - " SELECT `##user`.user_id, location, block_order, module_name" . - " FROM `##block`" . - " JOIN `##user`" . - " WHERE `##block`.user_id = -1" . - " AND `##user`.user_id > 0" -)->execute(); - -Database::prepare( - "INSERT INTO `##block` (gedcom_id, location, block_order, module_name)" . - " SELECT `##gedcom`.gedcom_id, location, block_order, module_name" . - " FROM `##block`" . - " JOIN `##gedcom`" . - " WHERE `##block`.gedcom_id = -1" . - " AND `##gedcom`.gedcom_id > 0" -)->execute(); - -//////////////////////////////////////////////////////////////////////////////// -// Hit counter -//////////////////////////////////////////////////////////////////////////////// -// -if ($PGV_SCHEMA_VERSION >= 13) { - echo '<p>pgv_hit_counter => wt_hit_counter…</p>'; - - Database::prepare( - "REPLACE INTO `##hit_counter` (gedcom_id, page_name, page_parameter, page_count)" . - " SELECT gedcom_id, page_name, page_parameter, page_count FROM `{$DBNAME}`.`{$TBLPREFIX}hit_counter`" - )->execute(); -} else { - // Copied from PhpGedView's db_schema_12_13 - $statement = Database::prepare("INSERT IGNORE INTO `##hit_counter` (gedcom_id, page_name, page_parameter, page_count) VALUES (?, ?, ?, ?)"); - - foreach ($GEDCOMS as $GEDCOM => $GED_DATA) { - $file = $INDEX_DIRECTORY . '/' . $GED_DATA['gedcom'] . 'pgv_counters.txt'; - echo '<p>', $file, ' => wt_hit_counter…</p>'; - - if (file_exists($file)) { - foreach (file($file) as $line) { - if (preg_match('/(@([A-Za-z0-9:_-]+)@ )?(\d+)/', $line, $match)) { - if ($match[2]) { - $page_name = 'individual.php'; - $page_parameter = $match[2]; - } else { - $page_name = 'index.php'; - $page_parameter = 'gedcom:' . $GED_DATA['id']; - } - try { - $statement->execute([$GED_DATA['id'], $page_name, $page_parameter, $match[3]]); - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // Primary key violation? Ignore? - } - } - } - } - } -} - -//////////////////////////////////////////////////////////////////////////////// - -foreach ($GEDCOMS as $GED_DATA) { - Module::setDefaultAccess($GED_DATA['id']); -} - -echo '<p>pgv_site_setting => wt_module_setting…</p>'; - -Database::prepare( - "REPLACE INTO `##module_setting` (module_name, setting_name, setting_value)" . - " SELECT 'googlemap', site_setting_name, site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting`" . - " WHERE site_setting_name LIKE 'GM_%'" -)->execute(); -Database::prepare( - "REPLACE INTO `##module_setting` (module_name, setting_name, setting_value)" . - " SELECT 'lightbox', site_setting_name, site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting`" . - " WHERE site_setting_name LIKE 'LB_%'" -)->execute(); - -//////////////////////////////////////////////////////////////////////////////// - -echo '<p>pgv_favorites => wt_favorite…</p>'; - -try { - Database::prepare( - "REPLACE INTO `##favorite` (favorite_id, user_id, gedcom_id, xref, favorite_type, url, title, note)" . - " SELECT fv_id, u.user_id, g.gedcom_id, fv_gid, fv_type, fv_url, fv_title, fv_note" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}favorites` f" . - " LEFT JOIN `##gedcom` g ON (f.fv_username=g.gedcom_name)" . - " LEFT JOIN `##user` u ON (f.fv_username=u.user_name)" - )->execute(); -} catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // This table will only exist if the favorites module is installed in WT -} - -//////////////////////////////////////////////////////////////////////////////// - -echo '<p>pgv_news => wt_news…</p>'; - -try { - Database::prepare( - "REPLACE INTO `##news` (news_id, user_id, gedcom_id, subject, body, updated)" . - " SELECT n_id, u.user_id, g.gedcom_id, n_title, n_text, FROM_UNIXTIME(n_date)" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}news` n" . - " LEFT JOIN `##gedcom` g ON (n.n_username=g.gedcom_name)" . - " LEFT JOIN `##user` u ON (n.n_username=u.user_name)" - )->execute(); -} catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // This table will only exist if the news/blog module is installed in WT -} - -//////////////////////////////////////////////////////////////////////////////// - -echo '<p>pgv_messages => wt_message…</p>'; - -Database::prepare( - "REPLACE INTO `##message` (message_id, sender, ip_address, user_id, subject, body, created)" . - " SELECT m_id, m_from, '127.0.0.1', user_id, m_subject, m_body, STR_TO_DATE(LEFT(m_created,25),'%a, %d %M %Y %H:%i:%s')" . - " FROM `{$DBNAME}`.`{$TBLPREFIX}messages`" . - " JOIN `##user` ON (CONVERT(m_to USING utf8) COLLATE utf8_unicode_ci=user_name)" -)->execute(); - -//////////////////////////////////////////////////////////////////////////////// - -try { - echo '<p>pgv_placelocation => wt_placelocation…</p>'; - - Database::prepare( - "REPLACE INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon)" . - " SELECT pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon FROM `{$DBNAME}`.`{$TBLPREFIX}placelocation`" - )->execute(); -} catch (PDOException $ex) { - DebugBar::addThrowable($ex); - - // This table will only exist if the gm module is installed in PhpGedView/WT -} - -//////////////////////////////////////////////////////////////////////////////// - -echo '<p>Genealogy records…</p>'; - -Database::prepare( - "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . - " SELECT o_file, o_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}other`" . - " JOIN `##gedcom` ON (o_file = gedcom_id)" . - " ORDER BY o_type!='HEAD'" // Must load HEAD record first -)->execute(); - -Database::prepare( - "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . - " SELECT i_file, i_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}individuals`" . - " JOIN `##gedcom` ON (i_file = gedcom_id)" -)->execute(); - -Database::prepare( - "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . - " SELECT f_file, f_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}families`" . - " JOIN `##gedcom` ON (f_file = gedcom_id)" -)->execute(); - -Database::prepare( - "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . - " SELECT s_file, s_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}sources`" . - " JOIN `##gedcom` ON (s_file = gedcom_id)" -)->execute(); - -Database::prepare( - "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . - " SELECT m_gedfile, m_gedrec, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}media`" . - " JOIN `##gedcom` ON (m_gedfile = gedcom_id)" -)->execute(); - -Database::prepare( - "UPDATE `##gedcom_setting` SET setting_value='0' WHERE setting_name='imported'" -)->execute(); - -//////////////////////////////////////////////////////////////////////////////// - -Database::commit(); - -echo '<hr>'; -echo '<p>', I18N::translate('You need to sign in again, using your PhpGedView username and password.'), '</p>'; -echo '<a href="index.php"><button class="btn btn-primary">', I18N::translate('continue'), '</button></a>'; diff --git a/app/Http/Controllers/AdminController.php b/app/Http/Controllers/AdminController.php index 8bf74d9715..dea45b6f00 100644 --- a/app/Http/Controllers/AdminController.php +++ b/app/Http/Controllers/AdminController.php @@ -463,6 +463,7 @@ class AdminController extends AbstractBaseController { WT_ROOT . 'admin_module_sidebar.php', WT_ROOT . 'admin_module_tabs.php', WT_ROOT . 'admin_modules.php', + WT_ROOT . 'admin_pgv_to_wt.php', WT_ROOT . 'admin_site_access.php', WT_ROOT . 'admin_site_clean.php', WT_ROOT . 'admin_site_info.php', diff --git a/app/Http/Controllers/AdminPhpGedViewController.php b/app/Http/Controllers/AdminPhpGedViewController.php new file mode 100644 index 0000000000..3627c7527f --- /dev/null +++ b/app/Http/Controllers/AdminPhpGedViewController.php @@ -0,0 +1,1199 @@ +<?php +/** + * webtrees: online genealogy + * Copyright (C) 2018 webtrees development team + * 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 3 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. + * You should have received a copy of the GNU General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + */ +declare(strict_types=1); + +namespace Fisharebest\Webtrees\Http\Controllers; + +use Exception; +use Fisharebest\Webtrees\Auth; +use Fisharebest\Webtrees\Database; +use Fisharebest\Webtrees\DebugBar; +use Fisharebest\Webtrees\I18N; +use Fisharebest\Webtrees\Module; +use Fisharebest\Webtrees\Site; +use Fisharebest\Webtrees\Tree; +use Fisharebest\Webtrees\User; +use PDO; +use PDOException; +use Symfony\Component\HttpFoundation\Request; +use Symfony\Component\HttpFoundation\Response; +use Symfony\Component\HttpKernel\Exception\NotFoundHttpException; +use Throwable; + +/** + * Controller for importing from PhpGedView. + * + * This process needs to be as tolerant as possible of invalid or missing data, + * to allow a PGV user to recover their genealogy data. + */ +class AdminPhpGedViewController extends AbstractBaseController { + // Icons for success and failure + const SUCCESS = '<i class="fas fa-check" style="color:green"></i>'; + const FAILURE = '<i class="fas fa-times" style="color:red"></i>'; + + protected $layout = 'layouts/administration'; + + /** + * @param Request $request + * + * @return Response + */ + public function wizard(Request $request): Response { + $pgv_path = $request->get('pgv_path', ''); + + $title = I18N::translate('PhpGedView to webtrees transfer wizard'); + + if (file_exists($pgv_path . 'config.php')) { + return $this->viewResponse('admin/phpgedview/steps', [ + 'steps' => $this->wizardSteps($pgv_path), + 'title' => $title, + ]); + } else { + return $this->viewResponse('admin/phpgedview/wizard', [ + 'pgv_paths' => $this->defaultPhpGedViewPaths(), + 'title' => $title, + ]); + } + } + + /** + * Perform one step of the wizard + * + * @param Request $request + * + * @return Response + */ + public function step(Request $request): Response { + $step = $request->get('step'); + $pgv_path = $request->get('pgv_path'); + + $config = $this->readPhpGedViewConfig($pgv_path); + + switch ($step) { + case 'Check': + return $this->wizardStepCheck($config); + case 'Delete': + return $this->wizardStepDelete(); + case 'GeoData': + return $this->wizardStepGeographicData($config); + case 'Site': + return $this->wizardStepSitePreferences($config); + case 'Trees': + return $this->wizardStepTrees($config); + case 'Users': + return $this->wizardStepUsers($config); + default: + throw new NotFoundHttpException; + } + } + + /** + * @param string $pgv_path + * + * @return string[] + */ + private function wizardSteps(string $pgv_path): array { + return [ + route('phpgedview-wizard', ['pgv_path' => $pgv_path, 'step' => 'Check']) => 'config.php', + route('phpgedview-wizard', ['pgv_path' => $pgv_path, 'step' => 'Delete']) => I18N::translate('Delete'), + route('phpgedview-wizard', ['pgv_path' => $pgv_path, 'step' => 'GeoData']) => I18N::translate('Geographic data'), + route('phpgedview-wizard', ['pgv_path' => $pgv_path, 'step' => 'Site']) => I18N::translate('Site preferences'), + route('phpgedview-wizard', ['pgv_path' => $pgv_path, 'step' => 'Trees']) => I18N::translate('Family trees'), + route('phpgedview-wizard', ['pgv_path' => $pgv_path, 'step' => 'Users']) => I18N::translate('Users'), + ]; + } + + /** + * @param mixed[] $config + * + * @return Response + */ + private function wizardStepCheck(array $config): Response { + $pgv_path = $config['pgv_path']; + + if (!is_dir($pgv_path) || !is_readable($pgv_path . '/config.php')) { + return new Response(I18N::translate('The specified folder does not contain an installation of PhpGedView.'), Response::HTTP_INTERNAL_SERVER_ERROR); + } + + $INDEX_DIRECTORY = $config['INDEX_DIRECTORY']; + + if (!is_dir($INDEX_DIRECTORY)) { + return new Response(I18N::translate('%1$s does not exist', e($INDEX_DIRECTORY)), Response::HTTP_INTERNAL_SERVER_ERROR); + } + + $DBHOST = $config['DBHOST'] ?? ''; + $DBNAME = $config['DBNAME'] ?? ''; + $TBLPREFIX = $config['TBLPREFIX'] ?? ''; + + // Read the webtrees DB config + $wt_config = parse_ini_file(WT_ROOT . 'data/config.ini.php'); + + if ($DBHOST != $wt_config['dbhost']) { + return new Response(I18N::translate('PhpGedView must use the same database as webtrees.'), Response::HTTP_INTERNAL_SERVER_ERROR); + } + + try { + $PGV_SCHEMA_VERSION = Database::prepare( + "SELECT site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting` WHERE site_setting_name='PGV_SCHEMA_VERSION'" + )->fetchOne(); + if ($PGV_SCHEMA_VERSION < 10) { + return new Response(I18N::translate('The version of %s is too old.', 'PhpGedView'), Response::HTTP_INTERNAL_SERVER_ERROR); + } elseif ($PGV_SCHEMA_VERSION > 14) { + return new Response(I18N::translate('The version of %s is too new.', 'PhpGedView'), Response::HTTP_INTERNAL_SERVER_ERROR); + } + } catch (Exception $ex) { + DebugBar::addThrowable($ex); + + $content = I18N::translate('webtrees cannot connect to the PhpGedView database: %s.', $DBNAME . '@' . $DBHOST) . + '<br>' . + I18N::translate('MySQL gave the error: %s', $ex->getMessage()); + + return new Response($content, Response::HTTP_INTERNAL_SERVER_ERROR); + } + + return new Response(self::SUCCESS); + } + + /** + * @return Response + */ + private function wizardStepDelete(): Response { + Database::exec("DELETE FROM `##block_setting`"); + Database::exec("DELETE FROM `##block` WHERE user_id > 0 OR gedcom_id > 0"); + Database::exec("DELETE FROM `##change`"); + Database::exec("DELETE FROM `##message`"); + Database::exec("DELETE FROM `##user_gedcom_setting` WHERE user_id > 0"); + + return new Response(self::SUCCESS); + } + + /** + * Copy the geographic data from the maps module (if it is installed). + * + * @param mixed[] $config + * + * @return Response + */ + private function wizardStepGeographicData(array $config): Response { + $DBNAME = $config['DBNAME']; + $TBLPREFIX = $config['TBLPREFIX']; + + try { + Database::prepare( + "REPLACE INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon)" . + " SELECT pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon FROM `{$DBNAME}`.`{$TBLPREFIX}placelocation`" + )->execute(); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // This table will only exist if the gm module is installed in PhpGedView/WT + } + + return new Response(self::SUCCESS); + } + + /** + * @param mixed[] $config + * + * @return Response + */ + private function wizardStepSitePreferences(array $config): Response { + Site::setPreference('USE_REGISTRATION_MODULE', $config['USE_REGISTRATION_MODULE'] ?? ''); + Site::setPreference('ALLOW_USER_THEMES', $config['ALLOW_USER_THEMES'] ?? ''); + Site::setPreference('ALLOW_CHANGE_GEDCOM', $config['ALLOW_CHANGE_GEDCOM'] ?? ''); + Site::setPreference('SESSION_TIME', $config['PGV_SESSION_TIME'] ?? ''); + Site::setPreference('SMTP_ACTIVE', ($config['PGV_SMTP_ACTIVE'] ?? '') ? 'external' : 'internal'); + Site::setPreference('SMTP_HOST', $config['PGV_SMTP_HOST'] ?? ''); + Site::setPreference('SMTP_HELO', $config['PGV_SMTP_HELO'] ?? ''); + Site::setPreference('SMTP_PORT', $config['PGV_SMTP_PORT'] ?? ''); + Site::setPreference('SMTP_AUTH', $config['PGV_SMTP_AUTH'] ?? ''); + Site::setPreference('SMTP_AUTH_USER', $config['PGV_SMTP_AUTH_USER'] ?? ''); + Site::setPreference('SMTP_AUTH_PASS', $config['PGV_SMTP_AUTH_PASS'] ?? ''); + Site::setPreference('SMTP_SSL', $config['PGV_SMTP_SSL'] ?? ''); + Site::setPreference('SMTP_FROM_NAME', $config['PGV_SMTP_FROM_NAME'] ?? ''); + + $DBNAME = $config['DBNAME']; + $TBLPREFIX = $config['TBLPREFIX']; + + Database::prepare( + "REPLACE INTO `##site_setting` (setting_name, setting_value)" . + " SELECT site_setting_name, site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting`" . + " WHERE site_setting_name IN ('DEFAULT_GEDCOM', 'LAST_CHANGE_EMAIL')" + )->execute(); + + return new Response(self::SUCCESS); + } + + /** + * + * @TODO Most of the migration happens in the "Users" step. This needs to + * be broken down into smaller functions. + * + * @param mixed[] $config + * + * @return Response + */ + private function wizardStepTrees(array $config): Response { + return new Response(self::SUCCESS); + } + + /** + * @param mixed[] $config + * + * @return Response + */ + private function wizardStepUsers(array $config): Response { + $pgv_path = $config['pgv_path']; + + $INDEX_DIRECTORY = $config['INDEX_DIRECTORY']; + $DBNAME = $config['DBNAME']; + $TBLPREFIX = $config['TBLPREFIX']; + $PGV_SCHEMA_VERSION = (int) ($config['PGV_SCHEMA_VERSION'] ?? '0'); + + // Delete the existing user accounts, and any information associated with it + Database::exec("UPDATE `##log` SET user_id=NULL"); + Database::exec("DELETE FROM `##user_setting` WHERE user_id > 0"); + Database::exec("DELETE FROM `##user` WHERE user_id > 0"); + + + //////////////////////////////////////////////////////////////////////////////// + + if ($PGV_SCHEMA_VERSION >= 12) { + // pgv_gedcom => wt_gedcom… + + Database::prepare( + "INSERT INTO `##gedcom` (gedcom_id, gedcom_name)" . + " SELECT gedcom_id, gedcom_name FROM `{$DBNAME}`.`{$TBLPREFIX}gedcom`" + )->execute(); + + // pgv_gedcom_setting => wt_gedcom_setting… + + Database::prepare( + "INSERT INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value)" . + " SELECT gedcom_id, setting_name," . + " CASE setting_name" . + " WHEN 'THEME_DIR' THEN" . + " CASE setting_value" . + " WHEN '' THEN ''" . + " WHEN 'themes/cloudy/' THEN 'clouds'" . + " WHEN 'themes/minimal/' THEN 'minimal'" . + " WHEN 'themes/simplyblue/' THEN 'colors'" . + " WHEN 'themes/simplygreen/' THEN 'colors'" . + " WHEN 'themes/simplyred/' THEN 'colors'" . + " WHEN 'themes/xenea/' THEN 'xenea'" . + " ELSE 'themes/webtrees/'" . // ocean, simplyred/blue/green, standard, wood + " END" . + " WHEN 'LANGUAGE' THEN" . + " CASE setting_value" . + " WHEN 'arabic' THEN 'ar'" . + " WHEN 'catalan' THEN 'ca'" . + " WHEN 'chinese' THEN 'zh_CN'" . + " WHEN 'croatian' THEN 'hr'" . + " WHEN 'danish' THEN 'da'" . + " WHEN 'dutch' THEN 'nl'" . + " WHEN 'english' THEN 'en_US'" . + " WHEN 'english-uk' THEN 'en_GB'" . // PhpGedView once had the config for this, but no language files + " WHEN 'estonian' THEN 'et'" . + " WHEN 'finnish' THEN 'fi'" . + " WHEN 'french' THEN 'fr'" . + " WHEN 'german' THEN 'de'" . + " WHEN 'greek' THEN 'el'" . + " WHEN 'hebrew' THEN 'he'" . + " WHEN 'hungarian' THEN 'hu'" . + " WHEN 'indonesian' THEN 'id'" . + " WHEN 'italian' THEN 'it'" . + " WHEN 'lithuanian' THEN 'lt'" . + " WHEN 'norwegian' THEN 'nn'" . + " WHEN 'polish' THEN 'pl'" . + " WHEN 'portuguese' THEN 'pt'" . + " WHEN 'romainian' THEN 'ro'" . + " WHEN 'russian' THEN 'ru'" . + " WHEN 'serbian-la' THEN 'sr@Latn'" . + " WHEN 'slovak' THEN 'sk'" . + " WHEN 'slovenian' THEN 'sl'" . + " WHEN 'spanish' THEN 'es'" . + " WHEN 'spanish-ar' THEN 'es'" . // webtrees does not yet have this variant + " WHEN 'swedish' THEN 'sv'" . + " WHEN 'turkish' THEN 'tr'" . + " WHEN 'vietnamese' THEN 'vi'" . + " ELSE 'en_US'" . + " END" . + " ELSE setting_value" . + " END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}gedcom_setting`" . + " WHERE setting_name NOT IN ('HOME_SITE_TEXT', 'HOME_SITE_URL')" + )->execute(); + + // pgv_user => wt_user… + + try { + // "INSERT IGNORE" is needed to allow for PhpGedView users with duplicate emails. Only the first will be imported. + Database::prepare( + "INSERT IGNORE INTO `##user` (user_id, user_name, real_name, email, password)" . + " SELECT user_id, user_name, CONCAT_WS(' ', us1.setting_value, us2.setting_value), us3.setting_value, password FROM `{$DBNAME}`.`{$TBLPREFIX}user`" . + " LEFT JOIN `{$DBNAME}`.`{$TBLPREFIX}user_setting` us1 USING (user_id)" . + " LEFT JOIN `{$DBNAME}`.`{$TBLPREFIX}user_setting` us2 USING (user_id)" . + " JOIN `{$DBNAME}`.`{$TBLPREFIX}user_setting` us3 USING (user_id)" . + " WHERE us1.setting_name='firstname'" . + " AND us2.setting_name='lastname'" . + " AND us3.setting_name='email'" + )->execute(); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // Ignore duplicates + } + + // pgv_user_setting => wt_user_setting… + + Database::prepare( + "INSERT INTO `##user_setting` (user_id, setting_name, setting_value)" . + " SELECT user_id, setting_name," . + " CASE setting_name" . + " WHEN 'language' THEN " . + " CASE setting_value" . + " WHEN 'arabic' THEN 'ar'" . + " WHEN 'catalan' THEN 'ca'" . + " WHEN 'chinese' THEN 'zh_CN'" . + " WHEN 'croatian' THEN 'hr'" . + " WHEN 'danish' THEN 'da'" . + " WHEN 'dutch' THEN 'nl'" . + " WHEN 'english' THEN 'en_US'" . + " WHEN 'english-uk' THEN 'en_GB'" . // PhpGedView once had the config for this, but no language files + " WHEN 'estonian' THEN 'et'" . + " WHEN 'finnish' THEN 'fi'" . + " WHEN 'french' THEN 'fr'" . + " WHEN 'german' THEN 'de'" . + " WHEN 'greek' THEN 'el'" . + " WHEN 'hebrew' THEN 'he'" . + " WHEN 'hungarian' THEN 'hu'" . + " WHEN 'indonesian' THEN 'id'" . + " WHEN 'italian' THEN 'it'" . + " WHEN 'lithuanian' THEN 'lt'" . + " WHEN 'norwegian' THEN 'nn'" . + " WHEN 'polish' THEN 'pl'" . + " WHEN 'portuguese' THEN 'pt'" . + " WHEN 'romainian' THEN 'ro'" . + " WHEN 'russian' THEN 'ru'" . + " WHEN 'serbian-la' THEN 'sr@Latn'" . + " WHEN 'slovak' THEN 'sk'" . + " WHEN 'slovenian' THEN 'sl'" . + " WHEN 'spanish' THEN 'es'" . + " WHEN 'spanish-ar' THEN 'es'" . // webtrees does not yet have this variant + " WHEN 'swedish' THEN 'sv'" . + " WHEN 'turkish' THEN 'tr'" . + " WHEN 'vietnamese' THEN 'vi'" . + " ELSE 'en_US'" . + " END" . + " WHEN 'theme' THEN" . + " CASE setting_value" . + " WHEN '' THEN ''" . + " WHEN 'themes/cloudy/' THEN 'clouds'" . + " WHEN 'themes/minimal/' THEN 'minimal'" . + " WHEN 'themes/simplyblue/' THEN 'colors'" . + " WHEN 'themes/simplygreen/' THEN 'colors'" . + " WHEN 'themes/simplyred/' THEN 'colors'" . + " WHEN 'themes/xenea/' THEN 'xenea'" . + " ELSE 'themes/webtrees/'" . // ocean, simplyred/blue/green, standard, wood + " END" . + " ELSE" . + " CASE" . + " WHEN setting_value IN ('Y', 'yes') THEN 1 WHEN setting_value IN ('N', 'no') THEN 0 ELSE setting_value END" . + " END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}user_setting`" . + " JOIN `##user` USING (user_id)" . + " WHERE setting_name NOT IN ('email', 'firstname', 'lastname', 'loggedin')" + )->execute(); + + // pgv_user_gedcom_setting => wt_user_gedcom_setting… + + Database::prepare( + "INSERT INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value)" . + " SELECT user_id, gedcom_id, setting_name, setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}user_gedcom_setting`" . + " JOIN `##user` USING (user_id)" + )->execute(); + } else { + // Copied from PhpGedView's db_schema_11_12 + if (file_exists($INDEX_DIRECTORY . 'gedcoms.php')) { + require_once $INDEX_DIRECTORY . 'gedcoms.php'; + // gedcoms.php => wt_gedcom… + + if (isset($GEDCOMS) && is_array($GEDCOMS)) { + foreach ($GEDCOMS as $array) { + try { + Database::prepare("INSERT INTO `##gedcom` (gedcom_id, gedcom_name) VALUES (?,?)") + ->execute([$array['id'], $array['gedcom']]); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // Ignore duplicates + } + // insert gedcom + foreach ($array as $key => $value) { + if ($key != 'id' && $key != 'gedcom' && $key != 'commonsurnames') { + try { + Database::prepare("INSERT INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value) VALUES (?,?, ?)") + ->execute([$array['id'], $key, $value]); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // Ignore duplicates + } + } + } + } + } + } + + // Migrate the data from pgv_users into pgv_user/pgv_user_setting/pgv_user_gedcom_setting + // pgv_users => wt_user… + + try { + // "INSERT IGNORE" is needed to allow for PhpGedView users with duplicate emails. Only the first will be imported. + Database::prepare( + "INSERT IGNORE INTO `##user` (user_name, real_name, email, password)" . + " SELECT u_username, CONCAT_WS(' ', u_firstname, u_lastname), u_email, u_password FROM `{$DBNAME}`.`{$TBLPREFIX}users`" + )->execute(); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // This could only fail if; + // a) we've already done it (upgrade) + // b) it doesn't exist (new install) + } + + // pgv_users => wt_user_setting… + + try { + Database::prepare( + "INSERT INTO `##user_setting` (user_id, setting_name, setting_value)" . + " SELECT user_id, 'canadmin', CASE WHEN u_canadmin IN ('Y', 'yes') THEN 1 ELSE 0 END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'verified', CASE WHEN u_verified IN ('Y', 'yes') THEN 1 ELSE 0 END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'verified_by_admin', CASE WHEN u_verified_by_admin IN ('Y', 'yes') THEN 1 ELSE 0 END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'language', CASE u_language" . + " WHEN 'catalan' THEN 'ca'" . + " WHEN 'danish' THEN 'da'" . + " WHEN 'dutch' THEN 'nl'" . + " WHEN 'english' THEN 'en-US'" . + " WHEN 'english-uk' THEN 'en-GB'" . + " WHEN 'estonian' THEN 'et'" . + " WHEN 'finnish' THEN 'fi'" . + " WHEN 'french' THEN 'fr'" . + " WHEN 'german' THEN 'de'" . + " WHEN 'hebrew' THEN 'he'" . + " WHEN 'hungarian' THEN 'hu'" . + " WHEN 'italian' THEN 'it'" . + " WHEN 'norwegian' THEN 'nn'" . + " WHEN 'polish' THEN 'pl'" . + " WHEN 'portuguese' THEN 'pt'" . + " WHEN 'russian' THEN 'ru'" . + " WHEN 'slovak' THEN 'sk'" . + " WHEN 'slovenian' THEN 'sl'" . + " WHEN 'spanish' THEN 'es'" . + " WHEN 'swedish' THEN 'sv'" . + " WHEN 'turkish' THEN 'tr'" . + " ELSE 'en-US'" . // PhpGedView supports other languages that webtrees does not (yet) + " END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'reg_timestamp', IFNULL(u_reg_timestamp, '')" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'reg_hashcode', IFNULL(u_reg_hashcode, '')" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'theme', CASE u_theme" . + " WHEN 'themes/cloudy/' THEN 'clouds'" . + " WHEN 'themes/minimal/' THEN 'minimal'" . + " WHEN 'themes/simplyblue/' THEN 'colors'" . + " WHEN 'themes/simplygreen/' THEN 'colors'" . + " WHEN 'themes/simplyred/' THEN 'colors'" . + " WHEN 'themes/xenea/' THEN 'xenea'" . + " ELSE ''" . + " END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'sessiontime', IFNULL(u_sessiontime, '')" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'contactmethod', IFNULL(u_contactmethod, '')" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'visibleonline', CASE WHEN u_visibleonline IN ('Y', 'yes') THEN 1 ELSE 0 END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'comment', IFNULL(u_comment, '')" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'relationship_privacy', CASE WHEN u_relationship_privacy IN ('Y', 'yes') THEN 1 ELSE 0 END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'max_relation_path', IFNULL(u_max_relation_path, '')" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" . + " UNION ALL" . + " SELECT user_id, 'auto_accept', CASE WHEN u_auto_accept IN ('Y', 'yes') THEN 1 ELSE 0 END" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" + )->execute(); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // This could only fail if; + // a) we've already done it (upgrade) + // b) it doesn't exist (new install) + } + // Some PhpGedView installations store the u_reg_timestamp in the format "2010-03-07 21:41:07" + Database::prepare( + "UPDATE `##user_setting` SET setting_value=UNIX_TIMESTAMP(setting_value) WHERE setting_name='reg_timestamp' AND setting_value LIKE '____-__-__ __:__:__'" + )->execute(); + // Some PhpGedView installations have empty/invalid values for reg_timestamp + Database::prepare( + "UPDATE `##user_setting` SET setting_value=CAST(setting_value AS UNSIGNED) WHERE setting_name='reg_timestamp'" + )->execute(); + + // pgv_users => wt_user_gedcom_setting… + + $user_gedcom_settings = Database::prepare( + "SELECT user_id, u_gedcomid, u_rootid, u_canedit" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}users`" . + " JOIN `##user` ON (user_name=CONVERT(u_username USING utf8) COLLATE utf8_unicode_ci)" + )->fetchAll(); + + foreach ($user_gedcom_settings as $setting) { + try { + $array = unserialize($setting->u_gedcomid); + foreach ($array as $gedcom => $value) { + $tree = Tree::findByName($gedcom); + if ($tree !== null) { + Database::prepare( + "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value) VALUES (?, ?, ?, ?)" + )->execute([$setting->user_id, $tree->getTreeId(), 'gedcomid', $value]); + } + } + } catch (Throwable $ex) { + DebugBar::addThrowable($ex); + + // Invalid serialized data? + } + + try { + $array = unserialize($setting->u_rootid); + foreach ($array as $gedcom => $value) { + $tree = Tree::findByName($gedcom); + if ($tree !== null) { + Database::prepare( + "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value) VALUES (?, ?, ?, ?)" + )->execute([$setting->user_id, $tree->getTreeId(), 'rootid', $value]); + } + } + } catch (Throwable $ex) { + DebugBar::addThrowable($ex); + + // Invalid serialized data? + } + + try { + $array = unserialize($setting->u_canedit); + foreach ($array as $gedcom => $value) { + $tree = Tree::findByName($gedcom); + if ($tree !== null) { + Database::prepare( + "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value) VALUES (?, ?, ?, ?)" + )->execute([$setting->user_id, $tree->getTreeId(), 'canedit', $value]); + } + } + } catch (Throwable $ex) { + DebugBar::addThrowable($ex); + + // Invalid serialized data? + } + } + } + + define('PGV_PHPGEDVIEW', true); + define('PGV_PRIV_PUBLIC', Auth::PRIV_PRIVATE); + define('PGV_PRIV_USER', Auth::PRIV_USER); + define('PGV_PRIV_NONE', Auth::PRIV_NONE); + define('PGV_PRIV_HIDE', Auth::PRIV_HIDE); + + global $PRIV_HIDE, $PRIV_PUBLIC, $PRIV_USER, $PRIV_NONE; + $PRIV_PUBLIC = Auth::PRIV_PRIVATE; + $PRIV_USER = Auth::PRIV_USER; + $PRIV_NONE = Auth::PRIV_NONE; + $PRIV_HIDE = Auth::PRIV_HIDE; + + // Old versions of PhpGedView used a $GEDCOMS[] array. + // New versions used a database. + $GEDCOMS = Database::prepare( + "SELECT" . + " gedcom_id AS id," . + " gedcom_name AS gedcom," . + " gs1.setting_value AS config," . + " gs2.setting_value AS privacy" . + " FROM `##gedcom`" . + " JOIN `##gedcom_setting` AS gs1 USING (gedcom_id)" . + " JOIN `##gedcom_setting` AS gs2 USING (gedcom_id)" . + " WHERE gedcom_id>0" . + " AND gs1.setting_name='config'" . + " AND gs2.setting_name='privacy'" + )->fetchAll(PDO::FETCH_ASSOC); + + foreach ($GEDCOMS as $GEDCOM => $GED_DATA) { + // We read these variables from PhpGedView's index/*_conf.php, and set them here in case any are missing. + $ADVANCED_NAME_FACTS = ''; + $ADVANCED_PLAC_FACTS = ''; + $ALLOW_THEME_DROPDOWN = ''; + $CALENDAR_FORMAT = ''; + $CHART_BOX_TAGS = ''; + $CONTACT_EMAIL = ''; + $DEFAULT_PEDIGREE_GENERATIONS = ''; + $EXPAND_NOTES = ''; + $EXPAND_SOURCES = ''; + $FAM_FACTS_ADD = ''; + $FAM_FACTS_QUICK = ''; + $FAM_FACTS_UNIQUE = ''; + $FULL_SOURCES = ''; + $GENERATE_UIDS = ''; + $HIDE_GEDCOM_ERRORS = ''; + $HIDE_LIVE_PEOPLE = ''; + $INDI_FACTS_ADD = ''; + $INDI_FACTS_QUICK = ''; + $INDI_FACTS_UNIQUE = ''; + $LANGUAGE = ''; + $MAX_ALIVE_AGE = ''; + $MAX_DESCENDANCY_GENERATIONS = ''; + $MAX_PEDIGREE_GENERATIONS = ''; + $MAX_RELATION_PATH_LENGTH = ''; + $META_DESCRIPTION = ''; + $META_TITLE = ''; + $MULTI_MEDIA = ''; + $NOTE_FACTS_ADD = ''; + $NOTE_FACTS_QUICK = ''; + $NOTE_FACTS_UNIQUE = ''; + $NO_UPDATE_CHAN = ''; + $PEDIGREE_LAYOUT = ''; + $PEDIGREE_ROOT_ID = ''; + $PEDIGREE_SHOW_GENDER = ''; + $PREFER_LEVEL2_SOURCES = ''; + $QUICK_REQUIRED_FACTS = ''; + $QUICK_REQUIRED_FAMFACTS = ''; + $REPO_FACTS_ADD = ''; + $REPO_FACTS_QUICK = ''; + $REPO_FACTS_UNIQUE = ''; + $REQUIRE_AUTHENTICATION = ''; + $SHOW_COUNTER = ''; + $SHOW_DEAD_PEOPLE = ''; + $SHOW_EST_LIST_DATES = ''; + $SHOW_FACT_ICONS = ''; + $SHOW_GEDCOM_RECORD = ''; + $SHOW_HIGHLIGHT_IMAGES = ''; + $SHOW_LDS_AT_GLANCE = ''; + $SHOW_LIST_PLACES = ''; + $SHOW_LIVING_NAMES = ''; + $SHOW_MEDIA_DOWNLOAD = ''; + $SHOW_PARENTS_AGE = ''; + $SHOW_PEDIGREE_PLACES = ''; + $SHOW_PRIVATE_RELATIONSHIPS = ''; + $SHOW_RELATIVES_EVENTS = ''; + $SOUR_FACTS_ADD = ''; + $SOUR_FACTS_QUICK = ''; + $SOUR_FACTS_UNIQUE = ''; + $SUBLIST_TRIGGER_I = ''; + $SURNAME_LIST_STYLE = ''; + $SURNAME_TRADITION = ''; + $THEME_DIR = ''; + $USE_RELATIONSHIP_PRIVACY = ''; + $WEBMASTER_EMAIL = ''; + $WORD_WRAPPED_NOTES = ''; + + $config = str_replace(['$INDEX_DIRECTORY', '${INDEX_DIRECTORY}'], $INDEX_DIRECTORY, $GED_DATA['config']); + if (substr($config, 0, 1) === '.') { + $config = $pgv_path . '/' . $config; + } + if (is_readable($config)) { + require $config; + } + + $stmt_default_resn = Database::prepare("INSERT INTO `##default_resn` (gedcom_id, xref, tag_type, resn) VALUES (?, ?, ?, CASE ? WHEN -1 THEN 'hidden' WHEN 0 THEN 'confidential' WHEN 1 THEN 'privacy' ELSE 'none' END)"); + $stmt_gedcom_setting = Database::prepare("INSERT INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value) VALUES (?,?,?)"); + + $privacy = str_replace(['$INDEX_DIRECTORY', '${INDEX_DIRECTORY}'], $INDEX_DIRECTORY, $GED_DATA['privacy']); + if (substr($config, 0, 1) == '.') { + $privacy = $pgv_path . '/' . $privacy; + } + + if (is_readable($privacy)) { + require $privacy; + + foreach ($global_facts ?? [] as $key => $value) { + if (isset($value['details'])) { + $stmt_default_resn->execute([$GED_DATA['id'], null, $key, $value['details']]); + } + } + + foreach ($person_privacy ?? [] as $key => $value) { + $stmt_default_resn->execute([$GED_DATA['id'], $key, null, $value['details']]); + } + + foreach ($person_facts ?? [] as $key1 => $array) { + foreach ($array as $key2 => $value) { + if (isset($value['details'])) { + $stmt_default_resn->execute([$GED_DATA['id'], $key1, $key2, $value['details']]); + } + } + } + } + + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'ADVANCED_NAME_FACTS', $ADVANCED_NAME_FACTS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'ADVANCED_PLAC_FACTS', $ADVANCED_PLAC_FACTS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'ALLOW_THEME_DROPDOWN', $ALLOW_THEME_DROPDOWN]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'CALENDAR_FORMAT', $CALENDAR_FORMAT]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'CHART_BOX_TAGS', $CHART_BOX_TAGS]); + $user = User::findByIdentifier($CONTACT_EMAIL); + if ($user) { + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'CONTACT_USER_ID', $user->getUserId()]); + } + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'DEFAULT_PEDIGREE_GENERATIONS', $DEFAULT_PEDIGREE_GENERATIONS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'EXPAND_NOTES', $EXPAND_NOTES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'EXPAND_SOURCES', $EXPAND_SOURCES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FAM_FACTS_ADD', $FAM_FACTS_ADD]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FAM_FACTS_QUICK', $FAM_FACTS_QUICK]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FAM_FACTS_UNIQUE', $FAM_FACTS_UNIQUE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'FULL_SOURCES', $FULL_SOURCES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'GENERATE_UIDS', $GENERATE_UIDS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'HIDE_GEDCOM_ERRORS', $HIDE_GEDCOM_ERRORS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'HIDE_LIVE_PEOPLE', $HIDE_LIVE_PEOPLE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'INDI_FACTS_ADD', $INDI_FACTS_ADD]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'INDI_FACTS_QUICK', $INDI_FACTS_QUICK]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'INDI_FACTS_UNIQUE', $INDI_FACTS_UNIQUE]); + switch ($LANGUAGE) { + case 'catalan': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'ca']); + break; + case 'english-uk': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'en-GB']); + break; + case 'polish': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'pl']); + break; + case 'italian': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'it']); + break; + case 'spanish': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'es']); + break; + case 'finnish': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'fi']); + break; + case 'french': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'fr']); + break; + case 'german': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'de']); + break; + case 'danish': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'da']); + break; + case 'portuguese': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'pt']); + break; + case 'hebrew': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'he']); + break; + case 'estonian': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'et']); + break; + case 'turkish': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'tr']); + break; + case 'dutch': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'nl']); + break; + case 'slovak': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'sk']); + break; + case 'norwegian': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'nn']); + break; + case 'slovenian': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'sl']); + break; + case 'hungarian': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'hu']); + break; + case 'swedish': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'sv']); + break; + case 'russian': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'ru']); + break; + default: + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'LANGUAGE', 'en-US']); + break; + } + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_ALIVE_AGE', $MAX_ALIVE_AGE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_DESCENDANCY_GENERATIONS', $MAX_DESCENDANCY_GENERATIONS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_PEDIGREE_GENERATIONS', $MAX_PEDIGREE_GENERATIONS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MAX_RELATION_PATH_LENGTH', $MAX_RELATION_PATH_LENGTH]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MEDIA_DIRECTORY', 'media/']); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'META_DESCRIPTION', $META_DESCRIPTION]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'META_TITLE', $META_TITLE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'MEDIA_UPLOAD', $MULTI_MEDIA]); // see schema v12-13 + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NOTE_FACTS_ADD', $NOTE_FACTS_ADD]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NOTE_FACTS_QUICK', $NOTE_FACTS_QUICK]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NOTE_FACTS_UNIQUE', $NOTE_FACTS_UNIQUE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'NO_UPDATE_CHAN', $NO_UPDATE_CHAN]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PEDIGREE_LAYOUT', $PEDIGREE_LAYOUT]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PEDIGREE_ROOT_ID', $PEDIGREE_ROOT_ID]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PEDIGREE_SHOW_GENDER', $PEDIGREE_SHOW_GENDER]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'PREFER_LEVEL2_SOURCES', $PREFER_LEVEL2_SOURCES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'QUICK_REQUIRED_FACTS', $QUICK_REQUIRED_FACTS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'QUICK_REQUIRED_FAMFACTS', $QUICK_REQUIRED_FAMFACTS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REPO_FACTS_ADD', $REPO_FACTS_ADD]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REPO_FACTS_QUICK', $REPO_FACTS_QUICK]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REPO_FACTS_UNIQUE', $REPO_FACTS_UNIQUE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'REQUIRE_AUTHENTICATION', $REQUIRE_AUTHENTICATION]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_COUNTER', $SHOW_COUNTER]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_DEAD_PEOPLE', $SHOW_DEAD_PEOPLE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_EST_LIST_DATES', $SHOW_EST_LIST_DATES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_FACT_ICONS', $SHOW_FACT_ICONS]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_GEDCOM_RECORD', $SHOW_GEDCOM_RECORD]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_HIGHLIGHT_IMAGES', $SHOW_HIGHLIGHT_IMAGES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_LDS_AT_GLANCE', $SHOW_LDS_AT_GLANCE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_LIST_PLACES', $SHOW_LIST_PLACES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_LIVING_NAMES', $SHOW_LIVING_NAMES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_MEDIA_DOWNLOAD', $SHOW_MEDIA_DOWNLOAD]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_PARENTS_AGE', $SHOW_PARENTS_AGE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_PEDIGREE_PLACES', $SHOW_PEDIGREE_PLACES]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_PRIVATE_RELATIONSHIPS', $SHOW_PRIVATE_RELATIONSHIPS]); + + // Update these - see db_schema_5_6.php + $SHOW_RELATIVES_EVENTS = preg_replace('/_(BIRT|MARR|DEAT)_(COUS|MSIB|FSIB|GGCH|NEPH|GGPA)/', '', $SHOW_RELATIVES_EVENTS); + $SHOW_RELATIVES_EVENTS = preg_replace('/_FAMC_(RESI_EMIG)/', '', $SHOW_RELATIVES_EVENTS); + $SHOW_RELATIVES_EVENTS = preg_replace('/_MARR_(MOTH|FATH|FAMC)/', '_MARR_PARE', $SHOW_RELATIVES_EVENTS); + $SHOW_RELATIVES_EVENTS = preg_replace('/_DEAT_(MOTH|FATH)/', '_DEAT_PARE', $SHOW_RELATIVES_EVENTS); + preg_match_all('/[_A-Z]+/', $SHOW_RELATIVES_EVENTS, $match); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SHOW_RELATIVES_EVENTS', implode(',', array_unique($match[0]))]); + + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SOUR_FACTS_ADD', $SOUR_FACTS_ADD]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SOUR_FACTS_QUICK', $SOUR_FACTS_QUICK]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SOUR_FACTS_UNIQUE', $SOUR_FACTS_UNIQUE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SUBLIST_TRIGGER_I', $SUBLIST_TRIGGER_I]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SURNAME_LIST_STYLE', $SURNAME_LIST_STYLE]); + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'SURNAME_TRADITION', $SURNAME_TRADITION]); + switch ($THEME_DIR) { + case '': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', '']); + break; + case 'themes/cloudy/': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'clouds']); + break; + case 'themes/minimal/': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'minimal']); + break; + case 'themes/simplyblue/': + case 'themes/simplygreen/': + case 'themes/simplyred/': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'colors']); + break; + case 'themes/xenea/': + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'xenea']); + break; + default: + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'THEME_DIR', 'webtrees']); + break; + } + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'USE_RELATIONSHIP_PRIVACY', $USE_RELATIONSHIP_PRIVACY]); + $user = User::findByIdentifier($WEBMASTER_EMAIL); + if ($user) { + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'WEBMASTER_USER_ID', $user->getUserId()]); + } + $stmt_gedcom_setting->execute([$GED_DATA['id'], 'WORD_WRAPPED_NOTES', $WORD_WRAPPED_NOTES]); + } + Database::prepare("DELETE FROM `##gedcom_setting` WHERE setting_name IN ('config', 'privacy', 'path', 'pgv_ver', 'imported')")->execute(); + + // webtrees 1.0.5 combines user and gedcom settings for relationship privacy + // into a combined user-gedcom setting, for more granular control + Database::exec( + "INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value)" . + " SELECT u.user_id, g.gedcom_id, 'RELATIONSHIP_PATH_LENGTH', LEAST(us1.setting_value, gs1.setting_value)" . + " FROM `##user` u" . + " CROSS JOIN `##gedcom` g" . + " LEFT JOIN `##user_setting` us1 ON (u.user_id =us1.user_id AND us1.setting_name='max_relation_path')" . + " LEFT JOIN `##user_setting` us2 ON (u.user_id =us2.user_id AND us2.setting_name='relationship_privacy')" . + " LEFT JOIN `##gedcom_setting` gs1 ON (g.gedcom_id=gs1.gedcom_id AND gs1.setting_name='MAX_RELATION_PATH_LENGTH')" . + " LEFT JOIN `##gedcom_setting` gs2 ON (g.gedcom_id=gs2.gedcom_id AND gs2.setting_name='USE_RELATIONSHIP_PRIVACY')" . + " WHERE us2.setting_value AND gs2.setting_value" + ); + + Database::exec( + "DELETE FROM `##gedcom_setting` WHERE setting_name IN ('MAX_RELATION_PATH_LENGTH', 'USE_RELATIONSHIP_PRIVACY')" + ); + + Database::exec( + "DELETE FROM `##user_setting` WHERE setting_name IN ('relationship_privacy', 'max_relation_path_length')" + ); + + //////////////////////////////////////////////////////////////////////////////// + // The PhpGedView blocks don't migrate easily. + // Just give everybody and every tree default blocks + //////////////////////////////////////////////////////////////////////////////// + + Database::prepare( + "INSERT INTO `##block` (user_id, location, block_order, module_name)" . + " SELECT `##user`.user_id, location, block_order, module_name" . + " FROM `##block`" . + " JOIN `##user`" . + " WHERE `##block`.user_id = -1" . + " AND `##user`.user_id > 0" + )->execute(); + + Database::prepare( + "INSERT INTO `##block` (gedcom_id, location, block_order, module_name)" . + " SELECT `##gedcom`.gedcom_id, location, block_order, module_name" . + " FROM `##block`" . + " JOIN `##gedcom`" . + " WHERE `##block`.gedcom_id = -1" . + " AND `##gedcom`.gedcom_id > 0" + )->execute(); + + //////////////////////////////////////////////////////////////////////////////// + // Hit counter + //////////////////////////////////////////////////////////////////////////////// + // + if ($PGV_SCHEMA_VERSION >= 13) { + // pgv_hit_counter => wt_hit_counter… + + Database::prepare( + "REPLACE INTO `##hit_counter` (gedcom_id, page_name, page_parameter, page_count)" . + " SELECT gedcom_id, page_name, page_parameter, page_count FROM `{$DBNAME}`.`{$TBLPREFIX}hit_counter`" + )->execute(); + } else { + // Copied from PhpGedView's db_schema_12_13 + $statement = Database::prepare("INSERT IGNORE INTO `##hit_counter` (gedcom_id, page_name, page_parameter, page_count) VALUES (?, ?, ?, ?)"); + + foreach ($GEDCOMS as $GEDCOM => $GED_DATA) { + $file = $INDEX_DIRECTORY . '/' . $GED_DATA['gedcom'] . 'pgv_counters.txt'; + // $file, ' => wt_hit_counter… + + if (file_exists($file)) { + foreach (file($file) as $line) { + if (preg_match('/(@([A-Za-z0-9:_-]+)@ )?(\d+)/', $line, $match)) { + if ($match[2]) { + $page_name = 'individual.php'; + $page_parameter = $match[2]; + } else { + $page_name = 'index.php'; + $page_parameter = 'gedcom:' . $GED_DATA['id']; + } + try { + $statement->execute([$GED_DATA['id'], $page_name, $page_parameter, $match[3]]); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // Primary key violation? Ignore? + } + } + } + } + } + } + + //////////////////////////////////////////////////////////////////////////////// + + foreach ($GEDCOMS as $GED_DATA) { + Module::setDefaultAccess($GED_DATA['id']); + } + + // pgv_site_setting => wt_module_setting… + + Database::prepare( + "REPLACE INTO `##module_setting` (module_name, setting_name, setting_value)" . + " SELECT 'googlemap', site_setting_name, site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting`" . + " WHERE site_setting_name LIKE 'GM_%'" + )->execute(); + Database::prepare( + "REPLACE INTO `##module_setting` (module_name, setting_name, setting_value)" . + " SELECT 'lightbox', site_setting_name, site_setting_value FROM `{$DBNAME}`.`{$TBLPREFIX}site_setting`" . + " WHERE site_setting_name LIKE 'LB_%'" + )->execute(); + + //////////////////////////////////////////////////////////////////////////////// + + // pgv_favorites => wt_favorite… + + try { + Database::prepare( + "REPLACE INTO `##favorite` (favorite_id, user_id, gedcom_id, xref, favorite_type, url, title, note)" . + " SELECT fv_id, u.user_id, g.gedcom_id, fv_gid, fv_type, fv_url, fv_title, fv_note" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}favorites` f" . + " LEFT JOIN `##gedcom` g ON (f.fv_username=g.gedcom_name)" . + " LEFT JOIN `##user` u ON (f.fv_username=u.user_name)" + )->execute(); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // This table will only exist if the favorites module is installed in WT + } + + //////////////////////////////////////////////////////////////////////////////// + + // pgv_news => wt_news… + + try { + Database::prepare( + "REPLACE INTO `##news` (news_id, user_id, gedcom_id, subject, body, updated)" . + " SELECT n_id, u.user_id, g.gedcom_id, n_title, n_text, FROM_UNIXTIME(n_date)" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}news` n" . + " LEFT JOIN `##gedcom` g ON (n.n_username=g.gedcom_name)" . + " LEFT JOIN `##user` u ON (n.n_username=u.user_name)" + )->execute(); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); + + // This table will only exist if the news/blog module is installed in WT + } + + //////////////////////////////////////////////////////////////////////////////// + + // pgv_messages => wt_message… + + Database::prepare( + "REPLACE INTO `##message` (message_id, sender, ip_address, user_id, subject, body, created)" . + " SELECT m_id, m_from, '127.0.0.1', user_id, m_subject, m_body, STR_TO_DATE(LEFT(m_created,25),'%a, %d %M %Y %H:%i:%s')" . + " FROM `{$DBNAME}`.`{$TBLPREFIX}messages`" . + " JOIN `##user` ON (CONVERT(m_to USING utf8) COLLATE utf8_unicode_ci=user_name)" + )->execute(); + + + //////////////////////////////////////////////////////////////////////////////// + + // Genealogy records… + + Database::prepare( + "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . + " SELECT o_file, o_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}other`" . + " JOIN `##gedcom` ON (o_file = gedcom_id)" . + " ORDER BY o_type!='HEAD'" // Must load HEAD record first + )->execute(); + + Database::prepare( + "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . + " SELECT i_file, i_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}individuals`" . + " JOIN `##gedcom` ON (i_file = gedcom_id)" + )->execute(); + + Database::prepare( + "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . + " SELECT f_file, f_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}families`" . + " JOIN `##gedcom` ON (f_file = gedcom_id)" + )->execute(); + + Database::prepare( + "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . + " SELECT s_file, s_gedcom, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}sources`" . + " JOIN `##gedcom` ON (s_file = gedcom_id)" + )->execute(); + + Database::prepare( + "INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data, imported)" . + " SELECT m_gedfile, m_gedrec, 0 FROM `{$DBNAME}`.`{$TBLPREFIX}media`" . + " JOIN `##gedcom` ON (m_gedfile = gedcom_id)" + )->execute(); + + Database::prepare( + "UPDATE `##gedcom_setting` SET setting_value='0' WHERE setting_name='imported'" + )->execute(); + + $content = + I18N::translate('You need to sign in again, using your PhpGedView username and password.') . + '<br>' . + '<a href="' . e(route('admin-trees')) . '" class="btn btn-primary">' . I18N::translate('continue') . '</a>'; + + Auth::logout(); + + return new Response($content); + } + + /** + * Look for nearby installations of PhpGedView. + * + * @return string[] + */ + private function defaultPhpGedViewPaths(): array { + $php_paths = array_merge( + glob('../config.php') ?: [], + glob('../*/config.php') ?: [] + ); + + return array_map(function (string $path) { + return dirname($path) . DIRECTORY_SEPARATOR; + }, $php_paths); + } + + /** + * Read the entries from config.php into an array. + * + * @param string $pgv_path + * + * @return mixed[] + */ + private function readPhpGedViewConfig(string $pgv_path): array { + // Make a copy of the file, which ignores lines containing require/include + $config_php = file_get_contents($pgv_path . '/config.php'); + $config_php = preg_replace('/^\s*(include|require).*/m', '', $config_php); + $tmp_file = WT_DATA_DIR . 'pgv-config.php'; + file_put_contents($tmp_file, $config_php); + + try { + ob_start(); + include $tmp_file; + } catch (Exception $ex) { + } finally { + unlink($tmp_file); + ob_end_clean(); + } + + // The index directory can be either absolute or relative to the PhpGedView root. + $INDEX_DIRECTORY = $INDEX_DIRECTORY ?? ''; + if (preg_match('/^(\/|\\|[A-Z]:)/', $INDEX_DIRECTORY)) { + $INDEX_DIRECTORY = realpath($INDEX_DIRECTORY) . DIRECTORY_SEPARATOR; + } else { + $INDEX_DIRECTORY = realpath($pgv_path . DIRECTORY_SEPARATOR . $INDEX_DIRECTORY) . DIRECTORY_SEPARATOR; + } + + return get_defined_vars(); + } +} diff --git a/resources/views/admin/phpgedview/steps.php b/resources/views/admin/phpgedview/steps.php new file mode 100644 index 0000000000..b5dcec3943 --- /dev/null +++ b/resources/views/admin/phpgedview/steps.php @@ -0,0 +1,35 @@ +<?php use Fisharebest\Webtrees\I18N; ?> +<?php use Fisharebest\Webtrees\View; ?> + +<?= view('admin/breadcrumbs', ['links' => [route('admin-control-panel') => I18N::translate('Control panel'), route('admin-trees') => I18N::translate('Manage family trees'), $title]]) ?> + +<h1><?= $title ?></h1> + +<dl> + <?php foreach ($steps as $url => $text): ?> + <dt><?= $text ?></dt> + <dd class="wt-ajax-load" data-url="<?= e($url) ?>"></dd> + <?php endforeach ?> +</dl> + +<?php View::push('javascript') ?> +<script> + function nextAjaxStep() { + $("dd:empty:first").each(function(n, el) { + $(el).load(el.dataset.url, {}, function (responseText, textStatus, req) { + el.innerHTML = responseText; + if (textStatus === "error") { + $(".wt-ajax-load").removeClass("wt-ajax-load"); + } else { + nextAjaxStep(); + } + }); + + // Only process one callback at a time. + return false; + }); + } + + nextAjaxStep(); +</script> +<?php View::endpush() ?> diff --git a/resources/views/admin/phpgedview/wizard.php b/resources/views/admin/phpgedview/wizard.php new file mode 100644 index 0000000000..f2ba85ab99 --- /dev/null +++ b/resources/views/admin/phpgedview/wizard.php @@ -0,0 +1,60 @@ +<?php use Fisharebest\Webtrees\I18N; ?> + +<?= view('admin/breadcrumbs', ['links' => [route('admin-control-panel') => I18N::translate('Control panel'), route('admin-trees') => I18N::translate('Manage family trees'), $title]]) ?> + +<h1><?= $title ?></h1> + +<form class="form-horizontal"> + <input type="hidden" name="route" value="phpgedview-wizard"> + <?php if (!empty($pgv_paths)): ?> + <div class="row form-group"> + <div class="col-sm-3 col-form-label"> + <?= I18N::translate('PhpGedView might be installed in one of these folders:') ?> + </div> + <div class="col-sm-9"> + <?php foreach ($pgv_paths as $pgv_path): ?> + <div> + <a href="#" onclick="document.getElementById('pgv_path').value=this.dataset.path; return false;" data-path="<?= e($pgv_path) ?>"> + <?= e($pgv_path) ?> + </a> + </div> + <?php endforeach ?> + </div> + </div> + <?php endif ?> + + <div class="row form-group"> + <label class="col-sm-3 col-form-label" for="pgv_path"> + <?= I18N::translate('Where is your PhpGedView installation?') ?> + </label> + <div class="col-sm-9"> + <div class="input-group"> + <div class="input-group-prepend"> + <span class="input-group-text"><?= e(WT_ROOT) ?></span> + </div> + <input + type="text" + class="form-control" + dir="ltr" + id="pgv_path" + name="pgv_path" + size="40" + placeholder="<?= I18N::translate('Installation folder') ?>" + value="<?= count($pgv_paths) === 1 ? $pgv_paths[0] : '' ?>" + required + > + <div class="input-group-append"> + <span class="input-group-text">config.php</span> + </div> + </div> + </div> + </div> + + <div class="row form-group"> + <div class="offset-sm-3 col-sm-9"> + <button type="submit" class="btn btn-primary"> + <?= I18N::translate('continue') ?> + </button> + </div> + </div> +</form> diff --git a/resources/views/admin/trees.php b/resources/views/admin/trees.php index 040486608d..016796a678 100644 --- a/resources/views/admin/trees.php +++ b/resources/views/admin/trees.php @@ -391,7 +391,7 @@ <?= I18N::translate('<b>Important note:</b> The transfer wizard is not able to assist with moving media items. You will need to set up and move or copy your media configuration and objects separately after the transfer wizard is finished.') ?> </p> <p> - <a href="admin_pgv_to_wt.php"> + <a href="<?= route('phpgedview-wizard') ?>"> <?= I18N::translate('PhpGedView to webtrees transfer wizard') ?> </a> </p> diff --git a/resources/views/admin/upgrade/steps.php b/resources/views/admin/upgrade/steps.php new file mode 100644 index 0000000000..76ca69556d --- /dev/null +++ b/resources/views/admin/upgrade/steps.php @@ -0,0 +1,25 @@ +<?php use Fisharebest\Webtrees\I18N; ?> +<?php use Fisharebest\Webtrees\View; ?> + +<?= view('admin/breadcrumbs', ['links' => [route('admin-control-panel') => I18N::translate('Control panel'), route('admin-trees') => I18N::translate('Manage family trees'), $title]]) ?> + +<h1><?= $title ?></h1> + +<dl> + <?php foreach ($steps as $url => $text): ?> + <dt><?= $text ?></dt> + <dd class="wt-ajax-load" data-url="<?= e($url) ?>"></dd> + <?php endforeach ?> +</dl> + +<?php View::push('javascript') ?> +<script> + function nextUpgradeStep() { + $("dd:empty:first").each(function(el) { + $(el).load(el.dataset.url, {}, nextUpgradeStep); + }); + } + + nextUpgradeStep(); +</script> +<?php View::endpush() ?> diff --git a/resources/views/admin/upgrade/wizard.php b/resources/views/admin/upgrade/wizard.php new file mode 100644 index 0000000000..3f90f8d555 --- /dev/null +++ b/resources/views/admin/upgrade/wizard.php @@ -0,0 +1,60 @@ +<?php use Fisharebest\Webtrees\I18N; ?> + +<?= view('admin/breadcrumbs', ['links' => [route('admin-control-panel') => I18N::translate('Control panel'), route('admin-trees') => I18N::translate('Manage family trees'), $title]]) ?> + +<h1><?= $title ?></h1> + +<form class="form-horizontal"> + <input type="hidden" name="route" value="phpgedview-wizard"> + <?php if (!empty($pgv_paths)): ?> + <div class="row form-group"> + <div class="col-sm-3 col-form-label"> + <?= I18N::translate('PhpGedView might be installed in one of these folders:') ?> + </div> + <div class="col-sm-9"> + <?php foreach ($pgv_paths as $pgv_path): ?> + <div> + <a href="#" onclick="document.getElementById('pgv_path').value=this.dataset.path" data-path="<?= e($pgv_path) ?>"> + <?= e($pgv_path) ?> + </a> + </div> + <?php endforeach ?> + </div> + </div> + <?php endif ?> + + <div class="row form-group"> + <label class="col-sm-3 col-form-label" for="pgv_path"> + <?= I18N::translate('Where is your PhpGedView installation?') ?> + </label> + <div class="col-sm-9"> + <div class="input-group"> + <div class="input-group-prepend"> + <span class="input-group-text"><?= e(WT_ROOT) ?></span> + </div> + <input + type="text" + class="form-control" + dir="ltr" + id="pgv_path" + name="pgv_path" + size="40" + placeholder="<?= I18N::translate('Installation folder') ?>" + value="<?= count($pgv_paths) === 1 ? $pgv_paths[0] : '' ?>" + required + > + <div class="input-group-append"> + <span class="input-group-text">config.php</span> + </div> + </div> + </div> + </div> + + <div class="row form-group"> + <div class="offset-sm-3 col-sm-9"> + <button type="submit" class="btn btn-primary"> + <?= I18N::translate('continue') ?> + </button> + </div> + </div> +</form> diff --git a/routes/web.php b/routes/web.php index 1d9b136bae..1757ac69fb 100644 --- a/routes/web.php +++ b/routes/web.php @@ -100,6 +100,8 @@ if (Auth::isAdmin()) { 'GET:broadcast' => 'MessageController@broadcastPage', 'POST:broadcast' => 'MessageController@broadcastAction', 'POST:select2-flag' => 'AutocompleteController@select2Flag', + 'GET:phpgedview-wizard' => 'AdminPhpGedViewController@wizard', + 'POST:phpgedview-wizard' => 'AdminPhpGedViewController@step', ]; } diff --git a/themes/_administration/css-2.0.0/style.css b/themes/_administration/css-2.0.0/style.css index 68be74ead0..aefb7cd71f 100644 --- a/themes/_administration/css-2.0.0/style.css +++ b/themes/_administration/css-2.0.0/style.css @@ -16,6 +16,16 @@ /* The administration theme */ /* + * Any element that is loaded dynamically has the class wt-ajax-load. + * We can provide a "loading" placeholder for empty elements with this class. + */ +.wt-ajax-load:empty { + height: 16px; + width: 16px; + background: url(images/indicator.gif) no-repeat 50% 50%; +} + +/* * Pages have the following high-level structure: * * wt-global |