2 /*=====================================================================*\
3 || ################################################################### ||
4 || # BugStrike [#]version[#]
5 || # --------------------------------------------------------------- # ||
6 || # All parts of this file are ©2002-[#]year[#] Iris Studios, Inc. No # ||
7 || # part of this file may be reproduced in any way: part or whole. # ||
8 || # --------------------------------------------------------------- # ||
9 || # ©2002 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com # ||
10 || ################################################################### ||
11 \*=====================================================================*/
13 define('SVN', '$Id$');
15 $focus['showreport'] = 'focus';
17 require_once('./global.php');
19 $bug = $db->query_first("
20 SELECT bugvaluefill.*, bug.*, user.email, user.displayname, user.showemail
21 FROM " . TABLE_PREFIX
. "bug AS bug
22 LEFT JOIN " . TABLE_PREFIX
. "user AS user
23 ON (bug.userid = user.userid)
24 LEFT JOIN " . TABLE_PREFIX
. "bugvaluefill AS bugvaluefill
25 ON (bug.bugid = bugvaluefill.bugid)
26 WHERE bug.bugid = " . intval($bugsys->in
['bugid'])
29 if (!((can_perform('caneditown', $bug['productid']) AND $bugsys->userinfo
['userid'] == $bug['userid']) OR (can_perform('caneditother', $bug['productid']) AND $bugsys->userinfo
['userid'] != $bug['userid'])) AND !can_perform('canpostcomments', $bug['productid']))
31 $message->error_permission();
36 $message->error($lang->getlex('error_invalid_id'));
39 if ($bug['hidden'] AND !can_perform('canviewhidden', $bug['productid']))
41 $message->error_permission();
45 require_once('./includes/class_history.php');
47 $log->bugid
= $bug['bugid'];
49 // ###################################################################
51 if ($_POST['do'] == 'update')
53 // -------------------------------------------------------------------
54 // process comment stuff
55 if (!((can_perform('caneditown', $bug['productid']) AND $bugsys->userinfo
['userid'] == $bug['userid']) OR (can_perform('caneditother', $bug['productid']) AND $bugsys->userinfo
['userid'] != $bug['userid'])))
57 $hascomment = (!empty($bugsys->in
['comment'])) ? true
: false
;
59 if ($hascomment OR $autoaction['comment'])
61 if ($hascomment AND $autoaction['comment'])
63 $bugsys->in
['comment'] .= "\n\n" . $lang->string('--------------- AUTOMATIC RESPONSE ---------------') . "\n" . $autoaction['comment'];
65 else if (!$hascomment AND $autoaction['comment'])
67 $bugsys->in
['comment'] = $autoaction['comment'];
70 $bugsys->in
['comment_parsed'] = $bugsys->in
['comment'];
72 if (!$bugsys->options
['allowhtml'])
74 $bugsys->in
['comment_parsed'] = $bugsys->sanitize($bugsys->in
['comment_parsed']);
80 INSERT INTO " . TABLE_PREFIX
. "comment
81 (bugid, userid, dateline, comment, comment_parsed)
83 (" . intval($bugsys->in
['bugid']) . ", " . $bugsys->userinfo
['userid'] . ",
84 $time, '" . $bugsys->in
['comment'] . "',
85 '" . nl2br($bugsys->in
['comment_parsed']) . "'
89 $commentid = $db->insert_id();
92 UPDATE " . TABLE_PREFIX
. "bug
93 SET lastposttime = $time,
94 lastpostby = " . $bugsys->userinfo
['userid'] . ",
95 hiddenlastposttime = $time,
96 hiddenlastpostby = " . $bugsys->userinfo
['userid'] . "
97 WHERE bugid = " . intval($bugsys->in
['bugid'])
102 $log->arguments
= array($commentid);
107 $message->redirect($lang->string('Your reply has been added to the comment list.'), "showreport.php?bugid=$bug[bugid]");
110 // -------------------------------------------------------------------
112 $pcv = parse_pcv_select($bugsys->in
['pcv_select'], true
);
114 if (!$bugsys->in
['summary'])
116 $message->error($lang->string('You need to enter a summary for this bug.'));
120 $message->error($lang->string('Invalid product/component/version selected.'));
123 $hist[0] = (array)$db->query_first("SELECT * FROM " . TABLE_PREFIX
. "bug WHERE bugid = $bug[bugid]");
124 $hist2[0] = (array)$temp = $noinitialcustom = $db->query_first("SELECT * FROM " . TABLE_PREFIX
. "bugvaluefill WHERE bugid = $bug[bugid]");
126 // -------------------------------------------------------------------
130 $autoaction = $db->query_first("SELECT * FROM " . TABLE_PREFIX
. "autoaction WHERE actionid = " . intval($bugsys->in
['autoaction']));
133 $autoaction['fields'] = unserialize($autoaction['fieldchanges']);
135 foreach ($autoaction['fields']['builtin'] AS $field => $value)
137 $bugsys->in
["$field"] = $value;
140 foreach ($autoaction['fields']['custom'] AS $field => $value)
142 $bugsys->in
["field$field"] = $value;
146 process_custom_fields($bug['bugid']);
148 $dependencies = preg_split('#([^0-9].*?)#', $bugsys->in
['dependency'], -1, PREG_SPLIT_NO_EMPTY
);
149 $dependencies = ((count($dependencies) < 1) ?
'' : implode(', ', $dependencies));
152 UPDATE " . TABLE_PREFIX
. "bug
153 SET summary = '" . $bugsys->in
['summary'] . "',
154 severity = " . intval($bugsys->in
['severity']) . "," .
155 (can_perform('canchangestatus', $bug['productid']) ?
"
156 priority = " . intval($bugsys->in
['priority']) . ",
157 status = " . intval($bugsys->in
['status']) . ",
158 resolution = " . intval($bugsys->in
['resolution']) . ","
160 " . (can_perform('canassign', $bug['productid']) ?
"assignedto = " . intval($bugsys->in
['assignedto']) . "," : '') . "
161 duplicateof = " . intval($bugsys->in
['duplicateof']) . ",
162 dependency = '$dependencies',
163 productid = " . $pcv['product'] . ",
164 componentid = " . $pcv['component'] . ",
165 versionid = " . $pcv['version'] . ",
166 hidden = " . intval($bugsys->in
['hidden']) . "
167 WHERE bugid = $bug[bugid]"
170 // -------------------------------------------------------------------
173 $hist[1] = (array)$db->query_first("SELECT * FROM " . TABLE_PREFIX
. "bug WHERE bugid = $bug[bugid]");
174 $hist2[1] = (array)$db->query_first("SELECT * FROM " . TABLE_PREFIX
. "bugvaluefill WHERE bugid = $bug[bugid]");
176 $diff[0] = array_diff_assoc($hist[0], $hist[1]);
177 $diff[1] = array_diff_assoc($hist[1], $hist[0]);
179 $lookupindex = array(
180 'status' => 'status',
181 'severity' => 'severity',
182 'priority' => 'priority',
183 'versionid' => 'version',
184 'assignedto' => 'assignto',
185 'resolution' => 'resolution',
186 'productid' => 'product',
187 'componentid' => 'product'
190 foreach ($diff AS $num => $diffs)
192 foreach ($diffs AS $key => $value)
194 if (!isset($lookupindex["$key"]))
199 $ref = $lookupindex["$key"];
200 $temp =& $bugsys->datastore
["$ref"]["$value"];
201 $thevalue = $temp["$ref"];
202 $idbit = ' (id: ' . $temp["$ref" . 'id'] . ')';
204 if ($key == 'assignedto')
206 $thevalue = (($temp['userid']) ?
construct_user_display($temp) : '');
209 else if ($key == 'productid' OR $key == 'componentid')
212 $thevalue = $temp['title'];
215 $diff["$num"]["$key"] = (($thevalue) ?
$thevalue . $idbit : '');
219 foreach ($diff[1] AS $key => $value)
221 $log->log($log->diff($key, $diff[0]["$key"], $diff[1]["$key"]));
224 $diff2[0] = array_diff_assoc($hist2[0], $hist2[1]);
225 $diff2[1] = array_diff_assoc($hist2[1], $hist2[0]);
227 if ($noinitialcustom === false
)
229 $canallowempty = true
;
230 $checkbox = $db->query("SELECT * FROM " . TABLE_PREFIX
. "bugfield WHERE type = 'input_checkbox'");
231 while ($box = $db->fetch_array($checkbox))
233 $boxlist[] = 'field' . $box['fieldid'];
237 foreach ($diff2[1] AS $key => $value)
239 if (in_array($key, $boxlist) AND $canallowempty)
241 $log->allowempty
= true
;
245 $log->allowempty
= false
;
253 $log->log($log->diff('custom_' . $key, $diff2[0]["$key"], $diff2[1]["$key"]));
256 $log->allowempty
= false
;
258 // -------------------------------------------------------------------
260 $hascomment = (!empty($bugsys->in
['comment'])) ? true
: false
;
262 if ($hascomment OR $autoaction['comment'])
264 if ($hascomment AND $autoaction['comment'])
266 $bugsys->in
['comment'] .= "\n\n" . $lang->string('--------------- AUTOMATIC RESPONSE ---------------') . "\n" . $autoaction['comment'];
268 else if (!$hascomment AND $autoaction['comment'])
270 $bugsys->in
['comment'] = $autoaction['comment'];
273 $bugsys->in
['comment_parsed'] = $bugsys->in
['comment'];
275 if (!$bugsys->options
['allowhtml'])
277 $bugsys->in
['comment_parsed'] = $bugsys->sanitize($bugsys->in
['comment_parsed']);
283 INSERT INTO " . TABLE_PREFIX
. "comment
284 (bugid, userid, dateline, comment, comment_parsed)
286 (" . intval($bugsys->in
['bugid']) . ", " . $bugsys->userinfo
['userid'] . ",
287 $time, '" . $bugsys->in
['comment'] . "',
288 '" . nl2br($bugsys->in
['comment_parsed']) . "'
292 $commentid = $db->insert_id();
295 UPDATE " . TABLE_PREFIX
. "bug
296 SET lastposttime = $time,
297 lastpostby = " . $bugsys->userinfo
['userid'] . ",
298 hiddenlastposttime = $time,
299 hiddenlastpostby = " . $bugsys->userinfo
['userid'] . "
300 WHERE bugid = " . intval($bugsys->in
['bugid'])
305 $message->redirect($lang->string('Your changes to the bug have been saved.'), "showreport.php?bugid=$bug[bugid]");
308 /*=====================================================================*\
309 || ###################################################################
312 || ###################################################################
313 \*=====================================================================*/