add_suivi2($_POST["etape"], $id_user, $id, "evaluation", $field, $val_1_eval[$field], $val_2[$field], 'eee', 'manuel', $modif); } } unset($val_1_eval); unset($val_2); } if ($niveau >= 64) { /*Commentaire sur le taxon*/ $ligne = sql_assoc("SELECT commentaire FROM eee.taxons WHERE uid= {$id};", true); foreach ($ligne as $field => $val_1) { $val_2 = $_POST[$field]; $modif = check_modif($val_1, $val_2, $field); if ($modif != 'vide' and $modif != 'identiques') { add_suivi2($_POST["etape"], $id_user, $id, "taxons", $field, $val_1, $val_2, 'eee', 'manuel', $modif); /*Suivi*/ sql_assoc("UPDATE eee.taxons SET {$field} = " . frt($field, $val_2) . " WHERE uid={$id};", false); } } /*Commentaire sur la fiche*/ if (isset($_POST['commentaire_eval'])) { if (!empty($_POST['commentaire_eval'])) { $result = pg_query($db, $query_user . " AND id_user = '******'") or die("Erreur pgSQL : " . pg_result_error($result)); $user = pg_fetch_array($result, NULL, PGSQL_ASSOC); $insert = "INSERT INTO eee.discussion (uid,id_user,nom,prenom,id_cbn,commentaire_eval,datetime) \n\t\t\t\tVALUES ({$id},'{$user['id_user']}','{$user['nom']}','{$user['prenom']}',{$user['id_cbn']}," . sql_format_quote($_POST[commentaire_eval], 'do') . ",NOW())"; // echo $insert; $result = pg_query($db, $insert) or die("Erreur pgSQL : " . pg_result_error($result)); add_suivi2($etape, $id_user, $id, "discussion", "commentaire_eval", "", sql_format_quote($_POST[commentaire_eval], 'do'), $id_page, 'manuel', "ajout"); } } } } else {
$val_1 = "non"; } $modif = check_modif($val_1, $val_2, $field); if (DEBUG) { echo $field . " -> " . $val_1 . " | " . $val_2 . "<br>"; } if ($modif != 'vide' and $modif != 'identiques') { add_suivi2($etape, $id_user, $id, "statut_nat", $field, $val_1, $val_2, 'catnat', 'manuel', $modif); } } pg_free_result($result); unset($val_1); unset($val_2); // if (isset($ref[$champ_ref["statut_".$type_stt]])) {$res_new = ;} else {$res_new = $new_val;} $indi = frt('indi', $ref[$champ_ref['indi']][$_POST['INDI']]); $query = "UPDATE catnat.statut_nat SET indi=" . $indi . ", lr=" . frt('lr', $_POST['LR']) . ", rarete=" . frt('rarete', $_POST['RAR']) . ", endemisme=" . frt('endemisme', $_POST['END']) . ", presence=" . frt('presence', $_POST['PRES']) . " WHERE uid = {$id};"; if (DEBUG) { echo "<BR>{$query}"; } $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query); } if ($niveau >= 64) { /*Commentaires Taxon*/ $query = "SELECT commentaire FROM catnat.taxons_nat WHERE uid=" . $id . ";"; if (DEBUG) { echo "<br>" . $query; } $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query); $backup = pg_fetch_array($result, NULL, PGSQL_ASSOC); foreach ($backup as $field => $val_1) { $val_2 = $_POST[$field];