<?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]
");
}
?>