// ************************************************** 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/|