} 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);