@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" >