$result = add_type($protectedPost['TYPE_NAME'], $protectedPost['MODIF']); if ($result) { msg_error($result); $protectedPost['ADD_TYPE'] = "VALID"; } else { $protectedPost = ''; $tab_options['CACHE'] = 'RESET'; $msg_ok = $l->g(1121); } } if ($protectedPost['MODIF'] != '') { echo "<input type='hidden' name='MODIF' id='MODIF' value='" . $protectedPost['MODIF'] . "'"; } if (isset($protectedPost['ADD_TYPE']) or $protectedPost['MODIF']) { if ($protectedPost['MODIF']) { $info = find_info_type('', $protectedPost['MODIF']); $protectedPost['TYPE_NAME'] = $info->NAME; } $tab_typ_champ[0]['DEFAULT_VALUE'] = $protectedPost['TYPE_NAME']; $tab_typ_champ[0]['INPUT_NAME'] = "TYPE_NAME"; $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(938) . ": "; $tab_hidden['pcparpage'] = $protectedPost["pcparpage"]; tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('title' => $title, 'show_frame' => false)); } else { if (isset($msg_ok)) { msg_success($msg_ok); } $sql = "select ID,NAME from devicetype";
function add_type($name, $update = '') { global $l; if (trim($name) == '') { return $l->g(936); } else { $row = find_info_type($name, '', $update); if (isset($row->ID)) { return $l->g(937); } } if ($update != '') { $sql = "update devicetype set NAME = '%s' where ID = '%s' "; $arg = array($name, $update); } else { $sql = "insert into devicetype (NAME) VALUES ('%s')"; $arg = $name; } mysql2_query_secure($sql, $_SESSION['OCS']["writeServer"], $arg); return false; }