From 4cc5418ee4dc6041dd14581d87b416eed5989eb7 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sat, 28 Aug 2004 07:34:06 +0000
Subject: Threading and misc changes.

git-svn-id: svn://svn.zabbix.com/trunk@1414 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 frontends/php/items.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'frontends/php/items.php')

diff --git a/frontends/php/items.php b/frontends/php/items.php
index 91b6a41f..50112896 100644
--- a/frontends/php/items.php
+++ b/frontends/php/items.php
@@ -149,7 +149,7 @@
 	while($row=DBfetch($result))
 	{
 // Check if at least one host with read permission exists for this group
-		$result2=DBselect("select h.hostid,h.host from hosts h,items i,hosts_groups hg where h.status in (0,2) and h.hostid=i.hostid and hg.groupid=".$row["groupid"]." and hg.hostid=h.hostid group by h.hostid,h.host order by h.host");
+		$result2=DBselect("select h.hostid,h.host from hosts h,hosts_groups hg where h.status in (0,2) and hg.groupid=".$row["groupid"]." and hg.hostid=h.hostid group by h.hostid,h.host order by h.host");
 		$cnt=0;
 		while($row2=DBfetch($result2))
 		{
@@ -170,8 +170,8 @@
 	echo "<select class=\"biginput\" name=\"hostid\" onChange=\"submit()\">";
 
 	$sql=iif(isset($_GET["groupid"]),
-		"select h.hostid,h.host from hosts h,items i,hosts_groups hg where h.status in (0,2) and h.hostid=i.hostid and hg.groupid=".$_GET["groupid"]." and hg.hostid=h.hostid group by h.hostid,h.host order by h.host",
-		"select h.hostid,h.host from hosts h,items i where h.status in (0,2) and h.hostid=i.hostid group by h.hostid,h.host order by h.host");
+		"select h.hostid,h.host from hosts h,hosts_groups hg where h.status in (0,2) and hg.groupid=".$_GET["groupid"]." and hg.hostid=h.hostid group by h.hostid,h.host order by h.host",
+		"select h.hostid,h.host from hosts h where h.status in (0,2) group by h.hostid,h.host order by h.host");
 
 	$result=DBselect($sql);
 	while($row=DBfetch($result))
-- 
cgit