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; } }