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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
// define: $dbhost, $dbuser, $dbpass, $dbbase;
function ConnectToJS()
{
global $dbhost, $dbuser, $dbpass, $dbbase;
$db = mysql_connect("$dbhost", "$dbuser", "$dbpass");
if(mysql_select_db("$dbbase",$db))
return $db;
return 0;
}
$db = ConnectToJS();
$table = "logs_" . date("Y_m",time());
$sql = "
CREATE TABLE IF NOT EXISTS `$table` (
`id` bigint(20) NOT NULL auto_increment,
`hash` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`ip_int` bigint(20) NOT NULL,
`ip_host` varchar(255) NOT NULL,
`ip_country_id` int(10) NOT NULL,
`created_at` datetime NOT NULL,
`path` varchar(255) NOT NULL,
`referer` varchar(255) NOT NULL,
`referer_host` varchar(255) NOT NULL,
`query_str` varchar(255) NOT NULL,
`agent` varchar(255) NOT NULL,
`host` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `hash` (`hash`),
KEY `host` (`host`),
KEY `ip_country_id` (`ip_country_id`),
KEY `referer` (`referer`),
KEY `agent` (`agent`),
KEY `created_at` (`created_at`),
KEY `referer_host` (`referer_host`)
) ENGINE=MyISAM
";
mysql_query($sql,$db);
$ip = $_SERVER['REMOTE_ADDR'];
$ip_host = gethostbyaddr ( $_SERVER['REMOTE_ADDR'] );
$path = $_REQUEST['REQUEST_URI'];
$parts = parse_url($path);
$ip_int = explode(".",$ip);
$ip_int = $ip_int[0]*256*256*256 + $ip_int[1]*256*256 + $ip_int[2]*256 + $ip_int[3];
$sql = "
SELECT
id
FROM
ip_to_country
WHERE
$ip_int >= ip_start AND $ip_int <= ip_end
";
$res = mysql_query($sql,$db);
$r = mysql_fetch_assoc($res);
$ip_country_id = isset($r['id']) ? $r['id'] : 0;
$created_at = time();
$referer = $_REQUEST['HTTP_REFERER'];
$ref_parts = parse_url($referer);
$referer_host = $ref_parts['host'];
$query_str = $ref_parts['query'];
$agent = $_SERVER['HTTP_USER_AGENT'];
$host = $parts['host'];
$hash = md5($ip . $created_at . $path . $referer . $agent . $host);
$sql = "
INSERT INTO
$table
SET
hash = \"" . mysql_real_escape_string($hash) . "\",
ip = \"" . mysql_real_escape_string($ip) . "\",
ip_host = \"" . mysql_real_escape_string($ip_host) . "\",
ip_int = \"" . mysql_real_escape_string($ip_int) . "\",
ip_country_id = \"" . mysql_real_escape_string($ip_country_id) . "\",
created_at = NOW(),
path = \"" . mysql_real_escape_string($path) . "\",
referer = \"" . mysql_real_escape_string($referer) . "\",
referer_host = \"" . mysql_real_escape_string($referer_host) . "\",
query_str = \"" . mysql_real_escape_string($query_str) . "\",
agent = \"" . mysql_real_escape_string($agent) . "\",
host = \"" . mysql_real_escape_string($host) . "\"
";
mysql_query($sql,$db); |
