Need an "ORDER BY status", since we want the status 0 account if there's

both a status 0 and a status 3 present.

diff --git a/reg_svr/reg_svr.pc b/reg_svr/reg_svr.pc
index e5a6cd931c1e0a576a533f1694f6811cf5ff45a5..d9964a89d083a7a21048cfc67bdf38ccca328cfe 100644 (file)
--- a/reg_svr/reg_svr.pc
+++ b/reg_svr/reg_svr.pc
@@ -501,7 +501,10 @@ void SPIN(reg_client *rc, int argc, char **argv)
       return;
     }
 
+  /* "ORDER BY status" so that if there's both a matching state 0 entry
+     and a matching state 3 entry, we'll get the former. */
   EXEC SQL SELECT pin INTO :pin FROM users WHERE clearid = :rc->id;
+  ORDER BY status;
   strtrim(pin);
   if (strcmp(argv[0], pin) != 0)
     {