Ejemplo n.º 1
0
/**
 * 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;
}
Ejemplo n.º 2
0
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;
}