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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
| <?php
mysql_connect("localhost", "root", "")
or die("There is no connection to the mysql server!");
mysql_select_db("ipcounter")
or die("The ipcounter database could not be selected!");
$ip = $_SERVER["REMOTE_ADDR"];
$time = time();
$dnes = 0;
$v4era = 0;
$last6 = 0;
$sred_dnevno = 0;
$rekord_date = time();
$den_na4 = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
$den_krai = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y'));
$v4era_na4 = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
$before6 = mktime(0, 0, 0, date('m'), date('d') - 6, date('Y'));
$query1 = "select ip,timestamp
from ipcount where ip='$ip' and timestamp>='$den_na4'";
$result1 = mysql_query($query1)
or die("The query1 could not be made!");
$num1 = mysql_num_rows($result1);
if ($num1 == 0) {
$query = "insert into ipcount values('','" . $ip . "','" . $time . "')";
mysql_query($query);
} else {
$row = mysql_fetch_array($result1);
$timestamp = $row['timestamp'];
$ip_baz = $row['ip'];
$query = "update ipcount
set timestamp=" . $time . "
where ip=$ip_baz and timestamp=$timestamp";
mysql_query($query);
}
$query2 = "select * from ipcount
where timestamp>=$v4era_na4 and timestamp<$den_krai";
$result2 = mysql_query($query2);
while ($row = mysql_fetch_array($result2)) {
if ($row["timestamp"] < $den_na4) {
$v4era++;
} else {
$dnes++;
}
}
$query3 = "select count(distinct ip)
from ipcount where timestamp>=$before6
and timestamp<$den_na4";
$result3 = mysql_query($query3);
$broi = mysql_num_rows($result3);
if ($broi > 0) {
list ($last6) = mysql_fetch_array($result3);
}
$query4 = "select * from ipcount
where timestamp>=$before6 and timestamp<$den_na4";
$result4 = mysql_query($query4);
$sred_dnevno = substr(mysql_num_rows($result4) / 6, 0, 4);
for ($i = -1; $i < 6; $i++) {
$a[$i +1] = array ();
$na4 = mktime(0, 0, 0, date('m'), date('d') - ($i +1), date('Y'));
$krai = mktime(0, 0, 0, date('m'), date('d') - $i, date('Y'));
$query5 = "select ip,timestamp
from ipcount
where timestamp>=$na4 and timestamp<$krai";
$result5 = mysql_query($query5);
$a[$i +1][0] = mysql_num_rows($result5);
if ($a[$i +1][0] > 0) {
$tek_time = mysql_result($result5, 0, 'timestamp');
$a[$i +1][1] = date("j F Y", $tek_time);
} else {
$a[$i +1][1] = 0;
}
}
$rekord_mas = max($a[0], $a[1], $a[2], $a[3], $a[4], $a[5], $a[6]);
$rekord = $rekord_mas[0];
$rekord_date = $rekord_mas[1];
if ($rekord == $a[0][0]) {
$rekord_date = $rekord_date . "(днес)";
}
echo "<font color='red' size='4'>Уникални посещения днес:$dnes<br>Уникални посещения вчера:$v4era<br>";
echo "Общо уникални посещения за последните 6 дни(без днешния):$last6<br>";
echo "Уникални посещения средно на ден през последните 6 дни(без днешния): $sred_dnevno<br>Рекорд за последната седмица: " . $rekord . " уникални посещения на " . $rekord_date . "</font>";
?> |
