<?php

// $Id$

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

$fields = array(
	'priority' => array(
		5 => 1,
		2 => 2,
		1 => 3,
		3 => 4,
		4 => 5
	),
	
	'severity' => array(
		6 => 1,
		1 => 2,
		2 => 3,
		3 => 4,
		4 => 5,
		5 => 6
	)
);

$bugs = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug");
foreach ($bugs as $bug)
{
	$db->query("UPDATE " . TABLE_PREFIX . "bug SET priority = " . $fields['priority']["$bug[priority]"] . ", severity = " . $fields['severity']["$bug[severity]"] . " WHERE bugid = " . $bug['bugid']);
}

$severity = $db->query("SELECT * FROM " . TABLE_PREFIX . "severity");
foreach ($severity as $thing)
{
	$db->query("UPDATE " . TABLE_PREFIX . "severity SET severityid = " . rand(10, 100000) . " WHERE severityid = $thing[severityid]");
}

$priority = $db->query("SELECT * FROM " . TABLE_PREFIX . "priority");
foreach ($priority as $thing)
{
	$db->query("UPDATE " . TABLE_PREFIX . "priority SET priorityid = " . rand(10, 100000) . " WHERE priorityid = $thing[priorityid]");
}

$db->query("UPDATE " . TABLE_PREFIX . "severity SET severityid = displayorder");
$db->query("UPDATE " . TABLE_PREFIX . "priority SET priorityid = displayorder");

?>