""){
if ($scount<24){
echo "$row[1] ";
}
$scount++;
}
}
}
function insertTopBlock($topLine, $subLine){
?>
search
0){
//echo("start=$stpos ");
//echo("end=$enpos ");
//echo("raw=".substr($raw,$stpos,$enpos-$stpos)." ");
$raw=substr($raw,$stpos,$enpos-$stpos);
//echo("raw=$raw ");
}
$temp=$pg;
//$temp=str_replace($raw,"",$temp);
//echo("temp=$temp ");
$temp2=str_replace($raw,"",$temp);
//echo("temp2=$temp2 ");
if($temp2==""){
$temp2=$row2[5];
}
$result = mysql_query("SELECT * FROM PAGEHits WHERE yr='$y' AND month='$m' AND dy='$d' AND PAGE='$temp2'");
$num_rows = mysql_num_rows($result);
if($num_rows==0){
$sql="INSERT INTO PAGEHits (yr,month,hits,dy,PAGE ) VALUES('$y','$m',1,'$d','$temp2')";
$result2 = mysql_query($sql);
}else{
$result = mysql_query("SELECT * FROM PAGEHits WHERE yr='$y' AND month='$m' AND dy='$d' AND PAGE='$temp2'");
$row=mysql_fetch_row($result);
$curval=$row[3];
$curval=($curval+1);
//echo("incremented is ".$curval);
$query="UPDATE PAGEHits set yr='$y', month='$m', hits=$curval, dy='$d', PAGE='$temp2' WHERE id='$row[0]'";
$result=mysql_query($query);
}
//now log hosts
//now deal with USER AGENT TRACKING
$sql="CREATE TABLE HOSTHits (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, hits INT)";
$result = mysql_query($sql);
mysql_query("ALTER TABLE HOSTHits ADD dy TEXT");
mysql_query("ALTER TABLE HOSTHits ADD HOST TEXT");
$m=date("m");
$y=date("y");
$d=date("d");
$pg=$_SERVER['REMOTE_ADDR'];
$result = mysql_query("SELECT * FROM HOSTHits WHERE yr='$y' AND month='$m' AND dy='$d' AND HOST='$pg'");
$num_rows = mysql_num_rows($result);
if($num_rows==0){
$sql="INSERT INTO HOSTHits (yr,month,hits,dy,HOST ) VALUES('$y','$m',1,'$d','$pg')";
$result2 = mysql_query($sql);
}else{
$result = mysql_query("SELECT * FROM HOSTHits WHERE yr='$y' AND month='$m' AND dy='$d' AND HOST='$pg'");
$row=mysql_fetch_row($result);
$curval=$row[3];
$curval=($curval+1);
//echo("incremented is ".$curval);
$query="UPDATE HOSTHits set yr='$y', month='$m', hits=$curval, dy='$d', HOST='$pg' WHERE id='$row[0]'";
$result=mysql_query($query);
}
//finally look for where linked from
$sql="CREATE TABLE REFHits (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, hits INT)";
$result = mysql_query($sql);
mysql_query("ALTER TABLE REFHits ADD dy TEXT");
mysql_query("ALTER TABLE REFHits ADD REF TEXT");
$m=date("m");
$y=date("y");
$d=date("d");
$pg=$_SERVER['HTTP_REFERER'];
$stpos=strpos($pg,"crumb.sunderland.ac.uk/~admin/beta");
if($stpos==false){
//echo("$pg tracking $stpos");
$result = mysql_query("SELECT * FROM REFHits WHERE yr='$y' AND month='$m' AND dy='$d' AND REF='$pg'");
$num_rows = mysql_num_rows($result);
if($num_rows==0){
$sql="INSERT INTO REFHits (yr,month,hits,dy,REF ) VALUES('$y','$m',1,'$d','$pg')";
$result2 = mysql_query($sql);
}else{
$result = mysql_query("SELECT * FROM REFHits WHERE yr='$y' AND month='$m' AND dy='$d' AND REF='$pg'");
$row=mysql_fetch_row($result);
$curval=$row[3];
$curval=($curval+1);
//echo("incremented is ".$curval);
$query="UPDATE REFHits set yr='$y', month='$m', hits=$curval, dy='$d', REF='$pg' WHERE id='$row[0]'";
$result=mysql_query($query);
}
}
}
}
}
function insertFinalSideMenu(){
if(1==1){
gatherInfo(); //page tracking
?>
$row[5]){
?>
9){ //this is generic items insert
insertGenericMenuItems($row[5]);
}
if ($row[2]=="Interviews"){
insertInterviews();
}
if ($row[2]=="Seminars"){
insertSeminars();
}
if ($row[2]=="Links & Bibliographies"){
insertBibliographies();
}
if ($row[2]=="CRUMB Outputs"){
insertBibliographies();
}
//END OF OPEN SUBMENUS
?>
CRUMB :: admin | shell | face | face2
Curatorial Resource for Upstart Media Bliss
Previous Posts:
Dec 10, 2005
Oct 15, 2005
Choice Links:
for curators
for theorists
for technicians
NEW! Dec 2005: Spencer has finished the website
This is the good news that Spencer has finished the website
- and now he can go to bed.
search
About CRUMB
News
Bios, contacts, etc
Discussion List
CRUMB Interviews
CRUMB Seminars
Practical Resources
Publications
Links & Bibliographies
Advanced Search
");
}
echo"";
}
if ($row[2]=="Seminars"){
selectDatabase("CoreDatabase");
$selItem=$_GET[id];
$sql3="SELECT * FROM seminarTable ORDER BY Date";
$result3=mysql_query($sql3);
$sublink=0;
echo("
");
while ($row3=mysql_fetch_row($result3)) {
$sublink=$sublink+1;
//if ($row3[0]==$selItem){
if (($sublink==$_GET[sublink] && $_SESSION['noarrow']<>1)){
echo("
");
}
if ($row[2]==""){
$sql2="SELECT * FROM sideMenu where subLink='$row[5]' ORDER BY ordinal";
$result2=mysql_query($sql2);
$sublink=0;
while ($row2=mysql_fetch_row($result2)) {
$sublink=$sublink+1;
echo("
");
if ($sublink==$_GET[sublink] && $_SESSION['noarrow']<>1){
echo("
");
selectDatabase('CoreDatabase');
$SQL="SELECT * FROM newsDB WHERE visible='1' ORDER BY itemDate DESC";
$result=mysql_query($SQL);
$firstRef="";
while($thisRow=mysql_fetch_row($result)){
if ($firstRef==""){
$firstRef=$thisRow[3];
}
$authID=$row[1];
$title=$thisRow[2];
$date=$thisRow[3];
$y=substr($date,0,4);
$m=substr($date,4,2);
$d=substr($date,6,2);
$m=$months[$m-1];
$abstract=$thisRow[4];
$detail=$thisRow[5];
echo("");
if ($thisRow[0]==$_GET[id]){
echo(">");
}else{
echo(" ");
}
echo(" $m $d, $y ");
}
}
if($type=="isNews"){
echo("
");
}
if($type=="isPresentation"){
global $firstId;
echo(" Other presentations from this seminar: ");
selectDatabase("CoreDatabase");
$query2="SELECT * FROM presentationCollectionTable WHERE presentationCollectionIDs LIKE '%/".$_GET[presID]."/%'";
//echo($query2);
$result2= mysql_query($query2);
while($row2 = mysql_fetch_row($result2)) {
$firstId=$row2[0];
}
$query="SELECT * FROM SeminarPresentationLinks WHERE presentationCollection='$firstId'";
//echo($query);
$result = mysql_query($query);
while($row = mysql_fetch_row($result)) {
$semId=$row[1];
}
global $link_id;
selectDatabase("CoreDatabase");
$query="SELECT * FROM SeminarPresentationLinks WHERE Seminar=$semId";
//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=$semId";
//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);
$month=$months[$m];
$yr=substr($thisDate,6,4);
$dy=substr($thisDate,0,2);
echo(" $dy $month $yr
";
if ($row[1]<>""){
echo("");
}
}
echo("");
}
function getPresentationCollections(){
//Now get the drop down for presentation collections
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("CoreDatabase");
$sql = mysql_query("SELECT * FROM presentationCollectionTable");
echo("");
}
function getEveningEventCollections(){
//Now get the drop down for presentation collections
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("CoreDatabase");
$sql = mysql_query("SELECT * FROM eventCollectionTable");
echo("");
}
function getLInks(){
//Now get the drop down for link collections
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("AssetDatabase");
$sql = mysql_query("SELECT * FROM linkCollectionTable ORDER BY linkCollectionName");
echo("");
}
function getDocuments(){
//Now get the drop down for link collections
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("AssetDatabase");
$sql = mysql_query("SELECT * FROM documentTable");
echo("");
}
function getWork(){
//Now get the drop down for link collections
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("AssetDatabase");
$sql = mysql_query("SELECT * FROM workCollectionTable");
echo("");
}
function getWorks(){
//Now get the drop down for link collections
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("AssetDatabase");
$sql = mysql_query("SELECT * FROM workCollectionTable");
echo("");
}
function getMetaLInks(){
//Now get the drop down for link collections
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("AssetDatabase");
$sql = mysql_query("SELECT * FROM metaLinkCollectionTable");
echo("");
}
function getPresentationLInks(){
//Now get the drop down for images
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("CoreDatabase");
$sql = mysql_query("SELECT * FROM presentationCollectionTable");
echo("");
}
function getEveningEventLInks(){
//Now get the drop down for images
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("CoreDatabase");
$sql = mysql_query("SELECT * FROM eventCollectionTable");
echo("");
}
function getPeopleCollection(){
//Now get the drop down for images
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("CoreDatabase");
$sql = mysql_query("SELECT * FROM peopleCollectionTable ORDER BY peopleCollectionName");
echo("");
}
function getAllLInks(){
//Now get the drop down for links
global $link_id, $dbname, $debug;
$task=$_POST[task];
selectDatabase("AssetDatabase");
$sql = mysql_query("SELECT * FROM linkTable");
echo("");
}
function testQuery($thisDB, $thisQuery){
global $countVal, $link_id, $summary;
//echo($thisDB);
selectDatabase($thisDB);
$retVal="F";
//echo($thisQuery);
$result=mySql_query(($thisQuery),$link_id);
while($row9=mysql_fetch_row($result)){
$countVal=$row9[0];
if ($row9[0]!=0){
$retVal="T";
//echo($thisContentQuery);
}
}
//echo($thisQuery." ".$retVal);
return($retVal);
}
function testQuery2($thisDB, $thisQuery, $thisContentQuery, $thisType){
global $countVal, $link_id, $summary, $showFull, $firstFlag;
//echo($thisDB);
selectDatabase($thisDB);
$retVal="F";
//echo($thisQuery);
$result=mySql_query($thisQuery);
while($row9=mysql_fetch_row($result)){
$countVal=$row9[0];
if ($row9[0]!=0){
$retVal="T";
//echo($thisContentQuery);
$contentResult=mySql_query($thisContentQuery);
$contCount=0;
while($row10=mysql_fetch_row($contentResult) AND $contCount<4){
//echo($row10[0]);
//$summary="$summary $row10[1] ";
//echo("thistype=$thisType");
if ($thisType<>$lastType){
$lastType=$thisType;
if ($row9[0]>0){
if (1==1){
//$summary="$summary
";
//$summary
if ($showFull<>""){
//$summary="$summary
1){
echo("");
}else{
echo("");
}
if($row2[2]=="http://www.jiscmail.ac.uk/lists/new-media-curating.html"){
echo("$row2[1] ");
}else{
echo("$row2[1] ");
}
}
}
if ($row[2]=="Seminars"){
selectDatabase("CoreDatabase");
$selItem=$_GET[id];
$sql3="SELECT * FROM seminarTable ORDER BY Date";
$result3=mysql_query($sql3);
$sublink=0;
while ($row3=mysql_fetch_row($result3)) {
$sublink=$sublink+1;
//if ($row3[0]==$selItem){
if (($sublink==$_GET[sublink] && $_SESSION['noarrow']<>1)){
echo("");
}else{
echo("");
}
echo("$row3[2] ");
}
}
if ($row[2]=="Interviews"){
selectDatabase("CoreDatabase");
$selItem=$_GET[id];
$sql3="SELECT * FROM interviewcontent ORDER BY date";
$result3=mysql_query($sql3);
$sublink=0;
echo("
");
while ($row3=mysql_fetch_row($result3)) {
$sublink=$sublink+1;
// if ($row3[0]==$selItem){
//if ($row3[0]==$selItem){
if ($sublink==$_GET[sublink] && $_SESSION['noarrow']<>1){
echo("
");
$eID=$_GET[showExhib];
selectDatabase('CoreDatabase');
$SQL="SELECT * FROM exhibitionWorkLinks WHERE exhibition=$eID";
// echo($SQL);
$result = mysql_query($SQL, $link_id);
$row=mysql_fetch_row($result);
$workCollection=$row[2];
// echo(" work collection=$workCollection");
$SQL="SELECT * FROM exhibitionWorkLinks WHERE exhibition=$eID";
// echo($SQL);
$result = mysql_query($SQL, $link_id);
$row=mysql_fetch_row($result);
$workCollection=$row[2];
// echo(" work collection=$workCollection");
if ($workCollection<>""){
selectDatabase("AssetDatabase");
//echo("SELECT * FROM workCollectionTable WHERE id=$theseLinks");
$sql=mysql_query("SELECT * FROM workCollectionTable WHERE id=$workCollection");
while ($row = mysql_fetch_row($sql)) {
$imString=$row[3];
}
//echo("$imString ");
$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("CoreDatabase");
$result="SELECT * FROM workTable WHERE id='$seekVal'";
//echo($result);
$sql=mysql_query($result);
$userow=mysql_fetch_row($sql);
$linkDat="$userow[1]";
$thisWork=$userow[0];
//get artists
selectDatabase("CoreDatabase");
$imagesSoFar="";
$imcountA=1;
$getWorkNameSQLA="SELECT title from workTable where id='$thisWork'";
//echo ("semnamesql is $getWorkNameSQL");
$namresultsA=mysql_query($getWorkNameSQLA);
$rowA=mysql_fetch_row($namresultsA);
$artists="";
//echo(" Current artists links to the work '$row[0]' ");
$sqlPeop="SELECT * FROM worksArtistsLinks WHERE work='$thisWork'";
$peop=mysql_query($sqlPeop);
$rowP=mysql_fetch_row($peop);
$pid=$rowP[2];
selectDatabase("CoreDatabase");
$sqlA = mysql_query("SELECT * FROM peopleCollectionTable WHERE id=$pid");
if ($sqlA){
while ($rowA = mysql_fetch_row($sqlA)) {
$imStringA=$rowA[3];
}
//echo(" ");
$imCountA=1;
//now go through imstring
while(strLen($imStringA)>1){
$imStringA=subStr($imStringA, 1, strLen($imStringA));
//echo(" $imString");
$nextSlashA=strPos($imStringA,"/");
$seekValA=subStr($imStringA, 0, ($nextSlashA));
selectDatabase("CoreDatabase");
$resultA="SELECT * FROM PeopleTable WHERE id='$seekValA'";
//echo($result);
$sqlA=mysql_query($resultA);
$userowA=mysql_fetch_row($sqlA);
$linkDatA=$userowA[1]." ".$userowA[3]." ".$userowA[2];
$artists="$artists >$linkDatA ";
$imStringA=subStr($imStringA, $nextSlashA, strLen($imStringA));
$imCountA=$imCountA+1;
}
}
//end getartists
echo("
$imCount) $linkDat
$artists
");
$imString=subStr($imString, $nextSlash, strLen($imString));
$imCount=$imCount+1;
}
}
?>
"); //added for exhibition
}
if($type=="showExhibWorks"){
echo(" All works in this exhibition:
");
global $link_id;
$eID=$_GET[showExhib];
selectDatabase('CoreDatabase');
$SQL="SELECT * FROM exhibitionWorkLinks WHERE exhibition=$eID";
// echo($SQL);
$result = mysql_query($SQL, $link_id);
$row=mysql_fetch_row($result);
$workCollection=$row[2];
// echo(" work collection=$workCollection");
$SQL="SELECT * FROM exhibitionWorkLinks WHERE exhibition=$eID";
// echo($SQL);
$result = mysql_query($SQL, $link_id);
$row=mysql_fetch_row($result);
$workCollection=$row[2];
// echo(" work collection=$workCollection");
if ($workCollection<>""){
selectDatabase("AssetDatabase");
//echo("SELECT * FROM workCollectionTable WHERE id=$theseLinks");
$sql=mysql_query("SELECT * FROM workCollectionTable WHERE id=$workCollection");
while ($row = mysql_fetch_row($sql)) {
$imString=$row[3];
}
//echo("$imString ");
$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("CoreDatabase");
$result="SELECT * FROM workTable WHERE id='$seekVal'";
//echo($result);
$sql=mysql_query($result);
$userow=mysql_fetch_row($sql);
$linkDat="";
if($_GET[exD]==$userow[0]){
$linkDat="$linkDat>";
}else{
$linkDat="$linkDat ";
}
$linkDat="$linkDat$userow[1]";
$thisWork=$userow[0];
//get artists
selectDatabase("CoreDatabase");
$imagesSoFar="";
$imcountA=1;
$getWorkNameSQLA="SELECT title from workTable where id='$thisWork'";
//echo ("semnamesql is $getWorkNameSQL");
$namresultsA=mysql_query($getWorkNameSQLA);
$rowA=mysql_fetch_row($namresultsA);
$artists="";
//echo(" Current artists links to the work '$row[0]' ");
$sqlPeop="SELECT * FROM worksArtistsLinks WHERE work='$thisWork'";
$peop=mysql_query($sqlPeop);
$rowP=mysql_fetch_row($peop);
$pid=$rowP[2];
selectDatabase("CoreDatabase");
$sqlA = mysql_query("SELECT * FROM peopleCollectionTable WHERE id=$pid");
if ($sqlA){
while ($rowA = mysql_fetch_row($sqlA)) {
$imStringA=$rowA[3];
}
//echo(" ");
$imCountA=1;
//now go through imstring
while(strLen($imStringA)>1){
$imStringA=subStr($imStringA, 1, strLen($imStringA));
//echo(" $imString");
$nextSlashA=strPos($imStringA,"/");
$seekValA=subStr($imStringA, 0, ($nextSlashA));
selectDatabase("CoreDatabase");
$resultA="SELECT * FROM PeopleTable WHERE id='$seekValA'";
//echo($result);
$sqlA=mysql_query($resultA);
$userowA=mysql_fetch_row($sqlA);
$linkDatA=$userowA[1]." ".$userowA[3]." ".$userowA[2];
$artists="$artists >$linkDatA ";
$imStringA=subStr($imStringA, $nextSlashA, strLen($imStringA));
$imCountA=$imCountA+1;
}
}
//end getartists
echo("$linkDat ");
$imString=subStr($imString, $nextSlash, strLen($imString));
$imCount=$imCount+1;
}
}
}
if($type=="showExhibs"){
global $link_id;
echo(" All exhibitions:
");
selectDatabase('CoreDatabase');
$result= mysql_query("SELECT * FROM exhibitionTable", $link_id);
while ($row = mysql_fetch_row($result)) {
echo("");
if ($_GET[id]==$row[0]){
echo(">");
}else{
echo(" ");
}
echo("$row[2] ");
}
}
if($type=="isNewsItem"){
$months=array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
echo(" Recent Postings:
");
selectDatabase('CoreDatabase');
$SQL="SELECT * FROM newsDB WHERE visible='1' ORDER BY itemDate DESC";
$result=mysql_query($SQL);
$firstRef="";
while($thisRow=mysql_fetch_row($result)){
if ($firstRef==""){
$firstRef=$thisRow[3];
}
$authID=$row[1];
$title=$thisRow[2];
$date=$thisRow[3];
$y=substr($date,0,4);
$m=substr($date,4,2);
$d=substr($date,6,2);
$m=$months[$m-1];
$abstract=$thisRow[4];
$detail=$thisRow[5];
echo("");
if ($thisRow[0]==$_GET[id]){
echo(">");
}else{
echo(" ");
}
echo(" $m $d, $y ");
}
}
if($type=="isPresentation"){
global $firstId;
echo(" Other presentations from this seminar: ");
selectDatabase("CoreDatabase");
$query2="SELECT * FROM presentationCollectionTable WHERE presentationCollectionIDs LIKE '%/".$_GET[presID]."/%'";
//echo($query2);
$result2= mysql_query($query2);
while($row2 = mysql_fetch_row($result2)) {
$firstId=$row2[0];
}
$query="SELECT * FROM SeminarPresentationLinks WHERE presentationCollection='$firstId'";
//echo($query);
$result = mysql_query($query);
while($row = mysql_fetch_row($result)) {
$semId=$row[1];
}
global $link_id;
selectDatabase("CoreDatabase");
$query="SELECT * FROM SeminarPresentationLinks WHERE Seminar=$semId";
//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=$semId";
//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);
$month=$months[$m];
$yr=substr($thisDate,6,4);
$dy=substr($thisDate,0,2);
echo(" $dy $month $yr
");
}
}
function scanForSearchTerms($thisText){
global $abstract, $overviewCreds, $work, $artist;
selectDatabase("CoreDatabase");
//echo("SELECT * FROM popularSearches WHERE phrase='$nam'");
$excludes=" a b c d e f g h i j k l m n o p q r s t u v w x y z he she it they we my your the them is us test ";
$sql = mysql_query("SELECT * FROM popularSearches ORDER BY frequency");
$keywords="";
//echo("hello");
while($row=mysql_fetch_row($sql)){
//echo("seeking $row[1]");
$term=$row[1];
$term=trim($term);
str_replace("%20"," ",$term);
str_replace(" "," ",$term);
//$biography=str_replace($work,"$work",$biography);
$t1=strtoupper(substr($term,0,1)).strtolower(substr($term,1));
//echo("t1=$t1");
//$term=trim($term);
//echo("term is $term :".$work." ".$artist." ".$overviewCreds);
if ($term<>""){
if ((strpos (" ".$thisText." ", $term)>0) or (strpos (" ".$thisText." ", $t1)>0)){
if ((strpos ($excludes, $term)<1) and ($term<>"")){
//echo("found one");
$keywords="$keywords > ".strtolower($row[1])." ";
}
}
}
}
if ($keywords<>""){
echo("
