}
if (filesize(dirname(__FILE__) . '/unittest.dbf') == 0) {
try {
$query = @$sqlite->exec('CREATE TABLE requests (token TEXT, ip TEXT, ts TEXT, uri TEXT, referer TEXT, ua TEXT)');
} catch (Exception $e) {
header("HTTP/1.0 500 Internal Server Error");
exit;
}
}
if (isset($_GET['requests'])) {
$token = get_magic_quotes_gpc() ? stripslashes($_GET['requests']) : $_GET['requests'];
$ua = $_SERVER['HTTP_USER_AGENT'];
echo "<html><head><title>{$token}</title></head><body>\n";
sleep(5);
// $result = $sqlite->query_array("SELECT uri FROM requests");
$result = @$sqlite->query_array("SELECT uri FROM requests WHERE token = \"{$token}\" AND ua = \"{$ua}\"");
if ($result !== false) {
$nofRows = count($result);
echo "<span>{$nofRows}</span>\n";
foreach ($result as $entry) {
echo "<span>" . $entry['uri'] . "</span>\n";
}
}
echo "</body></html>\n";
} else {
if (!isset($_REQUEST['data'])) {
header("HTTP/1.0 400 Bad Request");
} else {
$ip = $_SERVER['REMOTE_ADDR'];
$ts = $_SERVER['REQUEST_TIME'];
$uri = isset($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '';
$ip = $_SERVER['REMOTE_ADDR'];
$ts = $_SERVER['REQUEST_TIME'];
// $uri = htmlspecialchars($uri);
$referrer = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
$ua = $_SERVER['HTTP_USER_AGENT'];
$token = isset($data['token']) ? $data['token'] : '';
$id = getNextRequestId($sqlite, $token);
$query = $sqlite->exec("INSERT INTO requests (requestid, token, ip, ts, uri, referer, ua) VALUES (\"{$id}\", \"{$token}\", \"{$ip}\", \"{$ts}\", \"{$uri}\", \"{$referrer}\", \"{$ua}\")");
return $query;
}
if (isset($_GET['requests'])) {
$token = htmlentities($_GET['requests']);
$ua = $_SERVER['HTTP_USER_AGENT'];
echo "<html><head><title>{$token}</title></head><body>\n";
// $result = $sqlite->query_array("SELECT uri FROM requests");
$result = @$sqlite->query_array("SELECT uri FROM requests WHERE token = \"{$token}\" AND ua = \"{$ua}\" ORDER BY ts ASC, requestid ASC");
if ($result !== false) {
$nofRows = count($result);
echo "<span>{$nofRows}</span>\n";
foreach ($result as $entry) {
echo "<span>" . $entry['uri'] . "</span>\n";
}
}
echo "</body></html>\n";
} else {
if (!isset($_REQUEST['data'])) {
header("HTTP/1.0 400 Bad Request");
} else {
$uri = isset($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '';
$input = file_get_contents("php://input");
$requests = @json_decode($input, true);
