summaryrefslogtreecommitdiffstats
path: root/frontends/php/report2.php
diff options
context:
space:
mode:
authorartem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-12-07 13:31:08 +0000
committerartem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-12-07 13:31:08 +0000
commit28dbc3a637659c5ddf6f765d211bdf306ff16694 (patch)
tree7637492e5ae51067cf3fec432a93fa4478994b79 /frontends/php/report2.php
parentc3fe2c6239d8e04709e97ac288fb97b24b563fcd (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.php4
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);