changeset 110:4aa1e1d545ed

urllog and quotedb: Use SQL LIKE operator for username search terms to avoid unnecessary case-sensitivity.
author Matti Hamalainen <ccr@tnsp.org>
date Mon, 19 Sep 2011 21:19:50 +0300
parents 74cb254dbf09
children e09c791b2a48
files quotedb.tcl urllog.tcl
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/quotedb.tcl	Mon Sep 19 21:18:57 2011 +0300
+++ b/quotedb.tcl	Mon Sep 19 21:19:50 2011 +0300
@@ -416,7 +416,7 @@
     if {$fprefix == "-"} {
       lappend fpatlist "utext NOT LIKE '%[qdb_escape $fpattern]%'"
     } elseif {$fprefix == "%"} {
-      lappend fpatlist "user='[qdb_escape $fpattern]'"
+      lappend fpatlist "user LIKE '[qdb_escape $fpattern]'"
     } elseif {$fprefix == "@"} {
       # foo
     } elseif {$fprefix == "+"} {
--- a/urllog.tcl	Mon Sep 19 21:18:57 2011 +0300
+++ b/urllog.tcl	Mon Sep 19 21:19:50 2011 +0300
@@ -581,7 +581,7 @@
     if {$fprefix == "-"} {
       lappend fpatlist "url NOT LIKE '%[urllog_escape $fpattern]%'"
     } elseif {$fprefix == "%"} {
-      lappend fpatlist "user='[urllog_escape $fpattern]'"
+      lappend fpatlist "user LIKE '[urllog_escape $fpattern]'"
     } elseif {$fprefix == "@"} {
       # foo
     } elseif {$prefix == "+"} {