Pittas (Pittidae) Birds of India, Bibliography of Indian Birds, Species Profiles of Indian Birds, AVIS Portal, IBIS Portals, AVIS IBIS Portals,Birding in India,Bird watching,Indian Birds,Indian Ornithology,Birds of India, Indian birds, bird photographs, Indian bird photographs, India Birds, Sundarbans, Indian bird checklist, Birds, birding hotspots, trip reports,guide to birds of India, bird photography, India bird photos, birds, Indian birds, Arpit Deomurari,AVIS-IBIS - An Avian Information System - Indian BioDiversity Information System,Kutch, Kachchh, Indian Ornithology http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas.html Wed, 19 Jun 2013 07:09:57 +0000 Joomla! 1.5 - Open Source Content Management en-gb Blue-naped Pitta - Pitta nipalensis http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/blue-naped-pitta-pitta-nipalensis.html http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/blue-naped-pitta-pitta-nipalensis.html
<?php
include(getcwd()."/ibisdata/ibisdbdata.php");
global $sn;
global $spcn;

$sn='Pitta nipalensis';
global $row;
global $result;
global $resultcle;
global $resulthm;
global $rowcle;
global $rowhm;
global $resultbook;
global $rowbook;
global $resultlit;
global $rowlit;
global $usrn;
global $pwds;
global $dbs;
$usrn = $dbusername;
$pwds = $dbpassword;
$dbs = $dbname;
?>
{tab=General Information}
<?php
$temp11 = getcwd();$spath="/images/albums/Passeriformes/Pittidae/Pitta_nipalensis/";
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_nipalensis/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute<br><br></b>";
}
else
{
echo '<img alt="'.$sn.'" src="http://avis.indianbiodiversity.org/'.$spath.randimage($fpath).'" width="150" border=0>';echo "<br><br>";}
@ $db = new mysqli('localhost', $usrn, $pwds, $dbs);
if (mysqli_connect_errno()) 
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from jos_master where M_SN = '".$sn."'";
$result = $db->query($query);
$num_results = $result->num_rows;
$row = $result->fetch_assoc();
$CLE_SN_SUB = $row['CLE_SN'];
$HM_SN_SUB = $row['HM_SN'];
$blurl = $row['BL_URL'];
$iucnurl = $row['IUCN_URL'];
$wkurl = $row['WK_URL'];
$querycle = "select * from cle63 where CLE_SN LIKE '".$CLE_SN_SUB."%' AND CLE_CAT <> 'species'";
$resultcle = $db->query($querycle);
$querycle = "select * from hm2006 where HM_SN LIKE '".$HM_SN_SUB."%' AND HM_CAT <> 'species'";
$resulthm = $db->query($querycle);
$spcn=$row['M_CN'];
echo "<b>Common Name : </b>" . $row['M_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['M_SN'] . "</i>";
echo "<b> (</b>" . $row['ABBI_AUTH'] . "<b>)</b><br><br>";
echo "<b>Order : </b>" . $row['M_Order'] ."<br>";
echo "<b>Family : </b>" . $row['M_Family'] . "<br>";
echo "<b>Taxonomic Group : </b>" . $row['M_TaxaGroup'] . "<br>";
if ($row['SYNO_CN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_CN'] . "<br>";
}
if ($row['SYNO_SN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_SN'] . "<br>";
}
if ($row['SYNOPIS_VERNA_NAME'] <> '')
{
echo "<b>Vernacular Name : </b>" . $row['SYNOPIS_VERNA_NAME'] . "</i><br><br>";
}
if ($row['M_Status'] <> '')
{
echo "<b>Status : </b>" . $row['M_Status'] ."<br>";
}
if ($row['M_Remark'] <> '')
{
echo "<b>Remark : </b>" . $row['M_Remark'] ."<br><br>";
}
?>
{slide=Pictures}
<?php
$temp11 = getcwd();
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_nipalensis/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute</b>";
}
else
{
echo "{ppgallery}albums\Passeriformes\Pittidae\Pitta_nipalensis{/ppgallery}";
}
?>
{/slide}
{slide=General Species Profile}
{/slide}
{tab=Taxonomy}
{slide=Clements Checklist of Birds of the World 6.4 December 2009 Updated}
<?php
echo "<b>Common Name : </b>" . $row['CLE_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['CLE_SN'] . "</i><br>";
echo "<b>Order : </b>" . $row['CLE_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['CLE_FAMILY'] . "<br>";
if ( $row['CLE_RANGE'] <> '')
{
echo "<b>Range : </b>" . $row['CLE_RANGE'] . "<br><br>";
}
$num_results = $resultcle->num_rows;
if ($num_results == 0 )
{
echo "<b> This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Taxon Category</b></th>
<th><b>Sub Species / Race</b></th>
<th><b>Range</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcle = $resultcle->fetch_assoc();
echo "<td>" . $rowcle['CLE_CAT'] . "</td>";
echo "<td><i>" . $rowcle['CLE_SN'] . "</i></td>";
echo "<td>" . $rowcle['CLE_RANGE'] . "</td>";
echo "<tr>";
}
echo "</table>";
if ( $row['CLE_Remarks'] <> '')
{
echo "<b>Remark : </b>" . $row['CLE_Remarks'] ."<br>";
}
}
?>
{/slide}
{slide=Howard and Moore Complete Checklist of the Birds of the World 2006}
<?php
echo "<b>3rd Edition, 2003.  Revised and Corrected per Corrigenda to December 31, 2006</b><br><br>";
echo "<b>Common Name : </b>" . $row['HM_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['HM_SN'] . "</i><br>";
if ( $row['HM_FAMILY'] <> '')
{
echo "<b>Family : </b>" . $row['HM_FAMILY'] . "<br><br>";
}
if ( $row['HM_Subfamily'] <> '')
{
echo "<b>SubFamily : </b>" . $row['HM_Subfamily'] . "<br><br>";
}
$num_results = $resulthm->num_rows;
if ($num_results == 0 )
{
echo "<b><br>This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Sub Species / Race</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowhm = $resulthm->fetch_assoc();
echo "<td><i>" . $rowhm['HM_SN'] . "</i></td>";
echo "<tr>";
}
echo "</table>";
}
?>
{/slide}
{slide=IOC World Bird Names (version 2.2)}
<?php
if ($row['IOC_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IOC Common Name : </b>" . $row['IOC_CN'] . "<br>";
echo "<b>IOC Scientific Name : </b><i>" . $row['IOC_SN'] . "</i><br><br>";
echo "<b>Distribution : </b><br>";
echo "<b>Region : </b>" . $row['IOC_REG'] ."\t\t";
echo "<b>Range : </b>" . $row['IOC_RANGE'] . "<br>";
if ($row['IOC_NBRANGE'] <> '')
{
echo "<b>Non Breeding Range : </b>" . $row['IOC_NBRANGE'] . "<br><br>";
}
echo "<b>Order : </b>" . $row['IOC_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['IOC_FAM'] . "<br>";
echo "<b>Category : </b>" . $row['IOC_FAMENG'] . "<br>";
if ( $row['IOC_TAXNOTE']<> '')
{
echo "<b>Note: </b>" . $row['IOC_TAXNOTE'] ."";
}
}
?>
{/slide}
{slide=A Synopsis of the Birds of India and Pakistan}
<?php
if ($row['SYNOPIS_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>SYNOPIS NO : </b>" . $row['SYNOPIS_NO'] . "<br><br>";
echo "<b>Scientific Name: </b><i>" . $row['SYNOPIS_SN'] ."</i><br>";
echo "<b>Common Name: </b>" . $row['SYNOPIS_CN'] . "<br>";
}
?>
{/slide}
{slide=Birdlife International Checklist Ver 3 June 2010}
<?php
if ($row['BL_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>Common Name : </b>" . $row['BL_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['BL_SN'] . "</i>\t\t";
echo "<b>(</b>" . $row['BL_AUTH'] ."<b>)</b><br>";
echo "<b>Birdlife Synonym : </b>" . $row['BL_SYN'] . "<br><br>";
echo "<b>BirdLife Redlist Status Year 2010: " . $row['BL_REDLIST2010'] . "</b><br>";


echo "<a href="http://avis.indianbiodiversity.org/. $row['BL_URL'] . "> BirdLife Species FactSheet for " . $row['BL_CN'] . " ( <i> " . $row['BL_SN'] . " )</i></a><br><br>";
echo "<b>Taxonomy Treatment : </b>" . $row['BL_TAXTREAT'] . "<br><br>";
if ($row['BL_TAXNOTE'] <> '')
{
echo "<b>Birdlife Taxonomy Notes : </b>" . $row['BL_TAXNOTE'] . "<br>";
}
}
?>
{/slide}
{slide=International Union for Conservation of Nature and Natural Resources}
<?php
if ($row['IUCN_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IUCN Common Name (Eng) : </b>" . $row['IUCN_CN_ENG'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['IUCN_SN'] . "</i>";
echo "<b> (</b>" . $row['IUCN_AUTH'] ."<b>)</b><br>";
if ($row['IUCN_CN_FRE']<> '')
{
echo " <b>French Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_FRE'])) . "<br>";
}
if ($row['IUCN_CN_SPA ']<> '')
{
echo " <b>Spanish Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_SPA '])) . "<br><br>";
}
echo "<a href="http://avis.indianbiodiversity.org/. $row['IUCN_URL'] . "> IUCN Redlist Species FactSheet for " . $row['IUCN_CN_ENG'] . " ( <i> " . $row['IUCN_SN'] . " )</i></a><br><br>";
echo "<b>Species : </b><i>" . $row['IUCN_SPECIES'] . "</i><br>";
echo "<b>Genus : </b>" . $row['IUCN_GENUS'] . "</i><br>";
echo "<b>Family : </b>" . $row['IUCN_FAMILY'] . "</i>\t\t";
echo "<b>Order : </b>" . $row['IUCN_ORDER'] . "</i><br><br>";
echo "<b>IUCN RedList Status : </b>" . $row['IUCN_RL_STATUS'] . "<br><br>";
if ($row['IUCN_RL_CRI']<> '')
{
echo "<b>IUCN RedList Criteria : </b>" . $row['IUCN_RL_CRI'] . "<br>";
}
echo "<b>IUCN RedList Criteria Version : </b>" . $row['IUCN_RL_CRI_VER'] . "<br>";
echo "<b>IUCN RedList Year Assessed : </b>" . $row['IUCN_RL_YEAR'] . "<br>";
if ($row['IUCN_RL_POP_TREND'] <> '')
{
echo "<b>IUCN RedList Population Trend : </b>" . $row['IUCN_RL_POP_TREND'] . "<br>";
}
if ($row['IUCN_RL_PET'] <> '')
{
echo "<b>IUCN RedList Petitioned : </b>" . $row['IUCN_RL_PET'] . "<br>";
}
}
?>
{/slide}
{slide=Oriental Bird Club Checklist Draft Novemebr 2009}
<?php
if ($row['OBC_SN']=='')
{
echo "No Data Available";
}
else
{echo "<b>Family : </b>" . $row['OBC_FAM'] . "<br><br>";
echo "<b>Scientific Name : </b><i>" . $row['OBC_SN'] ."</i><br>";
echo "<b>Common Name : </b>" . $row['OBC_CN'] . "<br><br>";
if ($row['IOC_DIFF'] <> '')
{
echo "<b>IOC Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['IOC_DIFF'])) . "<br>";
}
if ($row['BL_DIFF'] <> '')
{
echo "<b>Birdlife Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['BL_DIFF'])) . "<br><br>";
}
if ($row['BL_JUST'] <> '')
{
echo "<b>Birdlife Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['BL_JUST'])) . "<br>";
}
if ($row['OBC_JUST'] <> '')
{
echo "<b>OBC Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OBC_JUST'])) . "<br>";
}
if ($row['OTH_JUST'] <> '')
{
echo "<b>Other Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OTH_JUST'])) . "<br>";
}
}
?>
{/slide}
{tab=Bibliography}
<?php
$query = "select distinct Title, Author, SecondaryTitle, Volume, Pages, Fpage, Year from jos_bibliodb where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' order by Year DESC limit 100";
$resultlit = $db->query($query);
$num_results = $resultlit ->num_rows;
if ($num_results == 0 )
{
echo "<b>Currentlly No Literature Avialable</b>";
}
else
{
echo "<b>Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i></b><br>";
echo "<b>Number of Results found : ".$num_results."</b><br><br>";
if($num_results==100)
{
echo "<b>This is latest 100 Papers. To see Complete Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i> Use Species Bibliography Module</b>";
}
for ($i=0; $i <$num_results; $i++)
{
$rowlit = $resultlit ->fetch_assoc();
$tempdata = $i+1;
$tauth=htmlspecialchars_decode(htmlentities($rowlit ['Author']));
$ttitle=htmlspecialchars_decode(htmlentities($rowlit ['Title']));
$tsectitle=htmlspecialchars_decode(htmlentities($rowlit ['SecondaryTitle']));
$tvol=htmlspecialchars_decode(htmlentities($rowlit ['Volume']));
$tpage=htmlspecialchars_decode(htmlentities($rowlit ['Pages']));
$tfpage=htmlspecialchars_decode(htmlentities($rowlit ['Fpage']));
$tyear=htmlspecialchars_decode(htmlentities($rowlit ['Year']));
echo "<P ALIGN=JUSTIFY>";
echo "<b>$tempdata</b>";
echo ". ";
echo "$tauth ";
echo ", (";
echo "$tyear";
echo "), ";
echo "$ttitle";
echo ", ";
echo "<i>";
echo "$tsectitle";
echo "</i>";
echo ", ";
echo "$tvol";
echo ": ";
echo "$tpage";
if ($tfpage <> '')
{
echo " - ";
echo "$tfpage";
}
echo ". ";
echo "<br>";
echo "</p>";
echo "<HR>";
}
}
?>
{tab=Book Excerpts}
<?php
$query = "select * from jos_masterbookdata where NEW_SN = '".$sn."' order by YEAR";
$resultbook = $db->query($query);
$num_results = $resultbook->num_rows;
if ($num_results == 0 )
{
echo "<b>No Data Avialable</b>";
}
else
{
for ($i=0; $i <$num_results; $i++)
{
$rowbook = $resultbook->fetch_assoc();
$Bookname = $rowbook['BOOKNAME'];
$ArtName = $rowbook['ARTICLE_ID'];
$sldstart ='{slide= ';
$sldend= '}<br>';
$incluestart='{include_content_item ';
$incluend=' 1 1}<br>';
$slideend = '{/slide}<br><br>';
echo "$sldstart $Bookname $sldend";
echo "$incluestart $ArtName $incluend";
echo "$slideend";
}
}
?>
{tab=Museum Collections}
<?php
$query = "select * from jos_gbifaves where M_SN = '".$sn."' order by Datecollected";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if ($num_results == 0 )
{
echo "<b> No Data Avialbale for <i>" .$sn. "</i></b>";
}
else
{
echo "<b>Number of Museum Specimen Records Found : ".$num_results."</b> for <i>" .$sn." </i><br><br>";
echo "<table border='1'>
<tr>
<th>No.</th>
<th>Museum</th>
<th>Species</th>
<th>Collection Deatils</th>
<th>Collector</th>
<th>Date of Collection</th>
<th>Record</th>
<th>Locality</th>
<th>GBIF Portal Link</th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<td>".($i+1)."</td>";
echo "<td>" . $rowcoll['Dataprovider'] . "</td>";
echo "<td>" . $rowcoll['SN'] . "</td>";
$temp11 = $rowcoll['Institutioncode'] ." " . $rowcoll['Collectioncode']. " " .$rowcoll['CatalogueNo'];
echo "<td>" . $temp11 . "</td>";
echo "<td>" . $rowcoll['Collectorname'] . "</td>";
echo "<td>" . $rowcoll['Datecollected'] . "</td>";
echo "<td>" . $rowcoll['Basisofrecord'] . "</td>";
$temp22 = $rowcoll['Locality'] ." " . $rowcoll['County'] . " ".$rowcoll['StateProvince']." ".$rowcoll['Countryinterpreted']." ".$rowcoll['ContinentorOcean'] ." ". $rowcoll['Region'];
echo "<td>" .$temp22 ."</td>";
echo "<td> <a href="http://avis.indianbiodiversity.org/. $rowcoll['GBIFportalurl'] ." target=\"_blank\">Link</a></td>";
echo "<tr>";
}
}

echo "</table>";
$query = "select distinct jos_gbifaves.Dataprovider, Count(jos_gbifaves.ID) as cnt from jos_gbifaves where M_SN = '".$sn."'GROUP BY jos_gbifaves.Dataprovider";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if (!$num_results == 0 )
{
echo "<b><br>Biodiversity occurrence data provided by: (Accessed through GBIF Data Portal,  2009-08-06)</b>";
echo "<br><br><b>";
echo "Data Providers</b><br><ul>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<li>" . $rowcoll['Dataprovider']. " ( " . $rowcoll['cnt']. " Records )</li>";
echo "<br>";
}
echo "</ul>";
}
?>
{tab=Sound/Call}
<?php
$query = "select XCNO, remarks, type from jos_xenodata where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' OR KWNEW LIKE '%".$CLE_SN_SUB."%'";
$resultxeno = $db->query($query);
$num_results = $resultxeno->num_rows;
if ($num_results == 0 )
{
echo "<b>No Calls Avialable</b>";
}
else
{
echo $num_results . " calls found for " . $sn ."<br><br>";
echo "<HR>";
for ($i=0; $i<$num_results; $i++)
{
$rowxeno = $resultxeno->fetch_assoc();
$xc = $rowxeno['XCNO'];
$pstart = '<iframe src="http://www.xeno-canto.org/embed.php?XC=';
$pend = '&simple=0" scrolling=no frameborder=0 width=340 height=230></iframe>';
$tt2 ="<br>";
echo "$pstart $xc $pend";
echo "<br>Remarks: " . $rowxeno['remarks'] . "<br>";
echo "Call Type: " . $rowxeno['type'] . "<br>";
echo "<HR>";
}
}
echo 'The Bird Calls are embedded through xeno-canto.org See <a href="http://xeno-canto.org/termsofuse.php">Terms of Use xeno-canto.org</a><br><br>';
?>
{tab=Links}
<?php
$devtteemmpp = ' target="_blank" rel="nofollow"';
$devstrspecies = 'for ' . $row['M_CN'] . ' ( <i> ' . $row['M_SN'] . ' )</i>';
$avibase = 'http://avibase.bsc-eoc.org/avibase.jsp?pg=search&qstr=' . $row['FILENAMEPLUS'];
echo "<br><a href="http://avis.indianbiodiversity.org/. $avibase . $devtteemmpp . "> Avibase - The World Bird Database " . $devstrspecies . "</a><br><br>";
$bldataurl = 'http://www.birdlife.org/datazone/species/index.html?action=SpcHTMDetails.asp&sid=' . $row['BL_ID'] . '&m=0';
echo "<a href="http://avis.indianbiodiversity.org/. $bldataurl . $devtteemmpp . "> BirdLife Species FactSheet " . $devstrspecies . "</a><br><br>";
$bhlurl = 'http://www.biodiversitylibrary.org/name/'.$row['FILENAME'];
echo " <a href="http://avis.indianbiodiversity.org/. $bhlurl . $devtteemmpp . "> Biodiversity Heritage Library ". $devstrspecies . "</a><br><br>";
$dislifemaps = 'http://www.discoverlife.org/mp/20m?kind='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $dislifemaps .  $devtteemmpp . "> Discover Life Maps ". $devstrspecies . "</a><br><br>";
$Entrez  = 'http://www.ncbi.nlm.nih.gov/sites/gquery?term='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Entrez .  $devtteemmpp . "> Entrez, The Life Sciences Search Engine ". $devstrspecies . "</a><br><br>";
$GBIF = 'http://data.gbif.org/species/species/'.$row['FILENAME'];
echo "<a href="http://avis.indianbiodiversity.org/. $GBIF .  $devtteemmpp . "> GBIF, Global Biodiversity Information Facility ". $devstrspecies . "</a><br><br>";
$GoogleImages = 'http://images.google.com/images?q=' . $row['FILENAMEPLUS'] . '&hl=en&sa=N&tab=wi';
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleImages .  $devtteemmpp . "> Google Images ". $devstrspecies . "</a><br><br>";
$GoogleScholar  = 'http://scholar.google.com/scholar?hl=en&num=20&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleScholar .  $devtteemmpp . "> Google Scholar ". $devstrspecies . "</a><br><br>";
$GoogleWebsites = 'http://www.google.com/search?sourceid=navclient&querytime=sC&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleWebsites .  $devtteemmpp . "> Google Websites ". $devstrspecies . "</a><br><br>";
$ITIS = 'http://www.itis.gov/servlet/SingleRpt/SingleRpt?search_topic=TSN&searchvalue=' . $row['ITIS_TSN'];
echo "<a href="http://avis.indianbiodiversity.org/. $ITIS .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) ". $devstrspecies . "</a><br><br>";
$ITISCA = 'http://www.cbif.gc.ca/pls/itisca/next?v_tsn=' . $row['ITIS_TSN'] . '&taxa=&p_format=&p_ifx=cbif&p_lang=';
echo "<a href="http://avis.indianbiodiversity.org/. $ITISCA .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) CANADA ". $devstrspecies . "</a><br><br>";
$iucndata = 'http://www.iucnredlist.org/details/'.$row['IUCN_ID'];
echo "<a href="http://avis.indianbiodiversity.org/. $iucndata .  $devtteemmpp . "> IUCN Redlist Species FactSheet ". $devstrspecies . "</a><br><br>";
$ncbi = 'http://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?name='.$row['FILENAMEPLUS'] . '&lvl=0';
echo "<a href="http://avis.indianbiodiversity.org/. $ncbi .  $devtteemmpp . "> NCBI Molecular Data ". $devstrspecies . "</a><br><br>";
$Pubmed = 'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Search&term='.$row['FILENAMEPLUS'] . '&doptcmdl=DocSum';
echo "<a href="http://avis.indianbiodiversity.org/. $Pubmed .  $devtteemmpp . "> Pubmed Literature ". $devstrspecies . "</a><br><br>";
$catlife = 'http://www.catalogueoflife.org/annual-checklist/2010/search/all/key/'.$row['FILENAMEPLUS'] ;
echo "<a href="http://avis.indianbiodiversity.org/. $catlife .  $devtteemmpp . "> Catalogue of Life : Annual Checklist ". $devstrspecies . "</a><br><br>";
$treelife = 'http://tolweb.org/tree/home.pages/searchTOL?taxon='.$row['FILENAMEPLUS'] . '&Submit2=Find';
echo "<a href="http://avis.indianbiodiversity.org/. $treelife .  $devtteemmpp . "> Tree Of Life ". $devstrspecies . "</a><br><br>";
$uBioPortal = 'http://www.ubio.org/browser/search.php?search_all='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBioPortal .  $devtteemmpp . "> uBio Portal ". $devstrspecies . "</a><br><br>";
$uBio = 'http://portal.ubio.org/index.php?tnsnav=lists&map=&start=0&tnsclient=Yahoo&searchtype=web&search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBio .  $devtteemmpp . "> uBio  ". $devstrspecies . "</a><br><br>";
$Wikipedia = 'http://en.wikipedia.org/wiki/Special:Search?search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Wikipedia .  $devtteemmpp . "> Wikipedia  ". $devstrspecies . "</a><br><br>";
$XenoCanto = 'http://www.xeno-canto.org/species.php?query='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $XenoCanto .  $devtteemmpp . "> Xeno - Canto  ". $devstrspecies . "</a><br><br>";
$Zoonomen = 'http://www.google.com/custom?hl=en&q='.$row['FILENAMEPLUS'] .'&sitesearch=zoonomen.net/';
echo "<a href="http://avis.indianbiodiversity.org/. $Zoonomen .  $devtteemmpp . "> Zoonomen  ". $devstrspecies . "</a><br><br>";

?>
{/tabs}
<?php   
echo "<b>Cite this website along with its URL as:<br></b>";
echo "Anonymous. " .date("Y"). "<i> ".$sn."</i> - ".$row['ABBI_AUTH']." (".$spcn." )<i> in </i>Deomurari, A.N. (Compiler), 2010. AVIS-IBIS (Avian Information System - Indian BioDiversity Information System) v. 1.0. Foundation For Ecological Security, India";
echo " retrieved on ".date("m/d/Y");

?>
]]>
deomurari@gmail.com (Arpit Deomurari) Passeriformes - Pittidae ( Pittas ) Wed, 11 Nov 2009 05:36:10 +0000
Blue Pitta - Pitta cyanea http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/blue-pitta-pitta-cyanea.html http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/blue-pitta-pitta-cyanea.html
<?php
include(getcwd()."/ibisdata/ibisdbdata.php");
global $sn;
global $spcn;

$sn='Pitta cyanea';
global $row;
global $result;
global $resultcle;
global $resulthm;
global $rowcle;
global $rowhm;
global $resultbook;
global $rowbook;
global $resultlit;
global $rowlit;
global $usrn;
global $pwds;
global $dbs;
$usrn = $dbusername;
$pwds = $dbpassword;
$dbs = $dbname;
?>
{tab=General Information}
<?php
$temp11 = getcwd();$spath="/images/albums/Passeriformes/Pittidae/Pitta_cyanea/";
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_cyanea/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute<br><br></b>";
}
else
{
echo '<img alt="'.$sn.'" src="http://avis.indianbiodiversity.org/'.$spath.randimage($fpath).'" width="150" border=0>';echo "<br><br>";}
@ $db = new mysqli('localhost', $usrn, $pwds, $dbs);
if (mysqli_connect_errno()) 
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from jos_master where M_SN = '".$sn."'";
$result = $db->query($query);
$num_results = $result->num_rows;
$row = $result->fetch_assoc();
$CLE_SN_SUB = $row['CLE_SN'];
$HM_SN_SUB = $row['HM_SN'];
$blurl = $row['BL_URL'];
$iucnurl = $row['IUCN_URL'];
$wkurl = $row['WK_URL'];
$querycle = "select * from cle63 where CLE_SN LIKE '".$CLE_SN_SUB."%' AND CLE_CAT <> 'species'";
$resultcle = $db->query($querycle);
$querycle = "select * from hm2006 where HM_SN LIKE '".$HM_SN_SUB."%' AND HM_CAT <> 'species'";
$resulthm = $db->query($querycle);
$spcn=$row['M_CN'];
echo "<b>Common Name : </b>" . $row['M_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['M_SN'] . "</i>";
echo "<b> (</b>" . $row['ABBI_AUTH'] . "<b>)</b><br><br>";
echo "<b>Order : </b>" . $row['M_Order'] ."<br>";
echo "<b>Family : </b>" . $row['M_Family'] . "<br>";
echo "<b>Taxonomic Group : </b>" . $row['M_TaxaGroup'] . "<br>";
if ($row['SYNO_CN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_CN'] . "<br>";
}
if ($row['SYNO_SN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_SN'] . "<br>";
}
if ($row['SYNOPIS_VERNA_NAME'] <> '')
{
echo "<b>Vernacular Name : </b>" . $row['SYNOPIS_VERNA_NAME'] . "</i><br><br>";
}
if ($row['M_Status'] <> '')
{
echo "<b>Status : </b>" . $row['M_Status'] ."<br>";
}
if ($row['M_Remark'] <> '')
{
echo "<b>Remark : </b>" . $row['M_Remark'] ."<br><br>";
}
?>
{slide=Pictures}
<?php
$temp11 = getcwd();
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_cyanea/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute</b>";
}
else
{
echo "{ppgallery}albums\Passeriformes\Pittidae\Pitta_cyanea{/ppgallery}";
}
?>
{/slide}
{slide=General Species Profile}
{/slide}
{tab=Taxonomy}
{slide=Clements Checklist of Birds of the World 6.4 December 2009 Updated}
<?php
echo "<b>Common Name : </b>" . $row['CLE_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['CLE_SN'] . "</i><br>";
echo "<b>Order : </b>" . $row['CLE_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['CLE_FAMILY'] . "<br>";
if ( $row['CLE_RANGE'] <> '')
{
echo "<b>Range : </b>" . $row['CLE_RANGE'] . "<br><br>";
}
$num_results = $resultcle->num_rows;
if ($num_results == 0 )
{
echo "<b> This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Taxon Category</b></th>
<th><b>Sub Species / Race</b></th>
<th><b>Range</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcle = $resultcle->fetch_assoc();
echo "<td>" . $rowcle['CLE_CAT'] . "</td>";
echo "<td><i>" . $rowcle['CLE_SN'] . "</i></td>";
echo "<td>" . $rowcle['CLE_RANGE'] . "</td>";
echo "<tr>";
}
echo "</table>";
if ( $row['CLE_Remarks'] <> '')
{
echo "<b>Remark : </b>" . $row['CLE_Remarks'] ."<br>";
}
}
?>
{/slide}
{slide=Howard and Moore Complete Checklist of the Birds of the World 2006}
<?php
echo "<b>3rd Edition, 2003.  Revised and Corrected per Corrigenda to December 31, 2006</b><br><br>";
echo "<b>Common Name : </b>" . $row['HM_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['HM_SN'] . "</i><br>";
if ( $row['HM_FAMILY'] <> '')
{
echo "<b>Family : </b>" . $row['HM_FAMILY'] . "<br><br>";
}
if ( $row['HM_Subfamily'] <> '')
{
echo "<b>SubFamily : </b>" . $row['HM_Subfamily'] . "<br><br>";
}
$num_results = $resulthm->num_rows;
if ($num_results == 0 )
{
echo "<b><br>This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Sub Species / Race</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowhm = $resulthm->fetch_assoc();
echo "<td><i>" . $rowhm['HM_SN'] . "</i></td>";
echo "<tr>";
}
echo "</table>";
}
?>
{/slide}
{slide=IOC World Bird Names (version 2.2)}
<?php
if ($row['IOC_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IOC Common Name : </b>" . $row['IOC_CN'] . "<br>";
echo "<b>IOC Scientific Name : </b><i>" . $row['IOC_SN'] . "</i><br><br>";
echo "<b>Distribution : </b><br>";
echo "<b>Region : </b>" . $row['IOC_REG'] ."\t\t";
echo "<b>Range : </b>" . $row['IOC_RANGE'] . "<br>";
if ($row['IOC_NBRANGE'] <> '')
{
echo "<b>Non Breeding Range : </b>" . $row['IOC_NBRANGE'] . "<br><br>";
}
echo "<b>Order : </b>" . $row['IOC_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['IOC_FAM'] . "<br>";
echo "<b>Category : </b>" . $row['IOC_FAMENG'] . "<br>";
if ( $row['IOC_TAXNOTE']<> '')
{
echo "<b>Note: </b>" . $row['IOC_TAXNOTE'] ."";
}
}
?>
{/slide}
{slide=A Synopsis of the Birds of India and Pakistan}
<?php
if ($row['SYNOPIS_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>SYNOPIS NO : </b>" . $row['SYNOPIS_NO'] . "<br><br>";
echo "<b>Scientific Name: </b><i>" . $row['SYNOPIS_SN'] ."</i><br>";
echo "<b>Common Name: </b>" . $row['SYNOPIS_CN'] . "<br>";
}
?>
{/slide}
{slide=Birdlife International Checklist Ver 3 June 2010}
<?php
if ($row['BL_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>Common Name : </b>" . $row['BL_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['BL_SN'] . "</i>\t\t";
echo "<b>(</b>" . $row['BL_AUTH'] ."<b>)</b><br>";
echo "<b>Birdlife Synonym : </b>" . $row['BL_SYN'] . "<br><br>";
echo "<b>BirdLife Redlist Status Year 2010: " . $row['BL_REDLIST2010'] . "</b><br>";


echo "<a href="http://avis.indianbiodiversity.org/. $row['BL_URL'] . "> BirdLife Species FactSheet for " . $row['BL_CN'] . " ( <i> " . $row['BL_SN'] . " )</i></a><br><br>";
echo "<b>Taxonomy Treatment : </b>" . $row['BL_TAXTREAT'] . "<br><br>";
if ($row['BL_TAXNOTE'] <> '')
{
echo "<b>Birdlife Taxonomy Notes : </b>" . $row['BL_TAXNOTE'] . "<br>";
}
}
?>
{/slide}
{slide=International Union for Conservation of Nature and Natural Resources}
<?php
if ($row['IUCN_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IUCN Common Name (Eng) : </b>" . $row['IUCN_CN_ENG'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['IUCN_SN'] . "</i>";
echo "<b> (</b>" . $row['IUCN_AUTH'] ."<b>)</b><br>";
if ($row['IUCN_CN_FRE']<> '')
{
echo " <b>French Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_FRE'])) . "<br>";
}
if ($row['IUCN_CN_SPA ']<> '')
{
echo " <b>Spanish Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_SPA '])) . "<br><br>";
}
echo "<a href="http://avis.indianbiodiversity.org/. $row['IUCN_URL'] . "> IUCN Redlist Species FactSheet for " . $row['IUCN_CN_ENG'] . " ( <i> " . $row['IUCN_SN'] . " )</i></a><br><br>";
echo "<b>Species : </b><i>" . $row['IUCN_SPECIES'] . "</i><br>";
echo "<b>Genus : </b>" . $row['IUCN_GENUS'] . "</i><br>";
echo "<b>Family : </b>" . $row['IUCN_FAMILY'] . "</i>\t\t";
echo "<b>Order : </b>" . $row['IUCN_ORDER'] . "</i><br><br>";
echo "<b>IUCN RedList Status : </b>" . $row['IUCN_RL_STATUS'] . "<br><br>";
if ($row['IUCN_RL_CRI']<> '')
{
echo "<b>IUCN RedList Criteria : </b>" . $row['IUCN_RL_CRI'] . "<br>";
}
echo "<b>IUCN RedList Criteria Version : </b>" . $row['IUCN_RL_CRI_VER'] . "<br>";
echo "<b>IUCN RedList Year Assessed : </b>" . $row['IUCN_RL_YEAR'] . "<br>";
if ($row['IUCN_RL_POP_TREND'] <> '')
{
echo "<b>IUCN RedList Population Trend : </b>" . $row['IUCN_RL_POP_TREND'] . "<br>";
}
if ($row['IUCN_RL_PET'] <> '')
{
echo "<b>IUCN RedList Petitioned : </b>" . $row['IUCN_RL_PET'] . "<br>";
}
}
?>
{/slide}
{slide=Oriental Bird Club Checklist Draft Novemebr 2009}
<?php
if ($row['OBC_SN']=='')
{
echo "No Data Available";
}
else
{echo "<b>Family : </b>" . $row['OBC_FAM'] . "<br><br>";
echo "<b>Scientific Name : </b><i>" . $row['OBC_SN'] ."</i><br>";
echo "<b>Common Name : </b>" . $row['OBC_CN'] . "<br><br>";
if ($row['IOC_DIFF'] <> '')
{
echo "<b>IOC Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['IOC_DIFF'])) . "<br>";
}
if ($row['BL_DIFF'] <> '')
{
echo "<b>Birdlife Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['BL_DIFF'])) . "<br><br>";
}
if ($row['BL_JUST'] <> '')
{
echo "<b>Birdlife Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['BL_JUST'])) . "<br>";
}
if ($row['OBC_JUST'] <> '')
{
echo "<b>OBC Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OBC_JUST'])) . "<br>";
}
if ($row['OTH_JUST'] <> '')
{
echo "<b>Other Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OTH_JUST'])) . "<br>";
}
}
?>
{/slide}
{tab=Bibliography}
<?php
$query = "select distinct Title, Author, SecondaryTitle, Volume, Pages, Fpage, Year from jos_bibliodb where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' order by Year DESC limit 100";
$resultlit = $db->query($query);
$num_results = $resultlit ->num_rows;
if ($num_results == 0 )
{
echo "<b>Currentlly No Literature Avialable</b>";
}
else
{
echo "<b>Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i></b><br>";
echo "<b>Number of Results found : ".$num_results."</b><br><br>";
if($num_results==100)
{
echo "<b>This is latest 100 Papers. To see Complete Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i> Use Species Bibliography Module</b>";
}
for ($i=0; $i <$num_results; $i++)
{
$rowlit = $resultlit ->fetch_assoc();
$tempdata = $i+1;
$tauth=htmlspecialchars_decode(htmlentities($rowlit ['Author']));
$ttitle=htmlspecialchars_decode(htmlentities($rowlit ['Title']));
$tsectitle=htmlspecialchars_decode(htmlentities($rowlit ['SecondaryTitle']));
$tvol=htmlspecialchars_decode(htmlentities($rowlit ['Volume']));
$tpage=htmlspecialchars_decode(htmlentities($rowlit ['Pages']));
$tfpage=htmlspecialchars_decode(htmlentities($rowlit ['Fpage']));
$tyear=htmlspecialchars_decode(htmlentities($rowlit ['Year']));
echo "<P ALIGN=JUSTIFY>";
echo "<b>$tempdata</b>";
echo ". ";
echo "$tauth ";
echo ", (";
echo "$tyear";
echo "), ";
echo "$ttitle";
echo ", ";
echo "<i>";
echo "$tsectitle";
echo "</i>";
echo ", ";
echo "$tvol";
echo ": ";
echo "$tpage";
if ($tfpage <> '')
{
echo " - ";
echo "$tfpage";
}
echo ". ";
echo "<br>";
echo "</p>";
echo "<HR>";
}
}
?>
{tab=Book Excerpts}
<?php
$query = "select * from jos_masterbookdata where NEW_SN = '".$sn."' order by YEAR";
$resultbook = $db->query($query);
$num_results = $resultbook->num_rows;
if ($num_results == 0 )
{
echo "<b>No Data Avialable</b>";
}
else
{
for ($i=0; $i <$num_results; $i++)
{
$rowbook = $resultbook->fetch_assoc();
$Bookname = $rowbook['BOOKNAME'];
$ArtName = $rowbook['ARTICLE_ID'];
$sldstart ='{slide= ';
$sldend= '}<br>';
$incluestart='{include_content_item ';
$incluend=' 1 1}<br>';
$slideend = '{/slide}<br><br>';
echo "$sldstart $Bookname $sldend";
echo "$incluestart $ArtName $incluend";
echo "$slideend";
}
}
?>
{tab=Museum Collections}
<?php
$query = "select * from jos_gbifaves where M_SN = '".$sn."' order by Datecollected";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if ($num_results == 0 )
{
echo "<b> No Data Avialbale for <i>" .$sn. "</i></b>";
}
else
{
echo "<b>Number of Museum Specimen Records Found : ".$num_results."</b> for <i>" .$sn." </i><br><br>";
echo "<table border='1'>
<tr>
<th>No.</th>
<th>Museum</th>
<th>Species</th>
<th>Collection Deatils</th>
<th>Collector</th>
<th>Date of Collection</th>
<th>Record</th>
<th>Locality</th>
<th>GBIF Portal Link</th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<td>".($i+1)."</td>";
echo "<td>" . $rowcoll['Dataprovider'] . "</td>";
echo "<td>" . $rowcoll['SN'] . "</td>";
$temp11 = $rowcoll['Institutioncode'] ." " . $rowcoll['Collectioncode']. " " .$rowcoll['CatalogueNo'];
echo "<td>" . $temp11 . "</td>";
echo "<td>" . $rowcoll['Collectorname'] . "</td>";
echo "<td>" . $rowcoll['Datecollected'] . "</td>";
echo "<td>" . $rowcoll['Basisofrecord'] . "</td>";
$temp22 = $rowcoll['Locality'] ." " . $rowcoll['County'] . " ".$rowcoll['StateProvince']." ".$rowcoll['Countryinterpreted']." ".$rowcoll['ContinentorOcean'] ." ". $rowcoll['Region'];
echo "<td>" .$temp22 ."</td>";
echo "<td> <a href="http://avis.indianbiodiversity.org/. $rowcoll['GBIFportalurl'] ." target=\"_blank\">Link</a></td>";
echo "<tr>";
}
}

echo "</table>";
$query = "select distinct jos_gbifaves.Dataprovider, Count(jos_gbifaves.ID) as cnt from jos_gbifaves where M_SN = '".$sn."'GROUP BY jos_gbifaves.Dataprovider";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if (!$num_results == 0 )
{
echo "<b><br>Biodiversity occurrence data provided by: (Accessed through GBIF Data Portal,  2009-08-06)</b>";
echo "<br><br><b>";
echo "Data Providers</b><br><ul>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<li>" . $rowcoll['Dataprovider']. " ( " . $rowcoll['cnt']. " Records )</li>";
echo "<br>";
}
echo "</ul>";
}
?>
{tab=Sound/Call}
<?php
$query = "select XCNO, remarks, type from jos_xenodata where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' OR KWNEW LIKE '%".$CLE_SN_SUB."%'";
$resultxeno = $db->query($query);
$num_results = $resultxeno->num_rows;
if ($num_results == 0 )
{
echo "<b>No Calls Avialable</b>";
}
else
{
echo $num_results . " calls found for " . $sn ."<br><br>";
echo "<HR>";
for ($i=0; $i<$num_results; $i++)
{
$rowxeno = $resultxeno->fetch_assoc();
$xc = $rowxeno['XCNO'];
$pstart = '<iframe src="http://www.xeno-canto.org/embed.php?XC=';
$pend = '&simple=0" scrolling=no frameborder=0 width=340 height=230></iframe>';
$tt2 ="<br>";
echo "$pstart $xc $pend";
echo "<br>Remarks: " . $rowxeno['remarks'] . "<br>";
echo "Call Type: " . $rowxeno['type'] . "<br>";
echo "<HR>";
}
}
echo 'The Bird Calls are embedded through xeno-canto.org See <a href="http://xeno-canto.org/termsofuse.php">Terms of Use xeno-canto.org</a><br><br>';
?>
{tab=Links}
<?php
$devtteemmpp = ' target="_blank" rel="nofollow"';
$devstrspecies = 'for ' . $row['M_CN'] . ' ( <i> ' . $row['M_SN'] . ' )</i>';
$avibase = 'http://avibase.bsc-eoc.org/avibase.jsp?pg=search&qstr=' . $row['FILENAMEPLUS'];
echo "<br><a href="http://avis.indianbiodiversity.org/. $avibase . $devtteemmpp . "> Avibase - The World Bird Database " . $devstrspecies . "</a><br><br>";
$bldataurl = 'http://www.birdlife.org/datazone/species/index.html?action=SpcHTMDetails.asp&sid=' . $row['BL_ID'] . '&m=0';
echo "<a href="http://avis.indianbiodiversity.org/. $bldataurl . $devtteemmpp . "> BirdLife Species FactSheet " . $devstrspecies . "</a><br><br>";
$bhlurl = 'http://www.biodiversitylibrary.org/name/'.$row['FILENAME'];
echo " <a href="http://avis.indianbiodiversity.org/. $bhlurl . $devtteemmpp . "> Biodiversity Heritage Library ". $devstrspecies . "</a><br><br>";
$dislifemaps = 'http://www.discoverlife.org/mp/20m?kind='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $dislifemaps .  $devtteemmpp . "> Discover Life Maps ". $devstrspecies . "</a><br><br>";
$Entrez  = 'http://www.ncbi.nlm.nih.gov/sites/gquery?term='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Entrez .  $devtteemmpp . "> Entrez, The Life Sciences Search Engine ". $devstrspecies . "</a><br><br>";
$GBIF = 'http://data.gbif.org/species/species/'.$row['FILENAME'];
echo "<a href="http://avis.indianbiodiversity.org/. $GBIF .  $devtteemmpp . "> GBIF, Global Biodiversity Information Facility ". $devstrspecies . "</a><br><br>";
$GoogleImages = 'http://images.google.com/images?q=' . $row['FILENAMEPLUS'] . '&hl=en&sa=N&tab=wi';
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleImages .  $devtteemmpp . "> Google Images ". $devstrspecies . "</a><br><br>";
$GoogleScholar  = 'http://scholar.google.com/scholar?hl=en&num=20&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleScholar .  $devtteemmpp . "> Google Scholar ". $devstrspecies . "</a><br><br>";
$GoogleWebsites = 'http://www.google.com/search?sourceid=navclient&querytime=sC&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleWebsites .  $devtteemmpp . "> Google Websites ". $devstrspecies . "</a><br><br>";
$ITIS = 'http://www.itis.gov/servlet/SingleRpt/SingleRpt?search_topic=TSN&searchvalue=' . $row['ITIS_TSN'];
echo "<a href="http://avis.indianbiodiversity.org/. $ITIS .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) ". $devstrspecies . "</a><br><br>";
$ITISCA = 'http://www.cbif.gc.ca/pls/itisca/next?v_tsn=' . $row['ITIS_TSN'] . '&taxa=&p_format=&p_ifx=cbif&p_lang=';
echo "<a href="http://avis.indianbiodiversity.org/. $ITISCA .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) CANADA ". $devstrspecies . "</a><br><br>";
$iucndata = 'http://www.iucnredlist.org/details/'.$row['IUCN_ID'];
echo "<a href="http://avis.indianbiodiversity.org/. $iucndata .  $devtteemmpp . "> IUCN Redlist Species FactSheet ". $devstrspecies . "</a><br><br>";
$ncbi = 'http://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?name='.$row['FILENAMEPLUS'] . '&lvl=0';
echo "<a href="http://avis.indianbiodiversity.org/. $ncbi .  $devtteemmpp . "> NCBI Molecular Data ". $devstrspecies . "</a><br><br>";
$Pubmed = 'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Search&term='.$row['FILENAMEPLUS'] . '&doptcmdl=DocSum';
echo "<a href="http://avis.indianbiodiversity.org/. $Pubmed .  $devtteemmpp . "> Pubmed Literature ". $devstrspecies . "</a><br><br>";
$catlife = 'http://www.catalogueoflife.org/annual-checklist/2010/search/all/key/'.$row['FILENAMEPLUS'] ;
echo "<a href="http://avis.indianbiodiversity.org/. $catlife .  $devtteemmpp . "> Catalogue of Life : Annual Checklist ". $devstrspecies . "</a><br><br>";
$treelife = 'http://tolweb.org/tree/home.pages/searchTOL?taxon='.$row['FILENAMEPLUS'] . '&Submit2=Find';
echo "<a href="http://avis.indianbiodiversity.org/. $treelife .  $devtteemmpp . "> Tree Of Life ". $devstrspecies . "</a><br><br>";
$uBioPortal = 'http://www.ubio.org/browser/search.php?search_all='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBioPortal .  $devtteemmpp . "> uBio Portal ". $devstrspecies . "</a><br><br>";
$uBio = 'http://portal.ubio.org/index.php?tnsnav=lists&map=&start=0&tnsclient=Yahoo&searchtype=web&search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBio .  $devtteemmpp . "> uBio  ". $devstrspecies . "</a><br><br>";
$Wikipedia = 'http://en.wikipedia.org/wiki/Special:Search?search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Wikipedia .  $devtteemmpp . "> Wikipedia  ". $devstrspecies . "</a><br><br>";
$XenoCanto = 'http://www.xeno-canto.org/species.php?query='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $XenoCanto .  $devtteemmpp . "> Xeno - Canto  ". $devstrspecies . "</a><br><br>";
$Zoonomen = 'http://www.google.com/custom?hl=en&q='.$row['FILENAMEPLUS'] .'&sitesearch=zoonomen.net/';
echo "<a href="http://avis.indianbiodiversity.org/. $Zoonomen .  $devtteemmpp . "> Zoonomen  ". $devstrspecies . "</a><br><br>";

?>
{/tabs}
<?php   
echo "<b>Cite this website along with its URL as:<br></b>";
echo "Anonymous. " .date("Y"). "<i> ".$sn."</i> - ".$row['ABBI_AUTH']." (".$spcn." )<i> in </i>Deomurari, A.N. (Compiler), 2010. AVIS-IBIS (Avian Information System - Indian BioDiversity Information System) v. 1.0. Foundation For Ecological Security, India";
echo " retrieved on ".date("m/d/Y");

?>
]]>
deomurari@gmail.com (Arpit Deomurari) Passeriformes - Pittidae ( Pittas ) Wed, 11 Nov 2009 05:36:10 +0000
Hooded Pitta - Pitta sordida http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/hooded-pitta-pitta-sordida.html http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/hooded-pitta-pitta-sordida.html
<?php
include(getcwd()."/ibisdata/ibisdbdata.php");
global $sn;
global $spcn;

$sn='Pitta sordida';
global $row;
global $result;
global $resultcle;
global $resulthm;
global $rowcle;
global $rowhm;
global $resultbook;
global $rowbook;
global $resultlit;
global $rowlit;
global $usrn;
global $pwds;
global $dbs;
$usrn = $dbusername;
$pwds = $dbpassword;
$dbs = $dbname;
?>
{tab=General Information}
<?php
$temp11 = getcwd();$spath="/images/albums/Passeriformes/Pittidae/Pitta_sordida/";
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_sordida/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute<br><br></b>";
}
else
{
echo '<img alt="'.$sn.'" src="http://avis.indianbiodiversity.org/'.$spath.randimage($fpath).'" width="150" border=0>';echo "<br><br>";}
@ $db = new mysqli('localhost', $usrn, $pwds, $dbs);
if (mysqli_connect_errno()) 
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from jos_master where M_SN = '".$sn."'";
$result = $db->query($query);
$num_results = $result->num_rows;
$row = $result->fetch_assoc();
$CLE_SN_SUB = $row['CLE_SN'];
$HM_SN_SUB = $row['HM_SN'];
$blurl = $row['BL_URL'];
$iucnurl = $row['IUCN_URL'];
$wkurl = $row['WK_URL'];
$querycle = "select * from cle63 where CLE_SN LIKE '".$CLE_SN_SUB."%' AND CLE_CAT <> 'species'";
$resultcle = $db->query($querycle);
$querycle = "select * from hm2006 where HM_SN LIKE '".$HM_SN_SUB."%' AND HM_CAT <> 'species'";
$resulthm = $db->query($querycle);
$spcn=$row['M_CN'];
echo "<b>Common Name : </b>" . $row['M_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['M_SN'] . "</i>";
echo "<b> (</b>" . $row['ABBI_AUTH'] . "<b>)</b><br><br>";
echo "<b>Order : </b>" . $row['M_Order'] ."<br>";
echo "<b>Family : </b>" . $row['M_Family'] . "<br>";
echo "<b>Taxonomic Group : </b>" . $row['M_TaxaGroup'] . "<br>";
if ($row['SYNO_CN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_CN'] . "<br>";
}
if ($row['SYNO_SN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_SN'] . "<br>";
}
if ($row['SYNOPIS_VERNA_NAME'] <> '')
{
echo "<b>Vernacular Name : </b>" . $row['SYNOPIS_VERNA_NAME'] . "</i><br><br>";
}
if ($row['M_Status'] <> '')
{
echo "<b>Status : </b>" . $row['M_Status'] ."<br>";
}
if ($row['M_Remark'] <> '')
{
echo "<b>Remark : </b>" . $row['M_Remark'] ."<br><br>";
}
?>
{slide=Pictures}
<?php
$temp11 = getcwd();
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_sordida/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute</b>";
}
else
{
echo "{ppgallery}albums\Passeriformes\Pittidae\Pitta_sordida{/ppgallery}";
}
?>
{/slide}
{slide=General Species Profile}
{/slide}
{tab=Taxonomy}
{slide=Clements Checklist of Birds of the World 6.4 December 2009 Updated}
<?php
echo "<b>Common Name : </b>" . $row['CLE_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['CLE_SN'] . "</i><br>";
echo "<b>Order : </b>" . $row['CLE_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['CLE_FAMILY'] . "<br>";
if ( $row['CLE_RANGE'] <> '')
{
echo "<b>Range : </b>" . $row['CLE_RANGE'] . "<br><br>";
}
$num_results = $resultcle->num_rows;
if ($num_results == 0 )
{
echo "<b> This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Taxon Category</b></th>
<th><b>Sub Species / Race</b></th>
<th><b>Range</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcle = $resultcle->fetch_assoc();
echo "<td>" . $rowcle['CLE_CAT'] . "</td>";
echo "<td><i>" . $rowcle['CLE_SN'] . "</i></td>";
echo "<td>" . $rowcle['CLE_RANGE'] . "</td>";
echo "<tr>";
}
echo "</table>";
if ( $row['CLE_Remarks'] <> '')
{
echo "<b>Remark : </b>" . $row['CLE_Remarks'] ."<br>";
}
}
?>
{/slide}
{slide=Howard and Moore Complete Checklist of the Birds of the World 2006}
<?php
echo "<b>3rd Edition, 2003.  Revised and Corrected per Corrigenda to December 31, 2006</b><br><br>";
echo "<b>Common Name : </b>" . $row['HM_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['HM_SN'] . "</i><br>";
if ( $row['HM_FAMILY'] <> '')
{
echo "<b>Family : </b>" . $row['HM_FAMILY'] . "<br><br>";
}
if ( $row['HM_Subfamily'] <> '')
{
echo "<b>SubFamily : </b>" . $row['HM_Subfamily'] . "<br><br>";
}
$num_results = $resulthm->num_rows;
if ($num_results == 0 )
{
echo "<b><br>This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Sub Species / Race</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowhm = $resulthm->fetch_assoc();
echo "<td><i>" . $rowhm['HM_SN'] . "</i></td>";
echo "<tr>";
}
echo "</table>";
}
?>
{/slide}
{slide=IOC World Bird Names (version 2.2)}
<?php
if ($row['IOC_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IOC Common Name : </b>" . $row['IOC_CN'] . "<br>";
echo "<b>IOC Scientific Name : </b><i>" . $row['IOC_SN'] . "</i><br><br>";
echo "<b>Distribution : </b><br>";
echo "<b>Region : </b>" . $row['IOC_REG'] ."\t\t";
echo "<b>Range : </b>" . $row['IOC_RANGE'] . "<br>";
if ($row['IOC_NBRANGE'] <> '')
{
echo "<b>Non Breeding Range : </b>" . $row['IOC_NBRANGE'] . "<br><br>";
}
echo "<b>Order : </b>" . $row['IOC_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['IOC_FAM'] . "<br>";
echo "<b>Category : </b>" . $row['IOC_FAMENG'] . "<br>";
if ( $row['IOC_TAXNOTE']<> '')
{
echo "<b>Note: </b>" . $row['IOC_TAXNOTE'] ."";
}
}
?>
{/slide}
{slide=A Synopsis of the Birds of India and Pakistan}
<?php
if ($row['SYNOPIS_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>SYNOPIS NO : </b>" . $row['SYNOPIS_NO'] . "<br><br>";
echo "<b>Scientific Name: </b><i>" . $row['SYNOPIS_SN'] ."</i><br>";
echo "<b>Common Name: </b>" . $row['SYNOPIS_CN'] . "<br>";
}
?>
{/slide}
{slide=Birdlife International Checklist Ver 3 June 2010}
<?php
if ($row['BL_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>Common Name : </b>" . $row['BL_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['BL_SN'] . "</i>\t\t";
echo "<b>(</b>" . $row['BL_AUTH'] ."<b>)</b><br>";
echo "<b>Birdlife Synonym : </b>" . $row['BL_SYN'] . "<br><br>";
echo "<b>BirdLife Redlist Status Year 2010: " . $row['BL_REDLIST2010'] . "</b><br>";


echo "<a href="http://avis.indianbiodiversity.org/. $row['BL_URL'] . "> BirdLife Species FactSheet for " . $row['BL_CN'] . " ( <i> " . $row['BL_SN'] . " )</i></a><br><br>";
echo "<b>Taxonomy Treatment : </b>" . $row['BL_TAXTREAT'] . "<br><br>";
if ($row['BL_TAXNOTE'] <> '')
{
echo "<b>Birdlife Taxonomy Notes : </b>" . $row['BL_TAXNOTE'] . "<br>";
}
}
?>
{/slide}
{slide=International Union for Conservation of Nature and Natural Resources}
<?php
if ($row['IUCN_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IUCN Common Name (Eng) : </b>" . $row['IUCN_CN_ENG'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['IUCN_SN'] . "</i>";
echo "<b> (</b>" . $row['IUCN_AUTH'] ."<b>)</b><br>";
if ($row['IUCN_CN_FRE']<> '')
{
echo " <b>French Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_FRE'])) . "<br>";
}
if ($row['IUCN_CN_SPA ']<> '')
{
echo " <b>Spanish Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_SPA '])) . "<br><br>";
}
echo "<a href="http://avis.indianbiodiversity.org/. $row['IUCN_URL'] . "> IUCN Redlist Species FactSheet for " . $row['IUCN_CN_ENG'] . " ( <i> " . $row['IUCN_SN'] . " )</i></a><br><br>";
echo "<b>Species : </b><i>" . $row['IUCN_SPECIES'] . "</i><br>";
echo "<b>Genus : </b>" . $row['IUCN_GENUS'] . "</i><br>";
echo "<b>Family : </b>" . $row['IUCN_FAMILY'] . "</i>\t\t";
echo "<b>Order : </b>" . $row['IUCN_ORDER'] . "</i><br><br>";
echo "<b>IUCN RedList Status : </b>" . $row['IUCN_RL_STATUS'] . "<br><br>";
if ($row['IUCN_RL_CRI']<> '')
{
echo "<b>IUCN RedList Criteria : </b>" . $row['IUCN_RL_CRI'] . "<br>";
}
echo "<b>IUCN RedList Criteria Version : </b>" . $row['IUCN_RL_CRI_VER'] . "<br>";
echo "<b>IUCN RedList Year Assessed : </b>" . $row['IUCN_RL_YEAR'] . "<br>";
if ($row['IUCN_RL_POP_TREND'] <> '')
{
echo "<b>IUCN RedList Population Trend : </b>" . $row['IUCN_RL_POP_TREND'] . "<br>";
}
if ($row['IUCN_RL_PET'] <> '')
{
echo "<b>IUCN RedList Petitioned : </b>" . $row['IUCN_RL_PET'] . "<br>";
}
}
?>
{/slide}
{slide=Oriental Bird Club Checklist Draft Novemebr 2009}
<?php
if ($row['OBC_SN']=='')
{
echo "No Data Available";
}
else
{echo "<b>Family : </b>" . $row['OBC_FAM'] . "<br><br>";
echo "<b>Scientific Name : </b><i>" . $row['OBC_SN'] ."</i><br>";
echo "<b>Common Name : </b>" . $row['OBC_CN'] . "<br><br>";
if ($row['IOC_DIFF'] <> '')
{
echo "<b>IOC Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['IOC_DIFF'])) . "<br>";
}
if ($row['BL_DIFF'] <> '')
{
echo "<b>Birdlife Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['BL_DIFF'])) . "<br><br>";
}
if ($row['BL_JUST'] <> '')
{
echo "<b>Birdlife Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['BL_JUST'])) . "<br>";
}
if ($row['OBC_JUST'] <> '')
{
echo "<b>OBC Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OBC_JUST'])) . "<br>";
}
if ($row['OTH_JUST'] <> '')
{
echo "<b>Other Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OTH_JUST'])) . "<br>";
}
}
?>
{/slide}
{tab=Bibliography}
<?php
$query = "select distinct Title, Author, SecondaryTitle, Volume, Pages, Fpage, Year from jos_bibliodb where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' order by Year DESC limit 100";
$resultlit = $db->query($query);
$num_results = $resultlit ->num_rows;
if ($num_results == 0 )
{
echo "<b>Currentlly No Literature Avialable</b>";
}
else
{
echo "<b>Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i></b><br>";
echo "<b>Number of Results found : ".$num_results."</b><br><br>";
if($num_results==100)
{
echo "<b>This is latest 100 Papers. To see Complete Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i> Use Species Bibliography Module</b>";
}
for ($i=0; $i <$num_results; $i++)
{
$rowlit = $resultlit ->fetch_assoc();
$tempdata = $i+1;
$tauth=htmlspecialchars_decode(htmlentities($rowlit ['Author']));
$ttitle=htmlspecialchars_decode(htmlentities($rowlit ['Title']));
$tsectitle=htmlspecialchars_decode(htmlentities($rowlit ['SecondaryTitle']));
$tvol=htmlspecialchars_decode(htmlentities($rowlit ['Volume']));
$tpage=htmlspecialchars_decode(htmlentities($rowlit ['Pages']));
$tfpage=htmlspecialchars_decode(htmlentities($rowlit ['Fpage']));
$tyear=htmlspecialchars_decode(htmlentities($rowlit ['Year']));
echo "<P ALIGN=JUSTIFY>";
echo "<b>$tempdata</b>";
echo ". ";
echo "$tauth ";
echo ", (";
echo "$tyear";
echo "), ";
echo "$ttitle";
echo ", ";
echo "<i>";
echo "$tsectitle";
echo "</i>";
echo ", ";
echo "$tvol";
echo ": ";
echo "$tpage";
if ($tfpage <> '')
{
echo " - ";
echo "$tfpage";
}
echo ". ";
echo "<br>";
echo "</p>";
echo "<HR>";
}
}
?>
{tab=Book Excerpts}
<?php
$query = "select * from jos_masterbookdata where NEW_SN = '".$sn."' order by YEAR";
$resultbook = $db->query($query);
$num_results = $resultbook->num_rows;
if ($num_results == 0 )
{
echo "<b>No Data Avialable</b>";
}
else
{
for ($i=0; $i <$num_results; $i++)
{
$rowbook = $resultbook->fetch_assoc();
$Bookname = $rowbook['BOOKNAME'];
$ArtName = $rowbook['ARTICLE_ID'];
$sldstart ='{slide= ';
$sldend= '}<br>';
$incluestart='{include_content_item ';
$incluend=' 1 1}<br>';
$slideend = '{/slide}<br><br>';
echo "$sldstart $Bookname $sldend";
echo "$incluestart $ArtName $incluend";
echo "$slideend";
}
}
?>
{tab=Museum Collections}
<?php
$query = "select * from jos_gbifaves where M_SN = '".$sn."' order by Datecollected";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if ($num_results == 0 )
{
echo "<b> No Data Avialbale for <i>" .$sn. "</i></b>";
}
else
{
echo "<b>Number of Museum Specimen Records Found : ".$num_results."</b> for <i>" .$sn." </i><br><br>";
echo "<table border='1'>
<tr>
<th>No.</th>
<th>Museum</th>
<th>Species</th>
<th>Collection Deatils</th>
<th>Collector</th>
<th>Date of Collection</th>
<th>Record</th>
<th>Locality</th>
<th>GBIF Portal Link</th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<td>".($i+1)."</td>";
echo "<td>" . $rowcoll['Dataprovider'] . "</td>";
echo "<td>" . $rowcoll['SN'] . "</td>";
$temp11 = $rowcoll['Institutioncode'] ." " . $rowcoll['Collectioncode']. " " .$rowcoll['CatalogueNo'];
echo "<td>" . $temp11 . "</td>";
echo "<td>" . $rowcoll['Collectorname'] . "</td>";
echo "<td>" . $rowcoll['Datecollected'] . "</td>";
echo "<td>" . $rowcoll['Basisofrecord'] . "</td>";
$temp22 = $rowcoll['Locality'] ." " . $rowcoll['County'] . " ".$rowcoll['StateProvince']." ".$rowcoll['Countryinterpreted']." ".$rowcoll['ContinentorOcean'] ." ". $rowcoll['Region'];
echo "<td>" .$temp22 ."</td>";
echo "<td> <a href="http://avis.indianbiodiversity.org/. $rowcoll['GBIFportalurl'] ." target=\"_blank\">Link</a></td>";
echo "<tr>";
}
}

echo "</table>";
$query = "select distinct jos_gbifaves.Dataprovider, Count(jos_gbifaves.ID) as cnt from jos_gbifaves where M_SN = '".$sn."'GROUP BY jos_gbifaves.Dataprovider";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if (!$num_results == 0 )
{
echo "<b><br>Biodiversity occurrence data provided by: (Accessed through GBIF Data Portal,  2009-08-06)</b>";
echo "<br><br><b>";
echo "Data Providers</b><br><ul>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<li>" . $rowcoll['Dataprovider']. " ( " . $rowcoll['cnt']. " Records )</li>";
echo "<br>";
}
echo "</ul>";
}
?>
{tab=Sound/Call}
<?php
$query = "select XCNO, remarks, type from jos_xenodata where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' OR KWNEW LIKE '%".$CLE_SN_SUB."%'";
$resultxeno = $db->query($query);
$num_results = $resultxeno->num_rows;
if ($num_results == 0 )
{
echo "<b>No Calls Avialable</b>";
}
else
{
echo $num_results . " calls found for " . $sn ."<br><br>";
echo "<HR>";
for ($i=0; $i<$num_results; $i++)
{
$rowxeno = $resultxeno->fetch_assoc();
$xc = $rowxeno['XCNO'];
$pstart = '<iframe src="http://www.xeno-canto.org/embed.php?XC=';
$pend = '&simple=0" scrolling=no frameborder=0 width=340 height=230></iframe>';
$tt2 ="<br>";
echo "$pstart $xc $pend";
echo "<br>Remarks: " . $rowxeno['remarks'] . "<br>";
echo "Call Type: " . $rowxeno['type'] . "<br>";
echo "<HR>";
}
}
echo 'The Bird Calls are embedded through xeno-canto.org See <a href="http://xeno-canto.org/termsofuse.php">Terms of Use xeno-canto.org</a><br><br>';
?>
{tab=Links}
<?php
$devtteemmpp = ' target="_blank" rel="nofollow"';
$devstrspecies = 'for ' . $row['M_CN'] . ' ( <i> ' . $row['M_SN'] . ' )</i>';
$avibase = 'http://avibase.bsc-eoc.org/avibase.jsp?pg=search&qstr=' . $row['FILENAMEPLUS'];
echo "<br><a href="http://avis.indianbiodiversity.org/. $avibase . $devtteemmpp . "> Avibase - The World Bird Database " . $devstrspecies . "</a><br><br>";
$bldataurl = 'http://www.birdlife.org/datazone/species/index.html?action=SpcHTMDetails.asp&sid=' . $row['BL_ID'] . '&m=0';
echo "<a href="http://avis.indianbiodiversity.org/. $bldataurl . $devtteemmpp . "> BirdLife Species FactSheet " . $devstrspecies . "</a><br><br>";
$bhlurl = 'http://www.biodiversitylibrary.org/name/'.$row['FILENAME'];
echo " <a href="http://avis.indianbiodiversity.org/. $bhlurl . $devtteemmpp . "> Biodiversity Heritage Library ". $devstrspecies . "</a><br><br>";
$dislifemaps = 'http://www.discoverlife.org/mp/20m?kind='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $dislifemaps .  $devtteemmpp . "> Discover Life Maps ". $devstrspecies . "</a><br><br>";
$Entrez  = 'http://www.ncbi.nlm.nih.gov/sites/gquery?term='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Entrez .  $devtteemmpp . "> Entrez, The Life Sciences Search Engine ". $devstrspecies . "</a><br><br>";
$GBIF = 'http://data.gbif.org/species/species/'.$row['FILENAME'];
echo "<a href="http://avis.indianbiodiversity.org/. $GBIF .  $devtteemmpp . "> GBIF, Global Biodiversity Information Facility ". $devstrspecies . "</a><br><br>";
$GoogleImages = 'http://images.google.com/images?q=' . $row['FILENAMEPLUS'] . '&hl=en&sa=N&tab=wi';
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleImages .  $devtteemmpp . "> Google Images ". $devstrspecies . "</a><br><br>";
$GoogleScholar  = 'http://scholar.google.com/scholar?hl=en&num=20&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleScholar .  $devtteemmpp . "> Google Scholar ". $devstrspecies . "</a><br><br>";
$GoogleWebsites = 'http://www.google.com/search?sourceid=navclient&querytime=sC&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleWebsites .  $devtteemmpp . "> Google Websites ". $devstrspecies . "</a><br><br>";
$ITIS = 'http://www.itis.gov/servlet/SingleRpt/SingleRpt?search_topic=TSN&searchvalue=' . $row['ITIS_TSN'];
echo "<a href="http://avis.indianbiodiversity.org/. $ITIS .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) ". $devstrspecies . "</a><br><br>";
$ITISCA = 'http://www.cbif.gc.ca/pls/itisca/next?v_tsn=' . $row['ITIS_TSN'] . '&taxa=&p_format=&p_ifx=cbif&p_lang=';
echo "<a href="http://avis.indianbiodiversity.org/. $ITISCA .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) CANADA ". $devstrspecies . "</a><br><br>";
$iucndata = 'http://www.iucnredlist.org/details/'.$row['IUCN_ID'];
echo "<a href="http://avis.indianbiodiversity.org/. $iucndata .  $devtteemmpp . "> IUCN Redlist Species FactSheet ". $devstrspecies . "</a><br><br>";
$ncbi = 'http://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?name='.$row['FILENAMEPLUS'] . '&lvl=0';
echo "<a href="http://avis.indianbiodiversity.org/. $ncbi .  $devtteemmpp . "> NCBI Molecular Data ". $devstrspecies . "</a><br><br>";
$Pubmed = 'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Search&term='.$row['FILENAMEPLUS'] . '&doptcmdl=DocSum';
echo "<a href="http://avis.indianbiodiversity.org/. $Pubmed .  $devtteemmpp . "> Pubmed Literature ". $devstrspecies . "</a><br><br>";
$catlife = 'http://www.catalogueoflife.org/annual-checklist/2010/search/all/key/'.$row['FILENAMEPLUS'] ;
echo "<a href="http://avis.indianbiodiversity.org/. $catlife .  $devtteemmpp . "> Catalogue of Life : Annual Checklist ". $devstrspecies . "</a><br><br>";
$treelife = 'http://tolweb.org/tree/home.pages/searchTOL?taxon='.$row['FILENAMEPLUS'] . '&Submit2=Find';
echo "<a href="http://avis.indianbiodiversity.org/. $treelife .  $devtteemmpp . "> Tree Of Life ". $devstrspecies . "</a><br><br>";
$uBioPortal = 'http://www.ubio.org/browser/search.php?search_all='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBioPortal .  $devtteemmpp . "> uBio Portal ". $devstrspecies . "</a><br><br>";
$uBio = 'http://portal.ubio.org/index.php?tnsnav=lists&map=&start=0&tnsclient=Yahoo&searchtype=web&search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBio .  $devtteemmpp . "> uBio  ". $devstrspecies . "</a><br><br>";
$Wikipedia = 'http://en.wikipedia.org/wiki/Special:Search?search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Wikipedia .  $devtteemmpp . "> Wikipedia  ". $devstrspecies . "</a><br><br>";
$XenoCanto = 'http://www.xeno-canto.org/species.php?query='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $XenoCanto .  $devtteemmpp . "> Xeno - Canto  ". $devstrspecies . "</a><br><br>";
$Zoonomen = 'http://www.google.com/custom?hl=en&q='.$row['FILENAMEPLUS'] .'&sitesearch=zoonomen.net/';
echo "<a href="http://avis.indianbiodiversity.org/. $Zoonomen .  $devtteemmpp . "> Zoonomen  ". $devstrspecies . "</a><br><br>";

?>
{/tabs}
<?php   
echo "<b>Cite this website along with its URL as:<br></b>";
echo "Anonymous. " .date("Y"). "<i> ".$sn."</i> - ".$row['ABBI_AUTH']." (".$spcn." )<i> in </i>Deomurari, A.N. (Compiler), 2010. AVIS-IBIS (Avian Information System - Indian BioDiversity Information System) v. 1.0. Foundation For Ecological Security, India";
echo " retrieved on ".date("m/d/Y");

?>
]]>
deomurari@gmail.com (Arpit Deomurari) Passeriformes - Pittidae ( Pittas ) Wed, 11 Nov 2009 05:36:10 +0000
Indian Pitta - Pitta brachyura http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/indian-pitta-pitta-brachyura.html http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/indian-pitta-pitta-brachyura.html
<?php
include(getcwd()."/ibisdata/ibisdbdata.php");
global $sn;
global $spcn;

$sn='Pitta brachyura';
global $row;
global $result;
global $resultcle;
global $resulthm;
global $rowcle;
global $rowhm;
global $resultbook;
global $rowbook;
global $resultlit;
global $rowlit;
global $usrn;
global $pwds;
global $dbs;
$usrn = $dbusername;
$pwds = $dbpassword;
$dbs = $dbname;
?>
{tab=General Information}
<?php
$temp11 = getcwd();$spath="/images/albums/Passeriformes/Pittidae/Pitta_brachyura/";
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_brachyura/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute<br><br></b>";
}
else
{
echo '<img alt="'.$sn.'" src="http://avis.indianbiodiversity.org/'.$spath.randimage($fpath).'" width="150" border=0>';echo "<br><br>";}
@ $db = new mysqli('localhost', $usrn, $pwds, $dbs);
if (mysqli_connect_errno()) 
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from jos_master where M_SN = '".$sn."'";
$result = $db->query($query);
$num_results = $result->num_rows;
$row = $result->fetch_assoc();
$CLE_SN_SUB = $row['CLE_SN'];
$HM_SN_SUB = $row['HM_SN'];
$blurl = $row['BL_URL'];
$iucnurl = $row['IUCN_URL'];
$wkurl = $row['WK_URL'];
$querycle = "select * from cle63 where CLE_SN LIKE '".$CLE_SN_SUB."%' AND CLE_CAT <> 'species'";
$resultcle = $db->query($querycle);
$querycle = "select * from hm2006 where HM_SN LIKE '".$HM_SN_SUB."%' AND HM_CAT <> 'species'";
$resulthm = $db->query($querycle);
$spcn=$row['M_CN'];
echo "<b>Common Name : </b>" . $row['M_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['M_SN'] . "</i>";
echo "<b> (</b>" . $row['ABBI_AUTH'] . "<b>)</b><br><br>";
echo "<b>Order : </b>" . $row['M_Order'] ."<br>";
echo "<b>Family : </b>" . $row['M_Family'] . "<br>";
echo "<b>Taxonomic Group : </b>" . $row['M_TaxaGroup'] . "<br>";
if ($row['SYNO_CN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_CN'] . "<br>";
}
if ($row['SYNO_SN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_SN'] . "<br>";
}
if ($row['SYNOPIS_VERNA_NAME'] <> '')
{
echo "<b>Vernacular Name : </b>" . $row['SYNOPIS_VERNA_NAME'] . "</i><br><br>";
}
if ($row['M_Status'] <> '')
{
echo "<b>Status : </b>" . $row['M_Status'] ."<br>";
}
if ($row['M_Remark'] <> '')
{
echo "<b>Remark : </b>" . $row['M_Remark'] ."<br><br>";
}
?>
{slide=Pictures}
<?php
$temp11 = getcwd();
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_brachyura/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute</b>";
}
else
{
echo "{ppgallery}albums\Passeriformes\Pittidae\Pitta_brachyura{/ppgallery}";
}
?>
{/slide}
{slide=General Species Profile}
{/slide}
{tab=Taxonomy}
{slide=Clements Checklist of Birds of the World 6.4 December 2009 Updated}
<?php
echo "<b>Common Name : </b>" . $row['CLE_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['CLE_SN'] . "</i><br>";
echo "<b>Order : </b>" . $row['CLE_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['CLE_FAMILY'] . "<br>";
if ( $row['CLE_RANGE'] <> '')
{
echo "<b>Range : </b>" . $row['CLE_RANGE'] . "<br><br>";
}
$num_results = $resultcle->num_rows;
if ($num_results == 0 )
{
echo "<b> This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Taxon Category</b></th>
<th><b>Sub Species / Race</b></th>
<th><b>Range</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcle = $resultcle->fetch_assoc();
echo "<td>" . $rowcle['CLE_CAT'] . "</td>";
echo "<td><i>" . $rowcle['CLE_SN'] . "</i></td>";
echo "<td>" . $rowcle['CLE_RANGE'] . "</td>";
echo "<tr>";
}
echo "</table>";
if ( $row['CLE_Remarks'] <> '')
{
echo "<b>Remark : </b>" . $row['CLE_Remarks'] ."<br>";
}
}
?>
{/slide}
{slide=Howard and Moore Complete Checklist of the Birds of the World 2006}
<?php
echo "<b>3rd Edition, 2003.  Revised and Corrected per Corrigenda to December 31, 2006</b><br><br>";
echo "<b>Common Name : </b>" . $row['HM_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['HM_SN'] . "</i><br>";
if ( $row['HM_FAMILY'] <> '')
{
echo "<b>Family : </b>" . $row['HM_FAMILY'] . "<br><br>";
}
if ( $row['HM_Subfamily'] <> '')
{
echo "<b>SubFamily : </b>" . $row['HM_Subfamily'] . "<br><br>";
}
$num_results = $resulthm->num_rows;
if ($num_results == 0 )
{
echo "<b><br>This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Sub Species / Race</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowhm = $resulthm->fetch_assoc();
echo "<td><i>" . $rowhm['HM_SN'] . "</i></td>";
echo "<tr>";
}
echo "</table>";
}
?>
{/slide}
{slide=IOC World Bird Names (version 2.2)}
<?php
if ($row['IOC_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IOC Common Name : </b>" . $row['IOC_CN'] . "<br>";
echo "<b>IOC Scientific Name : </b><i>" . $row['IOC_SN'] . "</i><br><br>";
echo "<b>Distribution : </b><br>";
echo "<b>Region : </b>" . $row['IOC_REG'] ."\t\t";
echo "<b>Range : </b>" . $row['IOC_RANGE'] . "<br>";
if ($row['IOC_NBRANGE'] <> '')
{
echo "<b>Non Breeding Range : </b>" . $row['IOC_NBRANGE'] . "<br><br>";
}
echo "<b>Order : </b>" . $row['IOC_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['IOC_FAM'] . "<br>";
echo "<b>Category : </b>" . $row['IOC_FAMENG'] . "<br>";
if ( $row['IOC_TAXNOTE']<> '')
{
echo "<b>Note: </b>" . $row['IOC_TAXNOTE'] ."";
}
}
?>
{/slide}
{slide=A Synopsis of the Birds of India and Pakistan}
<?php
if ($row['SYNOPIS_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>SYNOPIS NO : </b>" . $row['SYNOPIS_NO'] . "<br><br>";
echo "<b>Scientific Name: </b><i>" . $row['SYNOPIS_SN'] ."</i><br>";
echo "<b>Common Name: </b>" . $row['SYNOPIS_CN'] . "<br>";
}
?>
{/slide}
{slide=Birdlife International Checklist Ver 3 June 2010}
<?php
if ($row['BL_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>Common Name : </b>" . $row['BL_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['BL_SN'] . "</i>\t\t";
echo "<b>(</b>" . $row['BL_AUTH'] ."<b>)</b><br>";
echo "<b>Birdlife Synonym : </b>" . $row['BL_SYN'] . "<br><br>";
echo "<b>BirdLife Redlist Status Year 2010: " . $row['BL_REDLIST2010'] . "</b><br>";


echo "<a href="http://avis.indianbiodiversity.org/. $row['BL_URL'] . "> BirdLife Species FactSheet for " . $row['BL_CN'] . " ( <i> " . $row['BL_SN'] . " )</i></a><br><br>";
echo "<b>Taxonomy Treatment : </b>" . $row['BL_TAXTREAT'] . "<br><br>";
if ($row['BL_TAXNOTE'] <> '')
{
echo "<b>Birdlife Taxonomy Notes : </b>" . $row['BL_TAXNOTE'] . "<br>";
}
}
?>
{/slide}
{slide=International Union for Conservation of Nature and Natural Resources}
<?php
if ($row['IUCN_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IUCN Common Name (Eng) : </b>" . $row['IUCN_CN_ENG'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['IUCN_SN'] . "</i>";
echo "<b> (</b>" . $row['IUCN_AUTH'] ."<b>)</b><br>";
if ($row['IUCN_CN_FRE']<> '')
{
echo " <b>French Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_FRE'])) . "<br>";
}
if ($row['IUCN_CN_SPA ']<> '')
{
echo " <b>Spanish Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_SPA '])) . "<br><br>";
}
echo "<a href="http://avis.indianbiodiversity.org/. $row['IUCN_URL'] . "> IUCN Redlist Species FactSheet for " . $row['IUCN_CN_ENG'] . " ( <i> " . $row['IUCN_SN'] . " )</i></a><br><br>";
echo "<b>Species : </b><i>" . $row['IUCN_SPECIES'] . "</i><br>";
echo "<b>Genus : </b>" . $row['IUCN_GENUS'] . "</i><br>";
echo "<b>Family : </b>" . $row['IUCN_FAMILY'] . "</i>\t\t";
echo "<b>Order : </b>" . $row['IUCN_ORDER'] . "</i><br><br>";
echo "<b>IUCN RedList Status : </b>" . $row['IUCN_RL_STATUS'] . "<br><br>";
if ($row['IUCN_RL_CRI']<> '')
{
echo "<b>IUCN RedList Criteria : </b>" . $row['IUCN_RL_CRI'] . "<br>";
}
echo "<b>IUCN RedList Criteria Version : </b>" . $row['IUCN_RL_CRI_VER'] . "<br>";
echo "<b>IUCN RedList Year Assessed : </b>" . $row['IUCN_RL_YEAR'] . "<br>";
if ($row['IUCN_RL_POP_TREND'] <> '')
{
echo "<b>IUCN RedList Population Trend : </b>" . $row['IUCN_RL_POP_TREND'] . "<br>";
}
if ($row['IUCN_RL_PET'] <> '')
{
echo "<b>IUCN RedList Petitioned : </b>" . $row['IUCN_RL_PET'] . "<br>";
}
}
?>
{/slide}
{slide=Oriental Bird Club Checklist Draft Novemebr 2009}
<?php
if ($row['OBC_SN']=='')
{
echo "No Data Available";
}
else
{echo "<b>Family : </b>" . $row['OBC_FAM'] . "<br><br>";
echo "<b>Scientific Name : </b><i>" . $row['OBC_SN'] ."</i><br>";
echo "<b>Common Name : </b>" . $row['OBC_CN'] . "<br><br>";
if ($row['IOC_DIFF'] <> '')
{
echo "<b>IOC Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['IOC_DIFF'])) . "<br>";
}
if ($row['BL_DIFF'] <> '')
{
echo "<b>Birdlife Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['BL_DIFF'])) . "<br><br>";
}
if ($row['BL_JUST'] <> '')
{
echo "<b>Birdlife Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['BL_JUST'])) . "<br>";
}
if ($row['OBC_JUST'] <> '')
{
echo "<b>OBC Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OBC_JUST'])) . "<br>";
}
if ($row['OTH_JUST'] <> '')
{
echo "<b>Other Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OTH_JUST'])) . "<br>";
}
}
?>
{/slide}
{tab=Bibliography}
<?php
$query = "select distinct Title, Author, SecondaryTitle, Volume, Pages, Fpage, Year from jos_bibliodb where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' order by Year DESC limit 100";
$resultlit = $db->query($query);
$num_results = $resultlit ->num_rows;
if ($num_results == 0 )
{
echo "<b>Currentlly No Literature Avialable</b>";
}
else
{
echo "<b>Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i></b><br>";
echo "<b>Number of Results found : ".$num_results."</b><br><br>";
if($num_results==100)
{
echo "<b>This is latest 100 Papers. To see Complete Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i> Use Species Bibliography Module</b>";
}
for ($i=0; $i <$num_results; $i++)
{
$rowlit = $resultlit ->fetch_assoc();
$tempdata = $i+1;
$tauth=htmlspecialchars_decode(htmlentities($rowlit ['Author']));
$ttitle=htmlspecialchars_decode(htmlentities($rowlit ['Title']));
$tsectitle=htmlspecialchars_decode(htmlentities($rowlit ['SecondaryTitle']));
$tvol=htmlspecialchars_decode(htmlentities($rowlit ['Volume']));
$tpage=htmlspecialchars_decode(htmlentities($rowlit ['Pages']));
$tfpage=htmlspecialchars_decode(htmlentities($rowlit ['Fpage']));
$tyear=htmlspecialchars_decode(htmlentities($rowlit ['Year']));
echo "<P ALIGN=JUSTIFY>";
echo "<b>$tempdata</b>";
echo ". ";
echo "$tauth ";
echo ", (";
echo "$tyear";
echo "), ";
echo "$ttitle";
echo ", ";
echo "<i>";
echo "$tsectitle";
echo "</i>";
echo ", ";
echo "$tvol";
echo ": ";
echo "$tpage";
if ($tfpage <> '')
{
echo " - ";
echo "$tfpage";
}
echo ". ";
echo "<br>";
echo "</p>";
echo "<HR>";
}
}
?>
{tab=Book Excerpts}
<?php
$query = "select * from jos_masterbookdata where NEW_SN = '".$sn."' order by YEAR";
$resultbook = $db->query($query);
$num_results = $resultbook->num_rows;
if ($num_results == 0 )
{
echo "<b>No Data Avialable</b>";
}
else
{
for ($i=0; $i <$num_results; $i++)
{
$rowbook = $resultbook->fetch_assoc();
$Bookname = $rowbook['BOOKNAME'];
$ArtName = $rowbook['ARTICLE_ID'];
$sldstart ='{slide= ';
$sldend= '}<br>';
$incluestart='{include_content_item ';
$incluend=' 1 1}<br>';
$slideend = '{/slide}<br><br>';
echo "$sldstart $Bookname $sldend";
echo "$incluestart $ArtName $incluend";
echo "$slideend";
}
}
?>
{tab=Museum Collections}
<?php
$query = "select * from jos_gbifaves where M_SN = '".$sn."' order by Datecollected";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if ($num_results == 0 )
{
echo "<b> No Data Avialbale for <i>" .$sn. "</i></b>";
}
else
{
echo "<b>Number of Museum Specimen Records Found : ".$num_results."</b> for <i>" .$sn." </i><br><br>";
echo "<table border='1'>
<tr>
<th>No.</th>
<th>Museum</th>
<th>Species</th>
<th>Collection Deatils</th>
<th>Collector</th>
<th>Date of Collection</th>
<th>Record</th>
<th>Locality</th>
<th>GBIF Portal Link</th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<td>".($i+1)."</td>";
echo "<td>" . $rowcoll['Dataprovider'] . "</td>";
echo "<td>" . $rowcoll['SN'] . "</td>";
$temp11 = $rowcoll['Institutioncode'] ." " . $rowcoll['Collectioncode']. " " .$rowcoll['CatalogueNo'];
echo "<td>" . $temp11 . "</td>";
echo "<td>" . $rowcoll['Collectorname'] . "</td>";
echo "<td>" . $rowcoll['Datecollected'] . "</td>";
echo "<td>" . $rowcoll['Basisofrecord'] . "</td>";
$temp22 = $rowcoll['Locality'] ." " . $rowcoll['County'] . " ".$rowcoll['StateProvince']." ".$rowcoll['Countryinterpreted']." ".$rowcoll['ContinentorOcean'] ." ". $rowcoll['Region'];
echo "<td>" .$temp22 ."</td>";
echo "<td> <a href="http://avis.indianbiodiversity.org/. $rowcoll['GBIFportalurl'] ." target=\"_blank\">Link</a></td>";
echo "<tr>";
}
}

echo "</table>";
$query = "select distinct jos_gbifaves.Dataprovider, Count(jos_gbifaves.ID) as cnt from jos_gbifaves where M_SN = '".$sn."'GROUP BY jos_gbifaves.Dataprovider";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if (!$num_results == 0 )
{
echo "<b><br>Biodiversity occurrence data provided by: (Accessed through GBIF Data Portal,  2009-08-06)</b>";
echo "<br><br><b>";
echo "Data Providers</b><br><ul>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<li>" . $rowcoll['Dataprovider']. " ( " . $rowcoll['cnt']. " Records )</li>";
echo "<br>";
}
echo "</ul>";
}
?>
{tab=Sound/Call}
<?php
$query = "select XCNO, remarks, type from jos_xenodata where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' OR KWNEW LIKE '%".$CLE_SN_SUB."%'";
$resultxeno = $db->query($query);
$num_results = $resultxeno->num_rows;
if ($num_results == 0 )
{
echo "<b>No Calls Avialable</b>";
}
else
{
echo $num_results . " calls found for " . $sn ."<br><br>";
echo "<HR>";
for ($i=0; $i<$num_results; $i++)
{
$rowxeno = $resultxeno->fetch_assoc();
$xc = $rowxeno['XCNO'];
$pstart = '<iframe src="http://www.xeno-canto.org/embed.php?XC=';
$pend = '&simple=0" scrolling=no frameborder=0 width=340 height=230></iframe>';
$tt2 ="<br>";
echo "$pstart $xc $pend";
echo "<br>Remarks: " . $rowxeno['remarks'] . "<br>";
echo "Call Type: " . $rowxeno['type'] . "<br>";
echo "<HR>";
}
}
echo 'The Bird Calls are embedded through xeno-canto.org See <a href="http://xeno-canto.org/termsofuse.php">Terms of Use xeno-canto.org</a><br><br>';
?>
{tab=Links}
<?php
$devtteemmpp = ' target="_blank" rel="nofollow"';
$devstrspecies = 'for ' . $row['M_CN'] . ' ( <i> ' . $row['M_SN'] . ' )</i>';
$avibase = 'http://avibase.bsc-eoc.org/avibase.jsp?pg=search&qstr=' . $row['FILENAMEPLUS'];
echo "<br><a href="http://avis.indianbiodiversity.org/. $avibase . $devtteemmpp . "> Avibase - The World Bird Database " . $devstrspecies . "</a><br><br>";
$bldataurl = 'http://www.birdlife.org/datazone/species/index.html?action=SpcHTMDetails.asp&sid=' . $row['BL_ID'] . '&m=0';
echo "<a href="http://avis.indianbiodiversity.org/. $bldataurl . $devtteemmpp . "> BirdLife Species FactSheet " . $devstrspecies . "</a><br><br>";
$bhlurl = 'http://www.biodiversitylibrary.org/name/'.$row['FILENAME'];
echo " <a href="http://avis.indianbiodiversity.org/. $bhlurl . $devtteemmpp . "> Biodiversity Heritage Library ". $devstrspecies . "</a><br><br>";
$dislifemaps = 'http://www.discoverlife.org/mp/20m?kind='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $dislifemaps .  $devtteemmpp . "> Discover Life Maps ". $devstrspecies . "</a><br><br>";
$Entrez  = 'http://www.ncbi.nlm.nih.gov/sites/gquery?term='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Entrez .  $devtteemmpp . "> Entrez, The Life Sciences Search Engine ". $devstrspecies . "</a><br><br>";
$GBIF = 'http://data.gbif.org/species/species/'.$row['FILENAME'];
echo "<a href="http://avis.indianbiodiversity.org/. $GBIF .  $devtteemmpp . "> GBIF, Global Biodiversity Information Facility ". $devstrspecies . "</a><br><br>";
$GoogleImages = 'http://images.google.com/images?q=' . $row['FILENAMEPLUS'] . '&hl=en&sa=N&tab=wi';
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleImages .  $devtteemmpp . "> Google Images ". $devstrspecies . "</a><br><br>";
$GoogleScholar  = 'http://scholar.google.com/scholar?hl=en&num=20&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleScholar .  $devtteemmpp . "> Google Scholar ". $devstrspecies . "</a><br><br>";
$GoogleWebsites = 'http://www.google.com/search?sourceid=navclient&querytime=sC&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleWebsites .  $devtteemmpp . "> Google Websites ". $devstrspecies . "</a><br><br>";
$ITIS = 'http://www.itis.gov/servlet/SingleRpt/SingleRpt?search_topic=TSN&searchvalue=' . $row['ITIS_TSN'];
echo "<a href="http://avis.indianbiodiversity.org/. $ITIS .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) ". $devstrspecies . "</a><br><br>";
$ITISCA = 'http://www.cbif.gc.ca/pls/itisca/next?v_tsn=' . $row['ITIS_TSN'] . '&taxa=&p_format=&p_ifx=cbif&p_lang=';
echo "<a href="http://avis.indianbiodiversity.org/. $ITISCA .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) CANADA ". $devstrspecies . "</a><br><br>";
$iucndata = 'http://www.iucnredlist.org/details/'.$row['IUCN_ID'];
echo "<a href="http://avis.indianbiodiversity.org/. $iucndata .  $devtteemmpp . "> IUCN Redlist Species FactSheet ". $devstrspecies . "</a><br><br>";
$ncbi = 'http://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?name='.$row['FILENAMEPLUS'] . '&lvl=0';
echo "<a href="http://avis.indianbiodiversity.org/. $ncbi .  $devtteemmpp . "> NCBI Molecular Data ". $devstrspecies . "</a><br><br>";
$Pubmed = 'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Search&term='.$row['FILENAMEPLUS'] . '&doptcmdl=DocSum';
echo "<a href="http://avis.indianbiodiversity.org/. $Pubmed .  $devtteemmpp . "> Pubmed Literature ". $devstrspecies . "</a><br><br>";
$catlife = 'http://www.catalogueoflife.org/annual-checklist/2010/search/all/key/'.$row['FILENAMEPLUS'] ;
echo "<a href="http://avis.indianbiodiversity.org/. $catlife .  $devtteemmpp . "> Catalogue of Life : Annual Checklist ". $devstrspecies . "</a><br><br>";
$treelife = 'http://tolweb.org/tree/home.pages/searchTOL?taxon='.$row['FILENAMEPLUS'] . '&Submit2=Find';
echo "<a href="http://avis.indianbiodiversity.org/. $treelife .  $devtteemmpp . "> Tree Of Life ". $devstrspecies . "</a><br><br>";
$uBioPortal = 'http://www.ubio.org/browser/search.php?search_all='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBioPortal .  $devtteemmpp . "> uBio Portal ". $devstrspecies . "</a><br><br>";
$uBio = 'http://portal.ubio.org/index.php?tnsnav=lists&map=&start=0&tnsclient=Yahoo&searchtype=web&search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBio .  $devtteemmpp . "> uBio  ". $devstrspecies . "</a><br><br>";
$Wikipedia = 'http://en.wikipedia.org/wiki/Special:Search?search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Wikipedia .  $devtteemmpp . "> Wikipedia  ". $devstrspecies . "</a><br><br>";
$XenoCanto = 'http://www.xeno-canto.org/species.php?query='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $XenoCanto .  $devtteemmpp . "> Xeno - Canto  ". $devstrspecies . "</a><br><br>";
$Zoonomen = 'http://www.google.com/custom?hl=en&q='.$row['FILENAMEPLUS'] .'&sitesearch=zoonomen.net/';
echo "<a href="http://avis.indianbiodiversity.org/. $Zoonomen .  $devtteemmpp . "> Zoonomen  ". $devstrspecies . "</a><br><br>";

?>
{/tabs}
<?php   
echo "<b>Cite this website along with its URL as:<br></b>";
echo "Anonymous. " .date("Y"). "<i> ".$sn."</i> - ".$row['ABBI_AUTH']." (".$spcn." )<i> in </i>Deomurari, A.N. (Compiler), 2010. AVIS-IBIS (Avian Information System - Indian BioDiversity Information System) v. 1.0. Foundation For Ecological Security, India";
echo " retrieved on ".date("m/d/Y");

?>
]]>
deomurari@gmail.com (Arpit Deomurari) Passeriformes - Pittidae ( Pittas ) Wed, 11 Nov 2009 05:36:10 +0000
Mangrove Pitta - Pitta megarhyncha http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/mangrove-pitta-pitta-megarhyncha.html http://avis.indianbiodiversity.org/passeriformes-pittidae-pittas/mangrove-pitta-pitta-megarhyncha.html
<?php
include(getcwd()."/ibisdata/ibisdbdata.php");
global $sn;
global $spcn;

$sn='Pitta megarhyncha';
global $row;
global $result;
global $resultcle;
global $resulthm;
global $rowcle;
global $rowhm;
global $resultbook;
global $rowbook;
global $resultlit;
global $rowlit;
global $usrn;
global $pwds;
global $dbs;
$usrn = $dbusername;
$pwds = $dbpassword;
$dbs = $dbname;
?>
{tab=General Information}
<?php
$temp11 = getcwd();$spath="/images/albums/Passeriformes/Pittidae/Pitta_megarhyncha/";
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_megarhyncha/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute<br><br></b>";
}
else
{
echo '<img alt="'.$sn.'" src="http://avis.indianbiodiversity.org/'.$spath.randimage($fpath).'" width="150" border=0>';echo "<br><br>";}
@ $db = new mysqli('localhost', $usrn, $pwds, $dbs);
if (mysqli_connect_errno()) 
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from jos_master where M_SN = '".$sn."'";
$result = $db->query($query);
$num_results = $result->num_rows;
$row = $result->fetch_assoc();
$CLE_SN_SUB = $row['CLE_SN'];
$HM_SN_SUB = $row['HM_SN'];
$blurl = $row['BL_URL'];
$iucnurl = $row['IUCN_URL'];
$wkurl = $row['WK_URL'];
$querycle = "select * from cle63 where CLE_SN LIKE '".$CLE_SN_SUB."%' AND CLE_CAT <> 'species'";
$resultcle = $db->query($querycle);
$querycle = "select * from hm2006 where HM_SN LIKE '".$HM_SN_SUB."%' AND HM_CAT <> 'species'";
$resulthm = $db->query($querycle);
$spcn=$row['M_CN'];
echo "<b>Common Name : </b>" . $row['M_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['M_SN'] . "</i>";
echo "<b> (</b>" . $row['ABBI_AUTH'] . "<b>)</b><br><br>";
echo "<b>Order : </b>" . $row['M_Order'] ."<br>";
echo "<b>Family : </b>" . $row['M_Family'] . "<br>";
echo "<b>Taxonomic Group : </b>" . $row['M_TaxaGroup'] . "<br>";
if ($row['SYNO_CN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_CN'] . "<br>";
}
if ($row['SYNO_SN'] <> '')
{
echo "<b>Synonym Common Name : </b>" . $row['SYNO_SN'] . "<br>";
}
if ($row['SYNOPIS_VERNA_NAME'] <> '')
{
echo "<b>Vernacular Name : </b>" . $row['SYNOPIS_VERNA_NAME'] . "</i><br><br>";
}
if ($row['M_Status'] <> '')
{
echo "<b>Status : </b>" . $row['M_Status'] ."<br>";
}
if ($row['M_Remark'] <> '')
{
echo "<b>Remark : </b>" . $row['M_Remark'] ."<br><br>";
}
?>
{slide=Pictures}
<?php
$temp11 = getcwd();
$fpath=$temp11."/images/albums/Passeriformes/Pittidae/Pitta_megarhyncha/";
if (is_empty_dir($fpath))
{
Echo "<b>No Images available for the Species. Please Contribute</b>";
}
else
{
echo "{ppgallery}albums\Passeriformes\Pittidae\Pitta_megarhyncha{/ppgallery}";
}
?>
{/slide}
{slide=General Species Profile}
{/slide}
{tab=Taxonomy}
{slide=Clements Checklist of Birds of the World 6.4 December 2009 Updated}
<?php
echo "<b>Common Name : </b>" . $row['CLE_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['CLE_SN'] . "</i><br>";
echo "<b>Order : </b>" . $row['CLE_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['CLE_FAMILY'] . "<br>";
if ( $row['CLE_RANGE'] <> '')
{
echo "<b>Range : </b>" . $row['CLE_RANGE'] . "<br><br>";
}
$num_results = $resultcle->num_rows;
if ($num_results == 0 )
{
echo "<b> This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Taxon Category</b></th>
<th><b>Sub Species / Race</b></th>
<th><b>Range</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcle = $resultcle->fetch_assoc();
echo "<td>" . $rowcle['CLE_CAT'] . "</td>";
echo "<td><i>" . $rowcle['CLE_SN'] . "</i></td>";
echo "<td>" . $rowcle['CLE_RANGE'] . "</td>";
echo "<tr>";
}
echo "</table>";
if ( $row['CLE_Remarks'] <> '')
{
echo "<b>Remark : </b>" . $row['CLE_Remarks'] ."<br>";
}
}
?>
{/slide}
{slide=Howard and Moore Complete Checklist of the Birds of the World 2006}
<?php
echo "<b>3rd Edition, 2003.  Revised and Corrected per Corrigenda to December 31, 2006</b><br><br>";
echo "<b>Common Name : </b>" . $row['HM_CN'] . "</i><br>";
echo "<b>Scientific Name : </b><i>" . $row['HM_SN'] . "</i><br>";
if ( $row['HM_FAMILY'] <> '')
{
echo "<b>Family : </b>" . $row['HM_FAMILY'] . "<br><br>";
}
if ( $row['HM_Subfamily'] <> '')
{
echo "<b>SubFamily : </b>" . $row['HM_Subfamily'] . "<br><br>";
}
$num_results = $resulthm->num_rows;
if ($num_results == 0 )
{
echo "<b><br>This Species is Monotypic, No Subspecies</b>";
}
else
{
echo "<b>Number of SubSpecies : ".$num_results."</b><br><br>";
echo "<table border='1' cellpadding='10'>
<tr>
<th><b>Sub Species / Race</b></th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowhm = $resulthm->fetch_assoc();
echo "<td><i>" . $rowhm['HM_SN'] . "</i></td>";
echo "<tr>";
}
echo "</table>";
}
?>
{/slide}
{slide=IOC World Bird Names (version 2.2)}
<?php
if ($row['IOC_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IOC Common Name : </b>" . $row['IOC_CN'] . "<br>";
echo "<b>IOC Scientific Name : </b><i>" . $row['IOC_SN'] . "</i><br><br>";
echo "<b>Distribution : </b><br>";
echo "<b>Region : </b>" . $row['IOC_REG'] ."\t\t";
echo "<b>Range : </b>" . $row['IOC_RANGE'] . "<br>";
if ($row['IOC_NBRANGE'] <> '')
{
echo "<b>Non Breeding Range : </b>" . $row['IOC_NBRANGE'] . "<br><br>";
}
echo "<b>Order : </b>" . $row['IOC_ORDER'] ."\t\t";
echo "<b>Family : </b>" . $row['IOC_FAM'] . "<br>";
echo "<b>Category : </b>" . $row['IOC_FAMENG'] . "<br>";
if ( $row['IOC_TAXNOTE']<> '')
{
echo "<b>Note: </b>" . $row['IOC_TAXNOTE'] ."";
}
}
?>
{/slide}
{slide=A Synopsis of the Birds of India and Pakistan}
<?php
if ($row['SYNOPIS_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>SYNOPIS NO : </b>" . $row['SYNOPIS_NO'] . "<br><br>";
echo "<b>Scientific Name: </b><i>" . $row['SYNOPIS_SN'] ."</i><br>";
echo "<b>Common Name: </b>" . $row['SYNOPIS_CN'] . "<br>";
}
?>
{/slide}
{slide=Birdlife International Checklist Ver 3 June 2010}
<?php
if ($row['BL_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>Common Name : </b>" . $row['BL_CN'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['BL_SN'] . "</i>\t\t";
echo "<b>(</b>" . $row['BL_AUTH'] ."<b>)</b><br>";
echo "<b>Birdlife Synonym : </b>" . $row['BL_SYN'] . "<br><br>";
echo "<b>BirdLife Redlist Status Year 2010: " . $row['BL_REDLIST2010'] . "</b><br>";


echo "<a href="http://avis.indianbiodiversity.org/. $row['BL_URL'] . "> BirdLife Species FactSheet for " . $row['BL_CN'] . " ( <i> " . $row['BL_SN'] . " )</i></a><br><br>";
echo "<b>Taxonomy Treatment : </b>" . $row['BL_TAXTREAT'] . "<br><br>";
if ($row['BL_TAXNOTE'] <> '')
{
echo "<b>Birdlife Taxonomy Notes : </b>" . $row['BL_TAXNOTE'] . "<br>";
}
}
?>
{/slide}
{slide=International Union for Conservation of Nature and Natural Resources}
<?php
if ($row['IUCN_SN']=='')
{
echo "<b>No Data Avialable</b><br>";
}
else
{
echo "<b>IUCN Common Name (Eng) : </b>" . $row['IUCN_CN_ENG'] . "<br>";
echo "<b>Scientific Name : </b><i>" . $row['IUCN_SN'] . "</i>";
echo "<b> (</b>" . $row['IUCN_AUTH'] ."<b>)</b><br>";
if ($row['IUCN_CN_FRE']<> '')
{
echo " <b>French Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_FRE'])) . "<br>";
}
if ($row['IUCN_CN_SPA ']<> '')
{
echo " <b>Spanish Name : </b>" . htmlspecialchars_decode(htmlentities($row['IUCN_CN_SPA '])) . "<br><br>";
}
echo "<a href="http://avis.indianbiodiversity.org/. $row['IUCN_URL'] . "> IUCN Redlist Species FactSheet for " . $row['IUCN_CN_ENG'] . " ( <i> " . $row['IUCN_SN'] . " )</i></a><br><br>";
echo "<b>Species : </b><i>" . $row['IUCN_SPECIES'] . "</i><br>";
echo "<b>Genus : </b>" . $row['IUCN_GENUS'] . "</i><br>";
echo "<b>Family : </b>" . $row['IUCN_FAMILY'] . "</i>\t\t";
echo "<b>Order : </b>" . $row['IUCN_ORDER'] . "</i><br><br>";
echo "<b>IUCN RedList Status : </b>" . $row['IUCN_RL_STATUS'] . "<br><br>";
if ($row['IUCN_RL_CRI']<> '')
{
echo "<b>IUCN RedList Criteria : </b>" . $row['IUCN_RL_CRI'] . "<br>";
}
echo "<b>IUCN RedList Criteria Version : </b>" . $row['IUCN_RL_CRI_VER'] . "<br>";
echo "<b>IUCN RedList Year Assessed : </b>" . $row['IUCN_RL_YEAR'] . "<br>";
if ($row['IUCN_RL_POP_TREND'] <> '')
{
echo "<b>IUCN RedList Population Trend : </b>" . $row['IUCN_RL_POP_TREND'] . "<br>";
}
if ($row['IUCN_RL_PET'] <> '')
{
echo "<b>IUCN RedList Petitioned : </b>" . $row['IUCN_RL_PET'] . "<br>";
}
}
?>
{/slide}
{slide=Oriental Bird Club Checklist Draft Novemebr 2009}
<?php
if ($row['OBC_SN']=='')
{
echo "No Data Available";
}
else
{echo "<b>Family : </b>" . $row['OBC_FAM'] . "<br><br>";
echo "<b>Scientific Name : </b><i>" . $row['OBC_SN'] ."</i><br>";
echo "<b>Common Name : </b>" . $row['OBC_CN'] . "<br><br>";
if ($row['IOC_DIFF'] <> '')
{
echo "<b>IOC Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['IOC_DIFF'])) . "<br>";
}
if ($row['BL_DIFF'] <> '')
{
echo "<b>Birdlife Checklist Difference : </b>" . htmlspecialchars_decode(htmlentities($row['BL_DIFF'])) . "<br><br>";
}
if ($row['BL_JUST'] <> '')
{
echo "<b>Birdlife Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['BL_JUST'])) . "<br>";
}
if ($row['OBC_JUST'] <> '')
{
echo "<b>OBC Checklist Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OBC_JUST'])) . "<br>";
}
if ($row['OTH_JUST'] <> '')
{
echo "<b>Other Justification : </b>" . htmlspecialchars_decode(htmlentities($row['OTH_JUST'])) . "<br>";
}
}
?>
{/slide}
{tab=Bibliography}
<?php
$query = "select distinct Title, Author, SecondaryTitle, Volume, Pages, Fpage, Year from jos_bibliodb where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' order by Year DESC limit 100";
$resultlit = $db->query($query);
$num_results = $resultlit ->num_rows;
if ($num_results == 0 )
{
echo "<b>Currentlly No Literature Avialable</b>";
}
else
{
echo "<b>Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i></b><br>";
echo "<b>Number of Results found : ".$num_results."</b><br><br>";
if($num_results==100)
{
echo "<b>This is latest 100 Papers. To see Complete Bibliography of " .$row['M_CN']. "<i> ( " .$row['M_SN']. " )</i> Use Species Bibliography Module</b>";
}
for ($i=0; $i <$num_results; $i++)
{
$rowlit = $resultlit ->fetch_assoc();
$tempdata = $i+1;
$tauth=htmlspecialchars_decode(htmlentities($rowlit ['Author']));
$ttitle=htmlspecialchars_decode(htmlentities($rowlit ['Title']));
$tsectitle=htmlspecialchars_decode(htmlentities($rowlit ['SecondaryTitle']));
$tvol=htmlspecialchars_decode(htmlentities($rowlit ['Volume']));
$tpage=htmlspecialchars_decode(htmlentities($rowlit ['Pages']));
$tfpage=htmlspecialchars_decode(htmlentities($rowlit ['Fpage']));
$tyear=htmlspecialchars_decode(htmlentities($rowlit ['Year']));
echo "<P ALIGN=JUSTIFY>";
echo "<b>$tempdata</b>";
echo ". ";
echo "$tauth ";
echo ", (";
echo "$tyear";
echo "), ";
echo "$ttitle";
echo ", ";
echo "<i>";
echo "$tsectitle";
echo "</i>";
echo ", ";
echo "$tvol";
echo ": ";
echo "$tpage";
if ($tfpage <> '')
{
echo " - ";
echo "$tfpage";
}
echo ". ";
echo "<br>";
echo "</p>";
echo "<HR>";
}
}
?>
{tab=Book Excerpts}
<?php
$query = "select * from jos_masterbookdata where NEW_SN = '".$sn."' order by YEAR";
$resultbook = $db->query($query);
$num_results = $resultbook->num_rows;
if ($num_results == 0 )
{
echo "<b>No Data Avialable</b>";
}
else
{
for ($i=0; $i <$num_results; $i++)
{
$rowbook = $resultbook->fetch_assoc();
$Bookname = $rowbook['BOOKNAME'];
$ArtName = $rowbook['ARTICLE_ID'];
$sldstart ='{slide= ';
$sldend= '}<br>';
$incluestart='{include_content_item ';
$incluend=' 1 1}<br>';
$slideend = '{/slide}<br><br>';
echo "$sldstart $Bookname $sldend";
echo "$incluestart $ArtName $incluend";
echo "$slideend";
}
}
?>
{tab=Museum Collections}
<?php
$query = "select * from jos_gbifaves where M_SN = '".$sn."' order by Datecollected";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if ($num_results == 0 )
{
echo "<b> No Data Avialbale for <i>" .$sn. "</i></b>";
}
else
{
echo "<b>Number of Museum Specimen Records Found : ".$num_results."</b> for <i>" .$sn." </i><br><br>";
echo "<table border='1'>
<tr>
<th>No.</th>
<th>Museum</th>
<th>Species</th>
<th>Collection Deatils</th>
<th>Collector</th>
<th>Date of Collection</th>
<th>Record</th>
<th>Locality</th>
<th>GBIF Portal Link</th>
</tr>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<td>".($i+1)."</td>";
echo "<td>" . $rowcoll['Dataprovider'] . "</td>";
echo "<td>" . $rowcoll['SN'] . "</td>";
$temp11 = $rowcoll['Institutioncode'] ." " . $rowcoll['Collectioncode']. " " .$rowcoll['CatalogueNo'];
echo "<td>" . $temp11 . "</td>";
echo "<td>" . $rowcoll['Collectorname'] . "</td>";
echo "<td>" . $rowcoll['Datecollected'] . "</td>";
echo "<td>" . $rowcoll['Basisofrecord'] . "</td>";
$temp22 = $rowcoll['Locality'] ." " . $rowcoll['County'] . " ".$rowcoll['StateProvince']." ".$rowcoll['Countryinterpreted']." ".$rowcoll['ContinentorOcean'] ." ". $rowcoll['Region'];
echo "<td>" .$temp22 ."</td>";
echo "<td> <a href="http://avis.indianbiodiversity.org/. $rowcoll['GBIFportalurl'] ." target=\"_blank\">Link</a></td>";
echo "<tr>";
}
}

echo "</table>";
$query = "select distinct jos_gbifaves.Dataprovider, Count(jos_gbifaves.ID) as cnt from jos_gbifaves where M_SN = '".$sn."'GROUP BY jos_gbifaves.Dataprovider";
$resultcoll = $db->query($query);
$num_results = $resultcoll->num_rows;
if (!$num_results == 0 )
{
echo "<b><br>Biodiversity occurrence data provided by: (Accessed through GBIF Data Portal,  2009-08-06)</b>";
echo "<br><br><b>";
echo "Data Providers</b><br><ul>";
for ($i=0; $i <$num_results; $i++) {
$rowcoll = $resultcoll->fetch_assoc();
echo "<li>" . $rowcoll['Dataprovider']. " ( " . $rowcoll['cnt']. " Records )</li>";
echo "<br>";
}
echo "</ul>";
}
?>
{tab=Sound/Call}
<?php
$query = "select XCNO, remarks, type from jos_xenodata where KWNEW LIKE '%".$sn."%' OR KWNEW LIKE '%".$spcn."%' OR KWNEW LIKE '%".$CLE_SN_SUB."%'";
$resultxeno = $db->query($query);
$num_results = $resultxeno->num_rows;
if ($num_results == 0 )
{
echo "<b>No Calls Avialable</b>";
}
else
{
echo $num_results . " calls found for " . $sn ."<br><br>";
echo "<HR>";
for ($i=0; $i<$num_results; $i++)
{
$rowxeno = $resultxeno->fetch_assoc();
$xc = $rowxeno['XCNO'];
$pstart = '<iframe src="http://www.xeno-canto.org/embed.php?XC=';
$pend = '&simple=0" scrolling=no frameborder=0 width=340 height=230></iframe>';
$tt2 ="<br>";
echo "$pstart $xc $pend";
echo "<br>Remarks: " . $rowxeno['remarks'] . "<br>";
echo "Call Type: " . $rowxeno['type'] . "<br>";
echo "<HR>";
}
}
echo 'The Bird Calls are embedded through xeno-canto.org See <a href="http://xeno-canto.org/termsofuse.php">Terms of Use xeno-canto.org</a><br><br>';
?>
{tab=Links}
<?php
$devtteemmpp = ' target="_blank" rel="nofollow"';
$devstrspecies = 'for ' . $row['M_CN'] . ' ( <i> ' . $row['M_SN'] . ' )</i>';
$avibase = 'http://avibase.bsc-eoc.org/avibase.jsp?pg=search&qstr=' . $row['FILENAMEPLUS'];
echo "<br><a href="http://avis.indianbiodiversity.org/. $avibase . $devtteemmpp . "> Avibase - The World Bird Database " . $devstrspecies . "</a><br><br>";
$bldataurl = 'http://www.birdlife.org/datazone/species/index.html?action=SpcHTMDetails.asp&sid=' . $row['BL_ID'] . '&m=0';
echo "<a href="http://avis.indianbiodiversity.org/. $bldataurl . $devtteemmpp . "> BirdLife Species FactSheet " . $devstrspecies . "</a><br><br>";
$bhlurl = 'http://www.biodiversitylibrary.org/name/'.$row['FILENAME'];
echo " <a href="http://avis.indianbiodiversity.org/. $bhlurl . $devtteemmpp . "> Biodiversity Heritage Library ". $devstrspecies . "</a><br><br>";
$dislifemaps = 'http://www.discoverlife.org/mp/20m?kind='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $dislifemaps .  $devtteemmpp . "> Discover Life Maps ". $devstrspecies . "</a><br><br>";
$Entrez  = 'http://www.ncbi.nlm.nih.gov/sites/gquery?term='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Entrez .  $devtteemmpp . "> Entrez, The Life Sciences Search Engine ". $devstrspecies . "</a><br><br>";
$GBIF = 'http://data.gbif.org/species/species/'.$row['FILENAME'];
echo "<a href="http://avis.indianbiodiversity.org/. $GBIF .  $devtteemmpp . "> GBIF, Global Biodiversity Information Facility ". $devstrspecies . "</a><br><br>";
$GoogleImages = 'http://images.google.com/images?q=' . $row['FILENAMEPLUS'] . '&hl=en&sa=N&tab=wi';
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleImages .  $devtteemmpp . "> Google Images ". $devstrspecies . "</a><br><br>";
$GoogleScholar  = 'http://scholar.google.com/scholar?hl=en&num=20&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleScholar .  $devtteemmpp . "> Google Scholar ". $devstrspecies . "</a><br><br>";
$GoogleWebsites = 'http://www.google.com/search?sourceid=navclient&querytime=sC&q=' . $row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $GoogleWebsites .  $devtteemmpp . "> Google Websites ". $devstrspecies . "</a><br><br>";
$ITIS = 'http://www.itis.gov/servlet/SingleRpt/SingleRpt?search_topic=TSN&searchvalue=' . $row['ITIS_TSN'];
echo "<a href="http://avis.indianbiodiversity.org/. $ITIS .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) ". $devstrspecies . "</a><br><br>";
$ITISCA = 'http://www.cbif.gc.ca/pls/itisca/next?v_tsn=' . $row['ITIS_TSN'] . '&taxa=&p_format=&p_ifx=cbif&p_lang=';
echo "<a href="http://avis.indianbiodiversity.org/. $ITISCA .  $devtteemmpp . "> Integrated Taxonomic Information System (ITIS) CANADA ". $devstrspecies . "</a><br><br>";
$iucndata = 'http://www.iucnredlist.org/details/'.$row['IUCN_ID'];
echo "<a href="http://avis.indianbiodiversity.org/. $iucndata .  $devtteemmpp . "> IUCN Redlist Species FactSheet ". $devstrspecies . "</a><br><br>";
$ncbi = 'http://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?name='.$row['FILENAMEPLUS'] . '&lvl=0';
echo "<a href="http://avis.indianbiodiversity.org/. $ncbi .  $devtteemmpp . "> NCBI Molecular Data ". $devstrspecies . "</a><br><br>";
$Pubmed = 'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Search&term='.$row['FILENAMEPLUS'] . '&doptcmdl=DocSum';
echo "<a href="http://avis.indianbiodiversity.org/. $Pubmed .  $devtteemmpp . "> Pubmed Literature ". $devstrspecies . "</a><br><br>";
$catlife = 'http://www.catalogueoflife.org/annual-checklist/2010/search/all/key/'.$row['FILENAMEPLUS'] ;
echo "<a href="http://avis.indianbiodiversity.org/. $catlife .  $devtteemmpp . "> Catalogue of Life : Annual Checklist ". $devstrspecies . "</a><br><br>";
$treelife = 'http://tolweb.org/tree/home.pages/searchTOL?taxon='.$row['FILENAMEPLUS'] . '&Submit2=Find';
echo "<a href="http://avis.indianbiodiversity.org/. $treelife .  $devtteemmpp . "> Tree Of Life ". $devstrspecies . "</a><br><br>";
$uBioPortal = 'http://www.ubio.org/browser/search.php?search_all='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBioPortal .  $devtteemmpp . "> uBio Portal ". $devstrspecies . "</a><br><br>";
$uBio = 'http://portal.ubio.org/index.php?tnsnav=lists&map=&start=0&tnsclient=Yahoo&searchtype=web&search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $uBio .  $devtteemmpp . "> uBio  ". $devstrspecies . "</a><br><br>";
$Wikipedia = 'http://en.wikipedia.org/wiki/Special:Search?search='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $Wikipedia .  $devtteemmpp . "> Wikipedia  ". $devstrspecies . "</a><br><br>";
$XenoCanto = 'http://www.xeno-canto.org/species.php?query='.$row['FILENAMEPLUS'];
echo "<a href="http://avis.indianbiodiversity.org/. $XenoCanto .  $devtteemmpp . "> Xeno - Canto  ". $devstrspecies . "</a><br><br>";
$Zoonomen = 'http://www.google.com/custom?hl=en&q='.$row['FILENAMEPLUS'] .'&sitesearch=zoonomen.net/';
echo "<a href="http://avis.indianbiodiversity.org/. $Zoonomen .  $devtteemmpp . "> Zoonomen  ". $devstrspecies . "</a><br><br>";

?>
{/tabs}
<?php   
echo "<b>Cite this website along with its URL as:<br></b>";
echo "Anonymous. " .date("Y"). "<i> ".$sn."</i> - ".$row['ABBI_AUTH']." (".$spcn." )<i> in </i>Deomurari, A.N. (Compiler), 2010. AVIS-IBIS (Avian Information System - Indian BioDiversity Information System) v. 1.0. Foundation For Ecological Security, India";
echo " retrieved on ".date("m/d/Y");

?>
]]>
deomurari@gmail.com (Arpit Deomurari) Passeriformes - Pittidae ( Pittas ) Wed, 11 Nov 2009 05:36:10 +0000