diff options
Diffstat (limited to 'frontends/php/include')
| -rw-r--r-- | frontends/php/include/items.inc.php | 2 | ||||
| -rw-r--r-- | frontends/php/include/maps.inc.php | 2 | ||||
| -rw-r--r-- | frontends/php/include/screens.inc.php | 4 |
3 files changed, 4 insertions, 4 deletions
diff --git a/frontends/php/include/items.inc.php b/frontends/php/include/items.inc.php index 1e1f363c..10fec58c 100644 --- a/frontends/php/include/items.inc.php +++ b/frontends/php/include/items.inc.php @@ -808,7 +808,7 @@ $result &= DBexecute('delete from items_applications where itemid='.$itemid); $result &= DBexecute('delete from items where itemid='.$itemid); - $result &= DBexecute("DELETE FROM profiles WHERE idx='web.favorite.graphids' AND source='itemid' AND value='$itemid'"); + $result &= DBexecute("DELETE FROM profiles WHERE idx='web.favorite.graphids' AND source='itemid' AND value_id=$itemid"); if($result){ info("Item '".$host["host"].":".$item["key_"]."' deleted"); diff --git a/frontends/php/include/maps.inc.php b/frontends/php/include/maps.inc.php index 2aef1b6e..a06564df 100644 --- a/frontends/php/include/maps.inc.php +++ b/frontends/php/include/maps.inc.php @@ -194,7 +194,7 @@ } $result = DBexecute('DELETE FROM sysmaps_elements WHERE sysmapid='.$sysmapid); - $result &= DBexecute("DELETE FROM profiles WHERE idx='web.favorite.sysmapids' AND source='sysmapid' AND value='$sysmapid'"); + $result &= DBexecute("DELETE FROM profiles WHERE idx='web.favorite.sysmapids' AND source='sysmapid' AND value_id=$sysmapid"); $result &= DBexecute('DELETE FROM sysmaps WHERE sysmapid='.$sysmapid); return $result; diff --git a/frontends/php/include/screens.inc.php b/frontends/php/include/screens.inc.php index 6db521d6..5fa1419b 100644 --- a/frontends/php/include/screens.inc.php +++ b/frontends/php/include/screens.inc.php @@ -108,7 +108,7 @@ $result=DBexecute('DELETE FROM screens_items where screenid='.$screenid); $result&=DBexecute('DELETE FROM screens_items where resourceid='.$screenid.' and resourcetype='.SCREEN_RESOURCE_SCREEN); $result&=DBexecute('DELETE FROM slides where screenid='.$screenid); - $result&=DBexecute("DELETE FROM profiles WHERE idx='web.favorite.screenids' AND source='screenid' AND value='$screenid'"); + $result&=DBexecute("DELETE FROM profiles WHERE idx='web.favorite.screenids' AND source='screenid' AND value_id=$screenid"); $result&=DBexecute('DELETE FROM screens where screenid='.$screenid); return $result; } @@ -633,7 +633,7 @@ $result = DBexecute('DELETE FROM slideshows where slideshowid='.$slideshowid); $result &= DBexecute('DELETE FROM slides where slideshowid='.$slideshowid); - $result &= DBexecute("DELETE FROM profiles WHERE idx='web.favorite.screenids' AND source='slideshowid' AND value='$slideshowid'"); + $result &= DBexecute("DELETE FROM profiles WHERE idx='web.favorite.screenids' AND source='slideshowid' AND value_id=$slideshowid"); return $result; } |