I'm having problems with users / privileges in midgard. To explain, let me tell you what I'm doing.
We receive registration and payment information, store it in our system, and then do the following: Create a sitegroup record (our memberid and the sitegroup username are the same to link the two DB's together. insert into sitegroup values (0,'$username','',0) We take the last_insert_id of the command (which should be sitegroup.id) and then create a person record: insert into person values (0,'$username',$sitegroup_id) (we get person_num from the last_insert_id info here) Then we create a Group Record: insert into grp values (0,'$username','$addr1 $addr2','$zip','$city', '','$email','',0,$sitegroup_id) (we get group_num from the last_insert_id info here) Then we create a Member Record: insert into member values (0,$person_num,$group_num,'','owner',$sitegroup_id) The above sequence should give us a new Site Group (which we treat as a billing entity, the admin group for that company, and the "super user". What am I missing here? I notice that there is a group called "sitegroup_name administrators" when I create a sitegroup in nadmin. Do I have to name my admin group that way? Why is namdin showing a "sitegroup_name administrators" group in SG0? If you can help me understand this then I think that my problem w/ being able to login as a sitegroup administrator and see my web sites, etc. is solved. Thanks...I really hate to bug you on this, but documenting the relationships between the entities is the only way to make this an integratable tool. I'm not complaining, I understand documentation can get behind coding.... :) I'll send you the doc's on how we've integrated our proprietary components w/ midgard when I get the kinks worked out. Thanks in Advance Rob --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
