public static function updateGedcomMatch($dbw, $treeId, $gedcomId, $key, $matchTitle, $merged, $gedcomUser)
{
$newTitle = $matchTitle == '#nomatch#' ? null : Title::newFromText($matchTitle);
$oldTitle = null;
// read old match_namespace and title
$row = $dbw->selectRow('familytree_gedcom_data', array('fgd_match_namespace', 'fgd_match_title'), array('fgd_gedcom_id' => $gedcomId, 'fgd_gedcom_key' => $key));
if ($row && $row->fgd_match_namespace > 0) {
$oldTitle = Title::makeTitle($row->fgd_match_namespace, $row->fgd_match_title);
if ($oldTitle && ($oldTitle->getNamespace() == NS_PERSON || $oldTitle->getNamespace() == NS_FAMILY || $oldTitle->getNamespace() == NS_MYSOURCE) && (!$newTitle || $oldTitle->getPrefixedText() != $newTitle->getPrefixedText())) {
// remove match title from tree
if (!FamilyTreeUtil::removePage($dbw, $treeId, $oldTitle)) {
return false;
}
// unwatch match title if no other trees contain it
if (!$dbw->selectField('familytree_page', 'fp_tree_id', array('fp_namespace' => $row->fgd_match_namespace, 'fp_title' => $row->fgd_match_title, 'fp_user_id' => $gedcomUser->getID()))) {
$article = new Article($oldTitle, 0);
StructuredData::removeWatch($gedcomUser, $article);
}
}
}
if ($newTitle) {
$matchTitle = $newTitle->getDBkey();
$matchNamespace = $newTitle->getNamespace();
$potentialMatchesAttr = '';
$potentialMatchesValue = '';
$potentialMatchesUpdate = '';
if (($newTitle->getNamespace() == NS_PERSON || $newTitle->getNamespace() == NS_FAMILY || $newTitle->getNamespace() == NS_MYSOURCE) && (!$oldTitle || $oldTitle->getPrefixedText() != $newTitle->getPrefixedText())) {
// add match title to tree
if (!FamilyTreeUtil::addPage($dbw, $gedcomUser, $treeId, $newTitle, 0, 0)) {
return false;
}
// watch match title
$article = new Article($newTitle, 0);
StructuredData::addWatch($gedcomUser, $article);
}
} else {
$matchTitle = '';
$matchNamespace = -1;
$merged = 0;
$potentialMatchesAttr = ', fgd_potential_matches';
// reset potential matches to what's in the gedcom
$potentialMatchesValue = ", ''";
$potentialMatchesUpdate = ", fgd_potential_matches=''";
}
$matchTitle = $dbw->addQuotes($matchTitle);
$sql = "INSERT INTO familytree_gedcom_data (fgd_gedcom_id, fgd_gedcom_key, fgd_match_namespace, fgd_match_title, fgd_merged{$potentialMatchesAttr})" . " VALUES({$gedcomId}," . $dbw->addQuotes($key) . ",{$matchNamespace},{$matchTitle},{$merged}{$potentialMatchesValue})" . " ON DUPLICATE KEY UPDATE fgd_match_namespace={$matchNamespace}, fgd_match_title={$matchTitle}, fgd_merged={$merged}{$potentialMatchesUpdate}";
$dbw->query($sql);
return $dbw->lastErrno() == 0;
}
