From 9dd61f718a075a1f97aa0926e1110801edf4154b Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Mon, 17 Jan 2000 19:45:34 +0000
Subject: Use new "keywords" cache to display keywords in bug lists.  Not only
 is this much faster, but it also lets you sort by that column, and requires
 less special-case code.

---
 buglist.cgi | 16 +---------------
 1 file changed, 1 insertion(+), 15 deletions(-)

(limited to 'buglist.cgi')

diff --git a/buglist.cgi b/buglist.cgi
index 28f71098d..86fad102e 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -182,6 +182,7 @@ DefCol("os", "substring(bugs.op_sys, 1, 4)", "OS", "bugs.op_sys");
 DefCol("target_milestone", "bugs.target_milestone", "TargetM",
        "bugs.target_milestone");
 DefCol("votes", "bugs.votes", "Votes", "bugs.votes desc");
+DefCol("keywords", "bugs.keywords", "Keywords", "bugs.keywords");
 
 my @collist;
 if (defined $::COOKIE{'COLUMNLIST'}) {
@@ -570,8 +571,6 @@ foreach my $c (@collist) {
         } else {
             $tablestart .= $::title{$c};
         }
-    } elsif ($c eq "keywords") {
-        $tablestart .= "<TH valign=left>Keywords</TH>";
     }
 }
 
@@ -657,19 +656,6 @@ while (@row = FetchSQLData()) {
                     $value = "<nobr>$value</nobr>";
                 }
                 pnl "<td class=$c>$value";
-            } elsif ($c eq "keywords") {
-                my $query =
-                    $::db->query("SELECT keyworddefs.name
-                                  FROM keyworddefs, keywords
-                                  WHERE keywords.bug_id = $bug_id
-                                    AND keyworddefs.id = keywords.keywordid
-                                  ORDER BY keyworddefs.name");
-                my @list;
-                my @row;
-                while (@row= $query->fetchrow()) {
-                    push(@list, $row[0]);
-                }
-                pnl("<td>" . join(", ", @list) . "</td>");
             }
         }
         if ($dotweak) {
-- 
cgit v1.2.3-24-g4f1b