query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = " . $bugsys->input_clean('bugid', TYPE_UINT)); if (!$bug) { $message->error(L_INVALID_ID); } if (!check_bug_permissions($bug)) { $message->error_permission(); } $lookupfields = array( 'status' => 'status', 'priority' => 'priority', 'severity' => 'severity', 'resolution' => 'resolution', 'version' => 'version', 'product' => 'product', 'component' => 'product' ); $lookupkeys = array_keys($lookupfields); // ################################################################### $customfields = $db->query(" SELECT bugfield.* FROM " . TABLE_PREFIX . "bugfield AS bugfield LEFT JOIN " . TABLE_PREFIX . "bugfieldpermission AS permission ON (bugfield.fieldid = permission.fieldid) WHERE permission.mask <> 0 AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}" ); while ($field = $db->fetch_array($customfields)) { $fieldlist["custom.field$field[fieldid]"] = sprintf(_('Custom Field %1$s (%2$s)'), $field['fieldid'], $field['name']); } // ################################################################### $logs = array(); $logs_fetch = $db->query(" SELECT history.*, user.userid, user.email, user.displayname, user.showemail FROM " . TABLE_PREFIX . "history AS history LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = history.userid) WHERE bugid = $bug[bugid]" ); while ($log = $db->fetch_array($logs_fetch)) { $log['date'] = $datef->format($bugsys->options['dateformat'], $log['dateline']); $log['user'] = construct_user_display($log); $logs["$log[dateline]"]["$log[historyid]"] = $log; ksort($logs["$log[dateline]"]); } ksort($logs); foreach ($logs AS $dateline => $logitems) { $show['group'] = true; foreach ($logitems AS $log) { if ($log['field'] == '.' OR ($log['original'] == '' AND $log['changed'] == '')) { continue; } $funct->exec_swap_bg('', $stylevar['alt_color']); $bgcolor = $funct->bgcolour; if (preg_match('#^(comment|attachment)\.(.*)#', $log['field'], $matches)) { if ($matches[1] == 'comment') { $log['field'] = sprintf(_('Comment #%1$s %2$s'), $log['commentid'], ucwords($matches[2])); } else if ($matches[1] == 'attachment') { $log['field'] = sprintf(_('Attachment #2%1$s %2$s'), $log['attachmentid'], ucwords($matches[2])); } } else if (preg_match('#^custom.field([0-9]+?)#', $log['field'], $matches)) { if ($fieldlist["$log[field]"]) { $log['field'] = $fieldlist["$log[field]"]; } } else if (preg_match('#^\.(.*)#', $log['field'], $matches)) { $log['field'] = ucwords($matches[1]); if (in_array($matches[1], $lookupkeys)) { $lookup = $lookupfields["$matches[1]"]; $log['original'] = $bugsys->datastore[ $lookupfields["$lookup"] ]["$log[original]"]["$lookup"]; $log['changed'] = $bugsys->datastore[ $lookupfields["$lookup"] ]["$log[changed]"]["$lookup"]; } else if ($matches[1] == 'assignto' OR $matches[1] == 'assignedto') { if ($log['original']) { $user = new UserAPI($bugsys); $user->set('userid', $log['original']); $user->set_condition(); $user->fetch(); $log['original'] = construct_user_display($user->objdata); } if ($log['changed']) { $user = new UserAPI($bugsys); $user->set('userid', $log['changed']); $user->set_condition(); $user->fetch(); $log['changed'] = construct_user_display($user->objdata); } } } eval('$history .= "' . $template->fetch('history_bit') . '";'); $show['group'] = false; } } eval('$template->flush("' . $template->fetch('history') . '");'); /*=====================================================================*\ || ################################################################### || # $HeadURL$ || # $Id$ || ################################################################### \*=====================================================================*/ ?>