query($update) === FALSE) echo ''; } if ($_POST['listaid'] && isset($_POST['CbBoxValue'])) { $listaid = substr($_POST['listaid'], 5); $update = "UPDATE `www_archline_hu`.`crash` SET `eredmeny`='{$_POST['CbBoxValue']}' WHERE `id`='{$listaid}'"; if ($connection->query($update) === FALSE) echo ''; } } function downloadFile($filename) { if ($f = fopen($filename, "rb")) { $content_len = (int) filesize($filename); //@ini_set('zlib.output_compression', 'Off'); header('Pragma: public'); //header('Last-Modified: '.gmdate('D, d M Y H(idea)(worry)') . ' GMT'); header('Cache-Control: no-store, no-cache, must-revalidate'); // HTTP/1.1 header('Cache-Control: pre-check=0, post-check=0, max-age=0'); // HTTP/1.1 header('Content-Transfer-Encoding: none'); header('Content-Type: plain/text'); header('Content-Disposition: inline; filename="' . $filename . '"'); header("Content-length: $content_len"); while (!feof($f)) { echo fread($f, 2 << 20); } fclose($f); } else { print "error opening file"; } exit(); } if (isset($_GET) && !empty($_GET)) { $filepath = "/home/vendeg/crash/"; $filepath .= $_GET["guid"]; if (!file_exists($filepath)) $filepath = "../webdav/crash/" . $_GET['guid']; downloadFile($filepath); } else { ?> '; if (isset($_SESSION["maxdate"]) || isset($_SESSION["mindate"]) || isset($_SESSION["lista"])) { echo 'Dátum szűrés
-tól     -ig'; } else { echo 'Dátum szűrés
-tól     -ig'; } ?>

Eredmény szűrő:




= '" . $_POST['datemin'] . "'"; if (isset($_POST['datemax'])) $feltetel[] = "left(datum, 10) <= '" . $_POST['datemax'] . "'"; if (isset($_POST['lista']) && $_POST['lista'] != "%") $feltetel[] = "`eredmeny` = " . $_POST['lista'] . ""; if (isset($_POST['lista']) && $_POST['lista'] == "%") $feltetel[] = "1"; if (isset($_POST['datemax']) || isset($_POST['datemin']) || isset($_POST['lezart'])) $query .= "WHERE " . implode(' AND ', $feltetel); if (isset($_POST['product']) && $_POST['product'] != 0) { if ($_POST['product'] == 1) $query .= " AND SUBSTR(guid, 1, 5) NOT LIKE 'Live_%'"; if ($_POST['product'] == 2) $query .= " AND SUBSTR(guid, 1, 5) LIKE 'Live_%'"; } $query .= " ORDER BY id DESC LIMIT 500"; print "
"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; $msh2->query($query); $results = $msh2->fetchAssoc(); foreach ($results as $result) { $r = (object)$result; $filepathFtp = "/home/vendeg/crash/"; $filepathFtp .= $r->guid; $filepathFtp .= ".DMP"; $filepathWebdav = "../webdav/crash/"; $filepathWebdav .= $r->guid; $filepathWebdav .= ".DMP"; if (!file_exists($filepathFtp) && !file_exists($filepathWebdav)) continue; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print ''; print ''; print ''; print ''; print ''; print "
EmailÜzenetDátumDmp fájlInfo fájlMegjegyzésEredmény
"; print $r->email; print ""; print $r->info; print ""; //print substr($r->datum,0,10); print $r->datum; print ""; ?> guid ?> "; print ""; $infoPath = '/home/vendeg/crash/' . $r->guid . '.TXT'; $infoPathWebdav = '../webdav/crash/' . $r->guid . '.TXT'; $logPath = '/home/vendeg/crash/' . $r->guid . '.LOG'; $logPathWebdav = '../webdav/crash/' . $r->guid . '.LOG'; $logExtension = '.LOG'; $infoExtension = '.TXT'; if (!file_exists($infoPath) && !file_exists($infoPathWebdav)) { $infoPath = '/home/vendeg/crash/' . $r->guid . '.XML'; $infoExtension = '.XML'; } echo 'Info'; if (file_exists($logPath) || file_exists($logPathWebdav)) { echo ' Log'; } if (file_exists(infoPath)) { $file = '/home/vendeg/crash/' . $r->guid . '.TXT'; if (!file_exists($file)) $file = infoPathWebdav; $searchfor = 'developer'; $contents = file_get_contents($file); $pattern = preg_quote($searchfor, '/'); $pattern = "/^.*$pattern.*\$/m"; if (preg_match_all($pattern, $contents, $matches)) echo "developer"; $searchfor = 'Product: render'; $contents = file_get_contents($file); $pattern = preg_quote($searchfor, '/'); $pattern = "/^.*$pattern.*\$/m"; if (preg_match_all($pattern, $contents, $matches)) { echo "render"; } } print ""; echo ""; print ""; switch ($r->eredmeny) { case '0': echo ' '; break; case '1': echo ' '; break; case '2': echo ' '; break; case '3': echo ' '; break; case '4': echo ' '; break; case '5': echo ' '; break; case '6': echo ' '; break; case '7': echo ' '; break; } print "
"; ?>