lotgd/debug.php at master · NB-Core/lotgd · GitHub

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
<?php

declare(strict_types=1);

use Lotgd\MySQL\Database;
use Lotgd\Translator;
use Lotgd\SuAccess;
use Lotgd\Nav\SuperuserNav;
use Lotgd\Nav;
use Lotgd\Page\Header;
use Lotgd\Page\Footer;
use Lotgd\Http;

// translator ready
// addnews ready
// mail ready
use Lotgd\Output;

require_once __DIR__ . "/common.php";

$output = Output::getInstance();

Translator::getInstance()->setSchema("debug");

SuAccess::check(SU_EDIT_CONFIG);

SuperuserNav::render();
Nav::add("Debug Options");
Nav::add("", $_SERVER['REQUEST_URI']);
$sort = Http::get('sort');
if ($sort === false) {
    $sort = '';
}
Nav::add("Get Pageruntimes", "debug.php?debug=pageruntime&sort=" . URLEncode($sort));
Nav::add("Get Modulehooktimes", "debug.php?debug=hooksort&sort=" . URLEncode($sort));


Header::pageHeader("Debug Analysis");
$order = "sum";
if ($sort != "") {
    $order = $sort;
}
$debug = Http::get('debug');
if ($debug == '') {
    $debug = 'pageruntime';
}
$ascdesc_raw = (int)Http::get('direction');
if ($ascdesc_raw) {
    $ascdesc = "ASC";
} else {
    $ascdesc = "DESC";
}
Nav::add("Sorting");
Nav::add("By Total", "debug.php?debug=" . $debug . "&sort=sum&direction=" . $ascdesc_raw);
Nav::add("By Average", "debug.php?debug=" . $debug . "&sort=medium&direction=" . $ascdesc_raw);
Nav::add("Switch ASC/DESC", "debug.php?debug=" . $debug . "&sort=" . URLEncode($sort) . "&direction=" . (!$ascdesc_raw));


switch ($debug) {
    case "hooksort":
        $sql = "SELECT
					category,
					subcategory,
					SUM(value + 0) AS sum,
					AVG(value + 0) AS medium,
					COUNT(id) AS counter
				FROM
					`" . Database::prefix('debug') . "`
				WHERE
					type = 'hooktime'
				GROUP BY
					category, subcategory
				ORDER BY
					$order $ascdesc
				LIMIT 30;
				";
        $category = Translator::translate("Setting");
        $subcategory = Translator::translate("Module Name");
        $sum_desc = Translator::translate("Total Seconds");
        $med_desc = Translator::translate("Average per Hit");
        $hits = Translator::translate("Hits");
        break;

    case "pageruntime":
    default:
        $sql = "SELECT
				type,
				category,
				subcategory,
				SUM(value + 0) AS sum,
				AVG(value + 0) AS medium,
				COUNT(id) AS counter
			FROM " . Database::prefix('debug') . "
			WHERE type = 'pagegentime'
			GROUP BY type, category, subcategory
			ORDER BY $order $ascdesc
			LIMIT 30";

        $category = Translator::translate("Setting");
        $subcategory = Translator::translate("Module Name");
        $sum_desc = Translator::translate("Total Seconds");
        $med_desc = Translator::translate("Average per Hit");
        $hits = Translator::translate("Hits");
}
$none = Translator::translate("`iNone`i");
$notset = Translator::translate("`iNot set`i");
$output->rawOutput("<table border=0 cellpadding=2 cellspacing=1><tr class='trhead'><td>$category</td><td>$subcategory</td><td>$sum_desc</td><td>$med_desc</td><td>$hits</td></tr>");
debug($sql);
$result = Database::query($sql);
$i = true;
while ($row = Database::fetchAssoc($result)) {
    $i = !$i;
    $output->rawOutput("<tr class='" . ($i ? 'trdark' : 'trlight') . "'><td valign='top'>");
    $output->outputNotl("`b" . $row['category'] . "`b");
    $output->rawOutput("</td><td valign='top'>");
    $output->outputNotl("`b" . $row['subcategory'] . "`b");
    $output->rawOutput("</td><td valign='top'>");
    $output->outputNotl($row['sum']);
    $output->rawOutput("</td><td valign='top'>");
    $output->outputNotl($row['medium']);
    $output->rawOutput("</td><td valign='top'>");
    $output->outputNotl($row['counter']);
    $output->rawOutput("</td></tr>");
}
$output->rawOutput("</table>");
Footer::pageFooter();