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 ++----------------
 colchange.cgi |  2 +-
 query.cgi     | 12 ------------
 3 files changed, 3 insertions(+), 29 deletions(-)

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>" }
 
diff --git a/colchange.cgi b/colchange.cgi
index 35580be9c..0b137f8eb 100755
--- a/colchange.cgi
+++ b/colchange.cgi
@@ -27,7 +27,7 @@ puts "Content-type: text/html"
 # they get displayed in.
 
 set masterlist {opendate changeddate severity priority platform owner reporter status
-    resolution component product version project os summary summaryfull resolved_ts verified_ts}
+    resolution component product version project os summary summaryfull }
 
 
 if {[info exists FORM(rememberedquery)]} {
diff --git a/query.cgi b/query.cgi
index 82ba16c00..d285cf66c 100755
--- a/query.cgi
+++ b/query.cgi
@@ -173,18 +173,6 @@ puts "
 </tr>
 </table>
 
-<table border=0><tr><td align=right>
-<b><A HREF=\"bug_status.html#resolved_ts\">Date Resolved</a>:</b> </td>
-<td align=left><INPUT NAME=resolved_ts SIZE=9> (to <INPUT NAME=resolved_ts_2 SIZE=9>, optional)</td>
-</tr>
-<tr>
-<td align=right><b><A HREF=\"bug_status.html#resolved_ts\">Date Verified</a>:</b> </td>
-<td align=left><INPUT NAME=verified_ts SIZE=9> (to <INPUT NAME=verified_ts_2 SIZE=9>, optional)
-<font size=-1>&nbsp;&nbsp;date format: 24-FEB-98</font>
-</td>
-</tr>
-</table>
-
 <table border=0>
 <tr>
 <td align=right>Summary:</td>
-- 
cgit v1.2.3-24-g4f1b