Breviora can be downloaded via this MCZ web page and BioOne while issues older than 2004 can be found in the Biodiversity Heritage Library.

"; // sort breviora in descending order by number only. $order = " order by lpad(MCZBASE.get_publication_attribute(p.publication_id,'number'),10) desc "; break; case "bullmcz": $publication = "Bulletin of the Museum of Comparative Zoology"; // sort mcz bulletin by year, volume, number $order = " order by p.published_year desc, lpad(MCZBASE.get_publication_attribute(p.publication_id,'volume'),10) desc, lpad(MCZBASE.get_publication_attribute(p.publication_id,'number'),10) desc"; $bhl ="

The MCZ Bulletin can be downloaded via this MCZ web page and BioOne while issues older than 2004 can be found in the Biodiversity Heritage Library.

"; break; case "memoirs": $publication = "Memoirs of the Museum of Comparative Zoology"; $bhl ="

Memoirs of the MCZ can be found in the Biodiversity Heritage Library.

"; // default sort order break; case "booksmonographs": $publication = OTHER; $mczpublication = "Books and Monographs"; // default sort order $bhl ="

Books and Monographs published by the MCZ may be found in the Biodiversity Heritage Library.

"; break; case "annualreports": // NOTE: Add new cases in this form for other new values for the "MCZ publication" attribute. $publication = OTHER; $mczpublication = "Annual Report"; // default sort order $bhl ="

Annual Reports published by the MCZ may be found in the Biodiversity Heritage Library.

"; break; case "newsletter": // NOTE: Add new cases in this form for other new values for the "MCZ publication" attribute. $publication = OTHER; $mczpublication = "Newsletter"; // default sort order $bhl ="

Newsletters published by the MCZ may be found in the Biodiversity Heritage Library.

"; break; default; } $mode = "query"; } if (@$_GET['list']!="") { if (@$_GET['list']=="taxa") { $mode = "list_taxa"; } if (@$_GET['list']=="topics") { $mode = "list_topics"; } if (@$_GET['list']=="departments") { $mode = "list_departments"; } } function head($head) { $area = "Publications"; include("main_header.html"); echo "

MCZ Publications$head

"; } function foot() { include("footer.html"); } function do_query($sql,$headbit) { global $showhollis, $debug; $pdf = ''; $supplement = ''; @$connection=mczbase_connect(); if ($connection) { $result = oci_parse($connection, $sql); oci_execute($result); if ($debug===true) { echo "[$sql]"; } if ($debug===true) { echo oci_error(); } echo ""; echo "

"; } else { echo "Unable to connect to database."; } } $select = "select distinct p.publication_id, MCZBASE.get_publication_authors(p.publication_id) as authors, p.published_year, p.publication_title, MCZBASE.get_publication_attribute(p.publication_id,'journal name') as journal, MCZBASE.get_publication_attribute(p.publication_id,'volume') as volume, MCZBASE.get_publication_attribute(p.publication_id,'number') as pnumber, MCZBASE.get_publication_attribute(p.publication_id,'issue') as issue, MCZBASE.get_publication_attribute(p.publication_id,'page total') as page_total, MCZBASE.get_publication_attribute(p.publication_id,'begin page') as begin_page, MCZBASE.get_publication_attribute(p.publication_id,'end page') as end_page, MCZBASE.get_publication_attribute(p.publication_id,'HOLLIS number') as hollis_no, '' as pdf, MCZBASE.get_mcz_pubs_links(p.publication_id) as links, MCZBASE.get_publication_citation_count(p.publication_id) as specimens, MCZBASE.get_publication_attribute(p.publication_id,'publisher') as publisher "; switch ($mode) { case "list_taxa": // taxonomic groups head(" by Taxon"); @$connection=mczbase_connect(); if ($connection) { $sql="select count(publication_id), pub_att_value from MCZBASE.publication_attributes where publication_attribute = 'higher taxon' group by pub_att_value order by pub_att_value"; $result = oci_parse($connection,$sql); oci_execute($result); echo ""; } foot(); break; case "list_topics": // taxonomic groups head(" by Topic"); @$connection=mczbase_connect(); if ($connection) { echo ""; } foot(); break; case "list_departments": // taxonomic groups head(" by Department"); @$connection=mczbase_connect(); if ($connection) { echo ""; } foot(); break; case "query": $and = ""; $headbit = ""; $wherebit = ""; $topic = ""; if ($publication!="") { if ($publication==OTHER) { $headbit .= " $mczpublication"; $wherebit .= " $and MCZBASE.get_publication_attribute(p.publication_id, 'MCZ publication') = '$mczpublication' "; $and = " and "; } else { $headbit .= " $publication"; $wherebit .= " $and MCZBASE.get_publication_attribute(p.publication_id, 'journal name') = '$publication' "; $and = " and "; } } if ($higher_taxon!="") { $headbit .= " $higher_taxon"; $topic = $higher_taxon; $wherebit .= " $and MCZBASE.get_publication_attribute(p.publication_id, 'higher taxon') = '$higher_taxon' "; $and = " and "; } if ($paleo!="") { $headbit .= " $paleo"; $topic .= $and.$paleo; $wherebit .= " $and paleo = '$paleo' "; $and = " and "; } if ($department!="") { $headbit .= " $department"; $topic .= $and.$department; $wherebit .= " $and MCZBASE.get_publication_attribute(p.publication_id, 'department') = '$department' "; $and = " and "; } if ($other_subject!="") { $headbit .= " $other_subject"; $topic .= $and.$other_subject; $wherebit .= " $and MCZBASE.get_publication_attribute(p.publication_id, 'other subject') = '$other_subject' "; $and = " and "; } if ($term!="") { $headbit .= " $term"; $topic .= $and.$term; $wherebit .= " $and ( p.publication_title like '%$term%' or MCZBASE.get_publication_authors(p.publication_id) like '%$term%' or MCZBASE.get_publication_attribute(p.publication_id, 'higher_taxon') like '%$term%' or MCZBASE.get_publication_attribute(p.publication_id, 'genus') like '%$term%' or MCZBASE.get_publication_attribute(p.publication_id, 'other subject') like '%$term%' ) "; $and = " and "; } if ($headbit!="") { if ($publication!="") { if ($publication==OTHER) { $headbit = " in $mczpublication"; } else { $headbit = " in $publication"; } if ($topic!="") { $headbit = "$headbit on $topic"; } } else { $headbit = " on $topic"; } } // $mczpublications = " MCZBASE.get_publication_attribute(p.publication_id,'journal name') = 'Breviora' or MCZBASE.get_publication_attribute(p.publication_id,'journal name') = 'Bulletin of the Museum of Comparative Zoology' or MCZBASE.get_publication_attribute(p.publication_id,'journal name') = 'Memoirs of the Museum of Comparative Zoology' "; $mczpublications = " MCZBASE.is_mcz_publication(p.publication_id) = 1 "; if ($wherebit != "") { $wherebit = " where $wherebit and ($mczpublications) "; } head($headbit); echo "$bhl"; $sql="$select from MCZBASE.publication p $wherebit $order"; do_query($sql,$headbit); foot(); break; case "form": default: head(" Search"); echo "

Enter the appropriate information from the publication citation (author, year, title) that you wish to find and then click on \"Search Now\".

"; foot(); } ?>