From 7c36a9995a55b8bbd05a7b99ca54929b0f16bea6 Mon Sep 17 00:00:00 2001
From: "terry%netscape.com" <>
Date: Sat, 29 Aug 1998 03:19:31 +0000
Subject: Get rid of "verified_ts" and "resolved_ts" stuff; we aren't keeping
 that stuff in this database.

---
 buglist.cgi | 18 ++----------------
 1 file changed, 2 insertions(+), 16 deletions(-)

(limited to 'buglist.cgi')

diff --git a/buglist.cgi b/buglist.cgi
index a82238fe0..bc07173b0 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -118,8 +118,6 @@ proc DefCol {name k t {s ""} {q 0}} {
     set needquote($name) $q
 }
 
-DefCol resolved_ts "bugs.resolved_ts" DateResolved bugs.resolved_ts
-DefCol verified_ts "bugs.verified_ts" DateVerified bugs.verified_ts
 DefCol opendate "date_format(bugs.creation_ts,'Y-m-d')" Opened bugs.creation_ts
 DefCol changeddate "date_format(bugs.delta_ts,'Y-m-d')" Changed bugs.delta_ts
 DefCol severity "substring(bugs.bug_severity, 1, 3)" Sev bugs.bug_severity
@@ -186,7 +184,7 @@ if {[info exists FORM(sql)]} {
 
   set legal_fields { bug_id product version rep_platform op_sys bug_status
                      resolution priority bug_severity assigned_to reporter
-                     bug_file_loc component resolved_ts verified_ts}
+                     bug_file_loc component}
 
   foreach field [array names FORM] {
     if { [ lsearch $legal_fields $field ] != -1 && ![cequal $FORM($field) ""]} {
@@ -197,18 +195,6 @@ if {[info exists FORM(sql)]} {
           qadd "\t\t${or}bugs.$field = [DBNameToIdAndCheck $p]\n"
           set or "or "
         }
-      } elseif { $field == "resolved_ts"} {
-                        if {! [cequal $FORM(resolved_ts_2) ""]} { 
-                                qadd "\t\tbugs.resolved_ts between \n\t\t\tTO_DATE('$FORM($field)','DD-MON-YY') and\n \t\t\tTO_DATE('$FORM(resolved_ts_2)', 'DD-MON-YY')\n"
-                        } else {
-                                qadd "\t\tTO_CHAR (bugs.resolved_ts,'DD-MON-YY') = '[string toupper $FORM($field)]'\n"
-                                }
-      } elseif { $field == "verified_ts"} {
-                        if {! [cequal $FORM(verified_ts_2) ""]} {
-                                qadd "\t\tbugs.verified_ts between \n\t\t\tTO_DATE('$FORM($field)','DD-MON-YY') and\n \t\t\tTO_DATE('$FORM(verified_ts_2)', 'DD-MON-YY')\n"
-                        } else {
-                                qadd "\t\tTO_CHAR (bugs.verified_ts,'DD-MON-YY') = '[string toupper $FORM($field)]'\n"
-                                }
       } else {
         foreach v $MFORM($field) {
           if {[cequal $v "(empty)"]} {
@@ -418,7 +404,7 @@ set env(TZ) PST8PDT
 PutHeader "Bug List" "Bug List"
 
 puts -nonewline "
-<CENTER><H1>M<font -= 2>OZILLA</font> B<font -= 2>UGS</font></H1>
+<CENTER>
 <B>[fmtclock [getclock ]]</B>"
 if {[info exists FORM(debug)]} { puts "<PRE>$query</PRE>" }
 
-- 
cgit v1.2.3-24-g4f1b