From 5ea1687a67685fe34875967075bbd422b2d0137a Mon Sep 17 00:00:00 2001 From: artem Date: Mon, 19 May 2008 07:35:06 +0000 Subject: -[DEV-137] fixes for oracle (Artem) -[HAN-4] selects first host-group in overview screen (Artem) git-svn-id: svn://svn.zabbix.com/trunk@5707 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/chart6.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'frontends/php/chart6.php') diff --git a/frontends/php/chart6.php b/frontends/php/chart6.php index c5abf5f3..a3f7e0f7 100644 --- a/frontends/php/chart6.php +++ b/frontends/php/chart6.php @@ -58,10 +58,10 @@ include_once "include/page_header.php"; } $sql = 'SELECT g.*,h.host,h.hostid '. - ' FROM graphs as g '. - ' LEFT JOIN graphs_items as gi ON g.graphid=gi.graphid '. - ' LEFT JOIN items as i ON gi.itemid=i.itemid '. - ' LEFT JOIN hosts as h ON i.hostid=h.hostid '. + ' FROM graphs g '. + ' LEFT JOIN graphs_items gi ON g.graphid=gi.graphid '. + ' LEFT JOIN items i ON gi.itemid=i.itemid '. + ' LEFT JOIN hosts h ON i.hostid=h.hostid '. ' WHERE g.graphid='.$_REQUEST['graphid']. ' AND h.hostid IN ('.$available_hosts.') '; -- cgit