new-user fixes

* Only use latest application password for new member apps, in case
  someone applied and was not accepted using the same username previously
* Call `create-user-new' rather than `create-user'

diff --git a/new-user b/new-user
index 56d7845..cb64723 100755 (executable)
--- a/new-user
+++ b/new-user
@@ -14,13 +14,13 @@ if test -z "$REALNM"; then
        exit 1
 fi
 
-INITPW=$(sudo -u hcoop psql hcoop_hcoop -tc "select unix_passwd from MemberApp where name = '${USERNM}';")
+INITPW=$(sudo -u hcoop psql hcoop_hcoop -tc "select unix_passwd from MemberApp where name = '${USERNM}' order by id desc limit 1;")
 
 
 #
 # Create user
 #
-/afs/hcoop.net/common/etc/scripts/create-user $USERNM || \
+/afs/hcoop.net/common/etc/scripts/create-user-new $USERNM || \
 ( echo "create-user $USERNM failed" && exit 2 )
 
 #