session_start();
include "shared.php";
initialise();
?>
insertHead("CRUMB - Practical Resources -Reports");
?>
insertTopBlock("CRUMB Practical Resources","Reports");
?>
| | |
insertContent();
?>
| | | |
| | | | | | |
function insertContent(){
global $scanText;
?>
|
dumpReportCollection("AssetDatabase","SELECT * FROM reportcollectiontable WHERE reportCollectionName='_CRUMB_REPORTS'");
?>
|
}
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;
?>
|
|
}
}
?>