<?php
$mysql_server = "sqlserver";
$mysql_user = "sqluser";
$mysql_password = "sqlpassword";
$mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
mysql_select_db("bugtracker");

$delete_from = 1434862759;
$delete_user = 3;

$result = mysql_query("SELECT * FROM mantis_bug_history_table WHERE date_modified>='$delete_from' AND user_id='$delete_user' ORDER BY date_modified DESC");
while ($row = mysql_fetch_assoc($result)) {
  $bugid = $row['bug_id'];
  $field = $row['field_name'];
  $old_value = $row['old_value'];
  $new_value = $row['new_value'];
  $res = mysql_query("UPDATE mantis_bug_table SET $field='$old_value' WHERE id='$bugid' AND $field='$new_value'");
  echo "Updated rows: " . mysql_affected_rows() . "<br/>\n";
}
mysql_query("DELETE FROM mantis_bug_history_table WHERE date_modified>='$delete_from' AND user_id='$delete_user'");
echo "Deleted rows: " . mysql_affected_rows() . "<br/>\n";

$result = mysql_query("SELECT * FROM mantis_bug_table");
while ($row = mysql_fetch_assoc($result)) {
  $bugid = $row['id'];
  $updated = intval($row['date_submitted']);
  $sub = mysql_query("SELECT * FROM mantis_bug_history_table WHERE bug_id='$bugid'");
  while ($srow = mysql_fetch_assoc($sub)) {
    $updated = max($updated, intval($srow['date_modified']));
  }
  $sub = mysql_query("SELECT * FROM mantis_bugnote_table WHERE bug_id='$bugid'");
  while ($srow = mysql_fetch_assoc($sub)) {
    $updated = max($updated, intval($srow['last_modified']));
  }
  mysql_query("UPDATE mantis_bug_table SET last_updated='$updated' WHERE id='$bugid'");
  echo "Updated: " . mysql_affected_rows() . " ($bugid => $updated)<br/>\n";
}
?>