Mercurial > hg > egg-tcls

changeset 667:88d0e2ba73ca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
quotedb: Use LIKE instead of = for user.
author Matti Hamalainen <ccr@tnsp.org>
date Tue, 23 Feb 2021 13:04:24 +0200
parents 79b5d8944eea
children a026f5eb9439
files quotedb.tcl
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/quotedb.tcl	Sat Feb 20 17:52:49 2021 +0200
+++ b/quotedb.tcl	Tue Feb 23 13:04:24 2021 +0200
@@ -147,7 +147,7 @@
   set qoverride [matchattr $uhand n]
   set usql "SELECT utime AS utime FROM $utable WHERE id=$unum"
   if {$qoverride == 0} {
-    append usql " AND user='[utl_escape $uhand]'"
+    append usql " AND user LIKE '[utl_escape $uhand]'"
     set qextra ""
   } else {
     set qextra [qdb_qm $utable "update_override"]
@@ -196,7 +196,7 @@
   set qoverride [matchattr $uhand n]
   set usql "SELECT utime AS utime FROM $utable WHERE id=$unum"
   if {$qoverride == 0} {
-    append usql " AND user='[utl_escape $uhand]'"
+    append usql " AND user LIKE '[utl_escape $uhand]'"
     set qextra ""
   } else {
     set qextra [qdb_qm $utable "update_override"]
@@ -277,7 +277,7 @@
   }
 
   # Check if user has previously voted this item
-  set usql "SELECT id AS qid FROM ${utable}_votes WHERE user='[utl_escape $uhand]' AND urlid=$uid"
+  set usql "SELECT id AS qid FROM ${utable}_votes WHERE user LIKE '[utl_escape $uhand]' AND urlid=$uid"
   qdb_handle eval $usql {
     # Yes, update the previous vote
     set usql "UPDATE ${utable}_votes SET vote=$uvote WHERE id=$qid"