if ($afbDb->event_text != '') { $picture_text .= $afbDb->event_text . '<br>'; $picture_text2 .= $afbDb->event_text . '<br>'; } } // *** Show texts from connected objects *** $picture_qry = $dbh->query("SELECT * FROM humo_events\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_kind='object' AND LOWER(event_event)='" . strtolower($filename) . "'"); while ($pictureDb = $picture_qry->fetch(PDO::FETCH_OBJ)) { $connect_qry = $dbh->query("SELECT * FROM humo_connections\n\t\t\t\tWHERE connect_tree_id='" . $tree_id . "'\n\t\t\t\tAND connect_sub_kind='pers_object'\n\t\t\t\tAND connect_source_id='" . $pictureDb->event_gedcomnr . "'"); while ($connectDb = $connect_qry->fetch(PDO::FETCH_OBJ)) { $person_cls = new person_cls(); @($personDb = $db_functions->get_person($connectDb->connect_connect_id)); $name = $person_cls->person_name($personDb); $picture_text .= '<a href="' . CMS_ROOTPATH . 'family.php?database=' . $_SESSION['tree_prefix'] . '&id=' . $personDb->pers_indexnr . '&main_person=' . $personDb->pers_gedcomnumber . '">' . $name["standard_name"] . '</a><br>'; $picture_text2 .= $name["standard_name"] . '<br>'; $privacy = $person_cls->set_privacy($personDb); if ($privacy) { $picture_privacy = true; } $picture_text .= $pictureDb->event_text . '<br>'; $picture_text2 .= $pictureDb->event_text . '<br>'; } } $picture2 = show_picture($dir, $filename, 175, 120); $picture = '<img src="' . $dir . $picture2['thumb'] . $picture2['picture'] . '" width="' . $picture2['width'] . '" alt="' . $filename . '"></a>'; echo '<div class="photobook">'; if ($picture_privacy == false) { // *** Show photo using the lightbox effect *** echo '<a href="' . $dir . $filename . '" rel="lightbox" title="' . $picture_text2 . '">'; echo $picture; echo '<div class="photobooktext">' . $picture_text . '</div>';