cantico / absences

	$req = "select id from ".ABSENCES_TYPES_TBL." where name='".$babDB->db_escape_string($tname)."'";

	$res = $babDB->db_query($req);

	if( $res && $babDB->db_num_rows($res) > 0 )

		{

		$babBody->msgerror = absences_translate("This vacation type already exists") ." !";

		return false;

		}

	$req = "insert into ".ABSENCES_TYPES_TBL." ( name, description, quantity, maxdays, mindays, defaultdays, color, recover)";

	$req .= " values (

	$req = "SELECT id from ".ABSENCES_TYPES_TBL." WHERE name='".$babDB->db_escape_string($tname)."' AND id!='".$babDB->db_escape_string($vtid)."'";

	$res = $babDB->db_query($req);

	if( $res && $babDB->db_num_rows($res) > 0 )

		{

		$babBody->msgerror = absences_translate("This vacation type already exists") ." !";

		return false;

		}

	$req = "UPDATE ".ABSENCES_TYPES_TBL."

		SET

	$req = "select id from ".ABSENCES_COLLECTIONS_TBL." where name='".$babDB->db_escape_string($tname)."'";

	$res = $babDB->db_query($req);

	if( $res && $babDB->db_num_rows($res) > 0 )

		{

		$babBody->msgerror = absences_translate("This collection already exists") ." !";

		return false;

		}

	$req = "insert into ".ABSENCES_COLLECTIONS_TBL." ( name, description, id_cat )";

	$req .= " values ('".$babDB->db_escape_string($tname)."', '" .$babDB->db_escape_string($description)."', '" .$babDB->db_escape_string($category). "')";

	$req = "select id from ".ABSENCES_COLLECTIONS_TBL." where name='".$babDB->db_escape_string($tname)."' and id!='".$babDB->db_escape_string($vcid)."'";

	$res = $babDB->db_query($req);

	if( $res && $babDB->db_num_rows($res) > 0 )

		{

		$babBody->msgerror = absences_translate("This collection already exists") ." !";

		return false;

		}

	$res = $babDB->db_query("update ".ABSENCES_COLLECTIONS_TBL." set name='".$babDB->db_escape_string($tname)."', description='".$babDB->db_escape_string($description)."', id_cat='".$babDB->db_escape_string($category)."' where id='".$babDB->db_escape_string($vcid)."'");