function abm_rel_rel($do, $rel_id, $rel_type_id)
{
global $DBCFG;
//sanitize
$rel_id = secure_data($rel_id, "int");
$rel_type_id = secure_data($rel_type_id, "int");
$userId = $_SESSION[$_SESSION["CFGURL"]][ssuser_id];
switch ($do) {
case 'ALTA':
//check if the type relation exist
$ARRAYdataRelation = ARRAYdataRelation($rel_id);
$ARRAYtypeRelations = ARRAYtypeRelations($ARRAYdataRelation[t_relacion], $rel_type_id);
if (count($ARRAYtypeRelations["{$ARRAYdataRelation['t_relacion']}"]) == '1') {
$sql = SQL("update", " {$DBCFG['DBprefix']}tabla_rel set rel_rel_id='{$rel_type_id}', cuando=now(),uid='{$userId}' where id='{$rel_id}'");
}
break;
case 'BAJA':
$sql = SQL("update", " {$DBCFG['DBprefix']}tabla_rel set rel_rel_id='NULL', cuando=now(),uid='{$userId}' where id='{$rel_id}'");
break;
default:
}
return array("rel_id" => $rel_id);
}
echo ' ' . $_POST[code_tema] . ': ' . MSG_ERROR_CODE . ' (' . LABEL_Termino . ' ' . $task[tema] . ')';
break;
}
}
}
//gestión de codigo de tema
if ($_POST["edit_tema_id"]) {
$tema_id = str_replace("edit_tema", "", $_POST["edit_tema_id"]);
//additional secure check
$string_term = trim($_POST["edit_tema"]);
if (is_numeric($tema_id) && strlen($string_term) > 0) {
$task = abm_tema('mod', $string_term, $tema_id);
}
$arrayTerm = ARRAYverTerminoBasico($tema_id);
echo $arrayTerm[tema];
}
//abm for relations defined by user
if ($_POST["edit_rel_id"]) {
$rel_id = str_replace("edit_rel_id", "", $_POST["edit_rel_id"]);
//eliminar relación ==
if ($_POST[rel_rel_id] == '0') {
$task = abm_rel_rel("BAJA", $rel_id, $_POST[rel_rel_id]);
} elseif (is_numeric($_POST[rel_rel_id])) {
$task = abm_rel_rel("ALTA", $rel_id, $_POST[rel_rel_id]);
}
$arrayRelData = ARRAYdataRelation($task[rel_id]);
$labelRel = LABELrelTypeSYS($arrayRelData[t_relation]);
//reverse or not view of the relation
echo $_POST[relativeLabel] == 'X' ? $labelRel[rx_code] . $arrayRelData[rr_code] : $labelRel[r_code] . $arrayRelData[rr_code];
}
}
