session_start();
include "shared.php";
initialise();
?>
insertHead("CRUMB - Edited Files");
?>
function initialise(){
$_SESSION['open']=2;
$_SESSION['lastLoc']=$_SERVER['REQUEST_URI'];
$_SESSION['bref']=$_SERVER['REQUEST_URI'];
echo('');
global $monthArray,$monthNums, $orderMonths,$orderCode,$finalorderMonths,$finalorderCode, $transcript;
$monthArray= array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
$monthNums=array("01","02","03","04","05","06","07","08","09","10","11","12");
$orderMonths=array();
$orderCode=array();
$finalorderMonths=array();
$finalorderCode=array();
}
?>
function insertEditedFiles(){
global $alltext,$monthArray,$monthNums, $orderMonths,$orderCode,$finalorderMonths,$finalorderCode, $transcript;
?>
dumpReportCollection("AssetDatabase","SELECT * FROM reportcollectiontable WHERE reportCollectionName='_DISCUSSION_ARCHIVE_FILES'");
?>
|
}
?>
function dumpReportCollection($thisDB, $thisSql){
//echo($thisSql);
global $alltext;
//$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]."
";
?>
");
$imString=subStr($imString, $nextSlash, strLen($imString));
$imCount=$imCount+1;
$alltext="$alltext $scanText ";
?>
//insertIntroImages($userow[0]);?>
}
}
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=85;
$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
}
?>