diff options
| author | jeroenwalter <jeroen@enormkansloos.nl> | 2015-05-09 14:37:36 +0200 |
|---|---|---|
| committer | jeroenwalter <jeroen@enormkansloos.nl> | 2015-05-09 14:37:36 +0200 |
| commit | d5735d14dbf7dd7b4764d61cba3b54ce29b07a6e (patch) | |
| tree | aa60841a38a36a6e5e81fb5b4d3ae72c57a4d8b9 | |
| parent | 43bb1684c68f707a6fe999b5c206179ecccd07e2 (diff) | |
| download | ComicRackWeb-d5735d14dbf7dd7b4764d61cba3b54ce29b07a6e.zip ComicRackWeb-d5735d14dbf7dd7b4764d61cba3b54ce29b07a6e.tar.gz ComicRackWeb-d5735d14dbf7dd7b4764d61cba3b54ce29b07a6e.tar.bz2 | |
treat username case insensitive when logging in.
| -rw-r--r-- | ComicRackWebViewer/UserDatabase.cs | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/ComicRackWebViewer/UserDatabase.cs b/ComicRackWebViewer/UserDatabase.cs index eeb97ba..3830597 100644 --- a/ComicRackWebViewer/UserDatabase.cs +++ b/ComicRackWebViewer/UserDatabase.cs @@ -41,7 +41,7 @@ namespace BCR public static string LoginUser(string username, string password) { - NameValueCollection result = Database.Instance.QuerySingle("SELECT * FROM user WHERE username = '" + username + "' LIMIT 1;"); + NameValueCollection result = Database.Instance.QuerySingle("SELECT * FROM user WHERE username = '" + username + "' COLLATE NOCASE LIMIT 1;"); if (result == null) return null; |