Bug in function 'CHostsInfo'

[exkg]

Hi,


In 1.5.3 we have a bug in hosts status (include/classes/chostsinfo.mod.php), the hosts (avail,not avail and uncn) have a stranger count.



[]s,
Luciano

[exkg]

Bug in function 'CHostsInfo' (SOLVED)

Hi,


In function 'function BodyToString()' (around line 53) we have this:

===
$db_host_cnt = DBselect('SELECT COUNT(*) as cnt '.
' FROM hosts h, hosts_groups hg'.
' WHERE h.available='.HOST_AVAILABLE_TRUE.
' AND hg.groupid IN ('.$accessible_groups.') '.$cond);
===


We change:

===
$db_host_cnt = DBselect('SELECT COUNT(*) as cnt '.
' FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid = h.hostid'.
' WHERE h.available='.HOST_AVAILABLE_TRUE.
' AND hg.groupid IN ('.$accessible_groups.') '.$cond);
===

Its OK now.

Aly, what u think about put the 'hosts count total for group' in this display ? To managers know the total of servers in each group.




[]s,
Luciano

[Aly]

The fix is slightly different Putting a total value is OK, I'll commit it to svn in near future.