1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

<?php
require_once "configure.php";

// Expires in the past
header("Expires: Mon, 26 Jul 1990 05:00:00 GMT");
// Always modified
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
// HTTP/1.1
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
// HTTP/1.0
header("Pragma: no-cache");

preg_match("/^[a-zA-Z\-]*/", $_SERVER['HTTP_ACCEPT_LANGUAGE'], $language);
// $_SESSION['_tracking'] = $_SESSION['_tracking'] ?: session_id();

if(true){
    $sql = "INSERT into hit (
                createdate, docdate,
                tracking_code, action, url, userid, clientid,
                ip_address, browser_user_agent, screen_size, language_code, data,
                session
            ) VALUES (
                NOW(), NOW(),
                :tracking_code, :action, :url, :userid, :clientid,
                :ip_address, :browser_user_agent, :screen_size, :language_code, :data,
                :session
            )";
    $sql_param = array(
            'tracking_code'         => $_REQUEST['tracking_code'],
            'action'                 => $_REQUEST['action'] ?: "pageview",
            'url'                     => $_REQUEST['url'] ?: $_SERVER['HTTP_REFERER'],
            'userid'                 => $_REQUEST['userid'],
            'clientid'                 => $_REQUEST['clientid'],
            'ip_address'            => getRealIpAddr(),
            'browser_user_agent'     => $_REQUEST['browser_user_agent'] ?: $_SERVER['HTTP_USER_AGENT'],
            'screen_size'             => $_REQUEST['screen_size'],
            'language_code'         => $_REQUEST['language_code'] ?: $language[0],
            'data'                     => $_REQUEST['data'],
            'session'                 => session_id(),
        );

    bind_pdo($sql, $sql_param, "insert");
}