collection $row5[0]
"); $sql6="SELECT Seminar, presentationCollection from seminarpresentationlinks WHERE presentationCollection=$row5[0]"; $result6=mysql_query($sql6); //($sql6); while ($row6 = mysql_fetch_row($result6)) { // echo("seminar:$row6[0] $row6[1]
"); $sql7="Select COUNT(id) From seminarTable WHERE id=$row6[0]"; // echo($sql7); $result7=mysql_query($sql7); $res=mysql_fetch_row($result7); // echo("res=$res[0]"); if($res[0]>0){ $sID=$row6[0]; } } } $origsID=$sID; } $line2Text="Main Menu"; $prev=-1; $next=-1; getSeminarSessionsforwardback(); global $getnext, $nextref, $lastref,$lastid; selectDatabase('coreDatabase'); $sql = mysql_query("SELECT * FROM presentationtable WHERE id='$presID'"); global $abstract, $body, $title, $keywords, $fragments, $presID, $date,$dref; //get presentation info while ($row = mysql_fetch_row($sql)) { $abstract=$row[6]; //echo($abstract); $title=$row[2]; $line2Text=$title; $body=$row[7]; $keywords=$row[9]; $fragments=$row[8]; $presID=$row[0]; $semID=$row[1]; $dref=$row[3]; $date=substr($dref,6,2).".".substr($dref,4,2).".".substr($dref,0,4); $sql = mysql_query("SELECT TITLE FROM seminarTable WHERE id='$semID'"); $row = mysql_fetch_row($sql); $semTitle=$row[0]; $body=str_replace(chr(13), "
", $body); $scanText=" $title $abstract $body $keywords $fragments "; } $showList=$_GET[showList]; // $showList=1; if ($showList==1){ $_SESSION['presentBack']=$_SERVER['REQUEST_URI']; } //get seminar content data global $semID, $title, $abstract, $dat, $focus, $scanText, $semLink, $colChip; //$semID=$_GET[id]; $semID=$origsID; $focus=$_GET[focus]; selectDatabase("CoreDatabase"); // now get all participant ID values for this item mysql_query("ALTER TABLE seminarTable ADD colChip TEXT"); $sql = mysql_query("SELECT title, abstract, date, colChip FROM seminarTable WHERE id='$semID'"); $num_rows = mysql_num_rows($sql); while ($row = mysql_fetch_row($sql)) { //$title=$row[0]; //$abstract=$row[1]; //$dat=$row[2]; $colChip=$row[3]; //echo("hello $colChip"); if($colChip==""){ $colChip="#FFFFFF"; } } //$scanText="$scanText $abstract $title "; getIntroImageData($_GET[presID]); } function getSeminarSessionsforwardback(){ global $link_id,$prev,$next,$origsID,$currentPresID, $suff, $suff2, $prev, $next; selectDatabase("CoreDatabase"); $query="SELECT * FROM seminarpresentationlinks WHERE Seminar=$origsID"; //echo($query); $result = mysql_query($query, $link_id); while($row = mysql_fetch_row($result)) { $presColID=$row[2]; } if ($presColID<>""){ $query="SELECT * FROM seminarpresentationlinks WHERE Seminar=$origsID"; //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 "); if($getnext==1){ $nextref=$row[0]; $next=$row[0]; $getnext=0; } if($currentPresID==$_GET[presID]){ $lastref=$lastid; $prev=$lastid; $getnext=1; } $lastid=$row[0]; ?> 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 } ?>