post_bug.cgi 7.79 KB
Newer Older
1 2
#!/usr/bonsaitools/bin/perl -w
# -*- Mode: perl; indent-tabs-mode: nil -*-
terry%netscape.com's avatar
terry%netscape.com committed
3
#
4 5 6 7 8 9 10 11 12 13
# The contents of this file are subject to the Mozilla Public
# License Version 1.1 (the "License"); you may not use this file
# except in compliance with the License. You may obtain a copy of
# the License at http://www.mozilla.org/MPL/
#
# Software distributed under the License is distributed on an "AS
# IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
# implied. See the License for the specific language governing
# rights and limitations under the License.
#
terry%netscape.com's avatar
terry%netscape.com committed
14
# The Original Code is the Bugzilla Bug Tracking System.
15
#
terry%netscape.com's avatar
terry%netscape.com committed
16
# The Initial Developer of the Original Code is Netscape Communications
17 18 19 20
# Corporation. Portions created by Netscape are
# Copyright (C) 1998 Netscape Communications Corporation. All
# Rights Reserved.
#
terry%netscape.com's avatar
terry%netscape.com committed
21
# Contributor(s): Terry Weissman <terry@mozilla.org>
22
#                 Dan Mosedale <dmose@mozilla.org>
23
#                 Joe Robins <jmrobins@tgix.com>
terry%netscape.com's avatar
terry%netscape.com committed
24

25 26
use diagnostics;
use strict;
terry%netscape.com's avatar
terry%netscape.com committed
27

28
require "CGI.pl";
terry%netscape.com's avatar
terry%netscape.com committed
29

30 31
# Shut up misguided -w warnings about "used only once".  For some reason,
# "use vars" chokes on me when I try it here.
terry%netscape.com's avatar
terry%netscape.com committed
32

33 34 35 36
sub sillyness {
    my $zz;
    $zz = $::buffer;
    $zz = %::COOKIE;
37 38 39 40 41 42 43 44
    $zz = %::components;
    $zz = %::versions;
    $zz = @::legal_bug_status;
    $zz = @::legal_opsys;
    $zz = @::legal_platform;
    $zz = @::legal_priority;
    $zz = @::legal_product;
    $zz = @::legal_severity;
45
    $zz = %::target_milestone;
46
}
47

48
confirm_login();
terry%netscape.com's avatar
terry%netscape.com committed
49

dmose%mozilla.org's avatar
dmose%mozilla.org committed
50 51 52
print "Set-Cookie: PLATFORM=$::FORM{'product'} ; path=/ ; expires=Sun, 30-Jun-2029 00:00:00 GMT\n" if ( exists $::FORM{'product'} );
print "Set-Cookie: VERSION-$::FORM{'product'}=$::FORM{'version'} ; path=/ ; expires=Sun, 30-Jun-2029 00:00:00 GMT\n" if ( exists $::FORM{'product'} && exists $::FORM{'version'} );

53
print "Content-type: text/html\n\n";
terry%netscape.com's avatar
terry%netscape.com committed
54

55
if (defined $::FORM{'maketemplate'}) {
56 57
    print "<TITLE>Bookmarks are your friend.</TITLE>\n";
    print "<H1>Template constructed.</H1>\n";
terry%netscape.com's avatar
terry%netscape.com committed
58
    
59
    my $url = "enter_bug.cgi?$::buffer";
terry%netscape.com's avatar
terry%netscape.com committed
60

61
    print "If you put a bookmark <a href=\"$url\">to this link</a>, it will\n";
62 63
    print "bring up the submit-a-new-bug page with the fields initialized\n";
    print "as you've requested.\n";
64
    PutFooter();
65
    exit;
terry%netscape.com's avatar
terry%netscape.com committed
66 67
}

68
PutHeader("Posting Bug -- Please wait", "Posting Bug", "One moment please...");
terry%netscape.com's avatar
terry%netscape.com committed
69

70 71
umask 0;
ConnectToDatabase();
terry%netscape.com's avatar
terry%netscape.com committed
72

73 74 75 76 77 78 79 80 81 82 83 84 85
my $product = $::FORM{'product'};

