@feature_request: features(at)dfhu.org
@file:
@license: BSD
@description:
This file is great.
*/
require "./login_is.php";
require "../includes/db.inc.php";
$db_dir = DB_DIR;
if (!preg_match("/[0-9]{6}-site-freetale.sqlite/", $_GET['db'])) {
echo "BAD DATABSE";
exit;
}
$db = new DBx(DB_DIR . $_GET['db']);
$sql = "\nSELECT * FROM tics \n WHERE\n id=:id and url=:url \n LIMIT 1\n";
$db->p($sql);
$db->exec(array(":id" => $_GET['id'], ":url" => $_GET['url']));
$init = $db->f();
$_SESSION['id'] = $_GET['id'];
$_SESSION['url'] = $_GET['url'];
$_SESSION['db'] = $_GET['db'];
$_SESSION['replay_motion'] = 1;
$_SESSION['replay_summary'] = 0;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>FreeTale Replay</title>
if ($url == "") {
return "none";
}
$url = filter_var($url, FILTER_VALIDATE_URL, FILTER_FLAG_SCHEME_REQUIRED);
$url_string = htmlentities($url);
$url_link = "\n<a href=\"{$url}\" target=\"_blank\">{$url_string}</a>\n";
return $url_link;
}
if (!preg_match("/freetaleform.sqlite/", $_GET['db'])) {
echo "BAD DATABSE";
exit;
}
$db = new DBx(DB_DIR . $_GET['db']);
$prepare_vars = array(':id' => $_GET['id'], ':url' => $_GET['url']);
$sql = "\nSELECT * FROM \n actions \nWHERE\n id = :id\n AND\n url = :url\nORDER BY\n unixtime\n";
$db->p($sql . " LIMIT 1");
$db->exec($prepare_vars);
$meta_row = $db->f();
$url_link = anchor_link($meta_row['url']);
$referer_link = anchor_link($meta_row['referer']);
$db->p($sql);
$db->exec($prepare_vars);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Form Analytics</title>
<link rel="stylesheet" href="style.css" >
