From 232684261dc25c783e3b456b91bf45766caa27be Mon Sep 17 00:00:00 2001
From: Florian Schaal <florian@schaal-24.de>
Date: Fri, 01 Nov 2013 11:02:13 -0400
Subject: [PATCH] set database order in monitor
---
server/lib/classes/cron.d/100-monitor_database_size.inc.php | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/server/lib/classes/cron.d/100-monitor_database_size.inc.php b/server/lib/classes/cron.d/100-monitor_database_size.inc.php
index 4a248ad..25d2cba 100644
--- a/server/lib/classes/cron.d/100-monitor_database_size.inc.php
+++ b/server/lib/classes/cron.d/100-monitor_database_size.inc.php
@@ -72,8 +72,8 @@
/** The state of the database-usage */
$state = 'ok';
- /** Fetch the data of ALL databases into an array */
- $records = $app->db->queryAllRecords("SELECT database_name, sys_groupid FROM web_database WHERE server_id = $server_id");
+ /** Fetch the data of all active databases into an array */
+ $records = $app->db->queryAllRecords("SELECT database_name, sys_groupid FROM web_database WHERE server_id = $server_id AND active='y' GROUP BY sys_groupid, database_name ASC");
if(is_array($records) && !empty($records)) {
$data = array();
for ($i = 0; $i < sizeof($records); $i++) {
--
Gitblit v1.9.1