summaryrefslogtreecommitdiffstats
path: root/CGI.pl
diff options
context:
space:
mode:
Diffstat (limited to 'CGI.pl')
-rw-r--r--CGI.pl11
1 files changed, 6 insertions, 5 deletions
diff --git a/CGI.pl b/CGI.pl
index 033961424..ecd56860a 100644
--- a/CGI.pl
+++ b/CGI.pl
@@ -777,13 +777,14 @@ sub DumpBugActivity {
$datepart = "and bugs_activity.bug_when >= $starttime";
}
my $query = "
- select bugs_activity.field, bugs_activity.bug_when,
+ SELECT fielddefs.name, bugs_activity.bug_when,
bugs_activity.oldvalue, bugs_activity.newvalue,
profiles.login_name
- from bugs_activity,profiles
- where bugs_activity.bug_id = $id $datepart
- and profiles.userid = bugs_activity.who
- order by bugs_activity.bug_when";
+ FROM bugs_activity,profiles,fielddefs
+ WHERE bugs_activity.bug_id = $id $datepart
+ AND fielddefs.fieldid = bugs_activity.fieldid
+ AND profiles.userid = bugs_activity.who
+ ORDER BY bugs_activity.bug_when";
SendSQL($query);