echo $lg_catalog_allCat ?> echo $lg_rec_maj; ?> echo ((getTableUpdate("planet","plUpdate")>getTableUpdate("star","stUpdate"))?date_user_multiLg(getTableUpdate("planet","plUpdate"),$moisLang):date_user_multiLg(getTableUpdate("star","stUpdate"),$moisLang)); ?> |
|
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 1 OR plType = 2 OR plType = 4 OR plType = 6 OR plType = 7 OR plType=8";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
?>
| echo str_replace(" "," ",$lg_catalog_catNum0); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl; ?> |
|
| |
|
$extraRequete = "SELECT planet.plId FROM planet WHERE plType=1 OR plType=7 OR plType=8";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND ((pl1.plType = 1 AND pl2.plType = 1) OR (pl1.plType = 7 AND pl2.plType = 7) OR (pl1.plType = 8 AND pl2.plType = 8))";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType=1 or plType=7 or plType=8";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType=1 or plType=7 or plType=8");
?>
 |
 |
echo str_replace(" "," ",$lg_catalog_catNum1); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
|
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 7";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
// Nb de systemes multiplanetes ayant au moins une planete de type 7 (en transit)
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND (pl1.plType = 7 OR pl2.plType = 7)";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 7";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 7");
?>
| |
|
echo str_replace(" "," ",$lg_catalog_catNum8); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 4";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND pl1.plType = 4 AND pl2.plType = 4";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 4";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 4");
?>
 |
 |
echo str_replace(" "," ",$lg_catalog_catNum2); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet; ?> echo $lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 6";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND pl1.plType = 6 AND pl2.plType = 6";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 6";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 6");
?>
 |
 |
echo str_replace(" "," ",$lg_catalog_catNum3); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?> |
| |
$extraRequete = "SELECT planet.plId FROM planet WHERE plType = 2";
$nbPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "SELECT distinct(pl1.plStar) FROM planet AS pl1, planet AS pl2 WHERE pl1.plStar = pl2.plStar AND pl1.plName <> pl2.plName AND pl1.plType = 2 AND pl2.plType = 2";
$nbMultiPlanet = mysql_num_rows(mysql_query($extraRequete));
$extraRequete = "select distinct(plStar) from planet WHERE plType = 2";
$nbPlSyst = mysql_num_rows(mysql_query($extraRequete));
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 2");
?>
|
|
echo str_replace(" "," ",$lg_catalog_catNum4); ?> |
|
echo $nbPlSyst." ".$lg_catalog_plSys ?> |
 |
| |
|
echo $lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang); ?> |
|
echo $nbPlanet." ".$lg_catalog_pl ?> |
| |
|
|
|
echo $nbMultiPlanet." ".$lg_catalog_multiPlSys ?>
|
| |
echo "$lg_catalog_molecules" ?> Search for molecules
$result = mysql_query ("select max(p.plUpdate) as maxDate from planet p, mol_planet mp where plType in (1,2,4,6,7,8) and p.plId=mp.plId");
echo "".$lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang)."";
?>
echo "$lg_catalog_catNum5" ?>
$result = mysql_query ("select max(planet.plUpdate) as maxDate from planet where plType = 3");
echo "".$lg_rec_maj." ".date_user_multiLg(mysql_result($result,0,'maxDate'),$moisLang)."";
?>
echo "$lg_catalog_catNum6" ?> echo $lg_rec_maj." ".date_user_multiLg("2011-10-14",$moisLang); ?>
echo $lg_catalog_catNum7 ?> echo $lg_rec_maj." ".date_user_multiLg("2001-05-27",$moisLang); ?>
Kepler Planet Candidates and Kepler False Positives List
Kepler Community Follow-up Observing Program (CFOP)
echo $lg_rec_maj." ".date_user_multiLg("2012-05-02",$moisLang); ?>
echo $lg_catalog_otherList ?> :
|