summaryrefslogtreecommitdiffstats
path: root/frontends/php/overview.php
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-01-31 16:09:35 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-01-31 16:09:35 +0000
commitd07f777ed2cf0103ed550166f9b0e783db064255 (patch)
treefb331ae19aff60bdf2cea11bd99e34a99f45bc1d /frontends/php/overview.php
parent78776cf62621df9e12f0b791753174e638440efe (diff)
downloadzabbix-d07f777ed2cf0103ed550166f9b0e783db064255.tar.gz
zabbix-d07f777ed2cf0103ed550166f9b0e783db064255.tar.xz
zabbix-d07f777ed2cf0103ed550166f9b0e783db064255.zip
Getting rid of addslashes.
git-svn-id: svn://svn.zabbix.com/trunk@2592 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/overview.php')
-rw-r--r--frontends/php/overview.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/frontends/php/overview.php b/frontends/php/overview.php
index 657405d2..25b5411d 100644
--- a/frontends/php/overview.php
+++ b/frontends/php/overview.php
@@ -224,14 +224,14 @@
$_REQUEST["sort"]="order by i.description";
}
// $sql="select distinct description from items order by 1;";
- $sql="select distinct t.description from hosts h,items i,hosts_groups hg,triggers t,functions f where h.status=".HOST_STATUS_MONITORED." and t.status=".TRIGGER_STATUS_ENABLED." and h.hostid=i.hostid and hg.groupid=".$_REQUEST["groupid"]." and hg.hostid=h.hostid and t.triggerid=f.triggerid and f.itemid=i.itemid order by 1";
+ $sql="select distinct t.description from hosts h,items i,hosts_groups hg,triggers t,functions f where h.status=".HOST_STATUS_MONITORED." and t.status=".TRIGGER_STATUS_ENABLED." and h.hostid=i.hostid and hg.groupid=".zbx_ads($_REQUEST["groupid"])." and hg.hostid=h.hostid and t.triggerid=f.triggerid and f.itemid=i.itemid order by 1";
$result=DBselect($sql);
while($row=DBfetch($result))
{
$rows=array(nbsp($row["description"]));
foreach($hosts as $hostid)
{
- $sql="select t.status,t.value,t.lastchange from triggers t,functions f,items i where f.triggerid=t.triggerid and i.itemid=f.itemid and t.status=".TRIGGER_STATUS_ENABLED." and i.hostid=$hostid and t.description='".addslashes($row["description"])."'";
+ $sql="select t.status,t.value,t.lastchange from triggers t,functions f,items i where f.triggerid=t.triggerid and i.itemid=f.itemid and t.status=".TRIGGER_STATUS_ENABLED." and i.hostid=".zbx_ads($hostid)." and t.description='".zbx_ads($row["description"])."'";
$result2=DBselect($sql);
if(DBnum_rows($result2)==1)
{