Added a new table fielddefs that records information about the

different fields we keep an activity log on.  The bugs_activity table
now has a pointer into that table instead of recording the name directly.

Set up a new, highly experimental email-notification scheme.  To turn
it on, the maintainer has to turn on the "New email tech" param, and
then individual users have to turn on the "New email tech" preference.

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);