From 85851254e17a3ff0c2d1f37748e9c09c77eb5f58 Mon Sep 17 00:00:00 2001
From: florian030 <florian@schaal-24.de>
Date: Tue, 18 Feb 2014 02:12:06 -0500
Subject: [PATCH] added username to make the monitor-data usable for db-quota-checks
---
server/lib/classes/cron.d/100-monitor_database_size.inc.php | 1 +
1 files changed, 1 insertions(+), 0 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 81d1490..2cd78d1 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
@@ -85,6 +85,7 @@
$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]['username'] = $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='".$data[$i]['name']."'")['username'];
}
}
--
Gitblit v1.9.1