From: zacheiss <zacheiss>
Date: Thu, 9 Apr 2009 20:25:54 +0000 (+0000)
Subject: check_username_available() should know about the userhistory table.
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/4da47473feda7571d88722b17a98cd5e01ffa43f?hp=e984ef977fd3def1ee1baa2352f2cc357e07bbe1

check_username_available() should know about the userhistory table.
---

diff --git a/reg_svr/reg_svr.pc b/reg_svr/reg_svr.pc
index 79d209ca..a8616151 100644
--- a/reg_svr/reg_svr.pc
+++ b/reg_svr/reg_svr.pc
@@ -1006,6 +1006,13 @@ int check_username_available(char *username)
   if (count != 0)
     return MR_IN_USE;
 
+  EXEC SQL SELECT COUNT(login) INTO :count FROM userhistory
+    WHERE login = :username;
+  if (sqlca.sqlcode)
+    return MR_DBMS_ERR;
+  if (count != 0)
+    return MR_IN_USE;
+
   return MR_SUCCESS;
 }