<?php

// SVN $Id$

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

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

$bugs = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug");
foreach ($bugs as $bug)
{
	$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]
	");
}

?>