Help changing the status with php or SQL

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
DaVinci
Posts: 95
Joined: 13 Apr 2007, 07:39

Help changing the status with php or SQL

Post by DaVinci »

i need help with v.1.1.6
i've been using Mantis for over two years now and have customized it under way.
the last customization was the Status..
i only want to have three Status in Mantis:
[b]
New
Assigned
Closed[/b]

I've added the following line in config_inc.php:

[code]$g_status_enum_string =
'10:new,50:assigned,80:closed';[/code]

This resulted in that all the cases with Status listed below dissappeared from Mantis:
[b]feedback
acknowledged
confirmed
assigned
resolved[/b]

I want following:
- a code that will only show [b]'10:new,50:assigned,80:closed'[/b] in the Status menu
or
- an SQL that would change the status of all the cases [b]from resolved to close[/b], and rest to new

can someone please help me with this?
Mantis v.1.1.6 [in production enviourment]
Mantis v.1.2.0a2 [for test purposes and only for limited users]
Running on a Windows 2003 VPS
Post Reply