session_start();
include "shared.php";
initialise();
?>
global $title;
insertHead("CRUMB Seminars:Presentations:$title");
?>
| | |
insertPresentationContent();
?>
| | | |
| | | | | | |
function initialise(){
$_SESSION['open']=$_GET[op];
$_SESSION['adminBack']=$_SERVER['REQUEST_URI'];
global $mypage, $type;
$mypage=$_SERVER['REQUEST_URI'];
$_SESSION['bref']=$_SERVER['REQUEST_URI'];
$_SESSION['imageViewerBack']=$_SERVER['REQUEST_URI'];
$type="isPresentation";
//get spresentation content data
global $semID, $title, $abstract, $dat, $scanText,$presID,$prev,$next,$origsID;
$presID=$_GET[presID];
$semID=$_GET[semID];
$origsID=$semID;
if($semID==""){
//seek out seminar id
selectDatabase("CoreDatabase");
$sql5="SELECT * from presentationcollectiontable WHERE presentationCollectionIDs LIKE '%/$presID/%'";
//echo($sql5);
$result5=mysql_query($sql5);
while ($row5 = mysql_fetch_row($result5)) {
//echo("
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;
?>
//global $currentDate;
//echo("$currentDate");?>
//THIS ENDS THE 'CURRENT DATE IS DIFFERENT' CONDITION!
}
?>
global $currentStartTime,$lastref,$nextref,$prev,$next;
$currentStartTime=parseTime($row[4]);
$currentEndTime=parseTime($row[5]);
//echo(" $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];
?>
}}}
?>
function getIntroImageData($thisID){
global $interviewID, $imInsertString;
$imInsertString="";
selectDatabase("CoreDatabase");
$sql="SELECT * FROM presentationintroimagelinks WHERE presentation='$thisID'";
//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="6){
$imCount=1;
//echo("");
}
$imString=subStr($imString, $nextSlash, strLen($imString));
}
//echo("
");
//end now show the images
}
?>
function insertPresentationContent(){
global $imInsertString,$title,$date,$lastref,$origsID, $prev, $next, $presID,$abstract;
?>