// New format: array(ip, comment)
$statement->execute(array($value[0], 'search-engine', $value[1]));
} else {
// Old format: string(ip)
$statement->execute(array($value, 'search-engine', ''));
}
} catch (PDOException $ex) {
echo $ex, '<br>';
}
}
}
}
}
////////////////////////////////////////////////////////////////////////////////
foreach ($GEDCOMS as $GED_DATA) {
WT_Module::setDefaultAccess($GED_DATA['id']);
}
echo '<p>pgv_site_setting => wt_module_setting ...</p>';
ob_flush();
flush();
usleep(50000);
WT_DB::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();
WT_DB::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>';
ob_flush();
flush();
usleep(50000);
try {
WT_DB::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) {
public static function create($tree_name)
{
try {
// Create a new tree
WT_DB::prepare("INSERT INTO `##gedcom` (gedcom_name) VALUES (?)")->execute(array($tree_name));
$tree_id = WT_DB::prepare("SELECT LAST_INSERT_ID()")->fetchOne();
} catch (PDOException $ex) {
// A tree with that name already exists?
return;
}
// Update the list of trees - to include this new one
self::$trees = null;
// Module privacy
WT_Module::setDefaultAccess($tree_id);
// Gedcom and privacy settings
set_gedcom_setting($tree_id, 'ADVANCED_NAME_FACTS', 'NICK,_AKA');
set_gedcom_setting($tree_id, 'ADVANCED_PLAC_FACTS', '');
set_gedcom_setting($tree_id, 'ALLOW_THEME_DROPDOWN', true);
set_gedcom_setting($tree_id, 'CALENDAR_FORMAT', 'gregorian');
set_gedcom_setting($tree_id, 'CHART_BOX_TAGS', '');
set_gedcom_setting($tree_id, 'COMMON_NAMES_ADD', '');
set_gedcom_setting($tree_id, 'COMMON_NAMES_REMOVE', '');
set_gedcom_setting($tree_id, 'COMMON_NAMES_THRESHOLD', '40');
set_gedcom_setting($tree_id, 'CONTACT_USER_ID', WT_USER_ID);
set_gedcom_setting($tree_id, 'DEFAULT_PEDIGREE_GENERATIONS', '4');
set_gedcom_setting($tree_id, 'EXPAND_RELATIVES_EVENTS', false);
set_gedcom_setting($tree_id, 'EXPAND_SOURCES', false);
set_gedcom_setting($tree_id, 'FAM_FACTS_ADD', 'CENS,MARR,RESI,SLGS,MARR_CIVIL,MARR_RELIGIOUS,MARR_PARTNERS,RESN');
set_gedcom_setting($tree_id, 'FAM_FACTS_QUICK', 'MARR,DIV,_NMR');
set_gedcom_setting($tree_id, 'FAM_FACTS_UNIQUE', 'NCHI,MARL,DIV,ANUL,DIVF,ENGA,MARB,MARC,MARS');
set_gedcom_setting($tree_id, 'FAM_ID_PREFIX', 'F');
set_gedcom_setting($tree_id, 'FORMAT_TEXT', 'markdown');
set_gedcom_setting($tree_id, 'FULL_SOURCES', false);
set_gedcom_setting($tree_id, 'GEDCOM_ID_PREFIX', 'I');
set_gedcom_setting($tree_id, 'GEDCOM_MEDIA_PATH', '');
set_gedcom_setting($tree_id, 'GENERATE_UIDS', false);
set_gedcom_setting($tree_id, 'HIDE_GEDCOM_ERRORS', true);
set_gedcom_setting($tree_id, 'HIDE_LIVE_PEOPLE', true);
set_gedcom_setting($tree_id, 'INDI_FACTS_ADD', 'AFN,BIRT,DEAT,BURI,CREM,ADOP,BAPM,BARM,BASM,BLES,CHRA,CONF,FCOM,ORDN,NATU,EMIG,IMMI,CENS,PROB,WILL,GRAD,RETI,DSCR,EDUC,IDNO,NATI,NCHI,NMR,OCCU,PROP,RELI,RESI,SSN,TITL,BAPL,CONL,ENDL,SLGC,_MILI,ASSO,RESN');
set_gedcom_setting($tree_id, 'INDI_FACTS_QUICK', 'BIRT,BURI,BAPM,CENS,DEAT,OCCU,RESI');
set_gedcom_setting($tree_id, 'INDI_FACTS_UNIQUE', '');
set_gedcom_setting($tree_id, 'KEEP_ALIVE_YEARS_BIRTH', '');
set_gedcom_setting($tree_id, 'KEEP_ALIVE_YEARS_DEATH', '');
set_gedcom_setting($tree_id, 'LANGUAGE', WT_LOCALE);
// Default to the current admin’s language
set_gedcom_setting($tree_id, 'MAX_ALIVE_AGE', 120);
set_gedcom_setting($tree_id, 'MAX_DESCENDANCY_GENERATIONS', '15');
set_gedcom_setting($tree_id, 'MAX_PEDIGREE_GENERATIONS', '10');
set_gedcom_setting($tree_id, 'MEDIA_DIRECTORY', 'media/');
set_gedcom_setting($tree_id, 'MEDIA_ID_PREFIX', 'M');
set_gedcom_setting($tree_id, 'MEDIA_UPLOAD', WT_PRIV_USER);
set_gedcom_setting($tree_id, 'META_DESCRIPTION', '');
set_gedcom_setting($tree_id, 'META_TITLE', WT_WEBTREES);
set_gedcom_setting($tree_id, 'NOTE_FACTS_ADD', 'SOUR,RESN');
set_gedcom_setting($tree_id, 'NOTE_FACTS_QUICK', '');
set_gedcom_setting($tree_id, 'NOTE_FACTS_UNIQUE', '');
set_gedcom_setting($tree_id, 'NOTE_ID_PREFIX', 'N');
set_gedcom_setting($tree_id, 'NO_UPDATE_CHAN', false);
set_gedcom_setting($tree_id, 'PEDIGREE_FULL_DETAILS', true);
set_gedcom_setting($tree_id, 'PEDIGREE_LAYOUT', true);
set_gedcom_setting($tree_id, 'PEDIGREE_ROOT_ID', '');
set_gedcom_setting($tree_id, 'PEDIGREE_SHOW_GENDER', false);
set_gedcom_setting($tree_id, 'PREFER_LEVEL2_SOURCES', '1');
set_gedcom_setting($tree_id, 'QUICK_REQUIRED_FACTS', 'BIRT,DEAT');
set_gedcom_setting($tree_id, 'QUICK_REQUIRED_FAMFACTS', 'MARR');
set_gedcom_setting($tree_id, 'REPO_FACTS_ADD', 'PHON,EMAIL,FAX,WWW,NOTE,SHARED_NOTE,RESN');
set_gedcom_setting($tree_id, 'REPO_FACTS_QUICK', '');
set_gedcom_setting($tree_id, 'REPO_FACTS_UNIQUE', 'NAME,ADDR');
set_gedcom_setting($tree_id, 'REPO_ID_PREFIX', 'R');
set_gedcom_setting($tree_id, 'REQUIRE_AUTHENTICATION', false);
set_gedcom_setting($tree_id, 'SAVE_WATERMARK_IMAGE', false);
set_gedcom_setting($tree_id, 'SAVE_WATERMARK_THUMB', false);
set_gedcom_setting($tree_id, 'SHOW_AGE_DIFF', false);
set_gedcom_setting($tree_id, 'SHOW_COUNTER', true);
set_gedcom_setting($tree_id, 'SHOW_DEAD_PEOPLE', WT_PRIV_PUBLIC);
set_gedcom_setting($tree_id, 'SHOW_EST_LIST_DATES', false);
set_gedcom_setting($tree_id, 'SHOW_FACT_ICONS', true);
set_gedcom_setting($tree_id, 'SHOW_GEDCOM_RECORD', false);
set_gedcom_setting($tree_id, 'SHOW_HIGHLIGHT_IMAGES', true);
set_gedcom_setting($tree_id, 'SHOW_LDS_AT_GLANCE', false);
set_gedcom_setting($tree_id, 'SHOW_LEVEL2_NOTES', true);
set_gedcom_setting($tree_id, 'SHOW_LIVING_NAMES', WT_PRIV_USER);
set_gedcom_setting($tree_id, 'SHOW_MEDIA_DOWNLOAD', false);
set_gedcom_setting($tree_id, 'SHOW_NO_WATERMARK', WT_PRIV_USER);
set_gedcom_setting($tree_id, 'SHOW_PARENTS_AGE', true);
set_gedcom_setting($tree_id, 'SHOW_PEDIGREE_PLACES', '9');
set_gedcom_setting($tree_id, 'SHOW_PEDIGREE_PLACES_SUFFIX', false);
set_gedcom_setting($tree_id, 'SHOW_PRIVATE_RELATIONSHIPS', true);
set_gedcom_setting($tree_id, 'SHOW_RELATIVES_EVENTS', '_BIRT_CHIL,_BIRT_SIBL,_MARR_CHIL,_MARR_PARE,_DEAT_CHIL,_DEAT_PARE,_DEAT_GPAR,_DEAT_SIBL,_DEAT_SPOU');
set_gedcom_setting($tree_id, 'SHOW_STATS', false);
set_gedcom_setting($tree_id, 'SOURCE_ID_PREFIX', 'S');
set_gedcom_setting($tree_id, 'SOUR_FACTS_ADD', 'NOTE,REPO,SHARED_NOTE,RESN');
set_gedcom_setting($tree_id, 'SOUR_FACTS_QUICK', 'TEXT,NOTE,REPO');
set_gedcom_setting($tree_id, 'SOUR_FACTS_UNIQUE', 'AUTH,ABBR,TITL,PUBL,TEXT');
set_gedcom_setting($tree_id, 'SUBLIST_TRIGGER_I', '200');
set_gedcom_setting($tree_id, 'SURNAME_LIST_STYLE', 'style2');
switch (WT_LOCALE) {
case 'es':
set_gedcom_setting($tree_id, 'SURNAME_TRADITION', 'spanish');
break;
case 'is':
set_gedcom_setting($tree_id, 'SURNAME_TRADITION', 'icelandic');
break;
case 'lt':
set_gedcom_setting($tree_id, 'SURNAME_TRADITION', 'lithuanian');
break;
case 'pl':
set_gedcom_setting($tree_id, 'SURNAME_TRADITION', 'polish');
break;
case 'pt':
case 'pt-BR':
set_gedcom_setting($tree_id, 'SURNAME_TRADITION', 'portuguese');
break;
default:
set_gedcom_setting($tree_id, 'SURNAME_TRADITION', 'paternal');
break;
}
set_gedcom_setting($tree_id, 'THEME_DIR', 'webtrees');
set_gedcom_setting($tree_id, 'THUMBNAIL_WIDTH', '100');
set_gedcom_setting($tree_id, 'USE_RIN', false);
set_gedcom_setting($tree_id, 'USE_SILHOUETTE', true);
set_gedcom_setting($tree_id, 'WATERMARK_THUMB', false);
set_gedcom_setting($tree_id, 'WEBMASTER_USER_ID', WT_USER_ID);
set_gedcom_setting($tree_id, 'WEBTREES_EMAIL', '');
set_gedcom_setting($tree_id, 'WORD_WRAPPED_NOTES', false);
set_gedcom_setting($tree_id, 'imported', 0);
set_gedcom_setting($tree_id, 'title', WT_I18N::translate('My family tree'));
// Default restriction settings
$statement = WT_DB::prepare("INSERT INTO `##default_resn` (gedcom_id, xref, tag_type, resn) VALUES (?, NULL, ?, ?)");
$statement->execute(array($tree_id, 'SSN', 'confidential'));
$statement->execute(array($tree_id, 'SOUR', 'privacy'));
$statement->execute(array($tree_id, 'REPO', 'privacy'));
$statement->execute(array($tree_id, 'SUBM', 'confidential'));
$statement->execute(array($tree_id, 'SUBN', 'confidential'));
// Genealogy data
// It is simpler to create a temporary/unimported GEDCOM than to populate all the tables...
$john_doe = WT_I18N::translate('John /DOE/');
$note = WT_I18N::translate('Edit this individual and replace their details with your own');
WT_DB::prepare("INSERT INTO `##gedcom_chunk` (gedcom_id, chunk_data) VALUES (?, ?)")->execute(array($tree_id, "0 HEAD\n1 CHAR UTF-8\n0 @I1@ INDI\n1 NAME {$john_doe}\n1 SEX M\n1 BIRT\n2 DATE 01 JAN 1850\n2 NOTE {$note}\n0 TRLR\n"));
// Set the initial blocks
WT_DB::prepare("INSERT INTO `##block` (gedcom_id, location, block_order, module_name)" . " SELECT ?, location, block_order, module_name" . " FROM `##block`" . " WHERE gedcom_id=-1")->execute(array($tree_id));
// Update the list of trees - to include the new configuration settings
self::$trees = null;
}
