From b7d361f211812e6aab73ef038b06563198611af0 Mon Sep 17 00:00:00 2001
From: Nguyễn Gia Phong <mcsinyx@disroot.org>
Date: Mon, 6 Mar 2023 13:10:52 +0900
Subject: Correct uniqueness check

---
 src/http.cr | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

diff --git a/src/http.cr b/src/http.cr
index 192a398..ac688fb 100644
--- a/src/http.cr
+++ b/src/http.cr
@@ -93,10 +93,10 @@ class Server
       next http_error context, 400, "Invalid Parameter" if invalid_param
       next http_error context, 400, "Missing Parameter" unless params.size == 4
 
-
-      @db.exec "SELECT count(nick), count(opennic), count(icann)
-                FROM member
-                WHERE nick = %Q OR opennic = %Q OR icann = %Q",
+      @db.exec "SELECT count(CASE WHEN nick = %Q THEN 1 END),
+                       count(CASE WHEN opennic = %Q THEN 1 END),
+                       count(CASE WHEN icann = %Q THEN 1 END)
+                FROM member",
                params["nick"], params["opennic"], params["icann"] do |row|
         errors["nick"] = "Must be unique" if row[0].int > 0
         errors["opennic"] = "Must be unique" if row[1].int > 0
@@ -122,7 +122,6 @@ class Server
     end
   end
 
-  getter db
   getter opennic_page
   getter icann_page
 
-- 
cgit 1.4.1