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 = 'INSERT INTO ' . K_TABLE_CABLES . ' (
cab_a_obj_id,
cab_b_obj_id,
cab_cbt_id,
cab_color
) VALUES (
' . $cab_a_obj_id . ',
' . $cab_b_obj_id . ',
' . $cab_cbt_id . ',
\'' . F_escape_sql($cab_color) . '\'
)';
if (!($r = F_db_query($sql, $db))) {
F_display_db_error(false);
/**
* Check Form Fields.
* see: F_check_required_fields, F_check_fields_format
* @return false in case of error, true otherwise
*/
function F_check_form_fields()
{
require_once '../config/tce_config.php';
global $l;
$formfields = F_decode_form_fields();
//decode form fields
//check missing fields
if ($missing_fields = F_check_required_fields($formfields)) {
F_print_error('WARNING', $l['m_form_missing_fields'] . ': ' . $missing_fields);
F_stripslashes_formfields();
return FALSE;
}
//check fields format
if ($wrong_fields = F_check_fields_format($formfields)) {
F_print_error('WARNING', $l['m_form_wrong_fields'] . ': ' . $wrong_fields);
F_stripslashes_formfields();
return FALSE;
}
return TRUE;
}
