$list_mode[6] = 'NOCACHE';
} else {
$list_mode[6] = 'CACHE';
}
$tab_typ_champ[0]['DEFAULT_VALUE'] = $list_mode;
$tab_typ_champ[0]['INPUT_NAME'] = "MODE";
$tab_typ_champ[0]['INPUT_TYPE'] = 2;
$tab_name[0] = $l->g(1014) . ":";
$tab_typ_champ[0]['RELOAD'] = "CHANGE";
if ($protectedPost['MODE'] == 5 and $list_mode[$protectedPost['MODE']] == 'FUSER') {
$tab_typ_champ[1]['DEFAULT_VALUE'] = $protectedPost['FUSER'];
$tab_typ_champ[1]['INPUT_NAME'] = "FUSER";
$tab_typ_champ[1]['INPUT_TYPE'] = 0;
$tab_name[1] = $l->g(926) . " ";
}
tab_modif_values($tab_name, $tab_typ_champ, '', array('title' => $l->g(1015)));
if (isset($protectedPost['Reset_modif'])) {
reloadform_closeme('', true);
}
//passage en mode
if (isset($protectedPost['Valid_modif']) and $protectedPost["MODE"] != "") {
AddLog("MODE", $list_mode[$protectedPost["MODE"]]);
if ($protectedPost["MODE"] == 1) {
unset($_SESSION['OCS']['DEBUG'], $_SESSION['OCS']['MODE_LANGUAGE'], $_SESSION['OCS']["usecache"]);
} elseif ($protectedPost["MODE"] == 2) {
unset($_SESSION['OCS']['MODE_LANGUAGE']);
$_SESSION['OCS']['DEBUG'] = "ON";
} elseif ($protectedPost["MODE"] == 3) {
unset($_SESSION['OCS']['DEBUG']);
$_SESSION['OCS']['MODE_LANGUAGE'] = "ON";
} elseif ($protectedPost["MODE"] == 4) {
$tab_options['ARG_SQL'] = $sql['ARG'];
$tab_options['LBL_POPUP']['SUP'] = $l->g(919);
$tab_options['LBL']['GROUP_NAME'] = $l->g(49);
ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del);
echo "<input type='submit' name='NEW' id='NEW' value='" . $l->g(617) . "' align=center>";
if ($protectedPost["NEW"]) {
$name_field = array("GROUP", "MESSAGE");
$tab_name = array($l->g(577) . ": ", $l->g(449) . ":");
$type_field = array(2, 1);
$value_field = array($array_group, '');
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
foreach ($tab_typ_champ as $id => $values) {
$tab_typ_champ[$id]['CONFIG']['SIZE'] = 20;
}
if (isset($tab_typ_champ)) {
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden);
}
}
}
}
echo "</div></div>";
echo "<input type=hidden name='ADMIN' value='' id='ADMIN'>";
echo "<input type=hidden name='VISIBLE' value='' id='VISIBLE'>";
echo "<input type=hidden name='NO_VISIBLE' value='' id='NO_VISIBLE'>";
echo "<input type=hidden name='VALID_MODIF' value='' id='VALID_MODIF'>";
echo "<input type=hidden name='SHOW_ME' value='' id='SHOW_ME'>";
echo "<input type=hidden name='UPDATE_VALUE' value='' id='UPDATE_VALUE'>";
} else {
echo "<table align=center><tr><td align=center><img src='image/fond.png'></td></tr></table>";
}
if (isset($protectedPost["onglet"]) and isset($protectedPost["old_onglet"]) and $protectedPost["onglet"] != $protectedPost["old_onglet"]) {
$i++;
$info_form['FIELDS']['name_field'][$i] = $key;
$info_form['FIELDS']['type_field'][$i] = 0;
if ($key == 'ADDR_MAC_GENERIC') {
$info_form['FIELDS']['value_field'][$i] = isset($protectedPost[$key]) ? $protectedPost[$key] : RandomMAC();
} else {
$info_form['FIELDS']['value_field'][$i] = isset($protectedPost[$key]) ? $protectedPost[$key] : rand();
}
$info_form['FIELDS']['tab_name'][$i] = $value . "*";
$config[$i]['CONFIG']['SIZE'] = 30;
$other_data['COMMENT_BEHING'][$i] = '_M';
}
$accountinfo_form = show_accountinfo('', 'COMPUTERS', '5');
//merge data
$info_form['FIELDS']['name_field'] = array_merge($info_form['FIELDS']['name_field'], $accountinfo_form['FIELDS']['name_field']);
$info_form['FIELDS']['type_field'] = array_merge($info_form['FIELDS']['type_field'], $accountinfo_form['FIELDS']['type_field']);
$info_form['FIELDS']['value_field'] = array_merge($info_form['FIELDS']['value_field'], $accountinfo_form['FIELDS']['value_field']);
$info_form['FIELDS']['tab_name'] = array_merge($info_form['FIELDS']['tab_name'], $accountinfo_form['FIELDS']['tab_name']);
$config = array_merge($config, $accountinfo_form['CONFIG']);
$other_data['COMMENT_BEHING'] = array_merge($other_data['COMMENT_BEHING'], $accountinfo_form['COMMENT_BEHING']);
$tab_typ_champ = show_field($info_form['FIELDS']['name_field'], $info_form['FIELDS']['type_field'], $info_form['FIELDS']['value_field']);
foreach ($config as $key => $value) {
$tab_typ_champ[$key]['CONFIG'] = $value['CONFIG'];
$tab_typ_champ[$key]['COMMENT_BEHING'] = $other_data['COMMENT_BEHING'][$key];
}
if (isset($tab_typ_champ)) {
tab_modif_values($info_form['FIELDS']['tab_name'], $tab_typ_champ, $tab_hidden);
}
echo "</div>";
echo close_form();
}
$res_new_value = mysqli_query($_SESSION['OCS']["readServer"], $sql_new_value);
$val_new_value = mysqli_fetch_array($res_new_value);
if ($val_new_value['max'] == "") {
$val_new_value['max'] = 0;
}
$val_new_value['max']++;
mysqli_query($_SESSION['OCS']["writeServer"], "INSERT INTO config (NAME,TVALUE,IVALUE) VALUES('USER_GROUP_" . $val_new_value['max'] . "','" . $protectedPost['newfield'] . "','" . $val_new_value['max'] . "')") or mysqli_error($_SESSION['OCS']["writeServer"]);
//si on ajoute un champ, il faut créer la colonne dans la table downloadwk_pack
msg_success($l->g(1069));
} else {
msg_error($ERROR);
}
}
//NAME FIELD
$name_field = array("newfield");
$tab_name[0] = $l->g(577);
$type_field = array(0);
$value_field = array($protectedPost['newfield']);
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
$tab_typ_champ[0]['CONFIG']['SIZE'] = 20;
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('form_name' => 'NO_FORM'));
}
echo "</div>";
echo close_form();
if ($ajax) {
ob_end_clean();
tab_req($list_fields, $default_fields, $list_col_cant_del, $queryDetails, $tab_options);
}
?>
array_push($config['JAVASCRIPT'], '');
array_push($config['SIZE'], '');
} else {
array_push($value_field, $info_account_id[$name_accountinfo]);
if ($admin_accountinfo) {
array_push($config['COMMENT_AFTER'], $up_png);
} else {
array_push($config['COMMENT_AFTER'], "");
}
array_push($config['SELECT_DEFAULT'], '');
array_push($config['JAVASCRIPT'], '');
array_push($config['SIZE'], '');
}
array_push($name_field, $name_accountinfo);
array_push($tab_name, $val_admin_info['COMMENT']);
if ($_SESSION['OCS']['profile']->getConfigValue('CHANGE_ACCOUNTINFO') == "YES") {
array_push($type_field, $convert_type[$val_admin_info['TYPE']]);
} else {
array_push($type_field, 3);
}
$nb_row++;
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field, $config);
if ($_SESSION['OCS']['profile']->getConfigValue('ACCOUNTINFO') == 'YES') {
$tab_hidden = array('ADMIN' => '', 'UP' => '', 'DOWN' => '');
}
//echo "<input type='hidden' name='ADMIN' id='ADMIN' value=''>";
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('form_name' => 'NO_FORM', 'top_action' => $show_admin_button));
echo "</div>";
echo close_form();
}
$lbl_action = $l->g(905);
} else {
$id_pack_affect = $protectedGet['affect_reset'];
$hidden_action = 'reset';
$title_action = $l->g(906);
$lbl_action = $l->g(907);
}
$sql = "select da.name from devices d, \n\t\t\t\t\t\t download_enable de,\n\t\t\t\t\t\t\tdownload_available da\n where de.id='%s' and de.FILEID=da.FILEID\n\t\t\tand d.IVALUE=de.ID\n\t\t\tAND d.hardware_id='%s' AND d.name='%s'\n\t\t\tand tvalue like '%s'";
$arg = array($id_pack_affect, $protectedGet['systemid'], "DOWNLOAD", "ERR_%");
$res = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"], $arg);
$val = mysql_fetch_array($res);
if (isset($val['name'])) {
$tab_typ_champ[0]['INPUT_NAME'] = "MOTIF";
$tab_typ_champ[0]['INPUT_TYPE'] = 1;
$data_form[0] = "<center>" . $lbl_action . "</center>";
tab_modif_values($data_form, $tab_typ_champ, array('NAME_PACK' => $val['name'], 'ACTION' => $hidden_action), $title_action . $val['name'], "");
}
}
if (isset($protectedGet["suppack"]) & $_SESSION['OCS']['CONFIGURATION']['TELEDIFF'] == "YES") {
if ($_SESSION['OCS']["justAdded"] == false) {
desactive_packet($systemid, $protectedGet["suppack"]);
} else {
$_SESSION['OCS']["justAdded"] = false;
}
addLog($l->g(512), $l->g(886) . " " . $protectedGet["suppack"] . " => " . $systemid);
} else {
$_SESSION['OCS']["justAdded"] = false;
}
if (isset($protectedGet["actgrp"])) {
//this id is it a group?
$reqGroups = "SELECT h.id id\n\t\t\t\t\t FROM hardware h \n\t\t\t\t\t WHERE h.deviceid='_SYSTEMGROUP_' ";
$tab_typ_champ[1]['CONFIG']['MAXLENGTH'] = 255;
$tab_name[1] = $l->g(53) . ": ";
$sql = "select distinct NAME from devicetype ";
$res = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"]);
while ($row = mysqli_fetch_object($res)) {
$list_type[$row->NAME] = $row->NAME;
}
$tab_typ_champ[2]['DEFAULT_VALUE'] = $list_type;
$tab_typ_champ[2]['INPUT_NAME'] = "TYPE";
$tab_typ_champ[2]['INPUT_TYPE'] = 2;
$tab_name[2] = $l->g(66) . ": ";
$tab_hidden['mac'] = $protectedPost['MODIF'];
if (isset($ERROR)) {
msg_error($ERROR);
}
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('title' => $title));
} else {
//affichage des périphériques
if (!isset($protectedPost["pcparpage"])) {
$protectedPost["pcparpage"] = 5;
}
if (isset($protectedGet['value'])) {
if ($protectedGet['prov'] == "no_inv") {
$title = $l->g(947);
$sql = "SELECT ip, mac, mask, date, name FROM netmap n \n\t\t\t\tLEFT JOIN networks ns ON ns.macaddr=n.mac\n\t\t\t\tWHERE n.netid='%s' \n\t\t\t\tAND (ns.macaddr IS NULL OR ns.IPSUBNET <> n.netid) \n\t\t\t\tAND mac NOT IN (SELECT DISTINCT(macaddr) FROM network_devices)";
$tab_options['ARG_SQL'] = array($protectedGet['value']);
$list_fields = array($l->g(34) => 'ip', 'MAC' => 'mac', $l->g(208) => 'mask', $l->g(232) => 'date', $l->g(318) => 'name');
$tab_options['FILTRE'] = array_flip($list_fields);
$tab_options['ARG_SQL_COUNT'] = array($protectedGet['value']);
$list_fields['SUP'] = 'mac';
$list_fields['MODIF'] = 'mac';
if (count($groupListServers) == 0) {
msg_error($l->g(660));
} else {
$tab_name = array($l->g(651), $l->g(470));
$name_field = array("FILE_SERV_REDISTRIB", "HTTPS_SERV");
$type_field = array(2, 0);
$value_field = array($groupListServers, $protectedPost['HTTPS_SERV']);
}
}
if (isset($name_field)) {
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
foreach ($tab_typ_champ as $id => $values) {
$tab_typ_champ[$id]['CONFIG']['SIZE'] = 30;
if ($tab_typ_champ[$id]['INPUT_TYPE'] == 0) {
$tab_typ_champ[$id]['COMMENT_AFTER'] = '/' . $protectedGet["active"];
if ($id == 0) {
$tab_typ_champ[$id]['COMMENT_BEFORE'] = 'http://';
} else {
$tab_typ_champ[$id]['COMMENT_BEFORE'] = 'https://';
}
}
}
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('title' => $l->g(465) . ' => ' . $info_id['NAME'] . " (" . $protectedGet["active"] . ")"));
}
}
//var_dump($tab_typ_champ);
//fermeture du formulaire.
echo close_form();
} else {
msg_error($info_id['ERROR']);
}
require_once HEADER_HTML;
if (isset($protectedPost['Valid_CNX'])) {
$login_successful = $l->g(180);
msg_error($login_successful);
flush();
//you can't send a new login/passwd before 2 seconds
sleep(2);
}
echo "<br/>";
$name_field = array("LOGIN", "PASSWD");
$tab_name = array($l->g(24) . ": ", $l->g(217) . ":");
$type_field = array(0, 4);
$value_field = array($protectedPost['LOGIN'], '');
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
foreach ($tab_typ_champ as $id => $values) {
$tab_typ_champ[$id]['CONFIG']['SIZE'] = 20;
}
if (DEMO) {
msg_info($l->g(24) . ": " . DEMO_LOGIN . "<br/>" . $l->g(217) . ": " . DEMO_PASSWD);
}
if (isset($tab_typ_champ)) {
tab_modif_values($tab_name, $tab_typ_champ, array(), array('button_name' => 'CNX', 'show_button' => 'BUTTON'));
}
require_once FOOTER_HTML;
die;
} else {
header('WWW-Authenticate: Basic realm="OcsinventoryNG"');
header('HTTP/1.0 401 Unauthorized');
die;
}
}
function admin_profil($form)
{
global $protectedPost, $l, $pages_refs;
$yes_no = array('YES' => $l->g(455), 'NO' => $l->g(454));
$info_field = array('NAME' => array('INFO' => array('LBL' => $l->g(1153) . ": ", 'VALUE' => '')), 'GUI' => array('RESTRICTION' => array('LBL' => $l->g(1154) . ": ", 'VALUE' => $yes_no)), 'TELEDIFF_ACTIVATE' => array('RESTRICTION' => array('LBL' => $l->g(1158) . ": ", 'VALUE' => $yes_no)), 'TELEDIFF_VISIBLE' => array('RESTRICTION' => array('LBL' => $l->g(1301) . ": ", 'VALUE' => $yes_no)), 'EXPORT_XML' => array('RESTRICTION' => array('LBL' => $l->g(1305), 'VALUE' => $yes_no)), 'WOL' => array('RESTRICTION' => array('LBL' => $l->g(1281) . ": ", 'VALUE' => $yes_no)), 'MACADD' => array('ADMIN_BLACKLIST' => array('LBL' => $l->g(1159) . ": ", 'VALUE' => $yes_no)), 'SERIAL' => array('ADMIN_BLACKLIST' => array('LBL' => $l->g(1160) . ": ", 'VALUE' => $yes_no)), 'IPDISCOVER' => array('ADMIN_BLACKLIST' => array('LBL' => $l->g(1161) . ": ", 'VALUE' => $yes_no), 'CONFIGURATION' => array('LBL' => $l->g(1172) . ": ", 'VALUE' => $yes_no)), 'TELEDIFF' => array('CONFIGURATION' => array('LBL' => $l->g(1162) . ": ", 'VALUE' => $yes_no)), 'CONFIG' => array('CONFIGURATION' => array('LBL' => $l->g(1163) . ": ", 'VALUE' => $yes_no)), 'GROUPS' => array('CONFIGURATION' => array('LBL' => $l->g(1164) . ": ", 'VALUE' => $yes_no)), 'CONSOLE' => array('CONFIGURATION' => array('LBL' => $l->g(1165) . ": ", 'VALUE' => $yes_no)), 'ALERTE_MSG' => array('CONFIGURATION' => array('LBL' => $l->g(1166) . ": ", 'VALUE' => $yes_no)), 'ACCOUNTINFO' => array('CONFIGURATION' => array('LBL' => $l->g(1167) . ": ", 'VALUE' => $yes_no)), 'CHANGE_ACCOUNTINFO' => array('CONFIGURATION' => array('LBL' => $l->g(1168) . ": ", 'VALUE' => $yes_no)), 'CHANGE_USER_GROUP' => array('CONFIGURATION' => array('LBL' => $l->g(1169) . ": ", 'VALUE' => $yes_no)), 'MANAGE_PROFIL' => array('CONFIGURATION' => array('LBL' => $l->g(1170) . ": ", 'VALUE' => $yes_no)), 'MANAGE_USER_GROUP' => array('CONFIGURATION' => array('LBL' => $l->g(1171) . ": ", 'VALUE' => $yes_no)), 'MANAGE_SMTP_COMMUNITIES' => array('CONFIGURATION' => array('LBL' => $l->g(1205) . ": ", 'VALUE' => $yes_no)), 'DELETE_COMPUTERS' => array('CONFIGURATION' => array('LBL' => $l->g(1272) . ": ", 'VALUE' => $yes_no)));
$lbl_cat = array('INFO' => $l->g(1173), 'PAGE_PROFIL' => $l->g(1174), 'RESTRICTION' => $l->g(1175), 'ADMIN_BLACKLIST' => $l->g(1176), 'CONFIGURATION' => $l->g(1177));
if ($protectedPost['Valid_modif_profil']) {
//read profil file
$forprofil = read_profil_file($protectedPost['PROFILS']);
//read all profil value
$forall = read_config_file();
//build new tab with new values
foreach ($info_field as $if_name => $if_value) {
foreach ($if_value as $if_cat => $if_val) {
if (isset($protectedPost[$if_name]) and $protectedPost['cat'] == $if_cat) {
$new_value[$if_cat][$if_name] = $protectedPost[$if_name];
} else {
$new_value[$if_cat][$if_name] = $forprofil[$if_cat][$if_name];
}
}
}
foreach ($forall['URL'] as $name => $value) {
if (isset($protectedPost[$name]) and $protectedPost['cat'] == "PAGE_PROFIL") {
$new_value["PAGE_PROFIL"][$name] = '';
}
}
if (!isset($new_value['PAGE_PROFIL'])) {
$new_value['PAGE_PROFIL'] = $forprofil['PAGE_PROFIL'];
}
update_config_file($protectedPost['PROFILS'], $new_value);
msg_success($l->g(1274));
}
$array_profil = get_profile_labels();
echo $l->g(1196) . ": " . show_modif($array_profil, "PROFILS", 2, $form);
echo "<a href=\"index.php?" . PAG_INDEX . "=" . $pages_refs['ms_new_profil'] . "&head=1&form=" . $form . "\"><img src=image/plus.png></a>";
if (isset($protectedPost['PROFILS']) and $protectedPost['PROFILS'] != '') {
$forall = read_config_file();
$forprofil = read_profil_file($protectedPost['PROFILS'], 'WRITE');
if (is_array($forprofil) and is_array($forall)) {
foreach ($forprofil as $key => $value) {
if (isset($lbl_cat[$key])) {
$data_on[$key] = $lbl_cat[$key];
}
}
onglet($data_on, $form, "cat", 10);
if (isset($forprofil[$protectedPost['cat']]) and $protectedPost['cat'] != 'PAGE_PROFIL') {
$name_field = array();
$type_field = array();
$tab_name = array();
$value_field = array();
foreach ($info_field as $if_name => $if_value) {
foreach ($if_value as $if_cat => $if_val) {
if ($protectedPost['cat'] == $if_cat) {
if (isset($forprofil[$if_cat][$if_name])) {
$protectedPost[$if_name] = $forprofil[$if_cat][$if_name];
}
array_push($name_field, $if_name);
array_push($tab_name, $if_val['LBL']);
if (is_array($if_val['VALUE'])) {
array_push($type_field, 2);
if (!isset($protectedPost[$if_name])) {
array_push($if_val['VALUE'], '');
}
array_push($value_field, $if_val['VALUE']);
} else {
array_push($type_field, 0);
array_push($value_field, replace_language($forprofil[$if_cat][$if_name]));
}
}
}
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('button_name' => 'modif_profil'));
} elseif ($protectedPost['cat'] == 'PAGE_PROFIL') {
$champs = "<table align=center><tr><td align=center>";
$i = 0;
ksort($forall['URL']);
foreach ($forall['URL'] as $key => $value) {
$champs .= "<input type='checkbox' name='" . $key . "' id='" . $key . "' ";
if (isset($forprofil[$protectedPost['cat']][$key])) {
$champs .= " checked ";
}
$champs .= " ></td><td>" . $key . "</td><td align=center>";
$i++;
if ($i == 4) {
$champs .= "</td></tr><tr><td align=center>";
$i = 0;
}
}
$champs .= "</td></tr></table>";
tab_modif_values($champs, array(), array(), array('button_name' => 'modif_profil'));
}
}
}
}
function form_add_community($title = '', $default_value, $form)
{
global $l, $pages_refs, $protectedPost;
$name_field = array("NAME", "VERSION");
$tab_name = array($l->g(49) . ": ", $l->g(1199) . ": ");
$type_field = array(0, 2);
$value_field = array($default_value['NAME'], $default_value['VERSION']);
if ($protectedPost['VERSION'] == '3') {
array_push($name_field, "USERNAME", "AUTHKEY", "AUTHPASSWD");
array_push($tab_name, "USERNAME : "******"AUTHKEY : ", "AUTHPASSWD :");
array_push($type_field, 0, 0);
array_push($value_field, $default_value['USERNAME'], $default_value['AUTHKEY'], $default_value['AUTHPASSWD']);
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
foreach ($tab_typ_champ as $id => $values) {
$tab_typ_champ[$id]['CONFIG']['SIZE'] = 30;
}
$tab_typ_champ[1]['RELOAD'] = $form;
if (is_numeric($protectedPost['MODIF'])) {
$tab_hidden['MODIF'] = $protectedPost['MODIF'];
}
$tab_hidden['ADD_COMM'] = $protectedPost['ADD_COMM'];
$tab_hidden['ID'] = $protectedPost['ID'];
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('title' => $title, 'show_frame' => false));
}
function form_add_computer()
{
global $l;
$name_field = array("NAME", "OSNAME");
$name_field[] = "LASTNAME";
$name_field[] = "EMAIL";
$name_field[] = "COMMENTS";
//$name_field[]="USER_GROUP";
$tab_name[] = $l->g(49) . ": ";
$tab_name[] = $l->g(996) . ": ";
$tab_name[] = "Email: ";
$tab_name[] = $l->g(51) . ": ";
//$tab_name[]="Groupe de l'utilisateur: ";
$type_field[] = 0;
$type_field[] = 0;
$type_field[] = 0;
$type_field[] = 0;
//$type_field[]= 2;
if ($id_user != '' or $_SESSION['OCS']['profile']->getConfigValue('CHANGE_USER_GROUP') == 'NO') {
$tab_hidden['MODIF'] = $id_user;
$sql = "select ID,NEW_ACCESSLVL,USER_GROUP,FIRSTNAME,LASTNAME,EMAIL,COMMENTS from operators where id= '%s'";
$arg = $id_user;
$res = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"], $arg);
$row = mysqli_fetch_object($res);
if ($_SESSION['OCS']['profile']->getConfigValue('CHANGE_USER_GROUP') == 'YES') {
$protectedPost['ACCESSLVL'] = $row->NEW_ACCESSLVL;
$protectedPost['USER_GROUP'] = $row->USER_GROUP;
$value_field = array($row->ID, $list_profil, $list_groups);
}
$value_field[] = $row->FIRSTNAME;
$value_field[] = $row->LASTNAME;
$value_field[] = $row->EMAIL;
$value_field[] = $row->COMMENTS;
} else {
if ($_SESSION['OCS']['profile']->getConfigValue('CHANGE_USER_GROUP') == 'YES') {
$value_field = array($protectedPost['ID'], $list_profil, $list_groups);
}
$value_field[] = $protectedPost['FIRSTNAME'];
$value_field[] = $protectedPost['LASTNAME'];
$value_field[] = $protectedPost['EMAIL'];
$value_field[] = $protectedPost['COMMENTS'];
}
if ($_SESSION['OCS']['cnx_origine'] == "LOCAL") {
$name_field[] = "PASSWORD";
$type_field[] = 0;
$tab_name[] = $l->g(217) . ":";
$value_field[] = $protectedPost['PASSWORD'];
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
foreach ($tab_typ_champ as $id => $values) {
$tab_typ_champ[$id]['CONFIG']['SIZE'] = 40;
}
if ($_SESSION['OCS']['profile']->getConfigValue('MANAGE_USER_GROUP') == 'YES') {
$tab_typ_champ[2]["CONFIG"]['DEFAULT'] = "YES";
// $tab_typ_champ[1]['COMMENT_AFTER']="<a href=\"index.php?".PAG_INDEX."=".$pages_refs['ms_admin_profil']."&head=1\"><img src=image/plus.png></a>";
$tab_typ_champ[2]['COMMENT_AFTER'] = "<a href=\"index.php?" . PAG_INDEX . "=" . $pages_refs['ms_adminvalues'] . "&head=1&tag=USER_GROUP\"><img src=image/plus.png></a>";
}
if (isset($tab_typ_champ)) {
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden);
}
}
} else {
// Upgrade from 1.3.x
$valdatabase = 'ocsweb';
}
}
if (!$instOk) {
require_once 'require/function_table_html.php';
msg_info($l->g(2040) . " " . $MaxAvail . $l->g(1240) . "<br>" . $l->g(2041) . "<br><br><font color=red>" . $l->g(2102) . "</font>");
$form_name = 'fsub';
//echo "<br><form name='".$form_name."' id='".$form_name."' method='POST' action='install.php'>";
$name_field = array("name", "pass", "database", "host");
$tab_name = array($l->g(247) . ": ", $l->g(248) . ": ", $l->g(1233) . ":", $l->g(250) . ":");
$type_field = array(0, 4, 0, 0);
$value_field = array($valNme, $valPass, $valdatabase, $valServ);
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $title = "", $comment = "", $name_button = "INSTALL", $showbutton = 'BUTTON', $form_name);
die;
}
$msg_warning = "";
if ($firstAttempt == true && $_POST["pass"] == "") {
$msg_warning .= $l->g(2042) . "<br><br>";
}
if (!mysql_query("set global max_allowed_packet=2097152;")) {
$msg_warning .= $l->g(2043);
}
if ($msg_warning != "") {
msg_warning($msg_warning);
}
mysql_select_db($_POST['database']);
if (isset($_POST["label"])) {
if ($_POST["label"] != "") {
array_push($config['SELECT_DEFAULT'], '');
array_push($config['JAVASCRIPT'], '');
array_push($config['SIZE'], '');
}
array_push($name_field, $name_accountinfo);
array_push($tab_name, $val_admin_info['COMMENT']);
if ($_SESSION['OCS']['profile']->getConfigValue('CHANGE_ACCOUNTINFO') == "YES") {
array_push($type_field, $convert_type[$val_admin_info['TYPE']]);
} else {
array_push($type_field, 3);
}
$nb_row++;
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field, $config);
if ($_SESSION['OCS']['profile']->getConfigValue('ACCOUNTINFO') == 'YES') {
$tab_hidden = array('ADMIN' => '', 'UP' => '', 'DOWN' => '');
}
//echo "<input type='hidden' name='ADMIN' id='ADMIN' value=''>";
if ($show_all_column or $admin_accountinfo) {
$showbutton = false;
} else {
$showbutton = true;
}
if ($_SESSION['OCS']['profile']->getConfigValue('CHANGE_ACCOUNTINFO') != "YES") {
$showbutton = false;
}
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('show_button' => $showbutton, 'form_name' => $form_name = 'NO_FORM', 'top_action' => $show_admin_button, 'show_frame' => false));
echo '</div>';
echo close_form();
}
}
echo "<input type='hidden' id='modif' name='modif' value=''>";
echo "<input type='hidden' id='tri2' name='tri2' value='" . $_POST['tri2'] . "'>";
echo "<input type='hidden' id='sens' name='sens' value='" . $_POST['sens'] . "'>";
echo "</table>";
echo close_form();
//detail of group's machin
if ($_POST['modif'] != "" and !isset($_POST['Valid_modif']) and !isset($_POST['Reset_modif'])) {
$tab_name[1] = $l->g(646) . ": ";
$tab_name[2] = $l->g(648) . ": ";
$tab_typ_champ[1]['DEFAULT_VALUE'] = substr($data2[$_POST['modif']]['URL'], 7);
$tab_typ_champ[1]['COMMENT_BEFORE'] = "<b>http://</b>";
$tab_typ_champ[1]['COMMENT_AFTER'] = "<small>" . $l->g(691) . "</small>";
$tab_typ_champ[1]['INPUT_NAME'] = "URL";
$tab_typ_champ[1]['INPUT_TYPE'] = 0;
$tab_typ_champ[2]['DEFAULT_VALUE'] = $data2[$_POST['modif']]['REP_STORE'];
$tab_typ_champ[2]['INPUT_NAME'] = "REP_STORE";
$tab_typ_champ[2]['INPUT_TYPE'] = 0;
$tab_hidden["modif"] = $data2[$_POST['modif']]['ID'];
$tab_hidden["pcparpage"] = $_POST['pcparpage'];
$tab_hidden["page"] = $_POST['page'];
$tab_hidden["old_pcparpage"] = $_POST['old_pcparpage'];
if ($_POST['modif'] == "ALL") {
$tab_hidden["modif"] = "ALL";
$title = $l->g(692);
} else {
$title = $l->g(693) . " " . $data2[$_POST['modif']]['NAME'];
}
$comment = $l->g(694);
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('title' => $title, 'comment' => $comment));
}
}
$valNme = '';
}
if (defined('PSWD_BASE')) {
$valPass = PSWD_BASE;
} else {
$valPass = '';
}
if (defined('SERVER_WRITE')) {
$valServ = SERVER_WRITE;
} else {
$valServ = '';
}
if (defined('DB_NAME')) {
$valdatabase = DB_NAME;
} else {
$valdatabase = '';
}
}
//show first form
$form_name = 'fsub';
$name_field = array("name", "pass", "database", "host");
$tab_name = array($l->g(247) . ": ", $l->g(248) . ": ", $l->g(1233) . ":", $l->g(250) . ":");
$type_field = array(0, 4, 0, 0);
if (isset($_POST["name"], $_POST["pass"], $_POST["database"], $_POST["host"])) {
$value_field = array($_POST["name"], $_POST["pass"], $_POST["database"], $_POST["host"]);
} else {
$value_field = array($valNme, $valPass, $valdatabase, $valServ);
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('button_name' => 'INSTALL', 'show_button' => 'BUTTON', 'form_name' => $form_name));
die;
}
$tab_typ_champ[$i]['COMMENT_AFTER'] = "</td><td><input type='checkbox' name='check" . $truename . "' id='check" . $truename . "' " . (isset($protectedPost['check' . $truename]) ? " checked " : "") . ">";
} else {
$tab_typ_champ[$i]['COMMENT_AFTER'] = "</td><td><input type='checkbox' name='check" . $truename . "' id='check" . $truename . "' " . (isset($protectedPost['check' . $truename]) ? " checked " : "") . ">";
$tab_typ_champ[$i]['CONFIG']['MAXLENGTH'] = 100;
$tab_typ_champ[$i]['CONFIG']['SIZE'] = 30;
}
$tab_typ_champ[$i]['INPUT_NAME'] = $truename;
$tab_typ_champ[$i]['INPUT_TYPE'] = $convert_type[$field_of_accountinfo['LIST_TYPE'][$id]];
$tab_typ_champ[$i]['CONFIG']['JAVASCRIPT'] = $java . " onclick='document.getElementById(\"check" . $truename . "\").checked = true' ";
//$tab_typ_champ[$i]['DEFAULT_VALUE']=$protectedPost[$truename];
$tab_name[$i] = $lbl;
$i++;
}
}
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']);
$i++;
$info_form['FIELDS']['name_field'][$i] = $key;
$info_form['FIELDS']['type_field'][$i] = 0;
if ($key == 'ADDR_MAC_GENERIC') {
$info_form['FIELDS']['value_field'][$i] = isset($protectedPost[$key]) ? $protectedPost[$key] : RandomMAC();
} else {
$info_form['FIELDS']['value_field'][$i] = isset($protectedPost[$key]) ? $protectedPost[$key] : rand();
}
$info_form['FIELDS']['tab_name'][$i] = $value . "*";
$config[$i]['CONFIG']['SIZE'] = 30;
$other_data['COMMENT_AFTER'][$i] = '_M';
}
$accountinfo_form = show_accountinfo('', 'COMPUTERS', '5');
//merge data
$info_form['FIELDS']['name_field'] = array_merge($info_form['FIELDS']['name_field'], $accountinfo_form['FIELDS']['name_field']);
$info_form['FIELDS']['type_field'] = array_merge($info_form['FIELDS']['type_field'], $accountinfo_form['FIELDS']['type_field']);
$info_form['FIELDS']['value_field'] = array_merge($info_form['FIELDS']['value_field'], $accountinfo_form['FIELDS']['value_field']);
$info_form['FIELDS']['tab_name'] = array_merge($info_form['FIELDS']['tab_name'], $accountinfo_form['FIELDS']['tab_name']);
$config = array_merge($config, $accountinfo_form['CONFIG']);
$other_data['COMMENT_AFTER'] = array_merge($other_data['COMMENT_AFTER'], $accountinfo_form['COMMENT_AFTER']);
$tab_typ_champ = show_field($info_form['FIELDS']['name_field'], $info_form['FIELDS']['type_field'], $info_form['FIELDS']['value_field']);
foreach ($config as $key => $value) {
$tab_typ_champ[$key]['CONFIG'] = $value['CONFIG'];
$tab_typ_champ[$key]['COMMENT_AFTER'] = $other_data['COMMENT_AFTER'][$key];
}
if (isset($tab_typ_champ)) {
tab_modif_values($info_form['FIELDS']['tab_name'], $tab_typ_champ, $tab_hidden, array('show_frame' => false));
}
echo "</div>";
echo close_form();
}
function dde_conf($form_name)
{
global $l, $protectedPost, $protectedGet, $pages_refs, $infos_status;
if ($_SESSION['OCS']['CONFIGURATION']['TELEDIFF_WK'] == 'YES') {
//sous onglets
if ($infos_status['NIV_BIS'] != '') {
$conf_value['GENERAL'] = $l->g(107);
$conf_value['GUI'] = $l->g(84);
}
$conf_value['STATUS'] = $l->g(1095);
//$conf_value['ADMIN']='Administration';
onglet($conf_value, $form_name, "conf", 7);
if ($protectedPost['Valid'] == $l->g(103)) {
$etat = verif_champ();
if ($etat == "") {
$MAJ = update_default_value($protectedPost);
} else {
$msg = "";
foreach ($etat as $name => $value) {
$msg .= $name . " " . $l->g(759) . " " . $value . "<br>";
}
msg_error($msg);
}
}
if (!isset($protectedPost['conf']) or $protectedPost['conf'] == "GENERAL") {
pageTELEDIFF_WK($form_name);
}
if ($protectedPost['conf'] == "GUI") {
//mise a jour des données demandée par l'utilisateur
if ($protectedPost['Valid_fields_x'] != "") {
//si la mise a jour est limitée à certain champs
if (isset($protectedPost['DEFAULT_FIELD'])) {
$fields = explode(',', $protectedPost['DEFAULT_FIELD']);
} else {
$fields = array('type', 'field', 'lbl', 'must_completed', 'value', 'restricted', 'link_status');
//si le type est TEXTAREA, il faut aussi changer le type de la colonne en longtext
if ($protectedPost['type'] == 1) {
$type_modif = "longtext";
} else {
$type_modif = "varchar(255)";
}
$sql_modify_type = 'ALTER TABLE downloadwk_pack change
fields_%1$s
fields_%1$s ' . $type_modif . ' default null;';
$arg = array($protectedPost['FIELDS']);
mysql2_query_secure($sql_modify_type, $_SESSION['OCS']["writeServer"], $arg);
//echo $sql_modify_type;
}
//création de la requête
$sql_update = 'UPDATE downloadwk_fields
set ';
$arg = array();
foreach ($fields as $key => $value) {
$sql_update .= $value . "='%s' ,";
$arg[] = $protectedPost[$value];
}
$sql_update = substr($sql_update, 0, -1) . "where id='%s'";
$arg[] = $protectedPost['FIELDS'];
mysql2_query_secure($sql_update, $_SESSION['OCS']["writeServer"], $arg);
//print_r
//echo $sql_update;
}
$sql_service = "select id,field,value,lbl,default_field \n\t\t\t\t\t\t\t FROM downloadwk_tab_values";
$resultSERV = mysql2_query_secure($sql_service, $_SESSION['OCS']["readServer"]);
$List_tab[] = '';
while ($item = mysql_fetch_object($resultSERV)) {
$lbl = define_lbl($item->lbl, $item->default_field);
$List_tab[$item->id] = $lbl;
}
$name_field = array("TAB");
//$oblig_field['INFO_VALID']=$name_field['INFO_VALID'];
$tab_name = array($l->g(1097) . ":");
$type_field = array(2);
$value_field = array($List_tab);
if (isset($protectedPost['TAB']) and $protectedPost['TAB'] != 0) {
$sql_service = "select id,lbl,default_field \n\t\t\t\t\t\t\t\t FROM downloadwk_fields \n\t\t\t\t\t\t\t\t where TAB='%s'";
$arg = array($protectedPost['TAB']);
$resultSERV = mysql2_query_secure($sql_service, $_SESSION['OCS']["readServer"], $arg);
$List_fields[] = '';
while ($item = mysql_fetch_object($resultSERV)) {
$lbl = define_lbl($item->lbl, $item->default_field);
$List_fields[$item->id] = $lbl;
$default_field[$item->id] = $item->default_field;
}
array_push($name_field, "FIELDS");
array_push($tab_name, $l->g(1096) . ":");
array_push($type_field, 2);
array_push($value_field, $List_fields);
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
$tab_typ_champ[0]['COMMENT_BEHING'] = "<a href=# onclick=window.open(\"index.php?" . PAG_INDEX . "=" . $pages_refs['ms_admin_management'] . "&head=1&admin=tab&value=TAB&form=" . $form_name . "\",\"admin_management\",\"location=0,status=0,scrollbars=0,menubar=0,resizable=0,width=550,height=450\")><img src=image/plus.png></a>";
$tab_typ_champ[0]['RELOAD'] = $form_name;
$tab_typ_champ[1]['RELOAD'] = $form_name;
$tab_typ_champ[1]['COMMENT_BEHING'] = "<a href=# onclick=window.open(\"index.php?" . PAG_INDEX . "=" . $pages_refs['ms_admin_management'] . "&head=1&admin=fields&value=" . $protectedPost['TAB'] . "&form=" . $form_name . "\",\"admin_management\",\"location=0,status=0,scrollbars=0,menubar=0,resizable=0,width=700,height=650\")><img src=image/plus.png></a>";
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $title = "", $comment = "", $name_button = "modif", $showbutton = false, $form_name = 'NO_FORM');
if (isset($protectedPost['FIELDS']) and $protectedPost['FIELDS'] != 0) {
echo "<br>";
$sql_status = "SELECT id,lbl FROM downloadwk_statut_request";
$res_status = mysql2_query_secure($sql_status, $_SESSION['OCS']["readServer"]);
$status['0'] = $l->g(454);
while ($val_status = mysql_fetch_array($res_status)) {
$status[$val_status['id']] = $val_status['lbl'];
}
//print_r($status);
$list_type = array('TEXT', 'TEXTAREA', 'SELECT', 'SHOW DATA', 'PASSWORD', 'CHECKBOX', 'LIST', 'HIDDEN', 'BLOB (FILE)', 'LINK LIST', 'TABLE');
$yes_no = array($l->g(454), $l->g(455));
$sql_detailField = "select type,field,lbl,must_completed,\n\t\t\t\t\t\t\t\t\t\tvalue,restricted,link_status \n\t\t\t\t\t\t\t\t\t FROM downloadwk_fields \n\t\t\t\t\t\t\t\t\t where id='%s' and tab='%s' ";
$arg = array($protectedPost['FIELDS'], $protectedPost['TAB']);
$result_detailField = mysql2_query_secure($sql_detailField, $_SESSION['OCS']["readServer"], $arg);
$item_detailField = mysql_fetch_object($result_detailField);
//if there is no result or more than 1, don't show update table
$num_row = mysql_numrows($result_detailField);
if ($num_row == 1) {
$protectedPost['type'] = $item_detailField->type;
$protectedPost['must_completed'] = $item_detailField->must_completed;
$protectedPost['restricted'] = $item_detailField->restricted;
$protectedPost['link_status'] = $item_detailField->link_status;
$name_field = array('type', 'field', 'lbl', 'must_completed', 'value', 'restricted', 'link_status');
$tab_name = array($l->g(1071) . ':', $l->g(1098) . ':', $l->g(1063) . ':', $l->g(1064) . ':', $l->g(1099) . ':', $l->g(1065) . ':', $l->g(1066) . ':');
if ($default_field[$protectedPost['FIELDS']]) {
$title = $l->g(1101);
//$showbutton=false;
$type_field = array(3, 3, 3, 3, 0, 3, 3, 7);
$value_field = array($list_type[$item_detailField->type], $item_detailField->field, $l->g($item_detailField->lbl), $yes_no[$item_detailField->must_completed], $item_detailField->value, $yes_no[$item_detailField->restricted], $status[$item_detailField->link_status], 'value');
if ($item_detailField->field == "STATUS") {
$type_field[4] = 2;
unset($status[0]);
$value_field[4] = $status;
$protectedPost['value'] = $item_detailField->value;
}
$name_field[7] = 'DEFAULT_FIELD';
$tab_name[7] = '';
} else {
$title = "";
//$showbutton=true;
$type_field = array(2, 0, 0, 2, 0, 2, 2);
$value_field = array($list_type, $item_detailField->field, $item_detailField->lbl, $yes_no, $item_detailField->value, $yes_no, $status);
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $title, $comment = "", $name_button = "fields", $showbutton = true, $form_name = 'NO_FORM');
}
}
} elseif ($protectedPost['conf'] == "STATUS") {
//mise à jour des valeurs de statuts
if ($protectedPost['Valid_fields_x'] != '') {
if (trim($protectedPost['lbl']) != '') {
$sql_update = "UPDATE downloadwk_statut_request\n\t\t\t\t\t\t\t\t\t\tset LBL='%s' , ACTIF='%s'\n\t\t\t\t\t\t\t\t\t\twhere ID='%s'";
$arg = array($protectedPost['lbl'], $protectedPost['actif'], $protectedPost['id']);
mysql2_query_secure($sql_update, $_SESSION['OCS']["writeServer"], $arg);
msg_success($l->g(1121));
} else {
msg_error($l->g(988));
}
}
$infos_status = list_status(false);
$name_field = array("STATUS");
$tab_name = array($l->g(1100) . ":");
$type_field = array(2);
$value_field = array($infos_status['STAT']);
if (isset($protectedPost['STATUS']) and $protectedPost['STATUS'] != 0) {
//delete old post if you change status
if (isset($protectedPost['OLD_STATUS']) and $protectedPost['OLD_STATUS'] != $protectedPost['STATUS']) {
unset($protectedPost['actif'], $protectedPost['lbl'], $protectedPost['name']);
}
$yes_no = array($l->g(454), $l->g(455));
if (!isset($protectedPost['actif'])) {
$protectedPost['actif'] = $infos_status['ACTIF'][$protectedPost['STATUS']];
}
if (!isset($protectedPost['lbl'])) {
$protectedPost['lbl'] = $infos_status['STAT_BIS'][$protectedPost['STATUS']];
}
if (!isset($protectedPost['name'])) {
$protectedPost['name'] = $infos_status['NIV'][$protectedPost['STATUS']];
}
$protectedPost['id'] = $protectedPost['STATUS'];
array_push($name_field, 'actif', 'id', 'lbl', 'name', 'OLD_STATUS');
array_push($tab_name, $l->g(1102) . ':', $l->g(1103) . ':', $l->g(1063) . ':', $l->g(1064) . ':', '');
array_push($type_field, 2, 3, 0, 3, 7);
array_push($value_field, $yes_no, $protectedPost['id'], $protectedPost['lbl'], $protectedPost['name'], $protectedPost['STATUS']);
$showbutton = true;
} else {
$showbutton = false;
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
$tab_typ_champ[0]['RELOAD'] = $form_name;
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $title, $comment = "", $name_button = "fields", $showbutton, $form_name = 'NO_FORM');
}
}
}
$result_exist = ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del);
//if your profil is an admin groups, you can create one
if ($_SESSION['OCS']['profile']->getConfigValue('GROUPS') == "YES") {
echo "</td></tr></table>";
if ($protectedPost['onglet'] == "STAT") {
echo "<p><input type='submit' name='add_static_group' value='" . $l->g(587) . "'></p>";
}
}
//if user want add a new group
if (isset($protectedPost['add_static_group']) and $_SESSION['OCS']['profile']->getConfigValue('GROUPS') == "YES") {
//NAME FIELD
$name_field[] = "NAME";
$tab_name[] = $l->g(577);
$type_field[] = 0;
$value_field[] = $protectedPost['NAME'];
$name_field[] = "DESCR";
$tab_name[] = $l->g(53);
$type_field[] = 1;
$value_field[] = $protectedPost['DESCR'];
$tab_typ_champ = show_field($name_field, $type_field, $value_field);
$tab_typ_champ[0]['CONFIG']['SIZE'] = 20;
$tab_hidden['add_static_group'] = 'add_static_group';
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('form_name' => 'NO_FORM', 'show_frame' => false));
}
echo '</div>';
//fermeture du formulaire
echo close_form();
if ($ajax) {
ob_end_clean();
tab_req($list_fields, $default_fields, $list_col_cant_del, $querygroup, $tab_options);
}
} else {
$sql = "update config set IVALUE='%s' where name='%s'";
$arg = array($protectedPost["nb_total"], $name_to_update);
}
mysql2_query_secure($sql, $_SESSION['OCS']["writeServer"], $arg);
}
}
if (isset($protectedPost["MODIF"]) and $protectedPost["MODIF"] != '') {
$showbutton = true;
$tab_hidden = array('NUM_OFF' => $protectedPost["MODIF"]);
$type_field = array(0);
$name_field = array("nb_total");
$tab_name = array($l->g(6004) . " : ");
$value_field = array($protectedPost['nb_total']);
$config['JAVASCRIPT'][0] = $chiffres;
$tab_typ_champ = show_field($name_field, $type_field, $value_field, $config);
$tab_typ_champ[0]['CONFIG']['SIZE'] = 20;
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $title, $comment = "", $name_button = "modif", $showbutton);
} else {
$list_fields = array($l->g(36) => 'officekey', $l->g(66) => 'officeversion', $l->g(55) => 'NB', $l->g(6004) => 'NB_TOTAL', "PERCENT_BAR" => 'POURC', 'MODIF' => 'officekey');
$list_col_cant_del = $list_fields;
$default_fields = $list_fields;
$tab_options['LBL']['PERCENT_BAR'] = $l->g(1125);
$queryDetails = "select count(id) NB,\n\t\t\t\t\t\t\t\t\t officekey,\n\t\t\t\t\t\t\t\t\t officeversion,\n\t\t\t\t\t\t\t\t\t ivalue NB_TOTAL,\n\t\t\t\t\t\t\t\t\t round(count(id)*100/ivalue) POURC \n\t\t\t\t\t\t\tfrom officepack left join config on tvalue=officekey\n\t\t\t\t\t\t\tgroup by officekey";
tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $queryDetails, $form_name, 80, $tab_options);
}
}
}
?>
$config['SIZE'][0] = '8';
$tab_name = array($l->g(1295), $l->g(1294), $l->g(443));
$name_field = array("INSTALL_DATE", "INSTALL_HEURE", "DOWNLOAD_POSTCMD");
$type_field = array(0, 2, 2);
$value_field = array($protectedPost['INSTALL_DATE'], $hour_min, $action);
if ($protectedGet['origine'] != 'group') {
array_push($tab_name, $l->g(1293));
array_push($name_field, "TELE_FORCE");
array_push($type_field, 5);
array_push($value_field, array(''));
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field, $config);
// p($tab_typ_champ);
$tab_typ_champ[2]['CONFIG']['DEFAULT'] = 'YES';
//$configinput['DEFAULT'] == "YES"
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $l->g(1309));
} else {
if (isset($protectedPost['MODIF'])) {
$protectedPost['SELECT'] = $protectedPost['MODIF'];
$protectedPost['Valid_modif_x'] = true;
}
if ($protectedPost['SELECT'] != '' and isset($protectedPost['Valid_modif_x'])) {
if (isset($protectedPost['TELE_FORCE_0'])) {
active_option('DOWNLOAD_FORCE', $list_id, $protectedPost['SELECT'], '1');
}
if (isset($protectedPost['INSTALL_DATE']) and $protectedPost['INSTALL_DATE'] != '') {
$date = explode('/', $protectedPost['INSTALL_DATE']);
if ($l->g(269) == "%m/%d/%Y") {
$install_date = $date[2] . "/" . $date[0] . "/" . $date[1] . " " . $protectedPost['INSTALL_HEURE'];
} else {
$install_date = $date[2] . "/" . $date[1] . "/" . $date[0] . " " . $protectedPost['INSTALL_HEURE'];
$tab_typ_champ[1]['CONFIG']['MAXLENGTH'] = 255;
$tab_name[1] = $l->g(53) . ": ";
$sql = "select distinct NAME from devicetype ";
$res = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"]);
while ($row = mysql_fetch_object($res)) {
$list_type[$row->NAME] = $row->NAME;
}
$tab_typ_champ[2]['DEFAULT_VALUE'] = $list_type;
$tab_typ_champ[2]['INPUT_NAME'] = "TYPE";
$tab_typ_champ[2]['INPUT_TYPE'] = 2;
$tab_name[2] = $l->g(66) . ": ";
$tab_hidden['mac'] = $protectedPost['MODIF'];
if (isset($ERROR)) {
msg_error($ERROR);
}
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $title, $comment = "");
} else {
//affichage des p�riph�riques
if (!isset($protectedPost["pcparpage"])) {
$protectedPost["pcparpage"] = 5;
}
if (isset($protectedGet['value'])) {
if ($protectedGet['prov'] == "no_inv") {
$title = $l->g(947);
$sql = "SELECT ip, mac, mask, date, name\n\t\t\t\tFROM netmap n \n\t\t\t\tLEFT JOIN networks ns ON ns.macaddr=n.mac\n\t\t\t\tWHERE n.netid='%s' \n\t\t\t\tAND (ns.macaddr IS NULL OR ns.IPSUBNET <> n.netid) \n\t\t\t\tAND mac NOT IN (SELECT DISTINCT(macaddr) FROM network_devices)\n\t\t\t\tAND ns.HARDWARE_ID IS NULL";
$tab_options['ARG_SQL'] = array($protectedGet['value'], $protectedGet['value']);
$list_fields = array($l->g(34) => 'ip', 'MAC' => 'mac', $l->g(208) => 'mask', $l->g(232) => 'date', $l->g(318) => 'name');
$tab_options['FILTRE'] = array_flip($list_fields);
$tab_options['ARG_SQL_COUNT'] = array($protectedGet['value']);
$list_fields['SUP'] = 'mac';
$list_fields['MODIF'] = 'mac';
$tab_typ_champ[0]['CONFIG']['SIZE'] = 60;
$tab_typ_champ[0]['CONFIG']['MAXLENGTH'] = 255;
$tab_typ_champ[0]['INPUT_TYPE'] = 0;
$tab_name[0] = $l->g(252) . ": ";
$tab_typ_champ[1]['DEFAULT_VALUE'] = $list_registry_key;
$tab_typ_champ[1]['INPUT_NAME'] = "REGTREE";
$tab_typ_champ[1]['INPUT_TYPE'] = 2;
$tab_name[1] = $l->g(253) . ":";
$tab_typ_champ[2]['DEFAULT_VALUE'] = $protectedPost['REGKEY'];
$tab_typ_champ[2]['INPUT_NAME'] = "REGKEY";
$tab_typ_champ[2]['CONFIG']['SIZE'] = 60;
$tab_typ_champ[2]['CONFIG']['MAXLENGTH'] = 255;
$tab_name[2] = $l->g(254) . ": ";
$tab_typ_champ[3]['DEFAULT_VALUE'] = $protectedPost['REGVALUE'];
$tab_typ_champ[3]['INPUT_NAME'] = "REGVALUE";
$tab_typ_champ[3]['CONFIG']['SIZE'] = 60;
$tab_typ_champ[3]['CONFIG']['MAXLENGTH'] = 255;
$tab_typ_champ[3]['INPUT_TYPE'] = 0;
$tab_name[3] = $l->g(255) . ": ";
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('show_frame' => false));
}
echo "</div>";
echo close_form();
if ($ajax) {
ob_end_clean();
if (is_array($sql)) {
tab_req($list_fields, $default_fields, $list_col_cant_del, $sql['SQL'], $tab_options);
} else {
tab_req($list_fields, $default_fields, $list_col_cant_del, $sql, $tab_options);
}
}
$config['SIZE'][0] = '8';
$tab_name = array($l->g(1295), $l->g(1294), $l->g(443));
$name_field = array("INSTALL_DATE", "INSTALL_HEURE", "DOWNLOAD_POSTCMD");
$type_field = array(0, 2, 2);
$value_field = array($protectedPost['INSTALL_DATE'], $hour_min, $action);
if ($protectedGet['origine'] != 'group') {
array_push($tab_name, $l->g(1293));
array_push($name_field, "TELE_FORCE");
array_push($type_field, 5);
array_push($value_field, array(''));
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field, $config);
// p($tab_typ_champ);
$tab_typ_champ[2]['CONFIG']['DEFAULT'] = 'YES';
//$configinput['DEFAULT'] == "YES"
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('title' => $l->g(1309)));
} else {
if (isset($protectedPost['MODIF'])) {
$protectedPost['SELECT'] = $protectedPost['MODIF'];
$protectedPost['Valid_modif'] = true;
}
if ($protectedPost['SELECT'] != '' and isset($protectedPost['Valid_modif'])) {
if (isset($protectedPost['TELE_FORCE_0'])) {
active_option('DOWNLOAD_FORCE', $list_id, $protectedPost['SELECT'], '1');
}
if (isset($protectedPost['INSTALL_DATE']) and $protectedPost['INSTALL_DATE'] != '') {
$date = explode('/', $protectedPost['INSTALL_DATE']);
if ($l->g(269) == "%m/%d/%Y") {
$install_date = $date[2] . "/" . $date[0] . "/" . $date[1] . " " . $protectedPost['INSTALL_HEURE'];
} else {
$install_date = $date[2] . "/" . $date[1] . "/" . $date[0] . " " . $protectedPost['INSTALL_HEURE'];
array_push($type_field, 0);
array_push($value_field, $protectedPost['newlbl']);
if ($protectedGet['admin'] == "fields") {
array_push($name_field, "newtype");
array_push($tab_name, $l->g(1071) . ":");
array_push($type_field, 2);
array_push($value_field, $multi_choice);
array_push($name_field, "must_completed");
array_push($tab_name, $l->g(1064) . ":");
array_push($type_field, 2);
array_push($value_field, $yes_no);
array_push($name_field, "restricted");
array_push($tab_name, $l->g(1065) . ":");
array_push($type_field, 2);
array_push($value_field, $yes_no);
array_push($name_field, "link_status");
array_push($tab_name, $l->g(1066) . ":");
array_push($type_field, 2);
array_push($value_field, $status);
}
}
$tab_typ_champ = show_field($name_field, $type_field, $value_field, $config);
$tab_typ_champ[0]['CONFIG']['SIZE'] = 20;
$tab_typ_champ[1]['CONFIG']['SIZE'] = 20;
tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, $title = "", $comment = "", $name_button = "modif", $showbutton = true, $form_name = 'NO_FORM');
}
echo "</div>";
echo close_form();
?>
$list_mode[6] = 'NOCACHE';
} else {
$list_mode[6] = 'CACHE';
}
$tab_typ_champ[0]['DEFAULT_VALUE'] = $list_mode;
$tab_typ_champ[0]['INPUT_NAME'] = "MODE";
$tab_typ_champ[0]['INPUT_TYPE'] = 2;
$tab_name[0] = $l->g(1014) . ":";
$tab_typ_champ[0]['RELOAD'] = "CHANGE";
if ($protectedPost['MODE'] == 5 and $list_mode[$protectedPost['MODE']] == 'FUSER') {
$tab_typ_champ[1]['DEFAULT_VALUE'] = $protectedPost['FUSER'];
$tab_typ_champ[1]['INPUT_NAME'] = "FUSER";
$tab_typ_champ[1]['INPUT_TYPE'] = 0;
$tab_name[1] = $l->g(926) . " ";
}
tab_modif_values($tab_name, $tab_typ_champ, '', $l->g(1015), $comment = "");
if (isset($protectedPost['Reset_modif_x'])) {
reloadform_closeme('', true);
}
//passage en mode
if (isset($protectedPost['Valid_modif_x']) and $protectedPost["MODE"] != "") {
AddLog("MODE", $list_mode[$protectedPost["MODE"]]);
if ($protectedPost["MODE"] == 1) {
unset($_SESSION['OCS']['DEBUG'], $_SESSION['OCS']['MODE_LANGUAGE'], $_SESSION['OCS']["usecache"]);
} elseif ($protectedPost["MODE"] == 2) {
unset($_SESSION['OCS']['MODE_LANGUAGE']);
$_SESSION['OCS']['DEBUG'] = "ON";
} elseif ($protectedPost["MODE"] == 3) {
unset($_SESSION['OCS']['DEBUG']);
$_SESSION['OCS']['MODE_LANGUAGE'] = "ON";
} elseif ($protectedPost["MODE"] == 4) {
