Ysurac / FlightAirMap

require/class.MarineLive.php

Indentation +229 added lines, -229 removed lines

@@ -20,13 +20,13 @@ 
 	}
 
 
-    /**
-     * Get SQL query part for filter used
-     * @param array $filter the filter
-     * @param bool $where
-     * @param bool $and
-     * @return string the SQL part
-     */
+	/**
+	 * Get SQL query part for filter used
+	 * @param array $filter the filter
+	 * @param bool $where
+	 * @param bool $and
+	 * @return string the SQL part
+	 */
 	public function getFilter($filter = array(),$where = false,$and = false) {
 		global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver;
 		$filters = array();
@@ -105,14 +105,14 @@ 
 		return $filter_query;
 	}
 
-    /**
-     * Gets all the spotter information based on the latest data entry
-     *
-     * @param string $limit
-     * @param string $sort
-     * @param array $filter
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on the latest data entry
+	 *
+	 * @param string $limit
+	 * @param string $sort
+	 * @param array $filter
+	 * @return array the spotter information
+	 */
 	public function getLiveMarineData($limit = '', $sort = '', $filter = array())
 	{
 		global $globalDBdriver, $globalLiveInterval;
@@ -154,12 +154,12 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets Minimal Live Spotter data
-     *
-     * @param array $filter
-     * @return array the spotter information
-     */
+	/**
+	 * Gets Minimal Live Spotter data
+	 *
+	 * @param array $filter
+	 * @return array the spotter information
+	 */
 	public function getMinLiveMarineData($filter = array())
 	{
 		global $globalDBdriver, $globalLiveInterval;
@@ -188,15 +188,15 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets Minimal Live Spotter data since xx seconds
-     *
-     * @param array $coord
-     * @param array $filter
-     * @param bool $limit
-     * @param string $id
-     * @return array the spotter information
-     */
+	/**
+	 * Gets Minimal Live Spotter data since xx seconds
+	 *
+	 * @param array $coord
+	 * @param array $filter
+	 * @param bool $limit
+	 * @param string $id
+	 * @return array the spotter information
+	 */
 	public function getMinLastLiveMarineData($coord = array(),$filter = array(), $limit = false, $id = '')
 	{
 		global $globalDBdriver, $globalLiveInterval, $globalMap3DMarinesLimit, $globalArchive;
@@ -275,14 +275,14 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets Minimal Live Spotter data since xx seconds
-     *
-     * @param string $id
-     * @param array $filter
-     * @param bool $limit
-     * @return array the spotter information
-     */
+	/**
+	 * Gets Minimal Live Spotter data since xx seconds
+	 *
+	 * @param string $id
+	 * @param array $filter
+	 * @param bool $limit
+	 * @return array the spotter information
+	 */
 	public function getMinLastLiveMarineDataByID($id = '',$filter = array(), $limit = false)
 	{
 		global $globalDBdriver, $globalLiveInterval, $globalMap3DMarinesLimit, $globalArchive;
@@ -341,12 +341,12 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets number of latest data entry
-     *
-     * @param array $filter
-     * @return String number of entry
-     */
+	/**
+	 * Gets number of latest data entry
+	 *
+	 * @param array $filter
+	 * @return String number of entry
+	 */
 	public function getLiveMarineCount($filter = array())
 	{
 		global $globalDBdriver, $globalLiveInterval;
@@ -370,13 +370,13 @@ 
 		return $result['nb'];
 	}
 
-    /**
-     * Gets all the spotter information based on the latest data entry and coord
-     *
-     * @param $coord
-     * @param array $filter
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on the latest data entry and coord
+	 *
+	 * @param $coord
+	 * @param array $filter
+	 * @return array the spotter information
+	 */
 	public function getLiveMarineDatabyCoord($coord, $filter = array())
 	{
 		global $globalDBdriver, $globalLiveInterval;
@@ -399,13 +399,13 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets all the spotter information based on the latest data entry and coord
-     *
-     * @param $coord
-     * @param array $filter
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on the latest data entry and coord
+	 *
+	 * @param $coord
+	 * @param array $filter
+	 * @return array the spotter information
+	 */
 	public function getMinLiveMarineDatabyCoord($coord, $filter = array())
 	{
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
@@ -473,15 +473,15 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets all the spotter information based on a user's latitude and longitude
-     *
-     * @param $lat
-     * @param $lng
-     * @param $radius
-     * @param $interval
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on a user's latitude and longitude
+	 *
+	 * @param $lat
+	 * @param $lng
+	 * @param $radius
+	 * @param $interval
+	 * @return array the spotter information
+	 */
 	public function getLatestMarineForLayar($lat, $lng, $radius, $interval)
 	{
 		$Marine = new Marine($this->db);
@@ -538,32 +538,32 @@ 
 	}
 
 
-    /**
-     * Gets all the spotter information based on a particular callsign
-     *
-     * @param $ident
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on a particular callsign
+	 *
+	 * @param $ident
+	 * @return array the spotter information
+	 */
 	public function getLastLiveMarineDataByIdent($ident)
 	{
 		$Marine = new Marine($this->db);
 		date_default_timezone_set('UTC');
 
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
-                $query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.ident = :ident GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
+				$query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.ident = :ident GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
 
 		$spotter_array = $Marine->getDataFromDB($query,array(':ident' => $ident),'',true);
 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets all the spotter information based on a particular callsign
-     *
-     * @param $ident
-     * @param $date
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on a particular callsign
+	 *
+	 * @param $ident
+	 * @param $date
+	 * @return array the spotter information
+	 */
 	public function getDateLiveMarineDataByIdent($ident,$date)
 	{
 		$Marine = new Marine($this->db);
@@ -575,13 +575,13 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets all the spotter information based on a particular MMSI
-     *
-     * @param $mmsi
-     * @param $date
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on a particular MMSI
+	 *
+	 * @param $mmsi
+	 * @param $date
+	 * @return array the spotter information
+	 */
 	public function getDateLiveMarineDataByMMSI($mmsi,$date)
 	{
 		$Marine = new Marine($this->db);
@@ -593,53 +593,53 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets last spotter information based on a particular callsign
-     *
-     * @param $id
-     * @return array the spotter information
-     */
+	/**
+	 * Gets last spotter information based on a particular callsign
+	 *
+	 * @param $id
+	 * @return array the spotter information
+	 */
 	public function getLastLiveMarineDataById($id)
 	{
 		$Marine = new Marine($this->db);
 		date_default_timezone_set('UTC');
 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
-                $query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
+				$query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
 
 		$spotter_array = $Marine->getDataFromDB($query,array(':id' => $id),'',true);
 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets last spotter information based on a particular callsign
-     *
-     * @param $id
-     * @param $date
-     * @return array the spotter information
-     */
+	/**
+	 * Gets last spotter information based on a particular callsign
+	 *
+	 * @param $id
+	 * @param $date
+	 * @return array the spotter information
+	 */
 	public function getDateLiveMarineDataById($id,$date)
 	{
 		$Marine = new Marine($this->db);
 		date_default_timezone_set('UTC');
 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
-                $query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id AND l.date <= :date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
-                $date = date('c',$date);
+				$query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id AND l.date <= :date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
+				$date = date('c',$date);
 		$spotter_array = $Marine->getDataFromDB($query,array(':id' => $id,':date' => $date),'',true);
 
 		return $spotter_array;
 	}
 
 
-    /**
-     * Gets all the spotter information based on a particular id
-     *
-     * @param $id
-     * @param bool $liveinterval
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on a particular id
+	 *
+	 * @param $id
+	 * @param bool $liveinterval
+	 * @return array the spotter information
+	 */
 	public function getAllLiveMarineDataById($id,$liveinterval = false)
 	{
 		global $globalDBdriver, $globalLiveInterval;
@@ -667,18 +667,18 @@ 
 		return $spotter_array;
 	}
 
-    /**
-     * Gets all the spotter information based on a particular ident
-     *
-     * @param $ident
-     * @return array the spotter information
-     */
+	/**
+	 * Gets all the spotter information based on a particular ident
+	 *
+	 * @param $ident
+	 * @return array the spotter information
+	 */
 	public function getAllLiveMarineDataByIdent($ident)
 	{
 		date_default_timezone_set('UTC');
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
 		$query  = self::$global_query.' WHERE marine_live.ident = :ident';
-    		try {
+			try {
 			
 			$sth = $this->db->prepare($query);
 			$sth->execute(array(':ident' => $ident));
@@ -692,23 +692,23 @@ 
 
 
 	/**
-	* Deletes all info in the table
-	*
-	* @return String success or false
-	*
-	*/
+	 * Deletes all info in the table
+	 *
+	 * @return String success or false
+	 *
+	 */
 	public function deleteLiveMarineData()
 	{
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
 			//$query  = "DELETE FROM marine_live WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 MINUTE) >= marine_live.date";
 			$query  = 'DELETE FROM marine_live WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 12 HOUR) >= marine_live.date';
-            		//$query  = "DELETE FROM marine_live WHERE marine_live.id IN (SELECT marine_live.id FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) >= marine_live.date)";
+					//$query  = "DELETE FROM marine_live WHERE marine_live.id IN (SELECT marine_live.id FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) >= marine_live.date)";
 		} else {
 			$query  = "DELETE FROM marine_live WHERE NOW() AT TIME ZONE 'UTC' - INTERVAL '12 HOURS' >= marine_live.date";
 		}
         
-    		try {
+			try {
 			
 			$sth = $this->db->prepare($query);
 			$sth->execute();
@@ -720,18 +720,18 @@ 
 	}
 
 	/**
-	* Deletes all info in the table for aircraft not seen since 2 HOUR
-	*
-	* @return String success or false
-	*
-	*/
+	 * Deletes all info in the table for aircraft not seen since 2 HOUR
+	 *
+	 * @return String success or false
+	 *
+	 */
 	public function deleteLiveMarineDataNotUpdated()
 	{
 		global $globalDBdriver, $globalDebug;
 		if ($globalDBdriver == 'mysql') {
 			//$query = 'SELECT fammarine_id FROM marine_live WHERE DATE_SUB(UTC_TIMESTAMP(), INTERVAL 1 HOUR) >= marine_live.date AND marine_live.fammarine_id NOT IN (SELECT fammarine_id FROM marine_live WHERE DATE_SUB(UTC_TIMESTAMP(), INTERVAL 1 HOUR) < marine_live.date) LIMIT 800 OFFSET 0';
-    			$query = "SELECT marine_live.fammarine_id FROM marine_live INNER JOIN (SELECT fammarine_id,MAX(date) as max_date FROM marine_live GROUP BY fammarine_id) s ON s.fammarine_id = marine_live.fammarine_id AND DATE_SUB(UTC_TIMESTAMP(), INTERVAL 2 HOUR) >= s.max_date LIMIT 1200 OFFSET 0";
-    			try {
+				$query = "SELECT marine_live.fammarine_id FROM marine_live INNER JOIN (SELECT fammarine_id,MAX(date) as max_date FROM marine_live GROUP BY fammarine_id) s ON s.fammarine_id = marine_live.fammarine_id AND DATE_SUB(UTC_TIMESTAMP(), INTERVAL 2 HOUR) >= s.max_date LIMIT 1200 OFFSET 0";
+				try {
 				
 				$sth = $this->db->prepare($query);
 				$sth->execute();
@@ -739,8 +739,8 @@ 
 				return "error";
 			}
 			$query_delete = 'DELETE FROM marine_live WHERE fammarine_id IN (';
-                        $i = 0;
-                        $j =0;
+						$i = 0;
+						$j =0;
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 			foreach($all as $row)
 			{
@@ -748,20 +748,20 @@ 
 				$j++;
 				if ($j == 30) {
 					if ($globalDebug) echo ".";
-				    	try {
+						try {
 						
 						$sth = $this->db->prepare(substr($query_delete,0,-1).")");
 						$sth->execute();
 					} catch(PDOException $e) {
 						return "error";
 					}
-                                	$query_delete = 'DELETE FROM marine_live WHERE fammarine_id IN (';
-                                	$j = 0;
+									$query_delete = 'DELETE FROM marine_live WHERE fammarine_id IN (';
+									$j = 0;
 				}
 				$query_delete .= "'".$row['fammarine_id']."',";
 			}
 			if ($i > 0) {
-    				try {
+					try {
 					
 					$sth = $this->db->prepare(substr($query_delete,0,-1).")");
 					$sth->execute();
@@ -772,9 +772,9 @@ 
 			return "success";
 		} elseif ($globalDBdriver == 'pgsql') {
 			//$query = "SELECT fammarine_id FROM marine_live WHERE NOW() AT TIME ZONE 'UTC' - INTERVAL '9 HOURS' >= marine_live.date AND marine_live.fammarine_id NOT IN (SELECT fammarine_id FROM marine_live WHERE NOW() AT TIME ZONE 'UTC' - INTERVAL '9 HOURS' < marine_live.date) LIMIT 800 OFFSET 0";
-    			//$query = "SELECT marine_live.fammarine_id FROM marine_live INNER JOIN (SELECT fammarine_id,MAX(date) as max_date FROM marine_live GROUP BY fammarine_id) s ON s.fammarine_id = marine_live.fammarine_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 800 OFFSET 0";
-    			$query = "DELETE FROM marine_live WHERE fammarine_id IN (SELECT marine_live.fammarine_id FROM marine_live INNER JOIN (SELECT fammarine_id,MAX(date) as max_date FROM marine_live GROUP BY fammarine_id) s ON s.fammarine_id = marine_live.fammarine_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 800 OFFSET 0)";
-    			try {
+				//$query = "SELECT marine_live.fammarine_id FROM marine_live INNER JOIN (SELECT fammarine_id,MAX(date) as max_date FROM marine_live GROUP BY fammarine_id) s ON s.fammarine_id = marine_live.fammarine_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 800 OFFSET 0";
+				$query = "DELETE FROM marine_live WHERE fammarine_id IN (SELECT marine_live.fammarine_id FROM marine_live INNER JOIN (SELECT fammarine_id,MAX(date) as max_date FROM marine_live GROUP BY fammarine_id) s ON s.fammarine_id = marine_live.fammarine_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 800 OFFSET 0)";
+				try {
 				
 				$sth = $this->db->prepare($query);
 				$sth->execute();
@@ -818,18 +818,18 @@ 
 		return 'error';
 	}
 
-    /**
-     * Deletes all info in the table for an ident
-     *
-     * @param $ident
-     * @return String success or false
-     */
+	/**
+	 * Deletes all info in the table for an ident
+	 *
+	 * @param $ident
+	 * @return String success or false
+	 */
 	public function deleteLiveMarineDataByIdent($ident)
 	{
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
 		$query  = 'DELETE FROM marine_live WHERE ident = :ident';
         
-    		try {
+			try {
 			
 			$sth = $this->db->prepare($query);
 			$sth->execute(array(':ident' => $ident));
@@ -840,18 +840,18 @@ 
 		return "success";
 	}
 
-    /**
-     * Deletes all info in the table for an id
-     *
-     * @param $id
-     * @return String success or false
-     */
+	/**
+	 * Deletes all info in the table for an id
+	 *
+	 * @param $id
+	 * @return String success or false
+	 */
 	public function deleteLiveMarineDataById($id)
 	{
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
 		$query  = 'DELETE FROM marine_live WHERE fammarine_id = :id';
         
-    		try {
+			try {
 			
 			$sth = $this->db->prepare($query);
 			$sth->execute(array(':id' => $id));
@@ -864,11 +864,11 @@ 
 
 
 	/**
-	* Gets the marine races
-	*
-	* @return array all races
-	*
-	*/
+	 * Gets the marine races
+	 *
+	 * @return array all races
+	 *
+	 */
 	public function getAllRaces()
 	{
 		$query  = 'SELECT DISTINCT marine_live.race_id, marine_live.race_name FROM marine_live ORDER BY marine_live.race_name';
@@ -877,12 +877,12 @@ 
 		return $sth->fetchAll(PDO::FETCH_ASSOC);
 	}
 
-    /**
-     * Gets the aircraft ident within the last hour
-     *
-     * @param $ident
-     * @return String the ident
-     */
+	/**
+	 * Gets the aircraft ident within the last hour
+	 *
+	 * @param $ident
+	 * @return String the ident
+	 */
 	public function getIdentFromLastHour($ident)
 	{
 		global $globalDBdriver;
@@ -908,14 +908,14 @@ 
 			$ident_result = $row['ident'];
 		}
 		return $ident_result;
-        }
-
-    /**
-     * Check recent aircraft
-     *
-     * @param $ident
-     * @return String the ident
-     */
+		}
+
+	/**
+	 * Check recent aircraft
+	 *
+	 * @param $ident
+	 * @return String the ident
+	 */
 	public function checkIdentRecent($ident)
 	{
 		global $globalDBdriver;
@@ -941,14 +941,14 @@ 
 			$ident_result = $row['fammarine_id'];
 		}
 		return $ident_result;
-        }
-
-    /**
-     * Check recent aircraft by id
-     *
-     * @param $id
-     * @return String the ident
-     */
+		}
+
+	/**
+	 * Check recent aircraft by id
+	 *
+	 * @param $id
+	 * @return String the ident
+	 */
 	public function checkIdRecent($id)
 	{
 		global $globalDBdriver;
@@ -974,14 +974,14 @@ 
 			$ident_result = $row['fammarine_id'];
 		}
 		return $ident_result;
-        }
-
-    /**
-     * Check recent aircraft by mmsi
-     *
-     * @param $mmsi
-     * @return String the ident
-     */
+		}
+
+	/**
+	 * Check recent aircraft by mmsi
+	 *
+	 * @param $mmsi
+	 * @return String the ident
+	 */
 	public function checkMMSIRecent($mmsi)
 	{
 		global $globalDBdriver;
@@ -1007,41 +1007,41 @@ 
 			$ident_result = $row['fammarine_id'];
 		}
 		return $ident_result;
-        }
-
-    /**
-     * Adds a new spotter data
-     *
-     * @param String $fammarine_id the ID from flightaware
-     * @param String $ident the flight ident
-     * @param string $latitude
-     * @param string $longitude
-     * @param string $heading
-     * @param string $groundspeed
-     * @param string $date
-     * @param bool $putinarchive
-     * @param string $mmsi
-     * @param string $type
-     * @param string $typeid
-     * @param string $imo
-     * @param string $callsign
-     * @param string $arrival_code
-     * @param string $arrival_date
-     * @param string $status
-     * @param string $statusid
-     * @param bool $noarchive
-     * @param string $format_source
-     * @param string $source_name
-     * @param string $over_country
-     * @param string $captain_id
-     * @param string $captain_name
-     * @param string $race_id
-     * @param string $race_name
-     * @param string $distance
-     * @param string $race_rank
-     * @param string $race_time
-     * @return String success or false
-     */
+		}
+
+	/**
+	 * Adds a new spotter data
+	 *
+	 * @param String $fammarine_id the ID from flightaware
+	 * @param String $ident the flight ident
+	 * @param string $latitude
+	 * @param string $longitude
+	 * @param string $heading
+	 * @param string $groundspeed
+	 * @param string $date
+	 * @param bool $putinarchive
+	 * @param string $mmsi
+	 * @param string $type
+	 * @param string $typeid
+	 * @param string $imo
+	 * @param string $callsign
+	 * @param string $arrival_code
+	 * @param string $arrival_date
+	 * @param string $status
+	 * @param string $statusid
+	 * @param bool $noarchive
+	 * @param string $format_source
+	 * @param string $source_name
+	 * @param string $over_country
+	 * @param string $captain_id
+	 * @param string $captain_name
+	 * @param string $race_id
+	 * @param string $race_name
+	 * @param string $distance
+	 * @param string $race_rank
+	 * @param string $race_time
+	 * @return String success or false
+	 */
 	public function addLiveMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $heading = '', $groundspeed = '', $date = '', $putinarchive = false, $mmsi = '',$type = '',$typeid = '',$imo = '', $callsign = '',$arrival_code = '',$arrival_date = '',$status = '',$statusid = '',$noarchive = false,$format_source = '', $source_name = '', $over_country = '',$captain_id = '',$captain_name = '',$race_id = '', $race_name = '', $distance = '', $race_rank = '', $race_time = '')
 	{
 		global $globalArchive, $globalDebug;
@@ -1123,10 +1123,10 @@ 
 		if ($statusid == '') $statusid = NULL;
 		if ($distance == '') $distance = NULL;
 
-            	//if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
-            	if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
-            	if ($arrival_date == '') $arrival_date = NULL;
-            	$query = '';
+				//if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
+				if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
+				if ($arrival_date == '') $arrival_date = NULL;
+				$query = '';
 		if ($globalArchive) {
 			if ($globalDebug) echo '-- Delete previous data -- ';
 			$query .= 'DELETE FROM marine_live WHERE fammarine_id = :fammarine_id;';