diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-05-24 11:06:12 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-05-24 11:06:12 +0000 |
| commit | 677d4bfec7d7856e392ba7019e2679357407b083 (patch) | |
| tree | ead1850d32737e93b85409c46f0756500df5a445 /frontends/php/include/services.inc.php | |
| parent | 5a52eda5e955812145bfb53aaebf1d88e1e19d3d (diff) | |
| download | zabbix-677d4bfec7d7856e392ba7019e2679357407b083.tar.gz zabbix-677d4bfec7d7856e392ba7019e2679357407b083.tar.xz zabbix-677d4bfec7d7856e392ba7019e2679357407b083.zip | |
Fixed times update
git-svn-id: svn://svn.zabbix.com/trunk@4170 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/services.inc.php')
| -rw-r--r-- | frontends/php/include/services.inc.php | 27 |
1 files changed, 19 insertions, 8 deletions
diff --git a/frontends/php/include/services.inc.php b/frontends/php/include/services.inc.php index 0310dc07..6d671dd5 100644 --- a/frontends/php/include/services.inc.php +++ b/frontends/php/include/services.inc.php @@ -31,11 +31,12 @@ { return FALSE; } + DBExecute('DELETE FROM services_times WHERE serviceid='.$serviceid); - foreach($service_times as $val) - { - $result = DBexecute('insert into services_times (serviceid, type, ts_from, ts_to, note)'. - ' values ('.$serviceid.','.$val['type'].','.$val['from'].','.$val['to'].','.zbx_dbstr($val['note']).')'); + foreach($service_times as $val){ + $timeid = get_dbid('services_times','timeid'); + $result = DBexecute('insert into services_times (timeid, serviceid, type, ts_from, ts_to, note)'. + ' values ('.$timeid.','.$serviceid.','.$val['type'].','.$val['from'].','.$val['to'].','.zbx_dbstr($val['note']).')'); if(!$result) { @@ -53,10 +54,10 @@ $result = DBexecute("update services set name=".zbx_dbstr($name).",triggerid=$triggerid,status=0,algorithm=$algorithm,showsla=$showsla,goodsla=$goodsla,sortorder=$sortorder where serviceid=$serviceid"); DBexecute('delete from services_times where serviceid='.$serviceid); - foreach($service_times as $val) - { - DBexecute('insert into services_times (serviceid, type, ts_from, ts_to, note)'. - ' values ('.$serviceid.','.$val['type'].','.$val['from'].','.$val['to'].','.zbx_dbstr($val['note']).')'); + foreach($service_times as $val){ + $timeid = get_dbid('services_times','timeid'); + DBexecute('insert into services_times (timeid,serviceid, type, ts_from, ts_to, note)'. + ' values ('.$timeid.','.$serviceid.','.$val['type'].','.$val['from'].','.$val['to'].','.zbx_dbstr($val['note']).')'); } return $result; @@ -514,4 +515,14 @@ $dt = 0; } return S_UNKNOWN; } + + function get_service_childs($serviceid,&$childs,$soft=0){ + $query = 'SELECT sl.servicedownid FROM services_links sl WHERE sl.serviceupid = '.$serviceid.(($soft == 1)?(''):(' AND sl.soft <> 1')); + + $res = DBSelect($query); + while($row = DBFetch($res)){ + $childs[] = $row['servicedownid']; + get_service_childs($row['servicedownid'],$childs); + } + } ?> |