' . "\n"; $out .= '' . "\n"; $add = function (string $loc) use (&$out) { $out .= '' . htmlspecialchars($loc, ENT_XML1 | ENT_QUOTES, 'UTF-8') . '' . "\n"; }; $add($base . '/'); $tr = $pdo->query("SELECT train_no FROM trains WHERE run_days IS NOT NULL ORDER BY train_no"); foreach ($tr as $row) { $add($base . rr_train_url($row['train_no'])); } $stq = $pdo->query( "SELECT DISTINCT s.code FROM stations s JOIN train_stops ts ON ts.station_code = s.code JOIN trains t ON t.train_no = ts.train_no AND t.run_days IS NOT NULL ORDER BY s.code" ); foreach ($stq as $row) { $add($base . rr_station_url($row['code'])); } $out .= '' . "\n"; @file_put_contents($cacheFile, $out); echo $out;