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) . ");";