} // *** Add new source connection *** if (isset($_POST['connect_add'])) { // *** Generate new order number *** $event_sql = "SELECT * FROM humo_connections\n\t\tWHERE connect_tree_id='" . $tree_id . "'\n\t\tAND connect_kind='" . safe_text($_POST['connect_kind']) . "'\n\t\tAND connect_sub_kind='" . safe_text($_POST["connect_sub_kind"]) . "'\n\t\tAND connect_connect_id='" . safe_text($_POST["connect_connect_id"]) . "'"; $event_qry = $dbh->query($event_sql); $count = $event_qry->rowCount(); $count++; $sql = "INSERT INTO humo_connections SET\n\t\tconnect_tree_id='" . $tree_id . "',\n\t\tconnect_order='" . $count . "',\n\t\tconnect_new_date='" . $gedcom_date . "',\n\t\tconnect_new_time='" . $gedcom_time . "',\n\t\tconnect_kind='" . safe_text($_POST['connect_kind']) . "',\n\t\tconnect_sub_kind='" . safe_text($_POST["connect_sub_kind"]) . "',\n\t\tconnect_connect_id='" . safe_text($_POST["connect_connect_id"]) . "'"; $result = $dbh->query($sql); } // *** End of update sources *** // *** Change source connection *** if (isset($_POST['connect_change'])) { foreach ($_POST['connect_change'] as $key => $value) { $sql = "UPDATE humo_connections SET\n\t\tconnect_kind='" . safe_text($_POST['connect_kind'][$key]) . "',\n\t\tconnect_sub_kind='" . safe_text($_POST['connect_sub_kind'][$key]) . "',\n\t\tconnect_date='" . $editor_cls->date_process("connect_date", $key) . "',\n\t\tconnect_place='" . $editor_cls->text_process($_POST["connect_place"][$key]) . "',\n\t\tconnect_page='" . $editor_cls->text_process($_POST["connect_page"][$key]) . "',\n\t\tconnect_role='" . $editor_cls->text_process($_POST["connect_role"][$key]) . "',\n\t\tconnect_source_id='" . safe_text($_POST['connect_source_id'][$key]) . "',\n\t\tconnect_item_id='" . safe_text($_POST['connect_item_id'][$key]) . "',\n\t\tconnect_text='" . safe_text($_POST['connect_text'][$key]) . "',"; if (isset($_POST['connect_quality'][$key]) and ($_POST['connect_quality'][$key] or $_POST['connect_quality'][$key] == '0')) { $sql .= " connect_quality='" . safe_text($_POST['connect_quality'][$key]) . "',"; } $sql .= " connect_changed_date='" . $gedcom_date . "', "; $sql .= " connect_changed_time='" . $gedcom_time . "'"; $sql .= " WHERE connect_id='" . safe_text($_POST["connect_change"][$key]) . "'"; //echo $sql; $result = $dbh->query($sql); } } // *** Remove source/ event connection *** if (isset($_GET['connect_drop'])) { echo '<div class="confirm">'; echo __('Are you sure you want to remove this event?'); echo ' <form method="post" action="' . $phpself2 . '" style="display : inline;">';
} } // ******************** // *** Show sources *** // ******************** if ($menu_admin == 'sources') { if (isset($_POST['source_add'])) { // *** Generate new gedcomnr, find highest gedcomnumber I100: strip I and order by numeric *** $new_nr_qry = "SELECT *, ABS(substring(source_gedcomnr, 2)) AS gednr\n\t\t\t\tFROM humo_sources WHERE source_tree_id='" . $tree_id . "' ORDER BY gednr DESC LIMIT 0,1"; $new_nr_result = $dbh->query($new_nr_qry); $new_nr = $new_nr_result->fetch(PDO::FETCH_OBJ); $new_gedcomnumber = 'S1'; if (isset($new_nr->source_gedcomnr)) { $new_gedcomnumber = 'S' . (substr($new_nr->source_gedcomnr, 1) + 1); } $sql = "INSERT INTO humo_sources SET\n\t\t\t\tsource_tree_id='" . $tree_id . "',\n\t\t\t\tsource_gedcomnr='" . $new_gedcomnumber . "',\n\t\t\t\tsource_status='" . $editor_cls->text_process($_POST['source_status']) . "',\n\t\t\t\tsource_title='" . $editor_cls->text_process($_POST['source_title']) . "',\n\t\t\t\tsource_date='" . safe_text($_POST['source_date']) . "',\n\t\t\t\tsource_place='" . $editor_cls->text_process($_POST['source_place']) . "',\n\t\t\t\tsource_publ='" . $editor_cls->text_process($_POST['source_publ']) . "',\n\t\t\t\tsource_refn='" . $editor_cls->text_process($_POST['source_refn']) . "',\n\t\t\t\tsource_auth='" . $editor_cls->text_process($_POST['source_auth']) . "',\n\t\t\t\tsource_subj='" . $editor_cls->text_process($_POST['source_subj']) . "',\n\t\t\t\tsource_item='" . $editor_cls->text_process($_POST['source_item']) . "',\n\t\t\t\tsource_kind='" . $editor_cls->text_process($_POST['source_kind']) . "',\n\t\t\t\tsource_repo_caln='" . $editor_cls->text_process($_POST['source_repo_caln']) . "',\n\t\t\t\tsource_repo_page='" . safe_text($_POST['source_repo_page']) . "',\n\t\t\t\tsource_repo_gedcomnr='" . $editor_cls->text_process($_POST['source_repo_gedcomnr']) . "',\n\t\t\t\tsource_text='" . $editor_cls->text_process($_POST['source_text']) . "',\n\t\t\t\tsource_new_date='" . $gedcom_date . "',\n\t\t\t\tsource_new_time='" . $gedcom_time . "'"; $result = $dbh->query($sql); //$new_source_qry= "SELECT * FROM humo_sources // WHERE source_tree_id='".$tree_id."' ORDER BY source_id DESC LIMIT 0,1"; //$new_source_result = $dbh->query($new_source_qry); //$new_source=$new_source_result->fetch(PDO::FETCH_OBJ); //$_POST['source_id']=$new_source->source_id; $_POST['source_id'] = $dbh->lastInsertId(); } if (isset($_POST['source_change'])) { $sql = "UPDATE humo_sources SET\n\t\t\tsource_status='" . $editor_cls->text_process($_POST['source_status']) . "',\n\t\t\tsource_title='" . $editor_cls->text_process($_POST['source_title']) . "',\n\t\t\tsource_date='" . $editor_cls->date_process('source_date') . "',\n\t\t\tsource_place='" . $editor_cls->text_process($_POST['source_place']) . "',\n\t\t\tsource_publ='" . $editor_cls->text_process($_POST['source_publ']) . "',\n\t\t\tsource_refn='" . $editor_cls->text_process($_POST['source_refn']) . "',\n\t\t\tsource_auth='" . $editor_cls->text_process($_POST['source_auth']) . "',\n\t\t\tsource_subj='" . $editor_cls->text_process($_POST['source_subj']) . "',\n\t\t\tsource_item='" . $editor_cls->text_process($_POST['source_item']) . "',\n\t\t\tsource_kind='" . $editor_cls->text_process($_POST['source_kind']) . "',\n\t\t\tsource_repo_caln='" . $editor_cls->text_process($_POST['source_repo_caln']) . "',\n\t\t\tsource_repo_page='" . $editor_cls->text_process($_POST['source_repo_page']) . "',\n\t\t\tsource_repo_gedcomnr='" . $editor_cls->text_process($_POST['source_repo_gedcomnr']) . "',\n\t\t\tsource_text='" . $editor_cls->text_process($_POST['source_text'], true) . "',\n\t\t\tsource_changed_date='" . $gedcom_date . "',\n\t\t\tsource_changed_time='" . $gedcom_time . "'\n\t\t\tWHERE source_tree_id='" . $tree_id . "' AND source_id='" . safe_text($_POST["source_id"]) . "'"; $result = $dbh->query($sql); family_tree_update($tree_prefix); } if (isset($_POST['source_remove'])) { echo '<div class="confirm">';