function look_config_default_values($field_name, $like = '', $default_values = '')
{
if ($like == '') {
$sql = "select NAME,IVALUE,TVALUE,COMMENTS from config where NAME in ";
$arg_sql = array();
$arg = mysql2_prepare($sql, $arg_sql, $field_name);
} else {
$arg['SQL'] = "select NAME,IVALUE,TVALUE,COMMENTS from config where NAME like '%s'";
$arg['ARG'] = $field_name;
}
$resdefaultvalues = mysql2_query_secure($arg['SQL'], $_SESSION['OCS']["readServer"], $arg['ARG']);
while ($item = mysqli_fetch_object($resdefaultvalues)) {
$result['name'][$item->NAME] = $item->NAME;
$result['ivalue'][$item->NAME] = $item->IVALUE;
$result['tvalue'][$item->NAME] = $item->TVALUE;
$result['comments'][$item->NAME] = $item->COMMENTS;
}
if (is_array($default_values)) {
foreach ($default_values as $key => $value) {
$key = strtolower($key);
if (is_array($value)) {
foreach ($value as $name => $val) {
if (!isset($result[$key][$name]) or $result[$key][$name] == '') {
$result[$key][$name] = $val;
}
}
}
}
}
return $result;
}
function delete_list_user($list_to_delete)
{
$table = array('tags' => 'login', 'operators' => 'id');
foreach ($table as $table_name => $field) {
$arg_sql = array($table_name, $field);
$sql_delete = "delete from %s where %s in ";
$sql_delete = mysql2_prepare($sql_delete, $arg_sql, $list_to_delete);
mysql2_query_secure($sql_delete['SQL'], $_SESSION['OCS']["writeServer"], $sql_delete['ARG']);
}
}
function erase($NAME)
{
global $protectedPost, $protectedGet, $list_hardware_id, $tab_hadware_id;
// if it's for group or a machine
if (isset($list_hardware_id)) {
$sql = "DELETE FROM devices WHERE name='%s' AND hardware_id='%s'";
$arg = array($NAME, $protectedGet["idchecked"]);
mysql2_query_secure($sql, $_SESSION['OCS']["writeServer"], $arg);
} else {
//else : request
$sql = "DELETE FROM devices WHERE name='%s' AND hardware_id in ";
$arg_sql = array($NAME);
$arg = mysql2_prepare($sql, $arg_sql, $tab_hadware_id);
mysql2_query_secure($arg['SQL'], $_SESSION['OCS']["writeServer"], $arg['ARG']);
}
}
$list_col_cant_del = array('NAME' => 'NAME', 'CHECK' => 'CHECK', $l->g(35));
$default_fields2 = array($l->g(95) => $l->g(95), $l->g(36) => $l->g(36), $l->g(23) . ": " . $l->g(46) => $l->g(23) . ": " . $l->g(46), $l->g(23) . ": " . $l->g(34) => $l->g(23) . ": " . $l->g(34));
$default_fields = array_merge($default_fields, $default_fields2);
if ($_SESSION['OCS']['profile']->getConfigValue('DELETE_COMPUTERS') == "YES") {
$list_fields['SUP'] = 'h.ID';
$list_col_cant_del['SUP'] = 'SUP';
}
$sql = prepare_sql_tab($list_fields, array('SUP', 'CHECK'));
$sql['SQL'] .= " from hardware h left join accountinfo a on h.id=a.hardware_id ";
$sql['SQL'] .= ",bios b, ";
$sql['SQL'] .= " networks n where h.id=n.hardware_id ";
$sql['SQL'] .= " and h.id=b.hardware_id and h.id in ";
$sql = mysql2_prepare($sql['SQL'], $sql['ARG'], $list_id[$protectedPost['detail']]);
if (($protectedPost['detail'] == "macaddress" or $protectedPost['detail'] == "macaddress_serial") and count($list_info) > 0) {
$sql['SQL'] .= " and n.macaddr in ";
$sql = mysql2_prepare($sql['SQL'], $sql['ARG'], $list_info[$protectedPost['detail']]);
}
$sql['SQL'] .= " group by h.id ";
$tab_options['ARG_SQL'] = $sql['ARG'];
$tab_options['FILTRE'] = array('NAME' => $l->g(35), 'b.ssn' => $l->g(36), 'n.macaddr' => $l->g(95));
$tab_options['LBL_POPUP']['SUP'] = 'NAME';
$tab_options['LBL']['SUP'] = $l->g(122);
$result_exist = ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del);
if ($result_exist != "" and $_SESSION['OCS']['profile']->getConfigValue('DELETE_COMPUTERS') == "YES") {
echo "<a href=# OnClick='confirme(\"\",\"DEL_SEL\",\"" . $form_name . "\",\"DEL_ALL\",\"" . $l->g(900) . "\");'><img src='image/delete.png' title='Supprimer' ></a>";
echo "<input type='hidden' id='DEL_ALL' name='DEL_ALL' value=''>";
}
echo "<p><input type='submit' value='" . $l->g(177) . "' name='FUSION'></p>";
echo "<input type=hidden name=old_detail id=old_detail value='" . $protectedPost['detail'] . "'>";
}
echo close_form();
function active_option($name, $list_id, $packid, $tvalue = '')
{
global $l;
desactive_option($name, $list_id, $packid);
$sql_active = "insert into devices (HARDWARE_ID, NAME, IVALUE,TVALUE) select ID,'%s','%s',";
if ($tvalue == '') {
$sql_active .= "null from hardware where id in ";
$arg_active = array($name, $packid);
} else {
$sql_active .= "'%s' from hardware where id in ";
$arg_active = array($name, $packid, $tvalue);
}
//$lbl_log=$l->g(601)." ".$id_pack." => ".$list_id;
$sql = mysql2_prepare($sql_active, $arg_active, $list_id);
$res_active = mysql2_query_secure($sql['SQL'], $_SESSION['OCS']["writeServer"], $sql['ARG'], $l->g(512));
return mysqli_affected_rows($_SESSION['OCS']["writeServer"]);
}
//this name is already exist
if ($val_verif['c'] > 0) {
$ERROR = $l->g(1067);
}
} else {
//name can't be null
$ERROR = $l->g(1068);
}
//can not contain special characters
if (preg_match('/[^0-9A-Za-z]/', $protectedPost['newfield']) and isset($protectedGet['admin'])) {
$ERROR .= $l->g(1178) . ' : <i>' . $l->g(1070) . "</i> " . $l->g(1179) . " <br>";
}
if (!isset($ERROR)) {
$sql_insert = "insert into " . $table . " (" . $fields . ") VALUES ";
$arg_sql = array();
$insert = mysql2_prepare($sql_insert, $arg_sql, $array_values);
mysql2_query_secure($insert['SQL'], $_SESSION['OCS']["writeServer"], $insert['ARG']);
// mysql_query( "INSERT INTO ".$table." (".$fields.") VALUES('".$values."')", $_SESSION['OCS']["writeServer"]) or mysql_error($_SESSION['OCS']["writeServer"]);
//If we add a field, you must add a new colonm in downloadwk_pack table
if ($table == "downloadwk_fields") {
$id = mysql_insert_id($_SESSION['OCS']["writeServer"]);
if (is_numeric($id)) {
if ($protectedPost["newtype"] == 1) {
$type = "LONGTEXT";
} elseif ($protectedPost["newtype"] == 8) {
$type = "BLOB";
} else {
$type = "VARCHAR(255)";
}
$sql_add_column = "ALTER TABLE downloadwk_pack ADD COLUMN fields_" . $id . " " . $type . " default NULL";
mysql2_query_secure($sql_add_column, $_SESSION['OCS']["writeServer"]);
$and_where = "";
if (isset($_SESSION['OCS']['USE_NEW_SOFT_TABLES']) and $_SESSION['OCS']['USE_NEW_SOFT_TABLES'] == 1) {
$sql_re['SQL'] = "select " . $info_name_soft['table'] . ".name , \n\t\t\t\t\t\t\tcount(s." . $info_name_soft['field_name_soft'] . ") nb, \n\t\t\t\t\t\t\ts." . $info_name_soft['field_name_soft'] . " id \n\t\t\t\t\t\tfrom softwares s \n\t\t\t\t\t\t\tleft join " . $info_name_soft['table'] . " \n\t\t\t\t\t\t\ton " . $info_name_soft['table'] . ".id=s." . $info_name_soft['field_name_soft'] . " ";
} else {
$sql_re['SQL'] = "select s." . $info_name_soft['field_name_soft'] . " , \n\t\t\t\t\t\tcount(s." . $info_name_soft['field_name_soft'] . ") nb, \n\t\t\t\t\t\ts." . $info_name_soft['field_name_soft'] . " id from softwares s ";
}
if (isset($_SESSION['OCS']["mesmachines"]) and $_SESSION['OCS']["mesmachines"] != '') {
$sql_re['SQL'] .= ",accountinfo a where " . $_SESSION['OCS']["mesmachines"] . " and a.hardware_id=s.HARDWARE_ID";
$and_where = " and ";
} else {
$and_where = " where ";
}
//$_SESSION['OCS']["forcedRequest"]=$sql['SQL'].$and_where." name in (".$forcedRequest.")";
$sql_re['SQL'] .= $and_where . " s." . $info_name_soft['field_name_soft'] . " in ";
$sql_re['ARG'] = array();
$sql = mysql2_prepare($sql_re['SQL'], $sql_re['ARG'], $list_soft);
//$sql['ARG']=('".implode("','",$list_soft)."')";
//$sql.=$fin_sql;
} elseif (!isset($list_soft)) {
$and_where = "";
$sql['SQL'] = "select " . $info_name_soft['table'] . "." . $info_name_soft['field'] . ", count(s." . $info_name_soft['field_name_soft'] . ") nb,\n\t\t\t\t\t s." . $info_name_soft['field_name_soft'] . " id from softwares s";
if (isset($_SESSION['OCS']['USE_NEW_SOFT_TABLES']) and $_SESSION['OCS']['USE_NEW_SOFT_TABLES'] == 1) {
$sql['SQL'] .= " left join " . $info_name_soft['table'] . " on " . $info_name_soft['table'] . ".id=s." . $info_name_soft['field_name_soft'] . " ";
}
$sql['ARG'] = array();
if (isset($_SESSION['OCS']["mesmachines"]) and $_SESSION['OCS']["mesmachines"] != '') {
$sql['SQL'] .= ",accountinfo a where " . $_SESSION['OCS']["mesmachines"] . " and a.hardware_id=s.HARDWARE_ID";
$and_where = " and ";
} else {
$and_where = " where ";
}
function id_without_idgroups($list_id)
{
$sql = "select id from hardware where deviceid <> '_SYSTEMGROUP_' \n\t\t\t\t\t\t\t\t\t\tAND deviceid <> '_DOWNLOADGROUP_' \n\t\t\t\t\t\t\t\t\t\tAND id in ";
$arg = array();
$sql = mysql2_prepare($sql, $arg, $list_id);
$result = mysql2_query_secure($sql['SQL'], $_SESSION['OCS']["readServer"], $sql['ARG']);
while ($item = mysqli_fetch_object($result)) {
$res[$item->id] = $item->id;
}
return $res;
}
echo $l->g(562) . " " . show_modif($list_index, 'DPT_CHOISE', 2, $form_name, array('DEFAULT' => "NO"));
} else {
msg_info(mb_strtoupper($l->g(1134)));
}
if (isset($protectedPost['DPT_CHOISE']) and $protectedPost['DPT_CHOISE'] != '0') {
$array_rsx = find_all_subnet($dpt[$protectedPost['DPT_CHOISE']]);
$tab_options['VALUE']['LBL_RSX'] = $_SESSION['OCS']["ipdiscover"][$dpt[$protectedPost['DPT_CHOISE']]];
$arg_sql = array();
$sql = " select * from (select inv.RSX as ID,\n\t\t\t\t\t inv.c as 'INVENTORIE',\n\t\t\t\t\t non_ident.c as 'NON_INVENTORIE',\n\t\t\t\t\t ipdiscover.c as 'IPDISCOVER',\n\t\t\t\t\t ident.c as 'IDENTIFIE',\n\t\t\t\t\t CASE WHEN ident.c IS NULL and ipdiscover.c IS NULL THEN 100 WHEN ident.c IS NULL THEN 0 ELSE round(100-(non_ident.c*100/(ident.c+non_ident.c)),1) END as 'pourcentage'\n\t\t\t from (SELECT COUNT(DISTINCT hardware_id) as c,'IPDISCOVER' as TYPE,tvalue as RSX\n\t\t\t\t\tFROM devices \n\t\t\t\t\tWHERE name='IPDISCOVER' and tvalue in ";
$arg = mysql2_prepare($sql, $arg_sql, $array_rsx);
$arg['SQL'] .= " GROUP BY tvalue) \n\t\t\t\tipdiscover right join\n\t\t\t\t (SELECT count(distinct(hardware_id)) as c,'INVENTORIE' as TYPE,ipsubnet as RSX\n\t\t\t\t\tFROM networks left join subnet on networks.ipsubnet=subnet.netid\n\t\t\t\t\tWHERE ipsubnet in ";
$arg = mysql2_prepare($arg['SQL'], $arg['ARG'], $array_rsx);
$arg['SQL'] .= " and status='Up' GROUP BY ipsubnet) \n\t\t\t\tinv on ipdiscover.RSX=inv.RSX left join\n\t\t\t\t\t(SELECT COUNT(DISTINCT mac) as c,'IDENTIFIE' as TYPE,netid as RSX\n\t\t\t\t\tFROM netmap \n\t\t\t\t\tWHERE mac IN (SELECT DISTINCT(macaddr) FROM network_devices) \n\t\t\t\t\t\tand netid in ";
$arg = mysql2_prepare($arg['SQL'], $arg['ARG'], $array_rsx);
$arg['SQL'] .= " GROUP BY netid) \n\t\t\t\tident on ipdiscover.RSX=ident.RSX left join\n\t\t\t\t\t(SELECT COUNT(DISTINCT mac) as c,'NON IDENTIFIE' as TYPE,netid as RSX\n\t\t\t\t\tFROM netmap n\n\t\t\t\t\tLEFT JOIN networks ns ON ns.macaddr=n.mac\n\t\t\t\t\tWHERE n.mac NOT IN (SELECT DISTINCT(macaddr) FROM network_devices) \n\t\t\t\t\t\tand (ns.macaddr IS NULL OR ns.IPSUBNET <> n.netid) \n\t \t\t\t\t\tand ns.HARDWARE_ID IS NULL\n\t\t\t\t\t\tand n.netid in ";
$arg = mysql2_prepare($arg['SQL'], $arg['ARG'], $array_rsx);
$arg['SQL'] .= " GROUP BY netid) \n\t\t\t\tnon_ident on non_ident.RSX=inv.RSX \n\t\t\t\t) toto";
$tab_options['ARG_SQL'] = $arg['ARG'];
$list_fields = array('LBL_RSX' => 'LBL_RSX', 'RSX' => 'ID', 'INVENTORIE' => 'INVENTORIE', 'NON_INVENTORIE' => 'NON_INVENTORIE', 'IPDISCOVER' => 'IPDISCOVER', 'IDENTIFIE' => 'IDENTIFIE');
if ($_SESSION['OCS']['CONFIGURATION']['IPDISCOVER'] == "YES") {
$list_fields['SUP'] = 'ID';
}
$list_fields['PERCENT_BAR'] = 'pourcentage';
$table_name = "IPDISCOVER";
$default_fields = $list_fields;
$list_col_cant_del = array('RSX' => 'RSX', 'SUP' => 'SUP');
$tab_options['LIEN_LBL']['INVENTORIE'] = 'index.php?' . PAG_INDEX . '=' . $pages_refs['ms_custom_info'] . '&head=1&prov=inv&value=';
$tab_options['LIEN_CHAMP']['INVENTORIE'] = 'ID';
$tab_options['LIEN_TYPE']['INVENTORIE'] = 'POPUP';
$tab_options['POPUP_SIZE']['INVENTORIE'] = "width=900,height=600";
$tab_options['NO_LIEN_CHAMP']['INVENTORIE'] = array(0);
function count_noinv_network_devices($dpt_choise = '')
{
$array_sub = find_all_subnet($dpt_choise);
$arg_count = array();
$sql_count = "SELECT COUNT(DISTINCT mac) as c\n\t\t\t\t\tFROM netmap n \n\t\t\t\t\tLEFT OUTER JOIN networks ns ON ns.macaddr = mac \n\t\t\t\t\tWHERE mac NOT IN (SELECT DISTINCT(macaddr) FROM network_devices) \n\t\t\t\t\t\tand ( ns.macaddr IS NULL OR ns.IPSUBNET <> n.netid)\n\t\t\t\t\t\tand netid in ";
$detail_query = mysql2_prepare($sql_count, $arg_count, $array_sub);
if (!isset($_SESSION['OCS']['COUNT_CONSOLE']['OCS_REPORT_NB_IPDISCOVER']) and $dpt_choise == '') {
$res_count = mysql2_query_secure($detail_query['SQL'], $_SESSION['OCS']["readServer"], $detail_query['ARG']);
$val_count = mysqli_fetch_array($res_count);
return $val_count['c'];
} else {
return $_SESSION['OCS']['COUNT_CONSOLE']['OCS_REPORT_NB_IPDISCOVER'];
}
}
$fields = array("a.tag" => $_SESSION['OCS']['TAG_LBL']['TAG'], $alias_name_soft => $l->g(20), "h.name" => $l->g(23), "h.userid" => $l->g(24), "h.description" => $l->g(53), "h.lastdate" => $l->g(728));
/*$result_search_soft = mysql2_query_secure( $sql['SQL'], $_SESSION['OCS']["readServer"],$sql['ARG']);
while($item_search_soft = mysqli_fetch_object($result_search_soft)){
$soft[]=$item_search_soft->name;
}*/
$sql = prepare_sql_tab(array_keys($fields));
$sql['SQL'] .= " from accountinfo a, (select hardware_id, " . $info_name_soft["field_name_soft"] . " as sname from softwares where " . $info_name_soft["field_name_soft"] . " in ";
$sql = mysql2_prepare($sql['SQL'], $sql['ARG'], $list_soft);
$sql['SQL'] .= ") s";
if (isset($_SESSION['OCS']['USE_NEW_SOFT_TABLES']) and $_SESSION['OCS']['USE_NEW_SOFT_TABLES'] == 1) {
$sql['SQL'] .= " left join (select id, name as " . $alias_name_soft . " from " . $info_name_soft['table'] . ") cache on cache.id=s.sname ";
}
$sql['SQL'] .= ",hardware h \n\t\t\t\t\twhere a.hardware_id=h.id and s.hardware_id=h.id ";
if (isset($_SESSION['OCS']['TAGS'])) {
$sql['SQL'] .= " and a.tag in ";
$sql = mysql2_prepare($sql['SQL'], $sql['ARG'], $_SESSION['OCS']['TAGS']);
}
$sql['SQL'] .= " order by h.name";
} else {
$fields = array('nb' => $l->g(55), 'name' => $l->g(20));
}
//echo generate_secure_sql($sql['SQL'],$sql['ARG']);
//die();
$toBeWritten = implode($separator, $fields) . "\r\n";
if (ini_get("zlib.output-compression")) {
ini_set("zlib.output-compression", "Off");
}
header("Pragma: public");
header("Expires: 0");
header("Cache-control: must-revalidate, post-check=0, pre-check=0");
header("Cache-control: private", false);
function is_mine_computer($id)
{
if (isset($_SESSION['OCS']['TAGS']) and is_array($_SESSION['OCS']['TAGS'])) {
$sql = "select hardware_id from accountinfo where hardware_id = %s and tag in ";
$arg = array($id);
$sql = mysql2_prepare($sql, $arg, $_SESSION['OCS']['TAGS']);
$result = mysql2_query_secure($sql['SQL'], $_SESSION['OCS']["readServer"], $sql['ARG']);
$item = mysqli_fetch_object($result);
if (isset($item->hardware_id)) {
return true;
} else {
return false;
}
}
return true;
}
$max_order++;
if ($type_field[$name] == "varchar(10)" or $type_field[$name] == "date") {
$type = 6;
$type_field[$name] = "varchar(10)";
} elseif ($type_field[$name] == "blob") {
$type = 5;
} elseif ($type_field[$name] == "varchar(255)") {
$type = 0;
} else {
$type = 0;
}
$sql = "insert into accountinfo_config ";
$arg = '';
$sql = mysql2_prepare($sql, $arg, $fields_table, true);
$values = array($type, $name, 1, $name . " (" . $l->g(2101) . ")", $max_order, 'COMPUTERS');
$sql = mysql2_prepare($sql['SQL'] . " VALUES ", $sql['ARG'], $values);
if (isset($protectedPost['EXE']) and $protectedPost['EXE'] != '') {
mysql2_query_secure($sql['SQL'], $_SESSION['OCS']["writeServer"], $sql['ARG']);
} else {
$add_lign_accountinfo_config[] = $sql['ARG'];
}
$sql_alter = "ALTER TABLE accountinfo CHANGE %s %s %s";
$arg = array($name, "fields_" . mysqli_insert_id($_SESSION['OCS']["writeServer"]), $type_field[$name]);
if (isset($protectedPost['EXE']) and $protectedPost['EXE'] != '') {
mysql2_query_secure($sql_alter, $_SESSION['OCS']["writeServer"], $arg);
addLog('SCRIPT_ADD_DATA_ACCOUNTINFO_CONFIG', $name);
} else {
$rename_col_accountinfo[] = $arg;
}
}
}
// Copyleft Erwan GOALOU 2010 (erwan(at)ocsinventory-ng(pt)org)
// Web: http://www.ocsinventory-ng.org
//
// This code is open source and may be copied and modified as long as the source
// code is always made freely available.
// Please refer to the General Public Licence http://www.gnu.org/ or Licence.txt
//====================================================================================
$data_limit = find_limit_values();
require_once 'require/function_ipdiscover.php';
if ($_SESSION['OCS']["TAGS"]) {
$sql_tag = mysql2_prepare('select id from hardware h, accountinfo a where a.hardware_id=h.id and a.tag in ', array(), $_SESSION['OCS']["TAGS"]);
$result = mysql2_query_secure($sql_tag['SQL'], $_SESSION['OCS']["readServer"], $sql_tag['ARG']);
while ($val = mysqli_fetch_object($result)) {
$my_id[] = $val->id;
}
$myids = mysql2_prepare('', array(), $my_id);
}
if (isset($_SESSION['OCS']['ADMIN_CONSOLE'])) {
$edit = 0;
} else {
$edit = 3;
}
$no_restrict = array("OCS_REPORT_NB_ALL_COMPUTOR");
$multi_search = array("OCS_REPORT_NB_NOTIFIED" => array("FIELD" => '', "COMP" => '', "VALUE" => ''), "OCS_REPORT_NB_ERR" => array("FIELD" => '', "COMP" => '', "VALUE" => ''), "OCS_REPORT_NB_CONTACT" => array("FIELD" => 'HARDWARE-LASTCOME', "COMP" => 'tall', "VALUE" => date($l->g(1242))), "OCS_REPORT_NB_INV" => array("FIELD" => 'HARDWARE-LASTDATE', "COMP" => 'tall', "VALUE" => date($l->g(1242))), "OCS_REPORT_NB_4_MOMENT" => array("FIELD" => 'HARDWARE-LASTCOME', "COMP" => 'small', "VALUE" => date($l->g(1242), mktime(0, 0, 0, date("m"), date("d") - $data_limit['GUI_REPORT_AGIN_MACH'], date("Y")))), "OCS_REPORT_NB_HARD_DISK_H" => array("FIELD" => '', "COMP" => '', "VALUE" => ''), "OCS_REPORT_OSNAME" => array("FIELD" => 'HARDWARE-OSNAME', "COMP" => '', "VALUE" => ''), "OCS_REPORT_USERAGENT" => array("FIELD" => 'HARDWARE-USERAGENT', "COMP" => 'exact', "VALUE" => ''), "OCS_REPORT_PROCESSORT" => array("FIELD" => 'HARDWARE-PROCESSORT', "COMP" => 'exact', "VALUE" => ''), "OCS_REPORT_RESOLUTION" => array("FIELD" => 'VIDEOS-RESOLUTION', "COMP" => '', "VALUE" => ''), "OCS_REPORT_WORKGROUP" => array("FIELD" => 'HARDWARE-WORKGROUP', "COMP" => 'exact', "VALUE" => ''), "OCS_REPORT_TAG" => array("FIELD" => 'ACCOUNTINFO-TAG', "COMP" => 'exact', "VALUE" => ''), "OCS_REPORT_IPSUBNET" => array("FIELD" => 'NETWORKS-IPSUBNET', "COMP" => 'exact', "VALUE" => ''), "OCS_REPORT_NB_LIMIT_FREQ_H" => array("FIELD" => 'HARDWARE-PROCESSORS', "COMP" => 'tall', "VALUE" => $data_limit['GUI_REPORT_PROC_MAX']), "OCS_REPORT_NB_LIMIT_FREQ_M" => array("FIELD" => 'HARDWARE-PROCESSORS', "COMP" => 'small', "VALUE" => $data_limit['GUI_REPORT_PROC_MINI']), "OCS_REPORT_NB_LIMIT_FREQ_B" => array("FIELD" => 'HARDWARE-PROCESSORS,HARDWARE-PROCESSORS', "COMP" => 'tall,small', "VALUE" => $data_limit['GUI_REPORT_PROC_MINI'] . ',' . $data_limit['GUI_REPORT_PROC_MAX']), "OCS_REPORT_NB_LIMIT_MEM_H" => array("FIELD" => 'HARDWARE-MEMORY', "COMP" => 'tall', "VALUE" => $data_limit['GUI_REPORT_RAM_MAX']), "OCS_REPORT_NB_LIMIT_MEM_M" => array("FIELD" => 'HARDWARE-MEMORY', "COMP" => 'small', "VALUE" => $data_limit['GUI_REPORT_RAM_MINI']), "OCS_REPORT_NB_LIMIT_MEM_B" => array("FIELD" => 'HARDWARE-MEMORY,HARDWARE-MEMORY', "COMP" => 'tall,small', "VALUE" => $data_limit['GUI_REPORT_RAM_MINI'] . ',' . $data_limit['GUI_REPORT_RAM_MAX']), "OCS_REPORT_NB_NOTIFIED" => array("FIELD" => 'DEVICES-DOWNLOAD', "COMP" => 'exact', "VALUE" => 'NULL', 'VALUE2' => $l->g(482), 'TYPE_FIELD' => "SelFieldValue"), "OCS_REPORT_NB_ERR" => array("FIELD" => 'DEVICES-DOWNLOAD', "COMP" => 'exact', "VALUE" => 'NULL', 'VALUE2' => "***" . $l->g(956) . "***", 'TYPE_FIELD' => "SelFieldValue"));
$table = array("OCS_REPORT_WORKGROUP" => "hardware", "OCS_REPORT_TAG" => "accountinfo", "OCS_REPORT_IPSUBNET" => "networks", "OCS_REPORT_NB_NOTIFIED" => "devices", "OCS_REPORT_NB_ERR" => "devices", "OCS_REPORT_OSNAME" => "hardware", "OCS_REPORT_USERAGENT" => "hardware", "OCS_REPORT_PROCESSORT" => "hardware", "OCS_REPORT_RESOLUTION" => "videos", "OCS_REPORT_NB_LIMIT_FREQ_H" => "hardware", "OCS_REPORT_NB_LIMIT_FREQ_M" => "hardware", "OCS_REPORT_NB_LIMIT_FREQ_B" => "hardware", "OCS_REPORT_NB_LIMIT_MEM_H" => "hardware", "OCS_REPORT_NB_LIMIT_MEM_M" => "hardware", "OCS_REPORT_NB_LIMIT_MEM_B" => "hardware", "OCS_REPORT_NB_ALL_COMPUTOR" => "hardware", "OCS_REPORT_NB_COMPUTOR" => "hardware", "OCS_REPORT_NB_CONTACT" => "hardware", "OCS_REPORT_NB_INV" => "hardware", "OCS_REPORT_NB_4_MOMENT" => "hardware", "OCS_REPORT_NB_SNMP" => "snmp", "OCS_REPORT_NB_HARD_DISK_H" => "drives", "OCS_REPORT_NB_HARD_DISK_M" => "drives", "OCS_REPORT_NB_HARD_DISK_B" => "drives", "OCS_REPORT_NB_IPDISCOVER" => "nk", "OCS_REPORT_NB_LAST_INV" => "hardware");
$table_field = array("OCS_REPORT_WORKGROUP" => array($l->g(33) => "workgroup"), "OCS_REPORT_TAG" => array($_SESSION['OCS']['TAG_LBL']['TAG'] => "tag"), "OCS_REPORT_IPSUBNET" => array($l->g(316) => "ipsubnet"), "OCS_REPORT_NB_NOTIFIED" => "devices", "OCS_REPORT_NB_ERR" => "devices", "OCS_REPORT_OSNAME" => array($l->g(25) => "osname"), "OCS_REPORT_USERAGENT" => array($l->g(218) => "useragent"), "OCS_REPORT_PROCESSORT" => array($l->g(350) => "processort"), "OCS_REPORT_RESOLUTION" => array($l->g(62) => "resolution"), "OCS_REPORT_NB_LIMIT_FREQ_H" => "hardware", "OCS_REPORT_NB_LIMIT_FREQ_M" => "hardware", "OCS_REPORT_NB_LIMIT_FREQ_B" => "hardware", "OCS_REPORT_NB_LIMIT_MEM_H" => "hardware", "OCS_REPORT_NB_LIMIT_MEM_M" => "hardware", "OCS_REPORT_NB_LIMIT_MEM_B" => "hardware", "OCS_REPORT_NB_ALL_COMPUTOR" => "hardware", "OCS_REPORT_NB_COMPUTOR" => "hardware", "OCS_REPORT_NB_CONTACT" => "hardware", "OCS_REPORT_NB_INV" => "hardware", "OCS_REPORT_NB_4_MOMENT" => "hardware", "OCS_REPORT_NB_SNMP" => "snmp", "OCS_REPORT_NB_HARD_DISK_H" => "drives", "OCS_REPORT_NB_HARD_DISK_M" => "drives", "OCS_REPORT_NB_HARD_DISK_B" => "drives", "OCS_REPORT_NB_IPDISCOVER" => "networks", "OCS_REPORT_NB_LAST_INV" => array("NAME" => "NAME", "ID" => "ID", $l->g(25) => "osname", $l->g(218) => "useragent"));
$link = array("OCS_REPORT_WORKGROUP" => array("RELOAD" => 'OCS_REPORT_WORKGROUP'), "OCS_REPORT_TAG" => array("RELOAD" => 'OCS_REPORT_TAG'), "OCS_REPORT_IPSUBNET" => array("RELOAD" => 'OCS_REPORT_IPSUBNET'), "OCS_REPORT_NB_NOTIFIED" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_ERR" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_OSNAME" => array("RELOAD" => 'OCS_REPORT_OSNAME'), "OCS_REPORT_USERAGENT" => array("RELOAD" => 'OCS_REPORT_USERAGENT'), "OCS_REPORT_PROCESSORT" => array("RELOAD" => 'OCS_REPORT_PROCESSORT'), "OCS_REPORT_RESOLUTION" => array("RELOAD" => 'OCS_REPORT_RESOLUTION'), "OCS_REPORT_NB_LIMIT_FREQ_H" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_LIMIT_FREQ_M" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_LIMIT_FREQ_B" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_LIMIT_MEM_H" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_LIMIT_MEM_M" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_LIMIT_MEM_B" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_ALL_COMPUTOR" => '', "OCS_REPORT_NB_COMPUTOR" => array("PAGE" => 'ms_all_computers'), "OCS_REPORT_NB_CONTACT" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_INV" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_4_MOMENT" => array("PAGE" => 'ms_multi_search'), "OCS_REPORT_NB_SNMP" => array("PAGE" => 'ms_snmp'), "OCS_REPORT_NB_IPDISCOVER" => array("PAGE" => 'ms_ipdiscover'), "OCS_REPORT_NB_LAST_INV" => array("RELOAD" => 'OCS_REPORT_NB_LAST_INV'));
//all fields repart on categories
$repart = array("OCS_REPORT_WORKGROUP" => "ELSE", "OCS_REPORT_TAG" => "ELSE", "OCS_REPORT_IPSUBNET" => "ELSE", "OCS_REPORT_NB_NOTIFIED" => "ELSE", "OCS_REPORT_NB_ERR" => "ELSE", "OCS_REPORT_OSNAME" => "SOFT", "OCS_REPORT_USERAGENT" => "SOFT", "OCS_REPORT_PROCESSORT" => "HARD", "OCS_REPORT_RESOLUTION" => "HARD", "OCS_REPORT_NB_LIMIT_FREQ_H" => "HARD", "OCS_REPORT_NB_LIMIT_FREQ_M" => "HARD", "OCS_REPORT_NB_LIMIT_FREQ_B" => "HARD", "OCS_REPORT_NB_LIMIT_MEM_H" => "HARD", "OCS_REPORT_NB_LIMIT_MEM_M" => "HARD", "OCS_REPORT_NB_LIMIT_MEM_B" => "HARD", "OCS_REPORT_NB_ALL_COMPUTOR" => "ACTIVITY", "OCS_REPORT_NB_COMPUTOR" => "ACTIVITY", "OCS_REPORT_NB_CONTACT" => "ACTIVITY", "OCS_REPORT_NB_INV" => "ACTIVITY", "OCS_REPORT_NB_4_MOMENT" => "ACTIVITY", "OCS_REPORT_NB_SNMP" => "ACTIVITY", "OCS_REPORT_NB_HARD_DISK_H" => "HARD", "OCS_REPORT_NB_HARD_DISK_M" => "HARD", "OCS_REPORT_NB_HARD_DISK_B" => "HARD", "OCS_REPORT_NB_IPDISCOVER" => "ACTIVITY", "OCS_REPORT_NB_LAST_INV" => "ACTIVITY");
//all lbl fields
$lbl_field = array("OCS_REPORT_WORKGROUP" => $l->g(778), "OCS_REPORT_TAG" => $l->g(779), "OCS_REPORT_IPSUBNET" => $l->g(780), "OCS_REPORT_NB_NOTIFIED" => $l->g(781), "OCS_REPORT_NB_ERR" => $l->g(782), "OCS_REPORT_OSNAME" => $l->g(783), "OCS_REPORT_USERAGENT" => $l->g(784), "OCS_REPORT_PROCESSORT" => $l->g(785), "OCS_REPORT_RESOLUTION" => $l->g(786), "OCS_REPORT_NB_LIMIT_FREQ_H" => $l->g(787) . " <b>" . show_modif($data_limit['GUI_REPORT_PROC_MAX'], "GUI_REPORT_PROC_MAX", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_PROC_MAX"))) . "</b> " . $l->g(1239), "OCS_REPORT_NB_LIMIT_FREQ_M" => $l->g(788) . " <b>" . show_modif($data_limit['GUI_REPORT_PROC_MINI'], "GUI_REPORT_PROC_MINI", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_PROC_MINI"))) . "</b> " . $l->g(1239), "OCS_REPORT_NB_LIMIT_FREQ_B" => $l->g(789) . " <b>" . $data_limit['GUI_REPORT_PROC_MINI'] . "</b> " . $l->g(1239) . " " . $l->g(582) . " <b>" . $data_limit['GUI_REPORT_PROC_MAX'] . "</b> " . $l->g(1239), "OCS_REPORT_NB_LIMIT_MEM_H" => $l->g(790) . " <b>" . show_modif($data_limit['GUI_REPORT_RAM_MAX'], "GUI_REPORT_RAM_MAX", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_RAM_MAX"))) . "</b> " . $l->g(1240), "OCS_REPORT_NB_LIMIT_MEM_M" => $l->g(791) . " <b>" . show_modif($data_limit['GUI_REPORT_RAM_MINI'], "GUI_REPORT_RAM_MINI", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_RAM_MINI"))) . "</b> " . $l->g(1240), "OCS_REPORT_NB_LIMIT_MEM_B" => $l->g(792) . " <b>" . $data_limit['GUI_REPORT_RAM_MINI'] . "</b> " . $l->g(1240) . " " . $l->g(582) . " <b>" . $data_limit['GUI_REPORT_RAM_MAX'] . "</b> " . $l->g(1240), "OCS_REPORT_NB_ALL_COMPUTOR" => $l->g(793), "OCS_REPORT_NB_COMPUTOR" => $l->g(794), "OCS_REPORT_NB_CONTACT" => $l->g(795), "OCS_REPORT_NB_INV" => $l->g(796), "OCS_REPORT_NB_4_MOMENT" => $l->g(797) . " <b>" . show_modif($data_limit['GUI_REPORT_AGIN_MACH'], "GUI_REPORT_AGIN_MACH", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_AGIN_MACH"))) . "</b> " . $l->g(496), "OCS_REPORT_NB_HARD_DISK_H" => $l->g(813) . " <b>" . show_modif($data_limit['GUI_REPORT_DD_MAX'], "GUI_REPORT_DD_MAX", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_DD_MAX"))) . "</b> " . $l->g(1240), "OCS_REPORT_NB_HARD_DISK_M" => $l->g(814) . " <b>" . show_modif($data_limit['GUI_REPORT_DD_MINI'], "GUI_REPORT_DD_MINI", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_DD_MINI"))) . "</b> " . $l->g(1240), "OCS_REPORT_NB_HARD_DISK_B" => $l->g(815) . " <b>" . $data_limit['GUI_REPORT_DD_MINI'] . "</b> " . $l->g(1240) . " " . $l->g(582) . " <b>" . $data_limit['GUI_REPORT_DD_MAX'] . "</b> " . $l->g(1240), "OCS_REPORT_NB_IPDISCOVER" => $l->g(913), "OCS_REPORT_NB_LAST_INV" => $l->g(914) . " <b>" . show_modif($data_limit['GUI_REPORT_LAST_DIFF'], "GUI_REPORT_LAST_DIFF", $edit, '', array('JAVASCRIPT' => valid_modif("GUI_REPORT_LAST_DIFF"))) . "</b> " . $l->g(496), "OCS_REPORT_NB_SNMP" => $l->g(1241));
function insert_blacklist_table($table, $field, $field_value)
{
global $l;
$i = 1;
$sql = "insert into %s ";
$arg = array($table);
$sql = mysql2_prepare($sql, $arg, $field, true);
$sql['SQL'] .= " value ";
$sql = mysql2_prepare($sql['SQL'], $sql['ARG'], $field_value);
// //no error
mysql2_query_secure($sql['SQL'], $_SESSION['OCS']["writeServer"], $sql['ARG']);
msg_success($l->g(655));
}
}
if ($show_stats) {
$sql_data_fixe = "select count(*) as %s,de.FILEID\n\t\t\t\tfrom devices d,download_enable de \n\t\t\t\twhere d.IVALUE=de.ID and d.name='DOWNLOAD' \n\t\t\t\tand d.tvalue %s '%s' ";
$sql_data_fixe_bis = "select count(*) as %s,de.FILEID\n\t\t\t\tfrom devices d,download_enable de \n\t\t\t\twhere d.IVALUE=de.ID and d.name='DOWNLOAD' \n\t\t\t\tand d.tvalue %s ";
$sql_data_fixe_ter = "select count(*) as %s,de.FILEID\n\t\t\t\tfrom devices d,download_enable de \n\t\t\t\twhere d.IVALUE=de.ID and d.name='DOWNLOAD' \n\t\t\t\tand (d.tvalue %s '%s' or d.tvalue %s '%s') ";
$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name]['ERR_'] = array('ERR_', 'LIKE', 'ERR_%', 'LIKE', 'EXIT_CODE%');
$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name]['SUCC'] = array('SUCC', 'LIKE', 'SUCCESS%');
$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name]['NOTI'] = array('NOTI', 'LIKE', 'NOTI%');
$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name]['NO_NOTIF'] = array('NO_NOTIF', 'IS NULL');
if ($restrict_computers) {
$sql_data_fixe .= " and d.hardware_id in ";
$sql_data_fixe_bis .= " and d.hardware_id in ";
$sql_data_fixe_ter .= " and d.hardware_id in ";
$temp = mysql2_prepare($sql_data_fixe, array(), $restrict_computers);
$temp_bis = mysql2_prepare($sql_data_fixe_bis, array(), $restrict_computers);
$temp_ter = mysql2_prepare($sql_data_fixe_ter, array(), $restrict_computers);
}
foreach ($_SESSION['OCS']['ARG_DATA_FIXE'][$table_name] as $key => $value) {
if ($restrict_computers) {
if ($key != 'NO_NOTIF' and $key != 'ERR_') {
$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key] = array_merge($_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key], $temp['ARG']);
$_SESSION['OCS']['SQL_DATA_FIXE'][$table_name][$key] = $temp['SQL'] . " group by FILEID";
} elseif ($key == 'NO_NOTIF') {
$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key] = array_merge($_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key], $temp_bis['ARG']);
$_SESSION['OCS']['SQL_DATA_FIXE'][$table_name][$key] = $temp_bis['SQL'] . " group by FILEID";
} elseif ($key == 'ERR_') {
$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key] = array_merge($_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key], $temp_ter['ARG']);
$_SESSION['OCS']['SQL_DATA_FIXE'][$table_name][$key] = $temp_ter['SQL'] . " group by FILEID";
}
} else {
if ($key != 'NO_NOTIF' and $key != 'ERR_') {
function insertinfo_computer($id, $fields, $values)
{
array_push($fields, 'hardware_id');
array_push($values, $id);
$sql = "insert into accountinfo ";
$arg_sql = array();
$sql = mysql2_prepare($sql, $arg_sql, $fields, $nocot = true);
$sql['SQL'] .= " values ";
$sql = mysql2_prepare($sql['SQL'], $sql['ARG'], $values);
mysql2_query_secure($sql['SQL'], $_SESSION['OCS']["writeServer"], $sql['ARG']);
}
}
//$querypack = 'SELECT ';
if ($protectedPost['onglet'] == 'SERV_GROUP') {
$distinct = true;
} else {
$distinct = false;
}
$sql = prepare_sql_tab($list_fields, array('SELECT'), $distinct);
$sql['SQL'] .= " from download_available a, download_enable e ";
if ($protectedPost['onglet'] == 'MACH') {
$sql['SQL'] .= "where a.FILEID=e.FILEID and e.SERVER_ID is null ";
} else {
$sql['SQL'] .= ", hardware h where a.FILEID=e.FILEID and h.id=e.group_id and e.SERVER_ID is not null ";
}
if (isset($fileid_show) and $fileid_show != array()) {
$sql = mysql2_prepare($sql['SQL'], $sql['ARG'], $fileid_show, true);
}
if (isset($_SESSION['OCS']['RESTRICTION']['TELEDIFF_VISIBLE']) and $_SESSION['OCS']['RESTRICTION']['TELEDIFF_VISIBLE'] == "YES") {
$sql['SQL'] .= " and a.comment not like '%s'";
array_push($sql['ARG'], '%[VISIBLE=0]%');
}
$tab_options['QUESTION']['SELECT'] = $l->g(699);
$tab_options['FILTRE'] = array('e.FILEID' => 'Timestamp', 'a.NAME' => $l->g(49));
$tab_options['ARG_SQL'] = $sql['ARG'];
$tab_options['MODIF']['IMG'] = "image/prec16.png";
$result_exist = tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $sql['SQL'], $form_name, 100, $tab_options);
}
echo "</td></tr></table></div>";
}
}
echo close_form();
}
}
tab_modif_values($tab_name, $tab_typ_champ, array('TAG_MODIF' => $protectedPost['MODIF'], 'FIELD_FORMAT' => $type_field[$protectedPost['MODIF']]), array('title' => $l->g(895)));
} elseif ($protectedPost['onglet'] == "SUP_PACK") {
echo "<div class='mvt_bordure'>";
$queryDetails = "select d_a.fileid,d_a.name \n\t\t\t\t\t\t\t\t\tfrom download_available d_a, download_enable d_e \n\t\t\t\t\t\t\t\t\twhere d_e.FILEID=d_a.FILEID group by d_a.NAME order by 1 desc";
$resultDetails = mysql2_query_secure($queryDetails, $_SESSION['OCS']["readServer"]);
while ($val = mysqli_fetch_array($resultDetails)) {
$List[$val["fileid"]] = $val["name"];
}
$select = show_modif($List, 'pack_list', 2, $form_name);
echo $l->g(970) . ": " . $select;
if ($protectedPost['pack_list'] != "") {
$sql = "select count(*) c, tvalue from download_enable d_e,devices d\n\t\t\t\t\t\t\twhere d.name='DOWNLOAD' and d.IVALUE=d_e.ID and d_e.fileid='%s'\n\t\t\t\t\t\t\tand d.hardware_id in ";
$arg = array($protectedPost['pack_list']);
$tab_result = mysql2_prepare($sql, $arg, $list_id);
$sql = $tab_result['SQL'] . " group by tvalue";
$result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"], $tab_result['ARG']);
while ($item = mysqli_fetch_object($result)) {
if ($item->tvalue == "") {
$value = $l->g(482);
} else {
$value = $item->tvalue;
}
echo "<br>" . $item->c . " " . $l->g(1023) . " " . $value . " " . $l->g(1024);
}
echo "<br><input type='submit' name='RAZ' value='" . $l->g(1025) . "'>";
}
echo "</div>";
} elseif ($protectedPost['onglet'] == "WOL") {
echo "<div class='mvt_bordure'>";
function delete_tab($id_tab)
{
$info_fields_into_tab = find_all_field_by_tab($id_tab);
if (isset($info_fields_into_tab) and $info_fields_into_tab != '') {
$result = delete_field($info_fields_into_tab);
} else {
$result = true;
}
if ($result) {
$id_tab = prepare_id($id_tab);
if (is_array($id_tab)) {
$sql_downloadwk_tab_values = "DELETE FROM downloadwk_tab_values WHERE ID in ";
$downloadwk_tab_values = mysql2_prepare($sql_downloadwk_tab_values, array(), $id_tab);
mysql2_query_secure($downloadwk_tab_values['SQL'], $_SESSION['OCS']["writeServer"], $downloadwk_tab_values['ARG']);
addLog('DEL_WK_TELEDIFF', 'delete TAB (downloadwk_tab_values) => ' . mysql_affected_rows() . ' values');
}
}
}
}
$tab_options['CACHE'] = 'RESET';
$sql = "insert into tags (tag,login) values ('%s','%s')";
$i = 0;
while (isset($array_result[$i])) {
$arg = array($array_result[$i], $protectedGet["id"]);
mysql2_query_secure($sql, $_SESSION['OCS']["writeServer"], $arg);
$i++;
}
unset($protectedPost['newtag']);
}
//suppression d'une liste de tag
if (isset($protectedPost['del_check']) and $protectedPost['del_check'] != '') {
$sql = "DELETE FROM tags WHERE tag in ";
$arg_sql = array();
$sql = mysql2_prepare($sql, $arg_sql, $protectedPost['del_check']);
$sql['SQL'] .= " AND login='******'";
array_push($sql['ARG'], $protectedGet["id"]);
mysql2_query_secure($sql['SQL'], $_SESSION['OCS']["writeServer"], $sql['ARG']);
$tab_options['CACHE'] = 'RESET';
}
if (isset($protectedPost['SUP_PROF'])) {
$sql = "DELETE FROM tags WHERE tag='%s' AND login='******'";
$arg = array($protectedPost['SUP_PROF'], $protectedGet["id"]);
mysql2_query_secure($sql, $_SESSION['OCS']["writeServer"], $arg);
}
echo "<br>";
echo open_form($form_name);
$list_fields = array('TAG' => 'tag');
$tab_options['FILTRE'] = array_flip($list_fields);
$tab_options['FILTRE']['NAME'] = $l->g(49);
function insert_with_rules($list_id, $rule_detail, $fileid)
{
if (is_array($list_id)) {
$list_id_hardware = implode(',', $list_id);
} else {
$list_id_hardware = $list_id;
}
if ($list_id_hardware == "") {
return;
}
//for servers
//recherche de tous les hardware_id des servers et des id de download_enable correspondant
$sql_infoServ = "select server_id,id from download_enable where group_id != '' \n\t\t\t\t\t\t\t\tand fileid=%s";
$arg_infoServ = $fileid;
//echo $sql_infoServ;
$res_infoServ = mysql2_query_secure($sql_infoServ, $_SESSION['OCS']["readServer"], $arg_infoServ);
//cr�ation de la liste des id_hardware des servers et d'un tableau de l'id de download_enable en fonction de l'hardware_id
while ($val_infoServ = mysql_fetch_array($res_infoServ)) {
$list_serverId[$val_infoServ['server_id']] = $val_infoServ['server_id'];
$tab_Server[$val_infoServ['server_id']] = $val_infoServ['id'];
}
if ($rule_detail['compto'] == "NAME" or $rule_detail['compto'] == "WORKGROUP" or $rule_detail['compto'] == "USERID") {
$tablecompto = "hardware";
$id_server = "ID";
}
if ($rule_detail['compto'] == "IPSUBNET" or $rule_detail['compto'] == "IPADDRESS") {
$tablecompto = "networks";
$id_server = "HARDWARE_ID";
}
$sql_servValues = "select a.%s,a.%s,d.id as id_download_enable from %s a,download_enable d\n\t\t\t\t\t\t where a.%s in ";
$arg_servValues = array($rule_detail['compto'], $id_server, $tablecompto, $id_server);
$arg = mysql2_prepare($sql_servValues, $arg_servValues, $list_serverId);
$arg['SQL'] .= " and d.server_id=a.%s and fileid='%s'";
array_push($arg['ARG'], $id_server);
array_push($arg['ARG'], $fileid);
$res_servValues = mysql2_query_secure($arg['SQL'], $_SESSION['OCS']["readServer"], $arg['ARG']);
//echo $sql_servValues."<br><br>";
while ($val_servValues = mysql_fetch_array($res_servValues)) {
$tab_serValues[$val_servValues[$rule_detail['compto']]] = $val_servValues[$id_server];
$correspond_servers[$val_servValues[$id_server]] = $val_servValues['id_download_enable'];
}
//for machines
if ($rule_detail['cfield'] == "NAME" or $rule_detail['cfield'] == "WORKGROUP" or $rule_detail['cfield'] == "USERID") {
$tablefield = "hardware";
$id_mach = "ID";
}
if ($rule_detail['cfield'] == "IPSUBNET" or $rule_detail['cfield'] == "IPADDRESS") {
$tablefield = "networks";
$id_mach = "HARDWARE_ID";
}
$sql_machValue = "select %s,%s from %s where %s in ";
$arg_machValue = array($rule_detail['cfield'], $id_mach, $tablefield, $id_mach);
$arg = mysql2_prepare($sql_machValue, $arg_machValue, $list_id_hardware);
$res_machValue = mysql2_query_secure($arg['SQL'], $_SESSION['OCS']["readServer"], $arg['ARG']);
//print_r($tab_serValues);
while ($val_machValue = mysql_fetch_array($res_machValue)) {
if ($rule_detail['op'] == "EGAL") {
//echo "<br>".$val_machValue[$rule_detail['cfield']]."<br>";
//cas of egal
if (isset($tab_serValues[$val_machValue[$rule_detail['cfield']]])) {
$tab_final[$val_machValue[$id_mach]] = $correspond_servers[$tab_serValues[$val_machValue[$rule_detail['cfield']]]];
$verif_idMach[$val_machValue[$id_mach]] = $val_machValue[$id_mach];
} else {
$not_match[$val_machValue[$id_mach]] = $val_machValue[$id_mach];
//$nb_notMatch++;
}
} elseif ($rule_detail['op'] == "DIFF") {
if (!isset($tab_serValues[$val_machValue[$rule_detail['cfield']]])) {
$tab_final[$val_machValue[$id_mach]] = $correspond_servers[$tab_serValues[$val_machValue[$rule_detail['cfield']]]];
$verif_idMach[$val_machValue[$id_mach]] = $val_machValue[$id_mach];
} else {
$not_match[$val_machValue[$id_mach]] = $val_machValue[$id_mach];
//$nb_notMatch++;
}
}
}
if (isset($verif_idMach)) {
$sql_verif = "select d.hardware_id as hardware_id\n\t\t\t from devices d,download_enable d_e \n\t\t\t where d.ivalue=d_e.id and fileid=%s\n\t\t\t\tAND d.HARDWARE_ID in ";
$arg_verif = array($fileid);
$arg = mysql2_prepare($sql_verif, $arg_verif, $verif_idMach);
$arg['SQL'] .= " and d.name='DOWNLOAD'";
$res_verif = mysql2_query_secure($arg['SQL'], $_SESSION['OCS']["readServer"], $arg['ARG']);
//recup�ration des machines en doublon
while ($val_verif = mysql_fetch_array($res_verif)) {
//cr�ation du tableau de doublon
$exist[$val_verif['hardware_id']] = $val_verif['hardware_id'];
//suppression des doublons
//unset($tab_final[$val_verif['hardware_id']]);
//$nb_exist++;
}
//suppression des doublons pour remettre le statut a attente de notification
if ($exist != '') {
desactive_mach_serv(implode(',', $exist), $fileid);
}
//insertion en base
$nb_insert = 0;
foreach ($tab_final as $key => $value) {
$query = "INSERT INTO devices(HARDWARE_ID, NAME, IVALUE) VALUES('%s', '%s','%s')";
$arg = array($key, 'DOWNLOAD', $value);
mysql2_query_secure($query, $_SESSION['OCS']["writeServer"], $arg);
$insert[$key] = $value;
$nb_insert++;
}
}
$not_found = array();
if (is_array($not_match)) {
foreach ($not_match as $key => $value) {
$not_found[] = $value;
}
}
$already_exist = array();
if (is_array($exist)) {
foreach ($exist as $key => $value) {
if (!isset($insert[$key])) {
$already_exist[] = $value;
}
}
}
//retour des erreurs
$don['not_match'] = $not_found;
$don['nb_not_match'] = count($not_found);
$don['exist'] = $already_exist;
$don['nb_exist'] = count($already_exist);
$don['nb_insert'] = $nb_insert;
//print_r($don);
return $don;
}
function deleteDid_snmp($id)
{
global $all_snmp_table;
if (is_array($id)) {
$id_snmp = explode(',', $id);
} else {
$id_snmp = $id;
}
//p($all_snmp_table);
foreach ($all_snmp_table as $key => $values) {
$sql = 'delete from %s where snmp_id in ';
$arg = array(strtolower($values));
$del_sql = mysql2_prepare($sql, $arg, $id_snmp, $nocot = true);
mysql2_query_secure($del_sql['SQL'], $_SESSION['OCS']["writeServer"], $del_sql['ARG'], true);
}
$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);
}
while($item = mysqli_fetch_object($resultlistid)){
$list_id_test[]=$item->id;
}*/
$queryDetails = "SELECT ";
foreach ($list_fields as $key => $value) {
$queryDetails .= $value;
if ($tab_options['AS'][$value]) {
$queryDetails .= " as " . $tab_options['AS'][$value];
}
$queryDetails .= ", ";
}
$queryDetails = substr($queryDetails, 0, -2);
$queryDetails .= " from hardware h left join accountinfo a on h.id=a.hardware_id ";
$queryDetails .= $query_add_table;
$queryDetails .= " where h.id in ";
$queryDetails = mysql2_prepare($queryDetails, array(), $list_id, true);
$queryDetails['SQL'] .= " group by h.ID ";
$tab_options['ARG_SQL'] = $queryDetails['ARG'];
$tab_options['SQL_COUNT'] = $querycount;
if ($_SESSION['OCS']['profile']->getConfigValue('DELETE_COMPUTERS') == "YES") {
$list_fields['SUP'] = 'h.ID';
}
$list_fields['CHECK'] = 'h.ID';
$list_col_cant_del = array('SUP' => 'SUP', 'NAME' => 'NAME', 'CHECK' => 'CHECK');
$default_fields = array($delfault_tag => $delfault_tag, $l->g(652) . ': ' . $l->g(46) => $l->g(652) . ': ' . $l->g(46), $l->g(652) . ": " . $l->g(820) => $l->g(652) . ": " . $l->g(820), $l->g(23) => $l->g(23), $l->g(652) . ": " . $l->g(24) => $l->g(652) . ": " . $l->g(24), $l->g(652) . ": " . $l->g(25) => $l->g(652) . ": " . $l->g(25), $l->g(652) . ": " . $l->g(357) => $l->g(652) . ": " . $l->g(357), 'SUP' => 'SUP', 'CHECK' => 'CHECK');
//print_r($list_fields);
//on modifie le type de champs en numéric de certain champs
//pour que le tri se fasse correctement
//$tab_options['TRI']['SIGNED']['a.TAG']="a.TAG";
//choix des fonctionnalitées pour les utilisateurs
$list_fonct["image/groups_search.png"] = $l->g(583);
function add_computers_cache($list_id, $groupid, $static)
{
require_once 'function_computers.php';
//Generating cache
if (lock($groupid)) {
$reqCache = "INSERT IGNORE INTO groups_cache(hardware_id, group_id, static) \n\t\t\t\t\t\tSELECT id, %s, %s from hardware where id in ";
$argCache = array($groupid, $static);
$cache = mysql2_prepare($reqCache, $argCache, $list_id);
mysql2_query_secure($cache['SQL'], $_SESSION['OCS']["writeServer"], $cache['ARG']);
$cached = mysql_affected_rows($_SESSION['OCS']["writeServer"]);
unlock($groupid);
return $cached;
}
}
