collection $row5[0]
"); $sql6="SELECT Seminar, presentationCollection from seminarpresentationlinks WHERE presentationCollection=$row5[0]"; $result6=mysql_query($sql6); //($sql6); while ($row6 = mysql_fetch_row($result6)) { // echo("seminar:$row6[0] $row6[1]
"); $sql7="Select COUNT(id) From seminarTable WHERE id=$row6[0]"; // echo($sql7); $result7=mysql_query($sql7); $res=mysql_fetch_row($result7); // echo("res=$res[0]"); if($res[0]>0){ $sID=$row6[0]; } } } $origsID=$sID; } $line2Text="Main Menu"; $prev=-1; $next=-1; getSeminarSessionsforwardback(); global $getnext, $nextref, $lastref,$lastid; selectDatabase('coreDatabase'); $sql = mysql_query("SELECT * FROM presentationtable WHERE id='$presID'"); global $abstract, $body, $title, $keywords, $fragments, $presID, $date,$dref; //get presentation info while ($row = mysql_fetch_row($sql)) { $abstract=$row[6]; //echo($abstract); $title=$row[2]; $line2Text=$title; $body=$row[7]; $keywords=$row[9]; $fragments=$row[8]; $presID=$row[0]; $semID=$row[1]; $dref=$row[3]; $date=substr($dref,6,2).".".substr($dref,4,2).".".substr($dref,0,4); $sql = mysql_query("SELECT TITLE FROM seminarTable WHERE id='$semID'"); $row = mysql_fetch_row($sql); $semTitle=$row[0]; $body=str_replace(chr(13), "
", $body); $scanText=" $title $abstract $body $keywords $fragments "; } $showList=$_GET[showList]; // $showList=1; if ($showList==1){ $_SESSION['presentBack']=$_SERVER['REQUEST_URI']; } //get seminar content data global $semID, $title, $abstract, $dat, $focus, $scanText, $semLink, $colChip; //$semID=$_GET[id]; $semID=$origsID; $focus=$_GET[focus]; 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 FROM seminarTable WHERE id='$semID'"); $num_rows = mysql_num_rows($sql); while ($row = mysql_fetch_row($sql)) { //$title=$row[0]; //$abstract=$row[1]; //$dat=$row[2]; $colChip=$row[3]; //echo("hello $colChip"); if($colChip==""){ $colChip="#FFFFFF"; } } //$scanText="$scanText $abstract $title "; getIntroImageData($_GET[presID]); } function getSeminarSessionsforwardback(){ global $link_id,$prev,$next,$origsID,$currentPresID, $suff, $suff2, $prev, $next; selectDatabase("CoreDatabase"); $query="SELECT * FROM seminarpresentationlinks WHERE Seminar=$origsID"; //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=$origsID"; //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); //echo($m); $month=$months[((Int) $m)-1]; //$month=$months[$m]; $yr=substr($thisDate,6,4); $dy=substr($thisDate,0,2); //echo("
$dy $month $yr
"); // THE NEXT BLOCK ADDS A SLOT FOR THE NEW DATE (left of table) $currentDate=$thisDate; ?> $currentDate");?> $currentStartTime - $currentEndTime "); if($getnext==1){ $nextref=$row[0]; $next=$row[0]; $getnext=0; } if($currentPresID==$_GET[presID]){ $lastref=$lastid; $prev=$lastid; $getnext=1; } $lastid=$row[0]; ?>

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=$thumbHeight/($thumbHeight/100); //$showThumbWidth=$thumbWidth/($thumbHeight/100); $largeWidth=$userow[8]; $largeHeight=$userow[9]; //echo("$thumbWidth $thumbHeight"); //$showLargeHeight=$largeHeight/($largeHeight/100); //$showLargeWidth=$largeWidth/($largeHeight/100); global $use; //echo("seeval is $seekVal
"); $imInsertString="

