"); } ?>

"); //getIntervieweeNoLink($row3[0]); getIntervieweeNoLinkInterviewBoxes($row3[0]); //echo("$row3[2]"); ?>

1){ $imString=subStr($imString, 1, strLen($imString)); $ordinals=subStr($ordinals, 1, strLen($ordinals)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); $nextordSlash=strPos($ordinals,"/"); $seekordVal=subStr($ordinals, 0, ($nextordSlash)); if ($seekordVal==""){ $seekordVal=$noItem; } $noItem=$noItem+1; //echo(" ($seekordVal) *$seekVal* "); $idArray[$seekordVal]=$seekVal; $imString=subStr($imString, $nextSlash, strLen($imString)); $ordinals=subStr($ordinals, $nextordSlash, strLen($ordinals)); } global $link_id; selectDatabase("AssetDatabase"); for ($imLop=1; $imLop

6){ $imCount=1; //echo(""); } global $imString; $imString=subStr($imString, $nextSlash, strLen($imString)); } echo($imString); } function getContentInfo(){ //get interview content data global $interviewID, $title, $abstract, $dat, $transcript, $vts, $next,$prev,$userow; $interviewID=$_GET[id]; $_SESSION['imageViewerBack']=$_SERVER['REQUEST_URI']; $vts=$_GET[vt]; if ($_GET[focus]==""){ $focus="transcript"; }else{ $focus=$_GET[focus]; } selectDatabase('coreDatabase'); $sql = mysql_query("SELECT * FROM interviewContent WHERE id='$interviewID'"); global $abstract, $body, $title, $keywords, $fragments; //get presentation info while ($row = mysql_fetch_row($sql)) { $title=$row[1]; $dref=$row[2]; //$date=substr($dref,6,2).".".substr($dref,4,2).".".substr($dref,0,4); $date=substr($dref,0,4); $keywords=$row[3]; $transcript=$row[4]; $intro=$row[5]; $semID=$row[1]; $colChip=$row[7]; $transcript=str_replace(chr(13), "
", $transcript); $transcript=str_replace(" ", " ", $transcript); $transcript=str_replace(" ", " ", $transcript); $intro=str_replace(chr(13), "
", $intro); $intro=str_replace("[SQ]", "'", $intro); $transcript=str_replace("[SQ]", "'", $transcript); getIntroImageData($_GET[id]); } } function getIntroImageData(){ global $interviewID, $imInsertString, $linkurl,$userow; $imInsertString=""; selectDatabase("CoreDatabase"); $sql="SELECT * FROM InterviewIntroImageLinks WHERE interview='$interviewID'"; //echo($sql); $res=mysql_query($sql); $thisCollection=-1; while($row=mySql_fetch_row($res)){ $thisCollection=$row[2]; } //echo($theseLinks); //this is the image collection selectDatabase("AssetDatabase"); $sql = mysql_query("SELECT * FROM imageCollectionTable WHERE id=$thisCollection"); //echo("SELECT * FROM imageCollectionTable WHERE id=$thisIm"); while ($row = mysql_fetch_row($sql)) { $imString=$row[3]; } //echo($imString); //now show the images selectDatabase("AssetDatabase"); if ($imString==$nothing){ //$use="

1){ $imString=subStr($imString, 1, strLen($imString)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); $result="SELECT * FROM imageDatabase WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); $thumbWidth=$userow[6]; $thumbHeight=$userow[7]; //echo("$thumbWidth $thumbHeight"); $showThumbHeight=$thumbHeight/($thumbHeight/100); $showThumbWidth=$thumbWidth/($thumbHeight/100); $largeWidth=$userow[8]; $largeHeight=$userow[9]; //echo("$thumbWidth $thumbHeight"); $showLargeHeight=$largeHeight/($largeHeight/100); $showLargeWidth=$largeWidth/($largeHeight/100); global $use; //echo("seeval is $seekVal
"); $imInsertString=""; if($userow[16]<>$nothing){ $imInsertString="

"; } //echo($use); if ($imCount>6){ $imCount=1; //echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } //echo("

"); //end now show the images } function getIntervieweeList($thisId){ global $link_id,$imInsertString; //echo($thisId); selectDatabase("CoreDatabase"); $sql="SELECT * FROM interviewIntervieweeLinks WHERE interview=$thisId"; //echo($sql); $result=mysql_query($sql, $link_id); //echo("rsult=$result"); while ($row2=mysql_fetch_row($result)){ $personString=$row2[2]; //echo($personString); } //$sql="SELECT * FROM presentationParticipantLinks WHERE presentation=$thisId"; $result = mysql_query("SELECT * FROM peopleCollectionTable WHERE id='$personString'"); //echo($sql); //$result=mysql_query($sql, $link_id); while ($row3=mysql_fetch_row($result)){ $personCollectionString=$row3[3]; //echo("PC=$personCollectionString2"); //echo($personCollectionString2); $personCollectionString=getPersonCollectionNoLinkNoStyle($personCollectionString); } return($personCollectionString); } function getPersonCollectionNoLinkNoStyle($pc){ global $interviewHref; $out=""; //echo("got $pc
"); global $embolden, $scanText; $embolden=array(); $datCount=1; //now go through ipeople while(strLen($pc)>1){ $datString=subStr($pc, 1, strLen($pc)); //echo("
$datString"); $nextSlash=strPos($datString,"/"); //echo("nextSlas=$nextSlash"); $seekVal=subStr($datString, 0, ($nextSlash)); //echo("s=$seekVal"); selectDatabase("CoreDatabase"); $result="SELECT * FROM PeopleTable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); $scanText=" $scanText $userow[1] $userow[2] $userow[1] $userow[3] $userow[2] "; $linkDat=$userow[1]." ".$userow[3]." ".$userow[2]; $initials1=substr($userow[1],0,1); $initials2=substr($userow[2],0,1); $initials3=substr($userow[3],0,1); //echo("$initials1$initials3$initials2:"); if ($userow[3]==""){ array_push($embolden, "$userow[1] $userow[2]:"); array_push($embolden, "$initials1$initials2:"); }else{ array_push($embolden, "$userow[1] $userow[3] $userow[2]:"); array_push($embolden, "$initials1$initials3$initials2:"); } if ($datCount<>1){ $out="$out & "; } $out="$out$linkDat"; $pc=subStr($pc, $nextSlash+1, strLen($pc)); $datCount=$datCount+1; } return($out); } function insertSpecificContent(){ global $interviewID, $colChip, $title, $abstract, $dat,$date, $transcript, $vts, $embolden, $intro,$htmlpage,$prev,$next, $focus; ?>

	">

