1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
function IF_log_changes($table, $where, $id, $modifier_id, $new_values, $bug_id,$link_id){
$select = new DB_nextbug;
$insert = new DB_nextbug;
// Recuperation des anciennes valeurs
$local_query = sprintf("SELECT *
FROM %s %s", $table, $where);
$select->query($local_query);
$select->next_record();
while (list($name, $value) = each($new_values) ) {
if ( $value != $select->f($name) ) {
$local_query = sprintf("INSERT INTO activity (table_name, field_name, old_value, new_value, date, owner_id, id, link_id)
VALUES('%s', '%s', '%s', '%s', NOW(), %d, %d, %d)", $table, $name, addslashes($select->f($name)), addslashes($value), $modifier_id, $bug_id, $link_id);
$insert->query($local_query);
}
}
} |
Partager