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/include/graphs.inc.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'frontends/php/include/graphs.inc.php') diff --git a/frontends/php/include/graphs.inc.php b/frontends/php/include/graphs.inc.php index 9c5867ac..f4574efe 100644 --- a/frontends/php/include/graphs.inc.php +++ b/frontends/php/include/graphs.inc.php @@ -168,7 +168,7 @@ $available_hosts = get_accessible_hosts_by_user($USER_DETAILS, PERM_READ_ONLY); $sql = 'SELECT g.graphid '. - ' FROM graphs as g, graphs_items as gi, items as i '. + ' FROM graphs g, graphs_items gi, items i '. ' WHERE g.graphid='.$graphid. ' AND g.graphid=gi.graphid '. ' AND i.itemid=gi.itemid '. @@ -203,7 +203,7 @@ $result = array(); $sql = 'SELECT DISTINCT g.graphid '. - ' FROM graphs as g, graphs_items as gi, items as i '. + ' FROM graphs g, graphs_items gi, items i '. ' WHERE g.graphid=gi.graphid '. (!empty($hostid)?' AND i.hostid='.$hostid:''). ' AND i.itemid=gi.itemid '. @@ -215,7 +215,7 @@ } $sql = 'SELECT DISTINCT g.graphid '. - ' FROM graphs as g, graphs_items as gi, items as i '. + ' FROM graphs g, graphs_items gi, items i '. ' WHERE g.graphid=gi.graphid '. (!empty($hostid)?' AND i.hostid='.$hostid:''). ' AND i.itemid=gi.itemid '. -- cgit