Open source project displaying live aircrafts, ships or trackers on 2D/3D map. Browse through the data based on a particular aircraft, airline, airport, tracker or vessel to search through the database or see extensive statistics. Can use ADS-B in SBS1 format (dump1090, Radarcape,...), VRS, VA (VATSIM, IVAO whazzup.txt, phpvms,...), ACARS (acarsdec, acarsdeco2), APRS, AIS as datasource.
removed 'AND' at line 336 as this was generating bad SQL, returning this error:
Invalid query : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND marine_output.ident = 'MARIELLA' ORDER BY marine_output.date DESC LIMIT 25 ' at line 1 Whole query: SELECT marine_output.* FROM marine_output WHERE AND marine_output.ident = :ident ORDER BY marine_output.date DESC LIMIT 25 OFFSET 0
removed 'AND' at line 336 as this was generating bad SQL, returning this error:
Invalid query : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND marine_output.ident = 'MARIELLA' ORDER BY marine_output.date DESC LIMIT 25 ' at line 1 Whole query: SELECT marine_output.* FROM marine_output WHERE AND marine_output.ident = :ident ORDER BY marine_output.date DESC LIMIT 25 OFFSET 0