site_id = :selectedSiteId ORDER BY dateTime DESC LIMIT 25 MYSQL; $availableFilesParams['selectedSiteId'] = $siteId; $availableFilesResult = DatabaseHelper::query($DBH, $availableFilesQuery, $availableFilesParams); $availableFiles = $availableFilesResult->fetchAll(PDO::FETCH_ASSOC); if (empty($availableFiles)) { exit; } $fileId = filter_input(INPUT_GET, 'selectedFileId', FILTER_VALIDATE_INT); if (empty($fileId)) { $latestFileData = TwlFile::getLatestFileData($siteName); $fileId = $latestFileData['file_id']; } else { $fileData = TwlFile::getDateTimeFromId($fileId); if (empty($fileData)) { exit; } } $duneQuery = <<<MYSQL SELECT dune_id AS dId, latitude AS la, longitude AS lo, toe, crest FROM dunes WHERE site_id = :selectedSiteId