""){ ?>

" border='0' width='150' height='100'>

Interviewer: >
$embolden[$emb]"; $transcript=str_replace($find,$rep,$transcript); $intro=str_replace($find,$rep,$intro); } ?> Interviewee: >
$embolden[$emb]"; $transcript=str_replace($find,$rep,$transcript); $intro=str_replace($find,$rep,$intro); } ?>

"); echo("$row[1]"); if ($row[2]<>""){ echo(" | Email: $row[2]"); } if ($row[3]<>""){ // echo(" [$row[3]]"); } echo("
"); echo("Comment:
$row[4]"); echo("

> alert moderators"); echo("

"); // echo("

"); echo("

"); echo(""); } } ?>

Scanning original transcript (temp note to spencer!)..

"); //first do links $quote='"'; $htmlpage=str_replace("','',$htmlpage); $htmlpage=str_replace('','',$htmlpage); // echo("$htmlpage"); $enpos=1; for($lop=1; $lop<100; $lop++){ $stpos=strpos($htmlpage,"-1 && $stpos>-1){ $enpos=strpos($htmlpage,"A>",$stpos)+2; //echo("END=$enpos"); $fulllink=substr($htmlpage,$stpos,($enpos-$stpos)); //echo("LINK:$fulllink
"); $repst=strpos($fulllink,chr(34).">")+2; $repen=strpos($fulllink,""); $txt=substr($fulllink,$repst,($repen-$repst)); //echo(substr($htmlpage,$stpos,$enpos-$stpos)); //echo("full=$txt
"); if($txt!="top" && $txt!="here"){ $fulllink=str_replace(""); $enpos=0; $stpos=0; for($lop=1; $lop<100; $lop++){ $stpos=strpos($htmlpage,"",$enpos); //echo("START=$stpos "); if ($enpos>-1 && $stpos>-1){ $enpos=strpos($htmlpage,'',$stpos)+4; //echo("END=$enpos"); $fulllink=substr($htmlpage,$stpos,($enpos-$stpos)); $context=substr($htmlpage,$stpos-20,($enpos-($stpos-20))); //echo("italic:$fulllink
"); //echo("context:$context
"); //$repst=strpos($fulllink,chr(34).">")+2; //$repen=strpos($fulllink,""); $txt=$fulllink; $txt=str_replace("","",$txt); $txt=str_replace('',"",$txt); //echo(substr($htmlpage,$stpos,$enpos-$stpos)); //echo("full=$txt
"); if($txt!="top" && $txt!="here" && $txt!="is" && $txt!="can" && $txt!="are" && $txt!="not" && $txt!="for" && $txt!="by" && $txt!="all"){ //echo($txt." - ".$fulllink."
"); $transcript=str_replace(trim($txt),trim($fulllink),$transcript); $intro=str_replace(trim($txt),trim($fulllink),$intro); //$fulllink=str_replace("

