#12 Not Allow to reopen a Problem

[Franz-Josef Tophoven]

It may be usefull to prevent Users to reopen an
Problem. It would be nicer to have an Pointer from the
new problem to the old one.

[Sven Jacobs]

Logged In: YES
user_id=439032

If fact it is not so dificult to adapt the code youself

descivate the openclosed tickets in the user settings :-)

create in the vj_showtickets

<select name="bug">
<option selected value="nobug"><?echo
$l_selectbugfromthislist?></option>
<?
$query = "SELECT bugs.bug_id FROM bugstest.bugs Where
bug_status <>\"closed\"";
$query .= "ORDER BY bug_id;";
$mysql_result = query($query);
while ($rowb = mysql_fetch_row($mysql_result)) {
echo" <option value=\"$rowb[0]\">$rowb[0]
</option>\n";
}

?>
</select>
something like that

adapt the vj_addevent script
to add the selected field in the table events ( need to add
colum there )

if (settype($txtDuration, "double") && !isset($dontinsert))
{
$query = "INSERT INTO events ";
$query .= "(t_id, e_description, e_duration, s_user,
e_status, e_assignedto, bug) ";
$query .= "VALUES
('$t_id', '$txtDescription', '$txtDuration', '$s_user', ";
$query .= "'OPEN', '$lstAssignedto', '$bug');";
$mysqlresult = query($query);
if ($mysqlresult) {

or something like that

[Sven Jacobs]

Logged In: YES
user_id=439032

If fact it is not so dificult to adapt the code youself

descivate the openclosed tickets in the user settings :-)

create in the vj_showtickets

<select name="bug">
<option selected value="nobug"><?echo
$l_selectbugfromthislist?></option>
<?
$query = "SELECT bugs.bug_id FROM bugstest.bugs Where
bug_status <>\"closed\"";
$query .= "ORDER BY bug_id;";
$mysql_result = query($query);
while ($rowb = mysql_fetch_row($mysql_result)) {
echo" <option value=\"$rowb[0]\">$rowb[0]
</option>\n";
}

?>
</select>
something like that

adapt the vj_addevent script
to add the selected field in the table events ( need to add
colum there )

if (settype($txtDuration, "double") && !isset($dontinsert))
{
$query = "INSERT INTO events ";
$query .= "(t_id, e_description, e_duration, s_user,
e_status, e_assignedto, bug) ";
$query .= "VALUES
('$t_id', '$txtDescription', '$txtDuration', '$s_user', ";
$query .= "'OPEN', '$lstAssignedto', '$bug');";
$mysqlresult = query($query);
if ($mysqlresult) {

or something like that