1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* adm_payment.php |
5
|
|
|
* |
6
|
|
|
* @version 1.0 |
7
|
|
|
* @copyright 2013 by Gorlum for http://supernova.ws |
8
|
|
|
*/ |
9
|
|
|
define('INSIDE', true); |
10
|
|
|
define('INSTALL', false); |
11
|
|
|
define('IN_ADMIN', true); |
12
|
|
|
|
13
|
|
|
require('../common.' . substr(strrchr(__FILE__, '.'), 1)); |
14
|
|
|
|
15
|
|
|
global $lang, $user; |
16
|
|
|
|
17
|
|
|
SnTemplate::messageBoxAdminAccessDenied(AUTH_LEVEL_ADMINISTRATOR); |
18
|
|
|
|
19
|
|
|
// define('SESSION_INTERRUPT', 15*60); // Можно увеличить до 4 часов - никито не может сидеть 2 суток с перерывом менее 4 часов |
20
|
|
|
// define('SUSPICIOUS_LONG', 2 * 60*60); // Тогда это увеличиваем до, скажем суток - и там смотрим |
21
|
|
|
|
22
|
|
|
define('SESSION_INTERRUPT', 1 * 60*60); // Можно увеличить до 4 часов - никито не может сидеть 2 суток с перерывом менее 4 часов |
23
|
|
|
define('SUSPICIOUS_LONG', 16 * 60*60); // Тогда это увеличиваем до, скажем суток - и там смотрим |
24
|
|
|
|
25
|
|
|
|
26
|
|
|
function check_suspicious(&$session, &$session_list_last_id, &$row) { |
27
|
|
|
$session[2] = $session[1] - $session[0]; |
28
|
|
|
if($session[2] > SUSPICIOUS_LONG) |
29
|
|
|
{ |
30
|
|
|
$session[2] = pretty_time($session[2]); |
31
|
|
|
$session[0] = date(FMT_DATE_TIME_SQL, $session[0]); |
32
|
|
|
$session[1] = date(FMT_DATE_TIME_SQL, $session[1]); |
33
|
|
|
$session_list_last_id[] = $session; |
34
|
|
|
} |
35
|
|
|
//$row ? |
36
|
|
|
$session = array( |
37
|
|
|
// 0 => $row['time'], // start |
38
|
|
|
// 1 => $row['time'], // end |
39
|
|
|
0 => $row['visit_time'], // start |
40
|
|
|
1 => $row['visit_time'], // end |
41
|
|
|
) |
42
|
|
|
//: false |
43
|
|
|
; |
44
|
|
|
} |
45
|
|
|
|
46
|
|
|
$session_list = array(); |
47
|
|
|
$query = doquery("SELECT `visit_time`, user_id FROM {{counter}} where user_id <> 0 and visit_time > UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)) order by user_id, visit_time;"); |
|
|
|
|
48
|
|
|
$session = array(); |
49
|
|
|
if($row = db_fetch($query)) { |
|
|
|
|
50
|
|
|
$session = array( |
51
|
|
|
0 => strtotime($row['visit_time']), // start |
52
|
|
|
1 => strtotime($row['visit_time']), // end |
53
|
|
|
); |
54
|
|
|
$last_id = $row['user_id']; |
55
|
|
|
} |
56
|
|
|
while($row = db_fetch($query)) { |
|
|
|
|
57
|
|
|
$row['visit_time'] = strtotime($row['visit_time']); |
58
|
|
|
if($last_id == $row['user_id']) { |
59
|
|
|
// Тот же юзер |
60
|
|
|
if($row['visit_time'] - $session[1] <= SESSION_INTERRUPT) { // Та же сессия |
61
|
|
|
$session[1] = $row['visit_time']; |
62
|
|
|
} else { |
63
|
|
|
// Новая сессия |
64
|
|
|
// check_suspicious($session, $session_list[$last_id], $row); |
65
|
|
|
$session[2] = $session[1] - $session[0]; |
66
|
|
|
if($session[2] > SUSPICIOUS_LONG) |
67
|
|
|
{ |
68
|
|
|
$session[2] = pretty_time($session[2]); |
69
|
|
|
$session[0] = date(FMT_DATE_TIME_SQL, $session[0]); |
70
|
|
|
$session[1] = date(FMT_DATE_TIME_SQL, $session[1]); |
71
|
|
|
$session_list[$last_id][] = $session; |
72
|
|
|
} |
73
|
|
|
$session = array( |
74
|
|
|
0 => $row['visit_time'], // start |
75
|
|
|
1 => $row['visit_time'], // end |
76
|
|
|
); |
77
|
|
|
} |
78
|
|
|
} else { |
79
|
|
|
// check_suspicious($session, $session_list[$last_id], $row); |
80
|
|
|
$session[2] = $session[1] - $session[0]; |
81
|
|
|
if($session[2] > SUSPICIOUS_LONG) |
82
|
|
|
{ |
83
|
|
|
$session[2] = pretty_time($session[2]); |
84
|
|
|
$session[0] = date(FMT_DATE_TIME_SQL, $session[0]); |
85
|
|
|
$session[1] = date(FMT_DATE_TIME_SQL, $session[1]); |
86
|
|
|
$session_list[$last_id][] = $session; |
87
|
|
|
} |
88
|
|
|
$session = array( |
89
|
|
|
0 => $row['visit_time'], // start |
90
|
|
|
1 => $row['visit_time'], // end |
91
|
|
|
); |
92
|
|
|
$last_id = $row['user_id']; |
93
|
|
|
} |
94
|
|
|
} |
95
|
|
|
|
96
|
|
|
if($last_id) { |
97
|
|
|
// check_suspicious($session, $session_list[$last_id], $row = array('time' => 0)); |
98
|
|
|
$session[2] = $session[1] - $session[0]; |
99
|
|
|
|
100
|
|
|
if($session[2] > SUSPICIOUS_LONG) |
101
|
|
|
{ |
102
|
|
|
$session[2] = pretty_time($session[2]); |
103
|
|
|
$session[0] = date(FMT_DATE_TIME_SQL, $session[0]); |
104
|
|
|
$session[1] = date(FMT_DATE_TIME_SQL, $session[1]); |
105
|
|
|
$session_list[$last_id][] = $session; |
106
|
|
|
} |
107
|
|
|
} |
108
|
|
|
|
109
|
|
|
print("<table border='1'>"); |
110
|
|
|
print("<tr>"); |
111
|
|
|
print("<td>ID</td><td>Username</td><td>Start</td><td>End</td><td>Length</td>"); |
112
|
|
|
print("<td>Last online</td>"); |
113
|
|
|
print("</tr>"); |
114
|
|
|
foreach($session_list as $user_id => $value) { |
115
|
|
|
$user_record = doquery("SELECT `username`, onlinetime FROM {{users}} WHERE id = {$user_id};", true); |
|
|
|
|
116
|
|
|
foreach($value as $interval_data) { |
117
|
|
|
print("<tr>"); |
118
|
|
|
print("<td>{$user_id}</td><td>{$user_record['username']}</td><td>{$interval_data[0]}</td><td>{$interval_data[1]}</td><td>{$interval_data[2]}</td>"); |
119
|
|
|
print("<td>" . date(FMT_DATE_TIME_SQL, $user_record['onlinetime']) . "</td>"); |
120
|
|
|
print("</tr>"); |
121
|
|
|
} |
122
|
|
|
} |
123
|
|
|
print("</table>"); |
124
|
|
|
|