/** * Clear items history and trends. * * @param $itemIds * * @return bool */ function delete_history_by_itemid($itemIds) { zbx_value2array($itemIds); $result = delete_trends_by_itemid($itemIds); if (!$result) { return $result; } DBexecute('DELETE FROM history_text WHERE ' . dbConditionInt('itemid', $itemIds)); DBexecute('DELETE FROM history_log WHERE ' . dbConditionInt('itemid', $itemIds)); DBexecute('DELETE FROM history_uint WHERE ' . dbConditionInt('itemid', $itemIds)); DBexecute('DELETE FROM history_str WHERE ' . dbConditionInt('itemid', $itemIds)); DBexecute('DELETE FROM history WHERE ' . dbConditionInt('itemid', $itemIds)); return true; }
function delete_history_by_itemid($itemids, $use_housekeeper = 0) { zbx_value2array($itemids); $result = delete_trends_by_itemid($itemids, $use_housekeeper); if (!$result) { return $result; } if ($use_housekeeper) { foreach ($itemids as $id => $itemid) { $housekeeperid = get_dbid('housekeeper', 'housekeeperid'); $sql = 'INSERT INTO housekeeper (housekeeperid,tablename,field,value)' . " VALUES ({$housekeeperid},'history_text','itemid',{$itemid})"; DBexecute($sql); $housekeeperid = get_dbid('housekeeper', 'housekeeperid'); $sql = 'INSERT INTO housekeeper (housekeeperid,tablename,field,value)' . " VALUES ({$housekeeperid},'history_log','itemid',{$itemid})"; DBexecute($sql); $housekeeperid = get_dbid('housekeeper', 'housekeeperid'); $sql = 'INSERT INTO housekeeper (housekeeperid,tablename,field,value)' . " VALUES ({$housekeeperid},'history_uint','itemid',{$itemid})"; DBexecute($sql); $housekeeperid = get_dbid('housekeeper', 'housekeeperid'); $sql = 'INSERT INTO housekeeper (housekeeperid,tablename,field,value)' . " VALUES ({$housekeeperid},'history_str','itemid',{$itemid})"; DBexecute($sql); $housekeeperid = get_dbid('housekeeper', 'housekeeperid'); $sql = 'INSERT INTO housekeeper (housekeeperid,tablename,field,value)' . " VALUES ({$housekeeperid},'history','itemid',{$itemid})"; DBexecute($sql); } return TRUE; } DBexecute('DELETE FROM history_text WHERE ' . DBcondition('itemid', $itemids)); DBexecute('DELETE FROM history_log WHERE ' . DBcondition('itemid', $itemids)); DBexecute('DELETE FROM history_uint WHERE ' . DBcondition('itemid', $itemids)); DBexecute('DELETE FROM history_str WHERE ' . DBcondition('itemid', $itemids)); DBexecute('DELETE FROM history WHERE ' . DBcondition('itemid', $itemids)); return TRUE; }