Differences

This shows you the differences between two versions of the page.

--- mantisbt:numeric_priorities [2008/02/12 01:04] – created vboctor
+++ mantisbt:numeric_priorities [2011/11/10 09:08] (current) – Page doesn't render wiki. Trying to fix by resaving. johnericson
@@ Line 1: / Line 1: @@
+====== Using Numeric Priorities ======
+===== Introduction =====
+Some users prefer to use numeric priorities like "1, 2, 3, etc" (where 1 is the highest) rather than using "immediate, urgent, high, etc".  This guide goes through the steps of customizing Mantis so that it uses such priority system.
+===== config_inc.php =====
+<code php>
+# Use numeric priorities
+$g_priority_enum_string = '1:1,2:2,3:3,4:4,5:5,6:6,7:7,8:8,9:9';
+# Default bug priority when reporting a new bug
+$g_default_bug_priority = 4;
+# Use text priorities rather than icons.
+$g_show_priority_text = ON;
+</code>
+===== Database Upgrade =====
+If you already have data in the database, then you will need to run the following UPDATE queries.
+<code sql>
+UPDATE `mantis_bug_table` SET `priority` = 1 WHERE `priority` = 60;
+UPDATE `mantis_bug_table` SET `priority` = 2 WHERE `priority` = 50;
+UPDATE `mantis_bug_table` SET `priority` = 3 WHERE `priority` = 40;
+UPDATE `mantis_bug_table` SET `priority` = 4 WHERE `priority` = 30;
+UPDATE `mantis_bug_table` SET `priority` = 5 WHERE `priority` = 20;
+UPDATE `mantis_bug_table` SET `priority` = 6 WHERE `priority` = 10;
+</code>
+===== custom_strings_inc.php =====
+Create custom_strings_inc.php in the Mantis root folder with the following contents:
+<code php>
+<?php
+$s_priority_enum_string = '1:1,2:2,3:3,4:4,5:5,6:6,7:7,8:8,9:9';
+?>
+</code>