docs/update_field_order_in_bugs.php

   1 <?php
   2
   3 // $Id$
   4
   5 chdir('./../');
   6 require_once('./global.php');
   7
   8 $fields = array(
   9         'priority' => array(
  10                 5 => 1,
  11                 2 => 2,
  12                 1 => 3,
  13                 3 => 4,
  14                 4 => 5
  15         ),
  16
  17         'severity' => array(
  18                 6 => 1,
  19                 1 => 2,
  20                 2 => 3,
  21                 3 => 4,
  22                 4 => 5,
  23                 5 => 6
  24         )
  25 );
  26
  27 $bugs = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug");
  28 foreach ($bugs as $bug)
  29 {
  30         $db->query("UPDATE " . TABLE_PREFIX . "bug SET priority = " . $fields['priority']["$bug[priority]"] . ", severity = " . $fields['severity']["$bug[severity]"] . " WHERE bugid = " . $bug['bugid']);
  31 }
  32
  33 $severity = $db->query("SELECT * FROM " . TABLE_PREFIX . "severity");
  34 foreach ($severity as $thing)
  35 {
  36         $db->query("UPDATE " . TABLE_PREFIX . "severity SET severityid = " . rand(10, 100000) . " WHERE severityid = $thing[severityid]");
  37 }
  38
  39 $priority = $db->query("SELECT * FROM " . TABLE_PREFIX . "priority");
  40 foreach ($priority as $thing)
  41 {
  42         $db->query("UPDATE " . TABLE_PREFIX . "priority SET priorityid = " . rand(10, 100000) . " WHERE priorityid = $thing[priorityid]");
  43 }
  44
  45 $db->query("UPDATE " . TABLE_PREFIX . "severity SET severityid = displayorder");
  46 $db->query("UPDATE " . TABLE_PREFIX . "priority SET priorityid = displayorder");
  47
  48 ?>