[wplug-web] members database

[Mark Dalrymple]

> I Have most of the wplug online members database together.

Sweet!

> How will this 
> database interact with users and administrators.

There's a permissions model.  You can see if the currently logged-in
user is the owner of their member info (e.g. the user id is the same
as the column used to join with the user tables), or is an administrator.
If so, you can present an admin page for editing the info(e).

> Once it is functioning OK, I'll begin to 
> migrate to tcl and OpenACS.

excellent.  The basic data models should be easily transportable.
Postgresql has real referential integrity, which you can take advantage
of.

Probably the best first-step would be to look at Joel Aufrechet's
tutorial:

http://openacs.org/doc/openacs-4-6-2/tutorial-newpackage.html

He covers making a package (you can ignore the stuff regarding CVS
and docmentation), making a table that hooks into acs_objects (the
basis of permissioning), writing query files, and also using the
templating system (specifically ad_form, which is a really easy way
to do html forms)

Cheers,
++md