summaryrefslogtreecommitdiffstats
path: root/frontends/php/include
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-23 12:41:07 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-23 12:41:07 +0000
commit81dfe4b7f787e20eb47a0417007dcb453c6f8381 (patch)
tree488fbb30b8f86c0b69c92390846701894819caf1 /frontends/php/include
parent76804392e7ba2ee49bea0aef1f86025b7126a551 (diff)
downloadzabbix-81dfe4b7f787e20eb47a0417007dcb453c6f8381.tar.gz
zabbix-81dfe4b7f787e20eb47a0417007dcb453c6f8381.tar.xz
zabbix-81dfe4b7f787e20eb47a0417007dcb453c6f8381.zip
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@2881 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include')
-rw-r--r--frontends/php/include/hosts.inc.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/frontends/php/include/hosts.inc.php b/frontends/php/include/hosts.inc.php
index 3a4496eb..2a3f9838 100644
--- a/frontends/php/include/hosts.inc.php
+++ b/frontends/php/include/hosts.inc.php
@@ -443,10 +443,10 @@
if($groupid > 0)
{
// Check if at least one host with read permission exists for this group
- $sql = "select h.hostid,h.host from hosts h,hosts_groups hg".$item_table.
+ $sql = "select distinct h.hostid,h.host from hosts h,hosts_groups hg".$item_table.
" where hg.groupid=".$groupid." and hg.hostid=h.hostid and".
" h.status<>".HOST_STATUS_DELETED.$with_host_status.$with_items.
- " group by h.hostid order by h.host";
+ " order by h.host";
$db_hosts = DBselect($sql);
while($db_host = DBfetch($db_hosts))