Esempio n. 1
0
			 }
		}
		echo "<BR><br><br>DONE !!! processed $i flights<BR>";
	} else if ($admin_op=="remakeScoreLog") {
		if ($logEntries > 0) $limitStr= " LIMIT $logScoreEntries ";
		else $limitStr='';
		
		$query="SELECT ID from $flightsTable WHERE  batchOpProcessed=0 ORDER BY ID ASC $limitStr";
		$res= $db->sql_query($query);

		$i=0;
		if($res > 0){
			 while ($row = mysql_fetch_assoc($res)) { 
				  $flight=new flight();
				  $flight->getFlightFromDB($row["ID"],0); // dont update takeoff				 
				  $flight->makeScoreLogEntry();
				  setBatchBit($row["ID"]);
				  $i++;
				  set_time_limit(300);
			 }
		}
		echo "<BR><br><br>DONE !!! processed $i flights<BR>";

	} else if ($admin_op=="cleanPhotosTable") {
		$query="TRUNCATE TABLE $photosTable ";
		$res= $db->sql_query($query);		
		if(!$res){
			echo "Problem in empting $photosTable : $query<BR>";
		}

		$query="UPDATE $flightsTable SET hasPhotos=0 ";