if(Param("usebuggroupsentry") && GroupExists($product)) {
  if(!UserInGroup($product)) {
    print "<H1>Permission denied.</H1>\n";
    print "Sorry; you do not have the permissions necessary to enter\n";
    print "a bug against this product.\n";
    print "<P>\n";
    PutFooter();
    exit;
  }
}

86
if (!defined $::FORM{'component'} || $::FORM{'component'} eq "") {
87 88
    PuntTryAgain("You must choose a component that corresponds to this bug. " .
                 "If necessary, just guess.");
89
}
terry%netscape.com's avatar
terry%netscape.com committed
90

91
if (!defined $::FORM{'short_desc'} || trim($::FORM{'short_desc'}) eq "") {
92
    PuntTryAgain("You must enter a summary for this bug.");
93 94
}

95 96 97 98 99
if ($::FORM{'assigned_to'} eq "") {
    SendSQL("select initialowner from components where program=" .
            SqlQuote($::FORM{'product'}) .
            " and value=" . SqlQuote($::FORM{'component'}));
    $::FORM{'assigned_to'} = FetchOneColumn();
100 101
} else {
    $::FORM{'assigned_to'} = DBNameToIdAndCheck($::FORM{'assigned_to'});
terry%netscape.com's avatar
terry%netscape.com committed
102 103
}

104
$::FORM{'reporter'} = DBNameToIdAndCheck($::FORM{'reporter'});
terry%netscape.com's avatar
terry%netscape.com committed
105 106


107 108
my @bug_fields = ("reporter", "product", "version", "rep_platform",
                  "bug_severity", "priority", "op_sys", "assigned_to",
109 110
                  "bug_status", "bug_file_loc", "short_desc", "component",
                  "target_milestone");
111 112 113 114 115 116

if (Param("useqacontact")) {
    SendSQL("select initialqacontact from components where program=" .
            SqlQuote($::FORM{'product'}) .
            " and value=" . SqlQuote($::FORM{'component'}));
    my $qacontact = FetchOneColumn();
117 118
    if (defined $qacontact && $qacontact != 0) {
        $::FORM{'qa_contact'} = $qacontact;
119 120 121 122
        push(@bug_fields, "qa_contact");
    }
}

123 124 125 126 127 128 129 130 131 132 133 134 135 136 137
if (exists $::FORM{'bug_status'}) {
    if (!UserInGroup("canedit") && !UserInGroup("canconfirm")) {
        delete $::FORM{'bug_status'};
    }
}

if (!exists $::FORM{'bug_status'}) {
    $::FORM{'bug_status'} = $::unconfirmedstate;
    SendSQL("SELECT votestoconfirm FROM products WHERE product = " .
            SqlQuote($::FORM{'product'}));
    if (!FetchOneColumn()) {
        $::FORM{'bug_status'} = "NEW";
    }
}

138 139 140 141 142 143
if (!exists $::FORM{'target_milestone'}) {
    SendSQL("SELECT defaultmilestone FROM products " .
            "WHERE product = " . SqlQuote($::FORM{'product'}));
    $::FORM{'target_milestone'} = FetchOneColumn();
}

144 145 146 147 148
if ( Param("strictvaluechecks") ) {
    GetVersionTable();  
    CheckFormField(\%::FORM, 'reporter');
    CheckFormField(\%::FORM, 'product', \@::legal_product);
    CheckFormField(\%::FORM, 'version', \@{$::versions{$::FORM{'product'}}});
149 150
    CheckFormField(\%::FORM, 'target_milestone',
                   \@{$::target_milestone{$::FORM{'product'}}});
151 152 153 154 155 156 157 158 159 160 161 162
    CheckFormField(\%::FORM, 'rep_platform', \@::legal_platform);
    CheckFormField(\%::FORM, 'bug_severity', \@::legal_severity);
    CheckFormField(\%::FORM, 'priority', \@::legal_priority);
    CheckFormField(\%::FORM, 'op_sys', \@::legal_opsys);
    CheckFormFieldDefined(\%::FORM, 'assigned_to');
    CheckFormField(\%::FORM, 'bug_status', \@::legal_bug_status);
    CheckFormFieldDefined(\%::FORM, 'bug_file_loc');
    CheckFormField(\%::FORM, 'component', 
                   \@{$::components{$::FORM{'product'}}});
    CheckFormFieldDefined(\%::FORM, 'comment');
}

