diff options
author | mkanat%kerio.com <> | 2005-07-08 09:31:41 +0000 |
---|---|---|
committer | mkanat%kerio.com <> | 2005-07-08 09:31:41 +0000 |
commit | 4f25eedf9065f28badf1e5e1df6c925062d8279e (patch) | |
tree | 01adc7e1f641b2104a5177bd84ad4ab084e71dda /contrib/bug_email.pl | |
parent | 6bff5c39e564cc34c85c4d30e11f6ff14482548a (diff) | |
download | bugs-4f25eedf9065f28badf1e5e1df6c925062d8279e.tar bugs-4f25eedf9065f28badf1e5e1df6c925062d8279e.tar.gz bugs-4f25eedf9065f28badf1e5e1df6c925062d8279e.tar.bz2 bugs-4f25eedf9065f28badf1e5e1df6c925062d8279e.tar.xz bugs-4f25eedf9065f28badf1e5e1df6c925062d8279e.zip |
Bug 285695: [PostgreSQL] Username checks for login, etc. need to be case insensitive
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=justdave
Diffstat (limited to 'contrib/bug_email.pl')
-rwxr-xr-x | contrib/bug_email.pl | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/contrib/bug_email.pl b/contrib/bug_email.pl index 46c23c3c3..1590387e6 100755 --- a/contrib/bug_email.pl +++ b/contrib/bug_email.pl @@ -38,7 +38,7 @@ # # You need to work with bug_email.pl the MIME::Parser installed. # -# $Id: bug_email.pl,v 1.27 2005/05/12 19:13:56 lpsolit%gmail.com Exp $ +# $Id: bug_email.pl,v 1.28 2005/07/08 02:31:43 mkanat%kerio.com Exp $ ############################################################### # 02/12/2000 (SML) @@ -112,6 +112,8 @@ my $restricted = 0; my $SenderShort; my $Message_ID; +my $dbh = Bugzilla->dbh; + # change to use default product / component functionality my $DEFAULT_PRODUCT = "PENDING"; my $DEFAULT_COMPONENT = "PENDING"; @@ -1149,7 +1151,8 @@ END $query .= $state . ", \'$bug_when\', \'$bug_when\', $ever_confirmed)\n"; # $query .= SqlQuote( "NEW" ) . ", now(), " . SqlQuote($comment) . " )\n"; - SendSQL("SELECT userid FROM profiles WHERE login_name=\'$reporter\'"); + SendSQL("SELECT userid FROM profiles WHERE " . + $dbh->sql_istrcmp('login_name', $dbh->quote($reporter))); my $userid = FetchOneColumn(); my $id; |