FROM Balance JOIN WebUser
ON Balance.name = WebUser.name
AND WebUser.bal = Balance.id
+ JOIN Membership
+ ON Membership.grp = 1
+ AND Membership.usr = WebUser.id
ORDER BY Balance.name`)
fun listUnownedBalances () =
FROM Balance LEFT OUTER JOIN WebUser
ON Balance.name = WebUser.name
AND WebUser.bal = Balance.id
+ LEFT OUTER JOIN Membership
+ ON Membership.grp = 1
+ AND Membership.usr = WebUser.id
WHERE WebUser.id IS NULL
+ OR Membership.grp IS NULL
ORDER BY Balance.name`)
fun validBalanceName name =
Init.grandfatherUsers()
%><h3>Grandfathered</h3>
-<% end %>
-
-<% if showNormal then %>
+<% elseif $"cmd" = "addform" then
+ showNormal := false %>
<h3>New member</h3>
<form action="users" method="post">
</table>
</form>
+<% end %>
+
+<% if showNormal then %>
+
+<a href="users?cmd=addform">Add a user manually</a><br>
+
<h3>Manage current members</h3>
<table>