// **************************************************
define("CMS_ROOTPATH", '');
include_once CMS_ROOTPATH . "include/db_login.php";
//Inloggen database.
include_once CMS_ROOTPATH . "include/safe.php";
//Variabelen
// *** Needed for privacy filter ***
include_once CMS_ROOTPATH . "include/settings_global.php";
//Variables
include_once CMS_ROOTPATH . "include/settings_user.php";
// USER variables
include_once CMS_ROOTPATH . "include/person_cls.php";
include_once CMS_ROOTPATH . "include/db_functions_cls.php";
$db_functions = new db_functions();
// *** Database ***
$datasql = $db_functions->get_trees();
//$num_rows=count($datasql);
foreach ($datasql as $dataDb) {
// *** Check is family tree is shown or hidden for user group ***
$hide_tree_array = explode(";", $user['group_hide_trees']);
$hide_tree = false;
for ($x = 0; $x <= count($hide_tree_array) - 1; $x++) {
if ($hide_tree_array[$x] == $dataDb->tree_id) {
$hide_tree = true;
}
}
if ($hide_tree == false) {
//$person_qry = $dbh->query("SELECT * FROM ".safe_text($dataDb->tree_prefix)."person ORDER BY pers_lastname");
$person_qry = $dbh->query("SELECT * FROM humo_persons\r\n\t\t\tWHERE pers_tree_id='" . $dataDb->tree_id . "' ORDER BY pers_lastname");
//GENDEX:
//person-URL|FAMILYNAME|Firstname /FAMILYNAME/|
