""){ $line2Text=$title; } $abstract=$row[1]; $dat=$row[2]; $colChip=$row[3]; $subtitle=$row[4]; $restOfScan=""; // $dref=substr($dat,6,2).".".substr($dat,4,2).".".substr($dat,0,4); $dref=substr($dat,0,4); $scanText="$scanText $abstract $title "; } global $transcript; $transcript=$scanText; } ?>
 
 
 "); } ?>

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)); } //now show the images //now show the images selectDatabase("AssetDatabase"); for ($imLop=1; $imLop
6){ $imCount=1; //echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } } //echo("seeval is $seekVal
"); ?>

""){ ?>
" border='0' width='150' height='100'>
 
1){ insertBrandingImages(); } ?>
"); } } } ?>
>  
""){ $query="SELECT * FROM seminarpresentationlinks WHERE Seminar=$_GET[id]"; //echo($query); //echo("SELECT * FROM presentationCollectionTable WHERE id=$presColID"); $result = mysql_query("SELECT * FROM presentationcollectiontable WHERE id=$presColID"); while($row = mysql_fetch_row($result)) { $datString=$row[3]; } //echo($presLinks); //now go through links and create SQL Statment for getting presentation list: $SQLStr=""; $datCount=1; //now go through datString while(strLen($datString)>1){ $datString=subStr($datString, 1, strLen($datString)); //echo("
$datString"); $nextSlash=strPos($datString,"/"); $seekVal=subStr($datString, 0, ($nextSlash)); selectDatabase("CoreDatabase"); $result="SELECT * FROM presentationtable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); $userowIdRef=$userow[0]; $linkDat=$userow[1]." - ".$userow[2]."
"; if ($SQLStr<>""){ $SQLStr="$SQLStr OR "; } $SQLStr="$SQLStr id='$userow[0]'"; //echo("$datCount) $linkDat"); $datString=subStr($datString, $nextSlash, strLen($datString)); $datCount=$datCount+1; } if ($SQLStr<>""){ $SQLStr="$SQLStr ORDER BY evdate, startTime"; $SQLStr="SELECT * FROM presentationtable WHERE $SQLStr"; } //echo("hello $SQLStr

"); //now test the query $currentDate="NoDateSet"; $sql=mysql_query($SQLStr); while($row = mysql_fetch_row($sql)) { //echo($row[2]); global $curentStartTime; //echo("row 4 is $row[4]"); $currentStartTime=parseTime($row[4]); //echo("cs is $currentStartTime"); $currentTitle=$row[2]; $currentPresID=$row[0]; $thisDate=parseDate($row[3]); if ($currentDate<>$thisDate){ $months=array("January","February","March","April","May","June","July","August","September","October","November","December"); $m=substr($thisDate,3,2); //echo($m); $month=$months[((Int) $m)-1]; //$month=$months[$m]; $yr=substr($thisDate,6,4); $dy=substr($thisDate,0,2); echo("
$dy $month $yr

"); // THE NEXT BLOCK ADDS A SLOT FOR THE NEW DATE (left of table) $currentDate=$thisDate; ?> $currentDate");?> $currentStartTime - $currentEndTime "); ?> $currentTitle"); ?>
Speakers: 

""){ $query="SELECT * FROM seminarpresentationlinks WHERE Seminar=$_GET[id]"; //echo($query); //echo("SELECT * FROM presentationCollectionTable WHERE id=$presColID"); $result = mysql_query("SELECT * FROM presentationcollectiontable WHERE id=$presColID"); while($row = mysql_fetch_row($result)) { $datString=$row[3]; } //echo($presLinks); //now go through links and create SQL Statment for getting presentation list: $SQLStr=""; $datCount=1; //now go through datString while(strLen($datString)>1){ $datString=subStr($datString, 1, strLen($datString)); //echo("
$datString"); $nextSlash=strPos($datString,"/"); $seekVal=subStr($datString, 0, ($nextSlash)); selectDatabase("CoreDatabase"); $result="SELECT * FROM presentationtable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); $userowIdRef=$userow[0]; $linkDat=$userow[1]." - ".$userow[2]."
"; if ($SQLStr<>""){ $SQLStr="$SQLStr OR "; } $SQLStr="$SQLStr id='$userow[0]'"; //echo("$datCount) $linkDat"); $datString=subStr($datString, $nextSlash, strLen($datString)); $datCount=$datCount+1; } if ($SQLStr<>""){ $SQLStr="$SQLStr ORDER BY evdate, startTime"; $SQLStr="SELECT * FROM presentationtable WHERE $SQLStr"; } //echo("hello $SQLStr

