$error_detected[] = _T("- The name field cannot be void.");
} else {
$field_name = $_POST["field_name"];
$field_perm = $_POST["field_perm"];
$field_type = $_POST["field_type"];
$field_required = $_POST["field_required"];
$field_pos = $_POST["field_pos"];
$query = "SELECT COUNT(*) + 1 AS idx\n\t\t\t\t\t FROM {$field_types_table}\n\t\t\t\t\t WHERE field_form={$quoted_form_name}";
$idx = db_get_one($DB, $query, $error_detected);
if ($idx != false) {
$DB->StartTrans();
$quoted_field_name = $DB->qstr($field_name, get_magic_quotes_gpc());
$query = "INSERT INTO {$field_types_table}\n\t\t\t\t\t\t (field_index, field_form, field_name, field_perm, field_type, field_required, field_pos)\n\t\t\t\t\t\t VALUES ({$idx}, {$quoted_form_name}, {$quoted_field_name}, {$field_perm}, {$field_type}, {$field_required}, {$field_pos})";
db_execute($DB, $query, $error_detected);
if ($field_type != $field_type_separator && count($error_detected) == 0) {
$field_id = get_last_auto_increment($DB, $field_types_table, "field_id", $error_detected);
header("location: editer_champ.php?form={$form_name}&id={$field_id}");
}
if ($field_name != '') {
add_dynamic_translation($DB, $field_name, $error_detected);
}
$DB->CompleteTrans();
}
}
} else {
$action = "";
$field_id = "";
foreach (array("del", "up", "down") as $varname) {
if (isset($_GET[$varname]) && is_numeric($_GET[$varname])) {
$action = $varname;
$field_id = (int) $_GET[$varname];
}
}
}
// missing required fields?
while (list($key, $val) = each($required)) {
if (!isset($disabled[$key]) && (!isset($adherent[$key]) || trim($adherent[$key]) == '')) {
$error_detected[] = _T("- Mandatory field empty.") . " ({$key})";
}
}
if (count($error_detected) == 0) {
if ($adherent["id_adh"] == "") {
$requete = "INSERT INTO " . PREFIX_DB . "adherents\n\t\t\t\t(" . substr($insert_string_fields, 1) . ")\n\t\t\t\tVALUES (" . substr($insert_string_values, 1) . ")";
if (!$DB->Execute($requete)) {
print substr($insert_string_values, 1) . ": " . $DB->ErrorMsg();
}
$adherent['id_adh'] = get_last_auto_increment($DB, PREFIX_DB . "adherents", "id_adh");
// to allow the string to be extracted for translation
$foo = _T("Member card added");
// logging
//nom_adh and prenom_adh is not sent when form is used by a simple user
//dblog('Member card updated:',strtoupper($_POST["nom_adh"]).' '.$_POST["prenom_adh"], $requete);
dblog('Member card updated:', strtoupper($_POST["login_adh"]), $requete);
} else {
$requete = "UPDATE " . PREFIX_DB . "adherents\n SET " . substr($update_string, 1) . "\n WHERE id_adh=" . $adherent['id_adh'];
$DB->Execute($requete);
// to allow the string to be extracted for translation
$foo = _T("Member card updated:");
// logging
//nom_adh and prenom_adh is not sent when form is used by a simple user
//dblog('Member card updated:',strtoupper($_POST["nom_adh"]).' '.$_POST["prenom_adh"], $requete);
dblog('Member card updated:', strtoupper($_POST["login_adh"]), $requete);
$missing_amount = missing_contrib_amount($DB, $contribution['trans_id'], $error_detected);
if ($missing_amount < $contribution['montant_cotis']) {
$error_detected[] = _T("- Sum of all contributions exceed corresponding transaction amount.");
} else {
$missing_amount -= $contribution['montant_cotis'];
}
}
}
if (count($error_detected) == 0) {
//Get user's login to put it in the logs
$query = 'SELECT login_adh FROM ' . PREFIX_DB . 'adherents WHERE id_adh=' . $contribution['id_adh'];
$login = $DB->GetOne($query);
if ($contribution["id_cotis"] == "") {
$requete = "INSERT INTO " . PREFIX_DB . "cotisations\n\t\t\t\t(" . substr($insert_string_fields, 1) . ")\n\t\t\t\tVALUES (" . substr($insert_string_values, 1) . ")";
if (db_execute($DB, $requete, $error_detected)) {
$contribution['id_cotis'] = get_last_auto_increment($DB, PREFIX_DB . "cotisations", "id_cotis");
// to allow the string to be extracted for translation
$foo = _T("Contribution added");
// logging
dblog('Contribution added', strtoupper($login), $requete);
}
} else {
$requete = "UPDATE " . PREFIX_DB . "cotisations\n SET " . substr($update_string, 1) . "\n WHERE id_cotis=" . $contribution['id_cotis'];
if (db_execute($DB, $requete, $error_detected)) {
// to allow the string to be extracted for translation
$foo = _T("Contribution updated");
// logging
dblog('Contribution updated', strtoupper($login), $requete);
}
}
// dynamic fields
} else {
if ($contrib_amount > $transaction['trans_amount']) {
$error_detected[] = _T("- Sum of all contributions exceed corresponding transaction amount.");
}
}
if ($transaction['id_adh'] <= 0) {
$error_detected[] = _T("- No originator selected (register a non-member first if necessary).");
}
}
if (count($error_detected) == 0) {
if ($transaction["trans_id"] == "") {
$requete = "INSERT INTO " . PREFIX_DB . "transactions\n\t\t\t(" . substr($insert_string_fields, 1) . ")\n\t\t\tVALUES (" . substr($insert_string_values, 1) . ")";
if (!$DB->Execute($requete)) {
print "{$requete}: " . $DB->ErrorMsg();
}
$transaction['trans_id'] = get_last_auto_increment($DB, PREFIX_DB . "transactions", "trans_id");
// to allow the string to be extracted for translation
$foo = _T("transaction added");
// logging
dblog('transaction added', '', $requete);
} else {
$requete = "UPDATE " . PREFIX_DB . "transactions\n\t\t\t\t SET " . substr($update_string, 1) . "\n\t\t\t\t WHERE trans_id=" . $transaction['trans_id'];
$DB->Execute($requete);
// to allow the string to be extracted for translation
$foo = _T("transaction updated");
// logging
dblog('transaction updated', '', $requete);
}
// dynamic fields
set_all_dynamic_fields($DB, 'trans', $transaction['trans_id'], $transaction['dyn']);
if ($missing_amount > 0) {
