verifyUser($HTTP_COOKIE_VARS["UserLoggedIn"]); $thePage->drawPageHeader(); //$filedir Pubs/publications.php= "/var/www/secure/publicationfiles"; //$htmlfiledir = "/secure/publicationfiles"; //$diffdir = "/var/www"; $filedir = "/home/vhosts/mrgcvd.engr.wisc.edu/secure/publicationfiles"; $htmlfiledir = "/secure/publicationfiles"; $diffdir = "/home/vhosts/mrgcvd.engr.wisc.edu"; echo "

"; echo "\n"; echo "\n"; echo ""; echo ""; echo ""; echo ""; $authorlist = trim($authorlist); if ($authorlist != "") { $authorID=findAuthorIDNoInsert($authorlist,$thePage->db); if ($authorID != 0) $authorstring = "WHERE (author1='$authorID' OR author2='$authorID' OR author3='$authorID' OR author4='$authorID' OR author5='$authorID' OR author6='$authorID' OR author7='$authorID' OR author8='$authorID' OR author9='$authorID' OR author10='$authorID' OR author11='$authorID' OR author12='$authorID' OR author13='$authorID' OR author14='$authorID' OR author15='$authorID' OR author16='$authorID')" ; } echo ""; echo ""; echo ""; echo ""; echo ""; switch ($sort) // Changes sort based on $sort variable { case "Year, ascending":$sortstring = "ORDER BY journalyear ASC"; break; case "Year, descending":$sortstring = "ORDER BY journalyear DESC"; break; case "Primary author":$sortstring = "ORDER BY primaryauthor ASC"; break; case "Article title":$sortstring = "ORDER BY title ASC"; break; case "Journal":$sortstring = "ORDER BY journalname ASC"; break; } $textsearch = trim($textsearch); if ($textsearch != "") { if (($authorlist) && ($authorID !=0)) $searchstring = "AND (title LIKE '%$textsearch%' OR journalname LIKE '%$textsearch%')"; else $searchstring = "WHERE (title LIKE '%$textsearch%' OR journalname LIKE '%$textsearch%')"; } $result = mysql_query("SELECT * FROM publications $authorstring $searchstring $sortstring",$thePage->db); if ($myrow = mysql_fetch_array($result)) { echo "\n"; do { $thePublication = new Publication($myrow); $thePublication->drawPublication($thePage->db,0); } while ($myrow = mysql_fetch_array($result)); } else { echo "\n"; } echo "

Sort by:	"; if ($sort == "Year, ascending") echo "Year, ascending"; else echo "Year, ascending"; if ($sort == "Year, descending") echo "Year, descending"; else echo "Year, descending"; /* if ($sort == "Primary author") echo "Primary author"; else echo "Primary author";*/ if ($sort == "Article title") echo "Article title"; else echo "Article title"; if ($sort == "Journal") echo "Journal"; else echo "Journal"; echo "	Author search:	\n"; $result = mysql_query("SELECT * FROM authors ORDER BY lastname",$thePage->db); // Fill the select list with all categories echo " "; if ($myrow = mysql_fetch_array($result)) { do { if ($myrow["id"] == $authorID) { if ($myrow["secondinitial"] != NULL) echo "" . $myrow["firstinitial"] .". " . $myrow["secondinitial"] . ". " . $myrow["lastname"] . ""; else echo "" . $myrow["firstinitial"] .". " . $myrow["lastname"] . ""; } else { if ($myrow["secondinitial"] != NULL) echo "" . $myrow["firstinitial"] .". " . $myrow["secondinitial"] . ". " . $myrow["lastname"] . ""; else echo "" . $myrow["firstinitial"] .". " . $myrow["lastname"] . ""; } } while ($myrow = mysql_fetch_array($result)); } echo "
Full-text search:
Publications
Sorry, no publications match those conditions.

\n"; echo ""; echo "

"; $thePage->drawPageFooter(); ?>