6){ $imCount=1; //echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } //echo("

"); //end now show the images } ?>

"" || $imInsertString==""){ ?>

""){ ?>

" border='0' width='150' height='100'>

Speakers:> $embolden[$emb]"; $body=str_replace($find,$rep,$body); } ?>

Scanning original transcript (temp note to spencer!)..

"); $quote='"'; $keywords=str_replace("','',$keywords); $keywords=str_replace('',"",$keywords); $abstract=str_replace("','',$abstract); $abstract=str_replace('',"",$abstract); // echo("$htmlpage"); $enpos=1; for($lop=1; $lop<100; $lop++){ $stpos=strpos($keywords,"-1 && $stpos>-1){ $enpos=strpos($keywords,"A>",$stpos)+2; //echo("END=$enpos"); $fulllink=substr($keywords,$stpos,($enpos-$stpos)); //echo("LINK:$fulllink
"); $repst=strpos($fulllink,chr(34).">")+2; $repen=strpos($fulllink,""); $txt=substr($fulllink,$repst,($repen-$repst)); //echo(substr($htmlpage,$stpos,$enpos-$stpos)); //echo("full=$txt
"); if($txt!="top" && $txt!="here" && $txt!="home"){ $fulllink=str_replace(""); $body=str_replace(trim($txt),trim($fulllink),$body); $abstract=str_replace(" ".trim($txt)," ".trim($fulllink),$abstract); } }else{ $stpos=101; } } //now do italics //echo("checking italics
"); $enpos=0; $stpos=0; for($lop=1; $lop<100; $lop++){ $stpos=strpos($keywords,"",$enpos); //echo("START=$stpos "); if ($enpos>-1 && $stpos>-1){ $enpos=strpos($keywords,'',$stpos)+4; //echo("END=$enpos"); $fulllink=substr($keywords,$stpos,($enpos-$stpos)); $context=substr($keywords,$stpos-20,($enpos-($stpos-20))); //echo("italic:$fulllink
"); //echo("context:$context
"); //$repst=strpos($fulllink,chr(34).">")+2; //$repen=strpos($fulllink,""); $txt=$fulllink; $txt=str_replace("","",$txt); $txt=str_replace('',"",$txt); //echo(substr($htmlpage,$stpos,$enpos-$stpos)); //echo("full=$txt
"); if($txt!="top" && $txt!="here" && $txt!="is" && $txt!="can" && $txt!="are" && $txt!="not" && $txt!="for" && $txt!="by" && $txt!="for"){ //echo($txt." - ".$fulllink."
"); $body=str_replace(trim($txt),trim($fulllink),$body); $abstract=str_replace(trim($txt),trim($fulllink),$abstract); //$fulllink=str_replace("","",$body); $abstract=str_replace("","",$abstract); $body=str_replace("

","
",$body); $abstract=str_replace("

","
",$abstract); $body=str_replace("

","

",$body); $abstract=str_replace("

","

",$abstract); $body=str_replace(chr(10),"
",$body); $abstract=str_replace(chr(10),"
",$abstract); if($_GET[presID]==38){ $body="Still working on this!

SUMMARY	Matt MediaLounge	Clive FACT	Carol Creative Time	Hannah C-Plex	Beryl Crumb
Space	Small, a 'waiting area' for small business offices, a first contact, near the cafe, near the market, in a converted old building. Things are on wheels to move around if not working well where they are. Chose HoloPro screens because important to work in daylight.	Big, purpose built, modern, in the nightclub district. Based on established FACT identity. Big gallery, smaller 'box' space with sunken sofas, bars and cinema spaces on the top floor. Clive is artist-advisor; the keyword is 'flexible' spaces for what artists need.	'Both Massless and Moist'. Some projects have no body (such skywriting with planes) and some are in the in the massive brick space of bridge arches (cold and damp). Also, interactive works in very public places like Jim Campbell's light walls. Tactics/places/ audiences.	Community led initiative from the Black Country. Ambitious, stunning building, which includes training, lifelong learning, community projects, public art and Gallery X. References to popular attractions and serious art discourse. Community/ quality/ local-international are keywords.	In all spaces, the conflict between 'linear' approach (clear, prescriptive, which can help those inexperienced in art spaces) and the 'radial' (loose, open,but doesn't annoy the experienced). Also, between individual use, and group experiences.
'The Lounge'	Discussion of whether it is a domestic lounge (sofa, near market) or airport lounge (clean, waiting)?	Has space with sunken sofas, and is in the gallery and louche bar quarter. A louche lounge?	Did have 'amazingly comfortable' loungers for in the Massless Medium show, adding comfort to a large and intimidating space.	Dotted rest and 'picnic areas' around ramps. Must attract people in and have good spaces for socialising e.g. cafes.	Lounge infers a social space, and soft/informal, which some artists object to.
Time	Planned in 3 areas: '5 min area' With passive information panels. '10 min area' with stand-up interaction. '30 min area' with sit-down terminals.	Video can cease to be a 'time-based medium' when in a gallery. A history of short glance-times for visual art galleries (30 seconds maybe if very lucky) makes it a particular problem for interactive works and video.	With a history of installation rather than video, 'we work in seconds'. Minutes seem like a luxury.	Science museums and theme parks DO do studies, but sometimes this is in order to herd people around as in The Dome. Even so, exhibits are often 'a bit too long'. Users 'need to know the level of 'commitment' in advance'	My research showed a very rough average of 7 minutes for some sit-down single-screen artworks, much less for stand-ups. Some evidence that women in particular spend shorter times on pieces where their own body image is on screen, or very open to the view of others.
Staffing	Reception staff need to be on board.	Invigilators need special training, especially for disability access.	Security staff in many different public locations need to be briefed, as people ask them first.	Planned to have 'Ruttlers' in all spaces to help.	Serious Games had specially trained extra staff.
Audience	Is mainly building tenants, their clients, students and cafe visitors.	Did research for ACE - organisations had a certain idea of how they were perceived, which wasn't always true!	With projects like sky writing, 'we get to use 'a million' a lot'. Gallery events are mostly 'young, Caucasian'.	Projected to be the diverse local community and UK tourists.	Some science centres audience studies will be on Crumb. Will try to get Clive's ACE report. Art galleries please reveal your studies!
Concerns	Would like to commission more 'content'.	Shifting focus from tactical temporary projects to longer term programming. That a range of priorities might be tested in this transition.	New media tends to get treated as a novelty.	Avoiding the bad examples of 'theme-park' thinking with little content (the Dome, for example).	Barbara London criticises 'The Novelty Hustle' of passing fashions. How can we aim for longevity and seriousness? How can we fill these new spaces?