163 164 165 166 167 168
my @used_fields;
foreach my $f (@bug_fields) {
    if (exists $::FORM{$f}) {
        push (@used_fields, $f);
    }
}
169 170 171 172
if (exists $::FORM{'bug_status'} && $::FORM{'bug_status'} ne $::unconfirmedstate) {
    push(@used_fields, "everconfirmed");
    $::FORM{'everconfirmed'} = 1;
}
173

174 175 176
my $query = "INSERT INTO bugs (\n" . join(",\n", @used_fields) . ",
creation_ts, groupset)
VALUES (
177
";
terry%netscape.com's avatar
terry%netscape.com committed
178

179
foreach my $field (@used_fields) {
180 181 182 183 184 185 186 187 188 189 190 191 192 193 194
# fix for 42609. if there is a http:// only in bug_file_loc, strip
# it out and send an empty value. 
    if ($field eq 'bug_file_loc') {
       if ($::FORM{$field} eq 'http://') {
           $::FORM{$field} = "";
           $query .= SqlQuote($::FORM{$field}) . ",\n";
           next;
       } 
       else {
          $query .= SqlQuote($::FORM{$field}) . ",\n";
       }
    }
    else {
       $query .= SqlQuote($::FORM{$field}) . ",\n";
    }
terry%netscape.com's avatar
terry%netscape.com committed
195 196
}

197 198 199 200 201
my $comment = $::FORM{'comment'};
$comment =~ s/\r\n/\n/g;     # Get rid of windows-style line endings.
$comment =~ s/\r/\n/g;       # Get rid of mac-style line endings.
$comment = trim($comment);

202 203 204 205 206 207 208 209 210 211 212 213 214 215
$query .= "now(), 0";

foreach my $b (grep(/^bit-\d*$/, keys %::FORM)) {
    if ($::FORM{$b}) {
        my $v = substr($b, 4);
        $query .= " + $v";    # Carefully written so that the math is
                                # done by MySQL, which can handle 64-bit math,
                                # and not by Perl, which I *think* can not.
    }
}



$query .= ")\n";
terry%netscape.com's avatar
terry%netscape.com committed
216 217


218
my %ccids;
terry%netscape.com's avatar
terry%netscape.com committed
219 220


221 222 223 224
if (defined $::FORM{'cc'}) {
    foreach my $person (split(/[ ,]/, $::FORM{'cc'})) {
        if ($person ne "") {
            $ccids{DBNameToIdAndCheck($person)} = 1;
terry%netscape.com's avatar
terry%netscape.com committed
225 226 227 228 229
        }
    }
}


230
# print "<PRE>$query</PRE>\n";
terry%netscape.com's avatar
terry%netscape.com committed
231

232
SendSQL($query);
terry%netscape.com's avatar
terry%netscape.com committed
233

234 235
SendSQL("select LAST_INSERT_ID()");
my $id = FetchOneColumn();
terry%netscape.com's avatar
terry%netscape.com committed
236

237 238 239
SendSQL("INSERT INTO longdescs (bug_id, who, bug_when, thetext) VALUES " .
        "($id, $::FORM{'reporter'}, now(), " . SqlQuote($comment) . ")");

240 241
foreach my $person (keys %ccids) {
    SendSQL("insert into cc (bug_id, who) values ($id, $person)");
terry%netscape.com's avatar
terry%netscape.com committed
242 243
}

244
print "<TABLE BORDER=1><TD><H2>Bug $id posted</H2>\n";
245
system("./processmail", $id, $::COOKIE{'Bugzilla_login'});
246
print "<TD><A HREF=\"show_bug.cgi?id=$id\">Back To BUG# $id</A></TABLE>\n";
terry%netscape.com's avatar
terry%netscape.com committed
247

248
print "<BR><A HREF=\"createattachment.cgi?id=$id\">Attach a file to this bug</a>\n";
249

250
navigation_header();
251

252
PutFooter();
253
exit;