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
|
<?
include("./include/admin_include_header.php");
header("Content-Type: text/html; charset=euckr");
$site_key = "search.naver.com/";
//$site_key = "search.daum.net";
$sql = "select count(*) as cnt from (select session_key as cnt from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%{$site_key}%' group by session_key order by reg_date) aa where 1";
//_pr($sql);
//select session_key from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%google.com/%' group by session_key;
$res = mysql_query($sql);
while($info=mysql_fetch_array($res)){
_pr($site_key);
_pr($info);
/*$sql = "select * from visit_ref_log where session_key = '{$info['session_key']}' order by reg_date limit 1";
$res2 = mysql_query($sql);
$info2 = mysql_fetch_array($res2);
_pr($info2);*/
}
$site_key = "search.daum.net/";
//$site_key = "search.daum.net";
$sql = "select count(*) as cnt from (select session_key as cnt from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%{$site_key}%' group by session_key order by reg_date) aa where 1";
//_pr($sql);
//select session_key from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%google.com/%' group by session_key;
$res = mysql_query($sql);
while($info=mysql_fetch_array($res)){
_pr($site_key);
_pr($info);
/*$sql = "select ref_key from visit_ref_log where session_key = '{$info['session_key']}' order by reg_date limit 1";
$res2 = mysql_query($sql);
$info2 = mysql_fetch_array($res2);
_pr($info2);*/
}
$site_key = "google.com/";
//$site_key = "search.daum.net";
$sql = "select count(*) as cnt from (select session_key as cnt from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%{$site_key}%' group by session_key order by reg_date) aa where 1";
//_pr($sql);
//select session_key from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%google.com/%' group by session_key;
$res = mysql_query($sql);
while($info=mysql_fetch_array($res)){
_pr($site_key);
_pr($info);
/*$sql = "select * from visit_ref_log where session_key = '{$info['session_key']}' order by reg_date limit 1";
$res2 = mysql_query($sql);
$info2 = mysql_fetch_array($res2);
_pr($info2);*/
}
$site_key = "search.zum.com/";
//$site_key = "search.daum.net";
$sql = "select count(*) as cnt from (select session_key as cnt from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%{$site_key}%' group by session_key order by reg_date) aa where 1";
//_pr($sql);
//select session_key from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%google.com/%' group by session_key;
$res = mysql_query($sql);
while($info=mysql_fetch_array($res)){
_pr($site_key);
_pr($info);
/*$sql = "select * from visit_ref_log where session_key = '{$info['session_key']}' order by reg_date limit 1";
$res2 = mysql_query($sql);
$info2 = mysql_fetch_array($res2);
_pr($info2);*/
}
$site_key = "www.bing.com/search";
//$site_key = "search.daum.net";
$sql = "select count(*) as cnt from (select session_key as cnt from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%{$site_key}%' group by session_key order by reg_date) aa where 1";
//_pr($sql);
//select session_key from visit_ref_log where reg_date >= '2019-12-01 00:00:00' and referer like '%google.com/%' group by session_key;
$res = mysql_query($sql);
while($info=mysql_fetch_array($res)){
_pr($site_key);
_pr($info);
/*$sql = "select * from visit_ref_log where session_key = '{$info['session_key']}' order by reg_date limit 1";
$res2 = mysql_query($sql);
$info2 = mysql_fetch_array($res2);
_pr($info2);*/
}
?>
</body>
</html>
|