Hello, I am trying to integrate Mantis (V1.2.1) to Subversion using SCMbug. I am trying to get the timestamp for the Mantis notes and note history to come out right. Here is what a note header looks like: (0000362) <http://evus-hgmth41:8888/mantis/view.php?id=80#c362> aschatte <http://evus-hgmth41:8888/mantis/view_user_page.php?id=23> (developer) 1969-12-31 18:00
The corresponding Note History looks like: 1969-12-31 18:33 aschatte <http://evus-hgmth41:8888/mantis/view_user_page.php?id=23> Note Added: 0000363 How do I get the right date? This appears to be generated by a database call in Mantis.pm (line 466): # Associate the comment with the bug $sql = "INSERT INTO mantis_bugnote_table(bug_id, reporter_id, bugnote_text_id, view_state, date_submitted, last_modified) VALUES(?,?,?,?,now(), now())"; $self->mantis_issue_sql( $sql, $bugid, $reporter_id, $mantis_bugnote_text_table_id, $mantis_bug_view_state ); # Preserve bug history. Mantis proposes a 7-digit long format for bug ids. $sql = "INSERT INTO mantis_bug_history_table(user_id, bug_id, date_modified, field_name, old_value, new_value, type) VALUES(?,?,now(),'',?,'',2)"; $self->mantis_issue_sql( $sql, $reporter_id, $bugid, sprintf("%07d", $mantis_bugnote_text_table_id) ); Thanks for the help, Alvin Schatte
_______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
