session_start();
include "shared.php";
initialise();
?>
$showList=$_GET[showList];
if ($showList==1){
insertHead("CRUMB Seminars - Main Menu");
}else{
insertHead("CRUMB Seminars - $title");
}
?>
| | |
if ($showList==1){
insertSeminarMainMenu();
}else{
insertSeminarSpecificContent();
}
?>
| | | |
| | | | | | |
function initialise(){
$_SESSION['open']=$_GET[op];
$_SESSION['adminBack']=$_SERVER['REQUEST_URI'];
$_SESSION['presentBack']=$_SERVER['REQUEST_URI'];
$_SESSION['imageViewerBack']=$_SERVER['REQUEST_URI'];
$_SESSION[bref]=$_SERVER['REQUEST_URI'];
//get seminar content data
global $semID, $title, $abstract, $dat, $dref,$focus, $scanText, $semLink, $colChip, $line2Text,$line3Text, $scanText,$subtitle;
$semID=$_GET[id];
$focus=$_GET[focus];
$line2Text="Main Menu";
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, subtitle FROM seminarTable WHERE id='$semID'");
$num_rows = mysql_num_rows($sql);
while ($row = mysql_fetch_row($sql)) {
$title=$row[0];
$line3Text=$row[5];
if ($title<>""){
$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;
}
?>
function insertSeminarMainMenu(){
//some useful variables for setting table spacing
$tableSideSpace=50;
$tableBottomSpace=20;
selectDatabase("CoreDatabase");
$selItem=$_GET[id];
$sql3="SELECT * FROM seminarTable ORDER BY Date DESC";
$result3=mysql_query($sql3);
$sublink=0;
$subCount=0;
?>
|
global $colChip, $scanText;
while ($row3=mysql_fetch_row($result3)) {
$colChip=$row3[4];
$subCount=$subCount+1;
$sublink=$sublink+1;
if ($subCount==3){
$subCount=1;
echo(" |
| |
| ");
}
?>
| |
}
?>
|
|
}
?>
function insertSemFrontImage($thisID){
global $semLink, $colChip;
selectDatabase("CoreDatabase");
$sql="SELECT * FROM seminarintroimagelinks WHERE Seminar='$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];
$ordinals=$row[4]."/";
}
//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));
}
//now show the images
//now show the images
selectDatabase("AssetDatabase");
for ($imLop=1; $imLop
if ($imCount>6){
$imCount=1;
//echo("");
}
$imString=subStr($imString, $nextSlash, strLen($imString));
}
}
//echo("seeval is $seekVal
");
?>
function insertSeminarSpecificContent(){
global $imInsertString, $focus,$title,$subtitle,$dref;
getIntroImageData($_GET[id]);
?>