From 3ebf583de9be9e3d8411fb5422cc7ca716cd7b39 Mon Sep 17 00:00:00 2001 From: Pasi Kallinen Date: Sat, 2 Jan 2016 19:53:30 +0200 Subject: [PATCH] Fix SQLite query where underscore was an unintended wildcard --- dgamelaunch.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/dgamelaunch.c b/dgamelaunch.c index a52812d..df0d72b 100644 --- a/dgamelaunch.c +++ b/dgamelaunch.c @@ -2266,7 +2266,7 @@ userexist (char *cname, int isnew) if (isnew && (strlen(cname) >= globalconfig.max_newnick_len)) strcat(tmpbuf, "%"); - qbuf = sqlite3_mprintf("select * from dglusers where username like '%q' limit 1", tmpbuf); + qbuf = sqlite3_mprintf("select * from dglusers where username = '%q' collate nocase limit 1", tmpbuf); ret = sqlite3_open(globalconfig.passwd, &db); if (ret) { -- 2.47.3