$eventDb = $event_qry->fetch(PDO::FETCH_OBJ); $event_order = $eventDb->event_order; // *** Remove colour from descendant *** $sql = "DELETE FROM humo_events WHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $descendant_array[$i] . "'\n\t\t\t\t\tAND event_kind='person_colour_mark' AND event_event='" . $event_event . "'"; $result = $dbh->query($sql); // *** Restore order of colour marks *** $event_sql = "SELECT * FROM humo_events\n\t\t\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $descendant_array[$i] . "' AND event_kind='" . $event_kind . "' AND event_order>'" . $event_order . "' ORDER BY event_order"; $event_qry = $dbh->query($event_sql); while ($eventDb = $event_qry->fetch(PDO::FETCH_OBJ)) { $sql = "UPDATE humo_events SET\n\t\t\t\t\tevent_order='" . ($eventDb->event_order - 1) . "',\n\t\t\t\t\tevent_changed_date='" . $gedcom_date . "',\n\t\t\t\t\tevent_changed_time='" . $gedcom_time . "'\n\t\t\t\t\tWHERE event_id='" . $eventDb->event_id . "'"; $result = $dbh->query($sql); } } } if (isset($_POST['event_ancestors'])) { ancestors($pers_gedcomnumber); foreach ($ancestor_array as $key2 => $value) { //echo $key2.'-'.$value.', '; $selected_ancestor = $value; // *** Get event_order from selected person *** $event_sql = "SELECT event_order FROM humo_events WHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $selected_ancestor . "'\n\t\t\t\t\tAND event_kind='person_colour_mark' AND event_event='" . $event_event . "'"; $event_qry = $dbh->query($event_sql); $eventDb = $event_qry->fetch(PDO::FETCH_OBJ); $event_order = $eventDb->event_order; // *** Check if ancestor allready has this colour *** $sql = "DELETE FROM humo_events WHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $selected_ancestor . "'\n\t\t\t\t\tAND event_kind='person_colour_mark' AND event_event='" . $event_event . "'"; $result = $dbh->query($sql); // *** Restore order of colour marks *** $event_sql = "SELECT * FROM humo_events\n\t\t\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $selected_ancestor . "' AND event_kind='" . $event_kind . "' AND event_order>'" . $event_order . "' ORDER BY event_order"; $event_qry = $dbh->query($event_sql); while ($eventDb = $event_qry->fetch(PDO::FETCH_OBJ)) {
function get_breadcrumbs($term, $taxonomy = '', $args = []) { // Parse arguments $args = wp_parse_args($args, ['before' => '<nav class="breadcrumbs" itemprop="breadcrumb"><ul><li>', 'join' => '</li><li>', 'after' => '</li></ul></nav>', 'count' => false]); // Initialize $output = ''; // Got something? if ($ancestors = ancestors($term, $taxonomy)) { // For each parent, create a list item foreach ($ancestors as $ancestor) { $item = get_term_by('id', $ancestor, $taxonomy); $crumbs[] = sprintf('<a href="%s" rel="tag">%s</a>%s', get_term_link($ancestor, $taxonomy), $item->name, $args['count'] ? sprintf(' <span class="term-count">(%s)</span>', $item->count) : ''); } // Got something? Wrap it up! if (!empty($crumbs)) { $output = $args['before'] . implode($args['join'], $crumbs) . $args['after']; } } // Return what we've got return apply_filters('ubik_terms_breadcrumbs', $output); }
//$fam_search = $dbh->query("SELECT pers_fams, pers_indexnr FROM ".$tree."person WHERE pers_gedcomnumber ='".$desc_pers."'"); $fam_search = $dbh->query("SELECT pers_fams, pers_indexnr\n\t\t\tFROM humo_persons WHERE pers_tree_id='" . $tree_id . "' AND pers_gedcomnumber ='" . $desc_pers . "'"); $fam_searchDb = $fam_search->fetch(PDO::FETCH_OBJ); if ($fam_searchDb->pers_fams != '') { $desc_fams = $fam_searchDb->pers_fams; } else { $desc_fams = $fam_searchDb->pers_indexnr; } $gn = 0; descendants($desc_fams, $desc_pers, $gn, $max_gens); } if (isset($_POST['part_tree']) and $_POST['part_tree'] == 'part' and isset($_POST['kind_tree']) and $_POST['kind_tree'] == "ancestor") { // map ancestors $anc_pers = $_POST['person']; $max_gens = $_POST['generations'] + 2; ancestors($anc_pers, $max_gens); } echo '<p>' . __('Gedcom file will be exported to backup_tmp/ folder') . '<br>'; $gedcom_texts = ''; if (isset($_POST['gedcom_texts'])) { $gedcom_texts = $_POST['gedcom_texts']; } $gedcom_sources = ''; if (isset($_POST['gedcom_sources'])) { $gedcom_sources = $_POST['gedcom_sources']; } $gedcom_char_set = ''; if (isset($_POST['gedcom_char_set'])) { $gedcom_char_set = $_POST['gedcom_char_set']; } $fh = fopen($myFile, 'w') or die("<b>ERROR: no permission to open a new file! Please check permissions of admin/backup_tmp folder!</b>");