remove sys_groupid from output

florian030

2014-02-18 bc1e70a3912f82aa1617ad93d983ff0ba653fb6a

remove sys_groupid from output

 interface/lib/classes/tools_monitor.inc.php

@@ -139,8 +139,8 @@
            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'];
                //* remove sys_groupid from output
                unset($line['sys_groupid']);
                //* 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'];
                foreach ($line as $item) {