1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* admin/adm_log_main.php |
5
|
|
|
* |
6
|
|
|
* @version 2.0 - full rewrote |
7
|
|
|
* @copyright 2014 by Gorlum for http://supernova.ws |
8
|
|
|
* |
9
|
|
|
*/ |
10
|
|
|
|
11
|
|
|
define('INSIDE', true); |
12
|
|
|
define('INSTALL', false); |
13
|
|
|
define('IN_ADMIN', true); |
14
|
|
|
|
15
|
|
|
require('../common.' . substr(strrchr(__FILE__, '.'), 1)); |
16
|
|
|
|
17
|
|
|
global $lang, $user; |
18
|
|
|
|
19
|
|
|
SnTemplate::messageBoxAdminAccessDenied(AUTH_LEVEL_ADMINISTRATOR); |
20
|
|
|
|
21
|
|
|
if($delete = sys_get_param_id('delete')) |
22
|
|
|
{ |
23
|
|
|
doquery("DELETE FROM `{{logs}}` WHERE `log_id` = {$delete} LIMIT 1;"); |
|
|
|
|
24
|
|
|
} |
25
|
|
|
elseif(sys_get_param_str('delete_update_info')) |
26
|
|
|
{ |
27
|
|
|
doquery("DELETE FROM `{{logs}}` WHERE `log_code` in (103, 180, 191);"); |
|
|
|
|
28
|
|
|
} |
29
|
|
|
elseif(sys_get_param_str('deleteall') == 'yes') |
30
|
|
|
{ |
31
|
|
|
// doquery("TRUNCATE TABLE `{{logs}}`"); |
32
|
|
|
} |
33
|
|
|
|
34
|
|
|
/** |
35
|
|
|
* @param $value |
36
|
|
|
* |
37
|
|
|
* @return string|null |
38
|
|
|
*/ |
39
|
|
|
function admLogRender($value) { |
40
|
|
|
if (is_array($value)) { |
41
|
|
|
$result = '<table class="no_border_image var_in">'; |
42
|
|
|
foreach ($value as $key => $val) { |
43
|
|
|
$result .= '<tr><td>' . $key . '</td><td>' . var_export($val, true) . '</td></tr>'; |
44
|
|
|
} |
45
|
|
|
$result .= '</table>'; |
46
|
|
|
} else { |
47
|
|
|
$result = var_export($value, true); |
48
|
|
|
} |
49
|
|
|
|
50
|
|
|
return $result; |
51
|
|
|
} |
52
|
|
|
|
53
|
|
|
if($detail = sys_get_param_id('detail')) |
54
|
|
|
{ |
55
|
|
|
$template = SnTemplate::gettemplate('admin/adm_log_main_detail', true); |
|
|
|
|
56
|
|
|
|
57
|
|
|
$errorInfo = doquery("SELECT * FROM `{{logs}}` WHERE `log_id` = {$detail} LIMIT 1;", true); |
|
|
|
|
58
|
|
|
$error_dump = json_decode($errorInfo['log_dump'], true); |
59
|
|
|
if(is_array($error_dump)) |
60
|
|
|
{ |
61
|
|
|
foreach ($error_dump as $key => $value) |
62
|
|
|
{ |
63
|
|
|
// $v = [ |
64
|
|
|
// 'VAR_NAME' => $key, |
65
|
|
|
// 'VAR_VALUE' => $key == 'query_log' ? $value : var_export($value, true) |
66
|
|
|
// ]; |
67
|
|
|
|
68
|
|
|
$val = $key == 'query_log' ? $value : admLogRender($value); |
69
|
|
|
|
70
|
|
|
$template->assign_block_vars('vars', [ |
71
|
|
|
'VAR_NAME' => $key, |
72
|
|
|
'VAR_VALUE' => $val, |
73
|
|
|
]); |
74
|
|
|
} |
75
|
|
|
} |
76
|
|
|
$template->assign_vars($errorInfo); |
77
|
|
|
} |
78
|
|
|
else |
79
|
|
|
{ |
80
|
|
|
$template = SnTemplate::gettemplate('admin/adm_log_main', true); |
81
|
|
|
|
82
|
|
|
$i = 0; |
83
|
|
|
$query = doquery("SELECT * FROM `{{logs}}` ORDER BY log_id DESC LIMIT 100;"); |
|
|
|
|
84
|
|
|
while($u = db_fetch($query)) |
85
|
|
|
{ |
86
|
|
|
$i++; |
87
|
|
|
$v = array(); |
88
|
|
|
foreach($u as $key => $value) |
89
|
|
|
{ |
90
|
|
|
$v[strtoupper($key)] = $value; |
91
|
|
|
} |
92
|
|
|
$template->assign_block_vars('error', $v); |
93
|
|
|
} |
94
|
|
|
$query = doquery("SELECT COUNT(*) AS LOG_MESSAGES_TOTAL, {$i} AS LOG_MESSAGES_VISIBLE FROM `{{logs}}`;", true); |
|
|
|
|
95
|
|
|
|
96
|
|
|
$template->assign_vars($query); |
97
|
|
|
} |
98
|
|
|
|
99
|
|
|
SnTemplate::display($template, $lang['adm_er_ttle']); |
100
|
|
|
|