// 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; }