florian030
2014-02-18 e0f619c9dc5ee4b1c484a5eab62ba341a4e240a0
Revert "add domain and username to db-size-monitoring"

This reverts commit b125fabc24d1236dda389b451650c1deb1e8883a.
2 files modified
14 ■■■■ changed files
interface/lib/classes/tools_monitor.inc.php 12 ●●●● patch | view | raw | blame | history
server/lib/classes/cron.d/100-monitor_database_size.inc.php 2 ●●● patch | view | raw | blame | history
interface/lib/classes/tools_monitor.inc.php
@@ -124,7 +124,9 @@
        $record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'database_size' and server_id = " . $_SESSION['monitor']['server_id'] . " order by created desc");
        if(isset($record['data'])) {
            $data = unserialize($record['data']);
            //* format the data
            /*
                Format the data
                */
            $html =
                '<div class="systemmonitor-state state-'.$record['state'].'">
                    <div class="systemmonitor-content icons32 ico-'.$record['state'].'">
@@ -134,15 +136,13 @@
                    <td>'.$app->lng("monitor_database_name_txt").'</td>
                    <td>'.$app->lng("monitor_database_size_txt").'</td>
                    <td>'.$app->lng("monitor_database_client_txt").'</td>
                    <td>'.$app->lng("monitor_database_domain_txt").'</td>
                    </tr>';
            foreach($data as $line) {
                $html .= '<tr>';
                if ($line['size'] > 0) $line['size'] = $app->functions->formatBytes($line['size']);
                //* get the username
                $line['sys_groupid']=$app->db->queryOneRecord("SELECT client.username FROM web_database, sys_group, client WHERE web_database.sys_groupid = sys_group.groupid AND sys_group.client_id = client.client_id AND web_database.database_name='".$line['name']."'")['username'];
                //* get the domain
                $line['domain']=$app->db->queryOneRecord("SELECT domain FROM web_domain WHERE domain_id=(SELECT parent_domain_id FROM web_database WHERE database_name='".$line['name']."')")['domain'];
                $t=$app->db->queryOneRecord("SELECT username FROM client WHERE sys_groupid = ".$line['client_id']);
                $line['client_id']=$t['username'];
                unset($t);
                foreach ($line as $item) {
                    $html .= '<td>' . $item . '</td>';
                }
server/lib/classes/cron.d/100-monitor_database_size.inc.php
@@ -84,7 +84,7 @@
            for ($i = 0; $i < sizeof($records); $i++) {
                $data[$i]['name'] = $records[$i]['database_name'];
                $data[$i]['size'] = $app->db->getDatabaseSize($data[$i]['name']);
                $data[$i]['sys_groupid'] = $records[$i]['sys_groupid'];
                $data[$i]['client_id'] = $records[$i]['sys_groupid'];
            }
        }