"; for($i=0;$i<2*$offset;$i++) { echo "  "; } if($row_ie[EVNT_TYPE]!=71) { echo "$row_ie[LIBELLE_TYPE] : $row_ie[LIBELLE_EVNT]"; } else { echo "$row_ie[LIBELLE_EVNT]"; } } info_evnt($row_ie[EVNT_ID],1,$offset+1); } } $INDIVIDU=$_REQUEST["INDIVIDU"]; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $result_ind = mysql_query( "select * from INDIVIDUS where ID_INDIVIDU='$INDIVIDU'"); $row_ind = mysql_fetch_array($result_ind); $result_patro = mysql_query( "select * from PATRONYMES where ID_PATRONYME='$row_ind[ID_PATRONYME]'"); $row_patro = mysql_fetch_array($result_patro); echo "

$row_ind[PRENOM] $row_patro[LIBELLE]

"; affiche_lien_arbre($INDIVIDU); echo "

"; display_lng_text("DETAIL_IND_INFOS"); echo "

"; $result_par = mysql_query( "select INDIVIDUS.ID_INDIVIDU as ID_IND, INDIVIDUS.PRENOM, PATRONYMES.LIBELLE from INDIVIDUS, PATRONYMES where ID_INDIVIDU='$row_ind[ID_PERE]' and PATRONYMES.ID_PATRONYME=INDIVIDUS.ID_PATRONYME"); if($row_par = mysql_fetch_array($result_par)) { echo "

 "; display_lng_text("DETAIL_IND_FATHER"); echo " : $row_par[PRENOM] $row_par[LIBELLE]
"; } $result_par = mysql_query( "select INDIVIDUS.ID_INDIVIDU as ID_IND, INDIVIDUS.PRENOM, PATRONYMES.LIBELLE from INDIVIDUS, PATRONYMES where ID_INDIVIDU='$row_ind[ID_MERE]' and PATRONYMES.ID_PATRONYME=INDIVIDUS.ID_PATRONYME"); if($row_par = mysql_fetch_array($result_par)) { echo "

 "; display_lng_text("DETAIL_IND_MOTHER"); echo " : $row_par[PRENOM] $row_par[LIBELLE]
"; } if($row_ind[ID_PAYS_NAISSANCE]!="999999") { if($row_ind[ID_ZONE_NAISSANCE]!="999999") { if($row_ind[ID_VILLE_NAISSANCE]!="999999") { $result_lieu = mysql_query( "select VILLES.LIBELLE as LIB_VILLE, PAYS.LIBELLE as LIB_PAYS, ZONES.LIBELLE as LIB_ZONE from PAYS, ZONES, VILLES where PAYS.ID_PAYS='$row_ind[ID_PAYS_NAISSANCE]' and ZONES.ID_ZONE='$row_ind[ID_ZONE_NAISSANCE]' and VILLES.ID_VILLE='$row_ind[ID_VILLE_NAISSANCE]' and PAYS.ID_PAYS=ZONES.ID_PAYS and VILLES.ID_ZONE=ZONES.ID_ZONE"); if($row_lieu = mysql_fetch_array($result_lieu)) { echo "

 "; display_lng_text("DETAIL_IND_BIRTH_PLACE"); echo " : $row_lieu[LIB_PAYS] - $row_lieu[LIB_ZONE] - $row_lieu[LIB_VILLE]
"; } } else { $result_lieu = mysql_query( "select PAYS.LIBELLE as LIB_PAYS, ZONES.LIBELLE as LIB_ZONE from PAYS, ZONES where PAYS.ID_PAYS='$row_ind[ID_PAYS_NAISSANCE]' and ZONES.ID_ZONE='$row_ind[ID_ZONE_NAISSANCE]' and PAYS.ID_PAYS=ZONES.ID_PAYS"); if($row_lieu = mysql_fetch_array($result_lieu)) { echo "

 "; display_lng_text("DETAIL_IND_BIRTH_PLACE"); echo " : $row_lieu[LIB_PAYS] - $row_lieu[LIB_ZONE]
"; } } } else { $result_lieu = mysql_query( "select PAYS.LIBELLE as LIB_PAYS from PAYS where PAYS.ID_PAYS='$row_ind[ID_PAYS_NAISSANCE]'"); if($row_lieu = mysql_fetch_array($result_lieu)) { echo "

 "; display_lng_text("DETAIL_IND_BIRTH_PLACE"); echo " : $row_lieu[LIB_PAYS]
"; } } } $result = mysql_query( "select EVENEMENTS_TYPE.LIBELLE as LIBELLE_TYPE, EVENEMENTS.LIBELLE as LIBELLE_EVNT, EVENEMENTS.ID_EVENEMENT as EVNT_ID, IND_LINK from EVENEMENTS, EVENEMENTS_TYPE where ID_PERE='$INDIVIDU' and TYPE_PERE=0 and EVENEMENTS_TYPE.ID_TYPE_EVENT=EVENEMENTS.TYPE order by EVENEMENTS.ID_EVENEMENT"); while($row = mysql_fetch_array($result)) { echo "

 $row[LIBELLE_TYPE] : $row[LIBELLE_EVNT]"; if($row[IND_LINK]!=-1) { display_lng_text("DETAIL_IND_WITH"); echo " "; affiche_lien_individu($row[IND_LINK]); } info_evnt($row[EVNT_ID],1,1); } $nb_enfants=0; $result_ind = mysql_query( "select INDIVIDUS.ID_INDIVIDU as ID_IND, INDIVIDUS.PRENOM, PATRONYMES.LIBELLE from INDIVIDUS, PATRONYMES where (ID_PERE='$INDIVIDU' or ID_MERE='$INDIVIDU') and PATRONYMES.ID_PATRONYME=INDIVIDUS.ID_PATRONYME"); while($row_ind = mysql_fetch_array($result_ind)) { if($nb_enfants==0) { echo "

"; display_lng_text("DETAIL_IND_CHILD"); echo "

"; } echo "

 $row_ind[LIBELLE] $row_ind[PRENOM]
"; $nb_enfants++; } affiche_pied_page(true); ?>