debugLog("SQL: Setting values with query: " . $query);
$connection = tsan_connect();
mysql_query($query, $connection) or kill_script('3.3');
mysql_close($connection);
}
function getInput($str)
{
global $analyticsPrefixString;
global $inputValues;
return $inputValues[$analyticsPrefixString . $str];
}
$inputValues = array();
$fieldList = '';
foreach ($_GET as $key => $value) {
if (in_array($key, $analytics_fields)) {
$inputValues[$key] = tsescape($value);
$fieldList .= ',`' . removestr('`', removeunsafe($key)) . '`';
}
}
$inputValuesStr = '';
foreach ($inputValues as $inputValue) {
$inputValuesStr .= ',"' . $inputValue . '"';
}
$query = 'INSERT INTO ' . $analytics_tableName . ' (ID' . $fieldList . ') VALUES ("NULL"' . $inputValuesStr . ') ';
$validationError = isValidSubmission($inputValues);
if ($validationError == 0 && $IS_ON) {
if ($inputValues[$analyticsPrefixString . "__update__"]) {
$whereSel = whereSelector();
appendToSQLCell(array($analyticsPrefixString . 'mouse' => getInput("mouse"), $analyticsPrefixString . 'key' => getInput("keys"), $analyticsPrefixString . 'clicks' => getInput("clicks"), $analyticsPrefixString . 'scroll' => getInput("scroll"), $analyticsPrefixString . 'event' => getInput("events")), $whereSel);
setSQLValues(array($analyticsPrefixString . 'duration' => getInput("duration")), $whereSel);
kill_script(0);
$paths = new Paths();
$phpPath = $paths->getFullPath('php');
$analyticsPath = $paths->getHTTPPath("submitAnalytics");
$jsPath = $paths->getHTTPPath("js");
$imgsPath = $paths->getHTTPPath("images");
$libsjsPath = $paths->getHTTPPath("libsjs");
$countriesjsPath = $paths->getHTTPPath("countriesjs");
require_once $phpPath . "libs.php";
$analytics_DBName = 'tsanalyticsdb';
$analytics_tableName = 'ts_analytics_data_01';
$analytics_username = '******';
$analytics_password = "******";
$analyticsPrefixString = 'ts_an_';
mysql_connect("topperstudioscom.ipagemysql.com", $analytics_username, $analytics_password);
mysql_select_db($analytics_DBName);
$q = "SELECT * FROM " . $analytics_tableName . ' WHERE `ID`="' . tsescape($_GET["cid"]) . '"';
$query = mysql_query($q);
$result = mysql_fetch_array($query);
//$result = $result[0];
$fields = array("winsize", "coords", "avg_conn", "reqid", "usrid", "referer", "screen", "time", "event", "duration", "s_REMOTE_PORT", "s_REMOTE_HOST", "s_REMOTE_ADDR", "s_TIME", "s_REQUEST_METHOD", "s_URL", "s_SERVER_PORT", "s_COUNTRY", "s_UA");
foreach ($fields as $key => $value) {
$fields[$key] = $analyticsPrefixString . $value;
}
/*
echo '<table cellpadding="4">';
foreach ($fields as $key => $value) {
$val = $result[$value];
if ($value==$analyticsPrefixString."event") {
$arr = explode("!", $val);
$val = "";
<?php
include '../paths.php';
$paths = new Paths();
$phpPath = $paths->getFullPath("php");
require_once $phpPath . "libs.php";
header("content-type:text/javascript");
$analytics_DBName = 'tsanalyticsdb';
$analytics_tableName = 'ts_analytics_data_01';
$analytics_username = '******';
$analytics_password = "******";
$analyticsPrefixString = 'ts_an_';
function tsan_connect()
{
global $analytics_username;
global $analytics_password;
global $analytics_DBName;
$connection = mysql_connect("topperstudioscom.ipagemysql.com", $analytics_username, $analytics_password) or kill_script('1');
mysql_select_db($analytics_DBName, $connection) or kill_script('2');
return $connection;
}
$COLS = $_GET["columns"] ? tsescape($_GET["columns"]) : "ID";
$link = tsan_connect();
$result = mysql_query("SELECT " . $COLS . " FROM " . $analytics_tableName . " WHERE ABS(ts_an_lastupdate - " . time() . ") < 10", $link);
$ARR = array();
while ($row = mysql_fetch_assoc($result)) {
array_push($ARR, $row);
}
echo $_GET['callback'] . "(" . json_encode($ARR) . ");";