"); } ?>

1){ $imString=subStr($imString, 1, strLen($imString)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); $result="SELECT * FROM imageDatabase WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); $thumbWidth=$userow[6]; $thumbHeight=$userow[7]; //echo("$thumbWidth $thumbHeight"); $showThumbHeight=$thumbHeight/($thumbHeight/100); $showThumbWidth=$thumbWidth/($thumbHeight/100); $largeWidth=$userow[8]; $largeHeight=$userow[9]; //echo("$thumbWidth $thumbHeight"); $showLargeHeight=$largeHeight/($largeHeight/100); $showLargeWidth=$largeWidth/($largeHeight/100); global $use, $imInsertString; //echo("seeval is $seekVal
"); //$imInsertString=""; if($userow[16]<>$nothing){ $imInsertString="

6){ $imCount=1; //echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } //echo("

"); //end now show the images } function getInterviewTabs(){ global $link_id, $tabCount; $id=$_GET[id]; $tabcount=0; $interviewID=$_GET[id]; $refArray = array("transcript","images","sound","video","links","comments"); $dbArray=array("CoreDatabase","CoreDatabase","CoreDatabase","CoreDatabase","CoreDatabase","CoreDatabase","CoreDatabase"); $queryArray=array("SELECT * FROM interviewContent WHERE id='$id'","SELECT imageCollection FROM interviewarchiveimagelinks WHERE interview='$id'","SELECT soundCollection FROM interviewsoundlinks WHERE interview='$id'", "SELECT videoCollection FROM interviewvideolinks WHERE interview='$id'","SELECT linkCollection FROM interviewlinklinks WHERE interview='$id'","SELECT * FROM usercomments WHERE articleType='Interview' AND inReplyTo='-1' AND articleId='$interviewID'"); ?> "); } } } ?>