"; } ?>

"); } ?> "); echo("$row[1]"); if ($row[2]<>""){ echo(" | Email: $row[2]"); } if ($row[3]<>""){ // echo(" [$row[3]]"); } echo("
"); echo("Comment:
$row[4]"); echo("

> alert moderators"); echo("

"); // echo(""); echo("

"); echo(""); } } ?>

"); } } } ?>

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)); } //echo($imString); //now show the images selectDatabase("AssetDatabase"); echo(""); $imCount=1; for ($imLop=1; $imLop"); ?> 3){ $imCount=1; echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } echo("

"); //echo("

"); //end now show the images } function dumpSoundCollection($thisDB, $thisSql){ //echo($thisSql); global $link_id; $wid=$_GET[id]; selectDatabase($thisDB); $sql=$thisSql; //echo($sql); $result = mysql_query($sql, $link_id); $linkrow=mysql_fetch_row($result); $linkID=$linkrow[0]; //echo("linkID=$linkID"); selectDatabase("AssetDatabase"); $sql = mysql_query("SELECT * FROM soundcollectiontable WHERE id=$linkID"); //echo($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 sounddatabase WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result, $link_id); $userow=mysql_fetch_row($sql); //$linkDat=$userow[2]."
> ".$userow[1]."

"; echo("> $userow[1] $userow[2]
"); $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } } ?> 1){ $imString=subStr($imString, 1, strLen($imString)); //echo("
$imString"); $nextSlash=strPos($imString,"/"); $seekVal=subStr($imString, 0, ($nextSlash)); selectDatabase("AssetDatabase"); $result="SELECT * FROM linktable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); //$linkDat=$userow[2]."
> ".$userow[1]."

"; echo("> $userow[1]"); $scanText="$scanText $userow[3] $userow[2] "; if($userow[3]<>""){ echo(" - "); echo("$userow[3]

"); }else{ echo("

"); } $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } echo(""); } ?> "); global $link_id, $title, $scanText; selectDatabase("CoreDatabase"); $sql="SELECT * FROM presentationpdflinks WHERE presentation='$_GET[presID]'"; //echo($sql); $result = mysql_query($sql, $link_id); $row=mysql_fetch_row($result); $linkID=$row[2]; selectDatabase("AssetDatabase"); //echo("SELECT * FROM linkCollectionTable WHERE id=$linkID"); $sql = mysql_query("SELECT * FROM reportcollectiontable WHERE id=$linkID"); //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); $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("> $userow[1]"); $scanText="$scanText $userow[3] $userow[2] "; if($userow[3]<>""){ echo(" - "); echo("$userow[3]

"); }else{ echo("

"); } $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } echo(""); } ?>
"); $imCount=1; //now go through attendee string 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 peopletable WHERE id='$seekVal'"; //echo($result); $sql=mysql_query($result); $userow=mysql_fetch_row($sql); //echo($userow[0].$userow[2]."
> ".$userow[1]); echo("> $userow[1] $userow[3] $userow[2]

"); $scanText=" $scanText $userow[1] $userow[3] $userow[2]"; $imString=subStr($imString, $nextSlash, strLen($imString)); $imCount=$imCount+1; } } ?>