break;
}
if ($formstatus = F_check_form_fields()) {
$sql = 'UPDATE ' . K_TABLE_CABLES . ' SET
cab_color=\'' . F_escape_sql($cab_color) . '\'
WHERE cab_a_obj_id=' . $cab_a_obj_id . ' AND cab_b_obj_id=' . $cab_b_obj_id . ' AND cab_cbt_id=' . $cab_cbt_id . '';
if (!($r = F_db_query($sql, $db))) {
F_display_db_error(false);
} else {
F_print_error('MESSAGE', $l['m_updated']);
}
}
break;
case 'add':
// Add
if ($formstatus = F_check_form_fields()) {
// check submitted form fields
// check for loop connection
if ($cab_a_obj_id == $cab_b_obj_id) {
F_print_error('WARNING', $l['m_connection_loop']);
$formstatus = false;
F_stripslashes_formfields();
break;
}
// check if the connection is unique
if (!F_check_unique(K_TABLE_CABLES, 'cab_a_obj_id=' . $cab_a_obj_id . ' AND cab_b_obj_id=' . $cab_b_obj_id . ' AND cab_cbt_id=' . $cab_cbt_id)) {
F_print_error('WARNING', $l['m_duplicate_connection']);
$formstatus = false;
F_stripslashes_formfields();
break;
}
}
$sql = 'UPDATE ' . K_TABLE_SSLCERTS . ' SET
ssl_name=\'' . F_escape_sql($db, $ssl_name) . '\',
ssl_enabled=\'' . intval($ssl_enabled) . '\',
ssl_user_id=\'' . $ssl_user_id . '\'
WHERE ssl_id=' . $ssl_id . '';
if (!($r = F_db_query($sql, $db))) {
F_display_db_error(false);
} else {
F_print_error('MESSAGE', $l['m_updated']);
}
}
break;
case 'add':
// Add
if ($formstatus = F_check_form_fields() and strlen($ssl_hash) == 32) {
// check if name is unique
if (!F_check_unique(K_TABLE_SSLCERTS, 'ssl_name=\'' . F_escape_sql($db, $ssl_name) . '\'')) {
F_print_error('WARNING', $l['m_duplicate_name']);
$formstatus = FALSE;
F_stripslashes_formfields();
break;
}
if ($_SESSION['session_user_level'] >= K_AUTH_ADMINISTRATOR) {
$ssl_user_id = intval($ssl_user_id);
} else {
$ssl_user_id = intval($_SESSION['session_user_id']);
}
$sql = 'INSERT INTO ' . K_TABLE_SSLCERTS . ' (
ssl_name,
ssl_hash,
