if ($focus=="biography"){
?>
echo("$bioShort");
?>
if ($transcript==""){
$transcript="No bio has been supplied for this interview";
}
// echo($transcript);
echo("
");
}
?>
$interviewerBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("CoreDatabase");
$sql2="SELECT * FROM interviewinterviewerlinks WHERE peopleCollection=$seekCollection";
$result2=mysql_query($sql2, $link_id);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
$sql3="SELECT * FROM interviewContent WHERE id=$userow2[1]";
$result3=mysql_query($sql3);
while($userow3=mysql_fetch_row($result3)){
$interviewerBlock="$interviewerBlock>".$userow3[1]." ";
}
}
}
//interviewees
$intervieweeBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("CoreDatabase");
$sql2="SELECT * FROM interviewintervieweelinks WHERE peopleCollection=$seekCollection";
$result2=mysql_query($sql2);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
$sql3="SELECT * FROM interviewContent WHERE id=$userow2[1]";
$result3=mysql_query($sql3);
while($userow3=mysql_fetch_row($result3)){
$intervieweeBlock="$intervieweeBlock>".$userow3[1]." ";
}
}
}
//presentations - particiapnt
$participantBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("coredatabase");
$sql2="SELECT * FROM presentationparticipantlinks WHERE peopleCollection=$seekCollection";
$result2=mysql_query($sql2, $link_id);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
$sql3="SELECT * FROM presentationtable WHERE id=$userow2[1]";
$result3=mysql_query($sql3, $link_id);
while($userow3=mysql_fetch_row($result3)){
$participantBlock="$participantBlock>".$userow3[2]." ";
}
}
}
//presentations - attendee
$attendeeBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("coredatabase");
$sql2="SELECT * FROM presentationattendeeLinks WHERE peopleCollection=$seekCollection";
$result2=mysql_query($sql2, $link_id);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
$sql3="SELECT * FROM presentationtable WHERE id=$userow2[1]";
$result3=mysql_query($sql3, $link_id);
while($userow3=mysql_fetch_row($result3)){
$attendeeBlock="$attendeeBlock>".$userow3[2]." ";
}
}
}
//exhibitions - curator
$exhibitionBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
// echo($sql);
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("coredatabase");
$sql2="SELECT * FROM exhibitioncuratorlinks WHERE curator=$seekCollection";
// echo($sql2);
$result2=mysql_query($sql2);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
$sql3="SELECT * FROM exhibitiontable WHERE id=$userow2[1]";
// echo($sql3);
$result3=mysql_query($sql3, $link_id);
while($userow3=mysql_fetch_row($result3)){
$exhibitionBlock="$exhibitionBlock>".$userow3[2]." ";
}
}
}
//crumb reports - author
$reportsBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
//echo($sql);
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("coredatabase");
$sql2="SELECT * FROM pdfparticipantLinks WHERE peopleCollection=$seekCollection";
// echo($sql2);
$result2=mysql_query($sql2, $link_id);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
selectDatabase("assetdatabase");
$sql3="SELECT * FROM reportdatabase WHERE id=$userow2[1]";
// echo($sql3);
$result3=mysql_query($sql3, $link_id);
while($userow3=mysql_fetch_row($result3)){
$sql4="SELECT COUNT(*) FROM reportcollectiontable WHERE reportCollectionName='_CRUMB_REPORTS' AND reportCollectionIDs LIKE '%/$userow2[1]/%'";
// echo($sql4);
$result4=mysql_query($sql4, $link_id);
$row4=mysql_fetch_row($result4);
// echo($row4[3]);
if ($row4[0]>0){
$reportsBlock="$reportsBlock> $userow3[1] (download report) ";
}
}
}
}
//cullen guides - author
$cullenGuidesBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
//echo($sql);
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("coredatabase");
$sql2="SELECT * FROM pdfparticipantlinks WHERE peopleCollection=$seekCollection";
// echo($sql2);
$result2=mysql_query($sql2, $link_id);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
selectDatabase("assetdatabase");
$sql3="SELECT * FROM reportdatabase WHERE id=$userow2[1]";
// echo($sql3);
$result3=mysql_query($sql3, $link_id);
while($userow3=mysql_fetch_row($result3)){
$sql4="SELECT COUNT(*) FROM reportcollectiontable WHERE reportCollectionName='_CULLEN_GUIDES' AND reportCollectionIDs LIKE '%/$userow2[1]/%'";
// echo($sql4);
$result4=mysql_query($sql4);
$row4=mysql_fetch_row($result4);
// echo($row4[3]);
if ($row4[0]>0){
$cullenGuidesBlock="$cullenGuidesBlock> $userow3[1] (download report) ";
}
}
}
}
//discussion files author
$discussionArchiveBlock="";
//get presentations
selectDatabase("coredatabase");
$sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'";
//echo($sql);
$result=mysql_query($sql, $link_id);
while($userow=mysql_fetch_row($result)){
//echo("collection $userow[0] : ");
$seekCollection=$userow[0];
selectDatabase("CoreDatabase");
$sql2="SELECT * FROM pdfparticipantlinks WHERE peopleCollection=$seekCollection";
// echo($sql2);
$result2=mysql_query($sql2, $link_id);
while($userow2=mysql_fetch_row($result2)){
// echo("interview - $userow2[1]");
//now get the interview name
selectDatabase("assetdatabase");
$sql3="SELECT * FROM reportdatabase WHERE id=$userow2[1]";
// echo($sql3);
$result3=mysql_query($sql3, $link_id);
while($userow3=mysql_fetch_row($result3)){
$sql4="SELECT COUNT(*) FROM reportcollectiontable WHERE reportCollectionName='_DISCUSSION_ARCHIVE_FILES' AND reportCollectionIDs LIKE '%/$userow2[1]/%'";
// echo($sql4);
$result4=mysql_query($sql4);
$row4=mysql_fetch_row($result4);
// echo($row4[3]);
if ($row4[0]>0){
$discussionArchiveBlock="$dscussionArchiveBlock> $userow3[1] (download report) ";
}
}
}
}
if ($interviewerBlock<>""){
echo("Interviews (as interviewer): $interviewerBlock ");
}
if ($intervieweeBlock<>""){
echo("Interviews (as interviewee): $intervieweeBlock ");
}
if ($participantBlock<>""){
echo("Presentations (as participant): $participantBlock ");
}
if ($attendeeBlock<>""){
echo("Presentations (as attendee): $attendeeBlock ");
}
if ($exhibitionBlock<>""){
echo("Exhibitions (as curator): $exhibitionBlock ");
}
if ($reportsBlock<>""){
echo("Crumb Reports (as author): $reportsBlock ");
}
if ($cullenGuidesBlock<>""){
echo("Cullen Guides (as author): $cullenGuidesBlock ");
}
if ($discussionArchiveBlock<>""){
echo("Discussion Archives (as participant): $discussionArchiveBlock ");
}
?>
}
?>
| |