|
selectDatabase("coreDatabase");
$selItem=$_GET[id];
$sql3="SELECT * FROM exhibitiontable";
$result3=mysql_query($sql3);
$sublink=0;
$subCount=0;
?>
global $colChip;
while ($row3=mysql_fetch_row($result3)) {
$colChip=$row3[4];
$subCount=$subCount+1;
$sublink=$sublink+1;
$dat=$row[3];
if ($subCount>=1){
$subCount=1;
echo(" | ");
}
?>
}
function getAuthors($thisId){
//echo("getting interviewer $thisId");
selectDatabase("coreDatabase");
$sql="SELECT * FROM pdfparticipantlinks WHERE pdf=$thisId";
//echo($sql);
$resultcur=mysql_query($sql);
//echo("hello");
while ($row2=mysql_fetch_row($resultcur)){
//echo("in loop");
$personString=$row2[2];
}
$resultcur = mysql_query("SELECT * FROM peoplecollectiontable WHERE id='$personString'");
//echo("SELECT * FROM peopleCollectionTable WHERE id='$personString'");
//$result=mysql_query($sql, $link_id);
while ($row3=mysql_fetch_row($resultcur)){
$personCollectionString2=$row3[3];
//echo("$row3[1]($row3[0])");
//echo("collection: $personCollectionString2");
parsePersonCollection($personCollectionString2);
}
}
function insertIntroImages($thisID){
selectDatabase("coreDatabase");
$sql="SELECT * FROM pdfintroimagelinks WHERE pdf='$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");
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 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=56;
$showThumbWidth=100;
$largeWidth=$userow[8];
$largeHeight=$userow[9];
//echo("$thumbWidth $thumbHeight");
$showLargeHeight=$largeHeight/($largeHeight/100);
$showLargeWidth=$largeWidth/($largeHeight/100);
//echo("seeval is $seekVal ");
?>
| |
if ($imCount>6){
$imCount=1;
echo(" ");
}
$imString=subStr($imString, $nextSlash, strLen($imString));
}
echo(" ");
//echo(" ");
//end now show the images
}
function initialise(){
$_SESSION['open']=5;
$_SESSION['adminBack']=$_SERVER['REQUEST_URI'];
$_SESSION['bref']=$_SERVER['REQUEST_URI'];
//get seminar content data
global $semID, $title, $abstract, $dat, $dref,$focus, $scanText, $semLink, $colChip, $line2Text, $scanText;
$semID=$_GET[id];
$focus=$_GET[focus];
}
?>
function dumpReportCollection($thisDB, $thisSql){
//echo($thisSql);
//$wid=$_GET[id];
selectDatabase($thisDB);
$sql=$thisSql;
//echo($sql);
selectDatabase("AssetDatabase");
$sql = mysql_query($sql);
//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);
//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));
selectDatabase("AssetDatabase");
$result="SELECT * FROM reportdatabase WHERE id='$seekVal'";
//echo($result);
$sql=mysql_query($result);
$userow=mysql_fetch_row($sql);
//$linkDat=$userow[2]." > ".$userow[1]."
";
echo(" | ");
?>
");
$imString=subStr($imString, $nextSlash, strLen($imString));
$imCount=$imCount+1;
?>
|
|
}
}
function getCurator($thisId){
global $scanText;
//echo("getting interviewer $thisId");
selectDatabase("coreDatabase");
$sql="SELECT * FROM exhibitioncuratorlinks WHERE exhibition=$thisId";
//echo($sql);
$resultcur=mysql_query($sql);
//echo("hello");
while ($row2=mysql_fetch_row($resultcur)){
//echo("in loop");
$personString=$row2[2];
}
$resultcur = mysql_query("SELECT * FROM peoplecollectiontable WHERE id='$personString'");
//echo("SELECT * FROM peopleCollectionTable WHERE id='$personString'");
//$result=mysql_query($sql, $link_id);
while ($row3=mysql_fetch_row($resultcur)){
$personCollectionString2=$row3[3];
//echo("$row3[1]($row3[0])");
//echo("collection: $personCollectionString2");
parsePersonCollection($personCollectionString2);
}
}
function insertExhibFrontImage($thisID){
global $semLink, $colChip;
selectDatabase("coreDatabase");
$sql="SELECT * FROM exhibitionintroimagelinks WHERE exhibition='$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("