\n"; echo "\t\n"; if (!strcmp($table,'reports') || !strcmp($table,'posters')) { echo "\t\tChapter\n"; } elseif (!strcmp($table,'slideshows')) { echo "\t\tTalk\n"; } elseif (!strcmp($table,'fridaytalks')) { echo "\t\tDate\n"; } elseif (!strcmp($table,'theses')) { echo "\t\tDegree\n"; } elseif (!strcmp($table,'newsletters')) { echo "\t\tVol,No\n"; } else { echo "\t\tMeeting\n"; } if (!strcmp($table,'newsletters')) {echo "\t\tEditor(s)\n"; } elseif (!strcmp($table,'theses')) { echo "\t\tAuthor\n"; } else {echo "\t\tAuthor(s)\n";} echo "\t\tTitle\n"; echo "\t\tAvailability\n"; echo "\t\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t\n"; if (!strcmp($table,'reports')||!strcmp($table,'slideshows')||!strcmp($table,'fridaytalks')||!strcmp($table,'posters')) { if ($year == $lockyear && !strcmp($line['title'],'Summary Book')) { echo "\t\t \n"; } elseif ($year >= $lockyear) { echo "\t\t\"\"\n"; } else { echo "\t\t \n"; } } elseif (!strcmp($table,'newsletters')) { if ($year > $lockyear) { echo "\t\t\"\"\n"; } else { echo "\t\t \n"; } } if (!strcmp($table,'reports')||!strcmp($table,'slideshows')||!strcmp($table,'posters')) { echo "\t\t".$line["chapter"]."\n"; } elseif (!strcmp($table,'theses')) { if (!strcmp($line["pubtype"],'MastersThesis')) {$thesis = 'MSc';} else {$thesis= 'PhD';} echo "\t\t".$thesis."\n"; } elseif (!strcmp($table,'newsletters')) { echo "\t\t".$line['volume'].','.$line['chapter']."\n"; } else { echo "\t\t".$line['booktitle']."\n"; } if (empty($line['authors'])) { echo "\t\t \n"; } else { echo "\t\t".$line['authors']."\n"; } echo "\t\t".$line['title']."\n"; if (!strcmp($table,'reports') || !strcmp($table,'theses')) { # if ($year != 2009) { echo "\t\tAbstract\n"; # } else { # echo "\t\t \n"; # } # } # elseif (!strcmp($table,'slideshows') && $line['webcasturl']){ # echo "\t\tWebcast\n"; } else { echo "\t\t \n"; } if (empty($line['authors'])) echo "\t\t \n"; else { echo "\t\tDocument\n"; } echo "\t\n"; } echo "\n"; mysql_free_result($result); mysql_close($link); } ##Function mysqlSelect2 function mysqlSelect2($db, $table, $query, $year) { require_once($_SERVER["DOCUMENT_ROOT"] . '/access/mysql_sponsors_read_only.inc'); $link = mysql_connect('localhost',$mysql_user_ro,$mysql_password_ro) or die('Could not connect: ' . mysql_error()); mysql_select_db($db) or die ('Could not select database'); $result = mysql_query($query) or die ('Query failed: ' . mysql_error()); echo "\n"; echo "\t\n"; if (!strcmp($table,'reports')) { echo "\t\t\n"; } elseif (!strcmp($table,'slideshows')) { echo "\t\t\n"; } elseif (!strcmp($table,'fridaytalks')) { echo "\t\t\n"; } elseif (!strcmp($table,'theses')) { echo "\t\t\n"; } elseif (!strcmp($table,'newsletters')) { echo "\t\t\n"; } else { echo "\t\t\n"; } if (!strcmp($table,'newsletters')) {echo "\t\t\n"; } elseif (!strcmp($table,'theses')) { echo "\t\t\n"; } else {echo "\t\t\n";} echo "\t\t\n"; echo "\t\t\n"; echo "\t\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t\n"; if (!strcmp($table,'reports')||!strcmp($table,'slideshows')){ if ($year >= $lockyear) { echo "\t\t\n"; } else { echo "\t\t\n"; } } if (!strcmp($table,'reports')||!strcmp($table,'slideshows')) { echo "\t\t\n"; } elseif (!strcmp($table,'theses')) { if (!strcmp($line["pubtype"],'MastersThesis')) {$thesis = 'MSc';} else {$thesis= 'PhD';} echo "\t\t\n"; } elseif (!strcmp($table,'newsletters')) { echo "\t\t\n"; } else { echo "\t\t\n"; } echo "\t\t\n"; echo "\t\t\n"; if (!strcmp($table,'reports') || !strcmp($table,'theses')) { # if ($year != 2009) { echo "\t\t\n"; # } else { # echo "\t\t\n"; # } # } # elseif (!strcmp($table,'slideshows') && $line['webcasturl']){ # echo "\t\t\n"; } else { echo "\t\t\n"; } echo "\t\t\n"; echo "\t\n"; } echo "
ChapterTalkDateDegreeVol,NoMeetingEditor(s)AuthorAuthor(s)TitleAvailability
\"\" ".$line["chapter"]."".$thesis."".$line['volume'].','.$line['chapter']."".$line['booktitle']."".$line['authors']."".$line['title']."Abstract Webcast Document
\n"; mysql_free_result($result); mysql_close($link); } ?>