EVOLUTION-MANAGER

Edit File: function_snmp.php

<?php
/*
 * Copyright 2005-2016 OCSInventory-NG/OCSInventory-ocsreports contributors.
 * See the Contributors file for more details about them.
 *
 * This file is part of OCSInventory-NG/OCSInventory-ocsreports.
 *
 * OCSInventory-NG/OCSInventory-ocsreports is free software: you can redistribute
 * it and/or modify it under the terms of the GNU General Public License as
 * published by the Free Software Foundation, either version 2 of the License,
 * or (at your option) any later version.
 *
 * OCSInventory-NG/OCSInventory-ocsreports is distributed in the hope that it
 * will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty
 * of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with OCSInventory-NG/OCSInventory-ocsreports. if not, write to the
 * Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA 02110-1301, USA.
 */
$snmp_tables_type = array($l->g(1215) => 'SNMP_BLADES', $l->g(1216) => 'SNMP_FIREWALLS', $l->g(1217) => 'SNMP_LOADBALANCERS',
    $l->g(79) => 'SNMP_PRINTERS', $l->g(1218) => 'SNMP_SWITCHINFOS', $l->g(729) => 'SNMP_COMPUTERS');

$snmp_tables = array('SNMP_ACCOUNTINFO', 'SNMP_CARDS', 'SNMP_CARTRIDGES', 'SNMP_CPUS', 'SNMP_DRIVES',
    'SNMP_FANS', 'SNMP_INPUTS', 'SNMP_LOCALPRINTERS', 'SNMP_MEMORIES',
    'SNMP_MODEMS', 'SNMP_NETWORKS', 'SNMP_PORTS', 'SNMP_POWERSUPPLIES', 'SNMP_SOFTWARES',
    'SNMP_SOUNDS', 'SNMP_STORAGES', 'SNMP_SWITCHS', 'SNMP_TRAYS', 'SNMP_VIDEOS', 'SNMP_VIRTUALMACHINES');

$all_snmp_table = array_merge($snmp_tables_type, $snmp_tables);

//is ID exist?
function info_snmp($snmp_id) {
    global $l, $snmp_tables_type;
    if ($snmp_id == "" || !is_numeric($snmp_id)) {
        return $l->g(837);
    }

$sql = "select * from snmp where id=%s";
    $arg = $snmp_id;
    $result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"], $arg);
    $array['data']['snmp'] = mysqli_fetch_object($result);
    if ($array['data']['snmp']->ID == "") {
        return $l->g(837);
    } else {
        foreach ($snmp_tables_type as $lbl => $table) {
            $sql = "select * from %s where snmp_id=%s";
            $arg = array(strtolower($table), $snmp_id);
            $result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"], $arg);
            $array['data'][$table] = mysqli_fetch_object($result);
            if ($array['data'][$table] != '')
                $array['lbl'] = $lbl;
        }
        return $array;
    }
}

function subnet_name($systemid) {
    if (!is_numeric($systemid))
        return false;
    $reqSub = "select NAME,NETID from subnet left join networks on networks.ipsubnet = subnet.netid
				where  networks.status='Up' and hardware_id=" . $systemid;
    $resSub = mysqli_query($_SESSION['OCS']["readServer"], $reqSub) or die(mysqli_error($_SESSION['OCS']["readServer"]));
    while ($valSub = mysqli_fetch_object($resSub)) {

$returnVal[] = $valSub->NAME . "  (" . $valSub->NETID . ")";
    }
    return $returnVal;
}

function print_item_header($text) {
    echo "<table align=\"center\"  width='100%'  cellpadding='4'>";
    echo "<tr>";
    echo "<td align='center' width='100%'><b><font color='blue'>" . mb_strtoupper($text) . "</font></b></td>";
    echo "</tr>";
    echo "</table>";
}

if ($data_exist) {
        return $show_table;
    }
    return false;
}

$sql = 'delete from snmp where id in ';
    $del_sql = mysql2_prepare($sql, array(), $id_snmp, $nocot = true);
    mysql2_query_secure($del_sql['SQL'], $_SESSION['OCS']["writeServer"], $del_sql['ARG'], true);
}

/*
 * Find all accountinfo for
 * snmp data
 */

$res_account_data = mysql2_query_secure($sql_account_data, $_SESSION['OCS']["readServer"], $arg_account_data);
    $val_account_data = mysqli_fetch_array($res_account_data);
    return $val_account_data;
}

array_push($arg_account_data, $id);
    mysql2_query_secure($sql_account_data, $_SESSION['OCS']["writeServer"], $arg_account_data);
    return $l->g(1121);
}