<?php

// SVN $Id$

chdir('./../');
require_once('./global.php');

$userlist = array();
$users = $db->query("SELECT userid, displayname FROM " . TABLE_PREFIX . "user");
while ($user = $db->fetch_array($users))
{
	$userlist["$user[userid]"] = $user['displayname'];
}

$bugs = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug");
while ($bug = $db->fetch_array($bugs))
{
	$db->query("
		UPDATE " . TABLE_PREFIX . "bug
		SET username = '" . $db->escape_string($userlist["$bug[userid]"]) . "',
			lastpostbyname = '" . $db->escape_string($userlist["$bug[lastpostby]"]) . "',
			hiddenlastpostbyname = '" . $db->escape_string($userlist["$bug[hiddenlastpostby]"]) . "'
		WHERE bugid = $bug[bugid]
	");
}

?>