"; echo ""; echo ""; echo ""; echo ""; echo "

"; $totale=0.; $str_1 ="create temporary table tmp1 select orbit, count(edtt) as ttt from comm_downlink group by orbit"; $query = mysql_query($str_1); $str_2 ="select a.orbit, a.edtt, a.nome from comm_downlink as a, tmp1 as b where (a.error < 1000 AND (a.ipm LIKE '%3%' OR a.ipm LIKE '%4%') AND " ."a.orbit=b.orbit AND b.ttt>1)"; $query = mysql_query($str_2); while ($row = mysql_fetch_row($query)) { $or=$row[0]; $time=$row[1]; $file=$row[2]; $str="select orbit, edtt, nome from comm_downlink where (error < 1000 AND (ipm LIKE '%3%' OR ipm LIKE '%4%') AND orbit=$or)"; $query_ = MyQuery($str); $t=$time; while ($row_ = mysql_fetch_row($query_)) { $time_=$row_[1]; $file_=$row_[2]; if ($file_>$file) {$t=$time_;} } //echo "or=".$or." newor=".$row_[0]." time=".$t." file=".$file." newfile=".$file_." "; $totale=$totale+$t; } $str_3="create temporary table tmp2 select a.orbit from comm_downlink as a, tmp1 as b where a.orbit=b.orbit AND b.ttt<2"; $query = MyQuery($str_3); $strsql = "select sum(a.edtt) as totalecolonna from comm_downlink as a, tmp2 as c WHERE (a.error < 1000 AND (a.ipm LIKE '%3%' OR a.ipm LIKE '%4%') AND " ."a.orbit=c.orbit)"; $query = mysql_query($strsql); $row = mysql_fetch_array($query); //echo $totale." "; $totale = $totale+$row["totalecolonna"]; //echo $totale." "; //$strsql = "select sum(temp.edtt) as totalecolonna from (select distinct(orbit), edtt from comm_downlink WHERE (error < 1000 AND (ipm LIKE '%3%' OR ipm LIKE '%4%'))) as temp"; //$query = mysql_query($strsql); //$row = mysql_fetch_array($query); //$totale = $row["totalecolonna"]; echo "TOT. Effective data taking time (s) with IPM 3/4:  $totale"; echo "

"; //$strsql = "select sum(edtt) as totalecolonna from comm_downlink WHERE (ipm NOT LIKE '%3%' AND ipm NOT LIKE '%4%')"; MyQuery("create temporary table tmp3 select distinct(orbit), edtt from comm_downlink WHERE (ipm NOT LIKE '%3%' AND ipm NOT LIKE '%4%')"); $strsql = "select sum(edtt) as totalecolonna from tmp3"; $query = mysql_query($strsql); $row = mysql_fetch_array($query); $totale = $row["totalecolonna"]; echo "TOT. Effective data taking time (s) without IPM 3/4:  $totale"; echo "

"; //$strsql = "select sum(edtt) as totalecolonna from comm_downlink "; MyQuery("create temporary table tmp4 select distinct(orbit), edtt from comm_downlink"); $strsql = "select sum(edtt) as totalecolonna from tmp4"; //$strsql = "select sum(temp2.edtt) as totalecolonna from (select distinct(orbit), edtt from comm_downlink) as temp2"; $query = mysql_query($strsql); $row = mysql_fetch_array($query)or die (mysql_error()); $totale = $row["totalecolonna"]; echo "TOT. Effective data taking time (s):  $totale"; echo "

"; echo "
"; echo "
"; echo ""; echo ""; if ( isset($_SESSION["login"]) ) { echo ""; } echo ""; echo ""; echo ""; $sql = "SELECT * FROM comm_downlink ORDER BY orbit DESC "; $res = MyQuery($sql); //testo aggiunto per colorare righe $bgcolor[0] = "bgcolor=#edf5fg"; $bgcolor[1] = "bgcolor=#cccccc"; $counter = 0; //fine testo aggiunto per colorare righe while( $row = mysql_fetch_array($res, MYSQL_ASSOC) ) { // testo aggiunto per colorare righe $bc = $bgcolor[$counter]; $counter = 1 - $counter; echo ""; //testo per modifica e eliminazione campo if ( isset($_SESSION["login"]) ) { echo ""; echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; $myData = Explode( "-", $row["datedld"] ); echo ""; $myData1 = Explode( "-", $row["datedlk"] ); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //fine testo echo "

Field modification

Counter

Filename/Action

Orbit of download

Absolute time (s)

Effective Data Taking Time (s)

Date & Hour MWT Download/Action

Date & Hour MWT Downlink (for downloads)

Size (GB)

Error Rate

Trigger

IPM

ws

Comments

change

delete

".$row["id"]."

".$row["nome"]."

".$row["orbit"]."

".$row["time"]."

".$row["edtt"]."

$myData[2]/$myData[1]/$myData[0] - ".$row["oradld"]."

$myData1[2]/$myData1[1]/$myData1[0] - ".$row["oradlk"]."

".$row["rr"]."

".$row["error"]."

".$row["a18"]."

".$row["ipm"]."

".$row["ws"]."

".$row["comments"]."

"; //testo scoperto oggi //fine del testo tolto include("footer-list.html"); ?>