1){ $imString=subStr($imString, 1, strLen($imString)); $ordinals=subStr($ordinals, 1, strLen($ordinals)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); $nextordSlash=strPos($ordinals,"/"); $seekordVal=subStr($ordinals, 0, ($nextordSlash)); if ($seekordVal==""){ $seekordVal=$noItem; } $noItem=$noItem+1; //echo(" ($seekordVal) *$seekVal* "); $idArray[$seekordVal]=$seekVal; $imString=subStr($imString, $nextSlash, strLen($imString)); $ordinals=subStr($ordinals, $nextordSlash, strLen($ordinals)); } //echo($imString); //now show the images selectDatabase("AssetDatabase"); echo(""); $imCount=1; for ($imLop=1; $imLop"); ?> 3){ $imCount=1; echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } echo("

"); //echo("

"); //end now show the images } ?> "); //echo($sql); //echo($sql); $res=mysql_query($sql); $thisCollection=-1; while($row=mySql_fetch_row($res)){ $thisCollection=$row[0]; } //echo($theseLinks); //this is the image collection selectDatabase("AssetDatabase"); $sql = mysql_query("SELECT * FROM videoCollectionTable WHERE id='$thisCollection'"); //echo("SELECT * FROM imageCollectionTable WHERE id=$thisCollection"); while ($row = mysql_fetch_row($sql)) { $imString=$row[3]; } //echo($imString); //now show the images selectDatabase("AssetDatabase"); echo(""); $imCount=1; //now go through imstring while(strLen($imString)>1){ $imString=subStr($imString, 1, strLen($imString)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); $result="SELECT * FROM videoDatabase WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); $thumbWidth=$userow[6]; $thumbHeight=$userow[7]; //echo("$thumbWidth $thumbHeight"); if ($thumbHeight==0){ $thumbHeight=1; } if ($thumbWidth==0){ $thumbWidth=1; } $showThumbHeight=$thumbHeight/($thumbHeight/90); $showThumbWidth=$thumbWidth/($thumbHeight/90); $largeWidth=$userow[8]; $largeHeight=$userow[9]; $vidid=$seekVal; $vidtitle=$userow[1]; if ($largeHeight==0){ $largeHeight=1; } if ($largeWidth==0){ $thumbWidth=1; } //echo("$thumbWidth $thumbHeight"); $showLargeHeight=$largeHeight/($largeHeight/90); $showLargeWidth=$largeWidth/($largeHeight/90); ?> 6){ $imCount=1; echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } echo("

"); //echo("

"); //end now show the images //echo("seeval is $seekVal
"); } ?>
"); $imCount=1; //now go through imstring while(strLen($imString)>1){ $imString=subStr($imString, 1, strLen($imString)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); selectDatabase("AssetDatabase"); $result="SELECT * FROM soundDatabase WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); //$linkDat=$userow[2]."
> ".$userow[1]."

"; echo("> $userow[1]"); if ($userow[1]<>""){echo(" - ");} echo(" $userow[2]
"); $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } } function dumpLinkCollection($thisDB, $thisSql){ //echo($thisSql); $wid=$_GET[id]; selectDatabase($thisDB); $sql=$thisSql; //echo($sql); $result = mysql_query($sql); $linkrow=mysql_fetch_row($result); $linkID=$linkrow[0]; //echo("linkID=$linkID"); selectDatabase("AssetDatabase"); $sql = mysql_query("SELECT * FROM linkCollectionTable WHERE id=$linkID"); //echo("SELECT * FROM linkCollectionTable WHERE id=$linkID"); //echo("SELECT * FROM imageCollectionTable WHERE id=$thisIm"); while ($row = mysql_fetch_row($sql)) { $imString=$row[3]; } //echo($imString); $imCount=1; //now go through imstring while(strLen($imString)>1){ $imString=subStr($imString, 1, strLen($imString)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); selectDatabase("AssetDatabase"); $result="SELECT * FROM linkTable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); //$linkDat=$userow[2]."
> ".$userow[1]."

"; echo("> $userow[1]"); if ($userow[1]<>""){ if ($userow[3]<>""){ echo(" - $userow[3]"); }else{ echo(""); } } echo("

"); $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } } ?>