exec('ls -t ~/stats.tf2pug.org/logs/ | grep -v \'L.*[0-9]\\.log\' | head -n100', $latestFiles); foreach ($latestFiles as $fileName) { $explodedFileName = explode(".", $fileName); $explodedFileName = $database->sqlEscapeString($explodedFileName); if (count($explodedFileName) == 2 && $explodedFileName[1] == log && filesize('./logs/' . $fileName) > 20000) { exec('grep \' tv_record \' ~/stats.tf2pug.org/logs/' . $fileName, $mapName); $mapName = explode(" ", $mapName[0]); $mapName = explode("_", $mapName[count($mapName) - 1]); $logDate = $mapName[0]; $mapName = $mapName[4]; if ($mapName) { $logDate = str_replace('h', ':', $logDate); $logDate = str_replace('m', '', $logDate); $logDate = strtotime($logDate); $server = explode("_", $explodedFileName[0]); $server = $server[0]; $newFileName = $server . '_' . $logDate . '_' . $mapName; if (!$database->queryAssoc("SELECT * FROM files WHERE fileName = '{$newFileName}'")) { $directory = './log/' . $newFileName; $newFileName = $newFileName . '.log'; mkdir($directory); copy('./logs/' . $fileName, $directory . '/' . $newFileName); if (!parse($directory, 'ready')) { unlink($directory . '/' . $newFileName); rmdir($directory); } } unset($logDate); } } }
// v1.1: Added paging through $_GET['sel'] to signify the selection. include 'database.php'; include 'page.php'; $database = new Database(); $search = $_REQUEST['search']; if ($search == '') { $search = date('m\\/Y'); } $search = $database->sqlEscapeString($search); foreach (explode(" ", $search) as $searchString) { if ($searchString == '') { continue; } $escapedSearchString = $database->sqlEscapeString($searchString); //echo "<pre>"; $results = $database->queryAssoc("SELECT * FROM statsIndex WHERE id like '%{$escapedSearchString}%'"); //echo "SELECT * FROM statsIndex WHERE id like '%$escapedSearchString%'"; foreach ($results as $result) { foreach ($files = explode(":", $result['files']) as $file) { $fileIndex[$file]++; $keywordsMatched[$file][] = $escapedSearchString; } } //print_r($results); //echo "</pre>"; } arsort($fileIndex); //echo "<pre>"; foreach ($fileIndex as $file => $group) { $explodedFile = explode("_", $file); $indexGroup[$group][$file] = (int) $explodedFile[1];