diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-12-07 13:31:08 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-12-07 13:31:08 +0000 |
| commit | 28dbc3a637659c5ddf6f765d211bdf306ff16694 (patch) | |
| tree | 7637492e5ae51067cf3fec432a93fa4478994b79 /frontends/php/report2.php | |
| parent | c3fe2c6239d8e04709e97ac288fb97b24b563fcd (diff) | |
- [DEV-59] sql improvement (Artem)
git-svn-id: svn://svn.zabbix.com/trunk@5146 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/report2.php')
| -rw-r--r-- | frontends/php/report2.php | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/frontends/php/report2.php b/frontends/php/report2.php index 67beba37..20ff8778 100644 --- a/frontends/php/report2.php +++ b/frontends/php/report2.php @@ -117,7 +117,6 @@ show_report2_header($config,$available_hosts); else show_table_header(S_ALL_HOSTS_BIG); - $result = DBselect('SELECT DISTINCT h.hostid,h.host,t.triggerid,t.expression,t.description,t.value '. ' FROM triggers t,hosts h,items i,functions f '. ' WHERE f.itemid=i.itemid '. @@ -136,8 +135,7 @@ show_report2_header($config,$available_hosts); $table = new CTableInfo(); $table->setHeader(array(is_show_subnodes() ? S_NODE : null,($_REQUEST['hostid'] == 0)?S_HOST:NULL, S_NAME,S_TRUE,S_FALSE,S_UNKNOWN,S_GRAPH)); while($row=DBfetch($result)){ - if(!check_right_on_trigger_by_triggerid(null, $row['triggerid'], $accessible_hosts)) - continue; + if(!check_right_on_trigger_by_triggerid(null, $row['triggerid'], $accessible_hosts)) continue; $availability = calculate_availability($row['triggerid'],0,0); |
