Exemplo n.º 1
0
         $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)) {
Exemplo n.º 2
0
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('&nbsp;<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);
}
Exemplo n.º 3
0
     //$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>");