"); //now test the query $currentDate="NoDateSet"; $sql=mysql_query($SQLStr); while($row = mysql_fetch_row($sql)) { //echo($row[2]); global $curentStartTime; //echo("row 4 is $row[4]"); $currentStartTime=parseTime($row[4]); //echo("cs is $currentStartTime"); $currentTitle=$row[2]; $currentPresID=$row[0]; $thisDate=parseDate($row[3]); if ($currentDate<>$thisDate){ $months=array("January","February","March","April","May","June","July","August","September","October","November","December"); $m=substr($thisdate,3,2); $month=$months[$m]; $yr=substr($thisDate,6,4); $dy=substr($thisDate,0,2); // THE NEXT BLOCK ADDS A SLOT FOR THE NEW DATE (left of table) $currentDate=$thisDate; ?> $currentDate");?> ""){ $query="SELECT * FROM seminareventlinks WHERE Seminar=$_GET[id]"; //echo($query); //echo("SELECT * FROM presentationCollectionTable WHERE id=$presColID"); $result = mysql_query("SELECT * FROM eventcollectiontable WHERE id=$presColID"); while($row = mysql_fetch_row($result)) { $datString=$row[3]; } //echo($presLinks); //now go through links and create SQL Statment for getting presentation list: $SQLStr=""; $datCount=1; //now go through datString while(strLen($datString)>1){ $datString=subStr($datString, 1, strLen($datString)); //echo("
$datString"); $nextSlash=strPos($datString,"/"); $seekVal=subStr($datString, 0, ($nextSlash)); selectDatabase("CoreDatabase"); $result="SELECT * FROM eventtable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); $userowIdRef=$userow[0]; $linkDat=$userow[1]." - ".$userow[2]."
"; if ($SQLStr<>""){ $SQLStr="$SQLStr OR "; } $SQLStr="$SQLStr id='$userow[0]'"; //echo("$datCount) $linkDat"); $datString=subStr($datString, $nextSlash, strLen($datString)); $datCount=$datCount+1; } if ($SQLStr<>""){ $SQLStr="$SQLStr ORDER BY evdate, startTime"; $SQLStr="SELECT * FROM eventtable WHERE $SQLStr"; } //echo("hello $SQLStr

"); //now test the query $currentDate="NoDateSet"; $sql=mysql_query($SQLStr); while($row = mysql_fetch_row($sql)) { //echo($row[2]); global $curentStartTime; //echo("row 4 is $row[4]"); $currentStartTime=parseTime($row[4]); //echo("cs is $currentStartTime"); $currentTitle=$row[2]; $currentDetails=$row[6]; $currentPresID=$row[0]; $thisDate=parseDate($row[3]); if ($currentDate<>$thisDate){ $months=array("January","February","March","April","May","June","July","August","September","October","November","December"); $m=substr($thisDate,3,2); //echo($m); $month=$months[((Int) $m)-1]; $yr=substr($thisDate,6,4); $dy=substr($thisDate,0,2); echo("
$dy $month $yr

"); // THE NEXT BLOCK ADDS A SLOT FOR THE NEW DATE (left of table) $currentDate=$thisDate; ?> $currentDate");?> $currentStartTime - $currentEndTime "); ?> > $currentTitle"); ?>

Details:  

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]"); $scanText="$scanText $userow[3] $userow[2] "; if($userow[3]<>""){ echo(" - "); echo("$userow[3]

"); }else{ echo("

"); } $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } echo(""); } ?>
"); $imCount=1; //now go through attendee string while(strLen($imString)>1){ $imString=subStr($imString, 1, strLen($imString)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); selectDatabase("CoreDatabase"); $result="SELECT * FROM peopletable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); //echo($userow[0].$userow[2]."
> ".$userow[1]); echo("> $userow[1] $userow[3] $userow[2]

"); $scanText=" $scanText $userow[1] $userow[3] $userow[2]"; $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } } function insertBrandingImages(){ echo("
"); global $interviewID, $link_id; selectDatabase("CoreDatabase"); $sql="SELECT * FROM seminarbrandingimagelinks WHERE seminar=$_GET[id]"; //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", $link_id); //echo("SELECT * FROM imageCollectionTable WHERE id=$thisIm"); while ($row = mysql_fetch_row($sql)) { $imString=$row[3]; } //echo($imString); //now show the images selectDatabase("AssetDatabase"); echo(""); $imCount=1; //now go through imstring $fullimdump=""; while(strLen($imString)>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]; $fullimdump="$fullimdump "; //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); //echo("seeval is $seekVal
"); ?> 6){ $imCount=1; echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } ?>

"); //end now show the images } function insertArchiveImages(){ $sql="SELECT * FROM seminararchiveimagelinks WHERE Seminar='$_GET[id]'"; //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"); } function dumpImageCollection($thisDB, $sql){ selectDatabase($thisDB); global $thisCollection, $scanText; //$sql=$thisSQL; //echo($sql); //echo($sql); $res=mysql_query($sql); $thisCollection=-1; while($row=mySql_fetch_row($res)){ $thisCollection=$row[2]; //echo("COL=$thisCollection $row[1] $row[2] $row[3]*"); } //this is the image collection selectDatabase("AssetDatabase"); $sql = mysql_query("SELECT * FROM imagecollectiontable WHERE id=$thisCollection"); //echo("SELECT * FROM imageCollectionTable WHERE id=$thisCollection"); while ($row = mysql_fetch_row($sql)) { $imString=$row[3]; $ordinals=$row[4]."/"; } //echo("DATA - $imString $ordinals"); //now get ordered list $idArray = array(); $noItem=1; while(strLen($imString)>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"); $scanText="$scanText $title "; ?> 3){ $imCount=1; echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } echo("
>
"); //echo("
"); //end now show the images } ?> 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="6){ $imCount=1; //echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } //echo("
"); //end now show the images } ?>