From 4da47473feda7571d88722b17a98cd5e01ffa43f Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Thu, 9 Apr 2009 20:25:54 +0000
Subject: [PATCH] check_username_available() should know about the userhistory
 table.

---
 reg_svr/reg_svr.pc | 7 +++++++
 1 file changed, 7 insertions(+)

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;
 }
 
-- 
2.45.1