diff options
| author | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-04-02 13:48:25 +0000 |
|---|---|---|
| committer | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-04-02 13:48:25 +0000 |
| commit | e07100470bbd5fdf1f312fb9072c865866672f11 (patch) | |
| tree | 2c815260ecc141317dace9869f623ab60b5ca414 /frontends/php/charts.php | |
| parent | e0937bd47e12d1d9a9fb6503152d1acb331d2929 (diff) | |
| download | zabbix-e07100470bbd5fdf1f312fb9072c865866672f11.tar.gz zabbix-e07100470bbd5fdf1f312fb9072c865866672f11.tar.xz zabbix-e07100470bbd5fdf1f312fb9072c865866672f11.zip | |
- fixed select statement for PostgreSQL (Eugene)
git-svn-id: svn://svn.zabbix.com/trunk@3968 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/charts.php')
| -rw-r--r-- | frontends/php/charts.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/frontends/php/charts.php b/frontends/php/charts.php index cb6a199a..33725b73 100644 --- a/frontends/php/charts.php +++ b/frontends/php/charts.php @@ -100,13 +100,13 @@ include_once "include/page_header.php"; if($_REQUEST["graphid"] > 0) { - if(! ($row = DBfetch(DBselect(" select distinct g.name from hosts h, items i, graphs_items gi, graphs g ". + if(! ($row = DBfetch(DBselect(" select distinct h.host, g.name from hosts h, items i, graphs_items gi, graphs g ". " where h.status=".HOST_STATUS_MONITORED. " and h.hostid=i.hostid and g.graphid=".$_REQUEST["graphid"]. " and i.itemid=gi.itemid and gi.graphid=g.graphid". " and h.hostid not in (".$denyed_hosts.") ". " and ".DBid2nodeid("g.graphid")."=".$ZBX_CURNODEID. - " order by h.host" + " order by h.host, g.name" )))) { update_profile("web.charts.graphid",0); |