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/bugzilla_email_append.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/bugzilla_email_append.pl')
-rwxr-xr-x | contrib/bugzilla_email_append.pl | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/contrib/bugzilla_email_append.pl b/contrib/bugzilla_email_append.pl index fee9b62ac..e409f0862 100755 --- a/contrib/bugzilla_email_append.pl +++ b/contrib/bugzilla_email_append.pl @@ -42,6 +42,8 @@ use BugzillaEmail; use Bugzilla::Config qw(:DEFAULT $datadir); use Bugzilla::BugMail; +my $dbh = Bugzilla->dbh; + # Create a new MIME parser: my $parser = new MIME::Parser; @@ -101,7 +103,8 @@ if (!defined($found_id)) { } # get the user id -SendSQL("SELECT userid FROM profiles WHERE login_name = \'$SenderShort\';"); +SendSQL("SELECT userid FROM profiles WHERE " . + $dbh->sql_istrcmp('login_name', $dbh->quote($SenderShort))); my $userid = FetchOneColumn(); if (!defined($userid)) { DealWithError("Userid not found for $SenderShort"); |