Thanks, Shane, but I have a fairly good idea of what's going on with the
detailed security templates used at www.fusebox.org
What mystifies me is that I can find the following in act_login.cfm:
<cfquery name="checkforgroups" datasource="#request.maindsn#">
select ug.group_id,g.loginscript
from user_groups ug,groups g
where ug.group_id=g.group_id
and ug.user_id=#val(client.user_id)#
</cfquery>
<cfset client.user_groups=valuelist(checkforgroups.group_id)>
<cfloop query="checkforgroups">
<cfif len(trim(loginscript))>
<cfinclude template="#request.cfroot#/#loginscript#">
</cfif>
</cfloop>
which finds the Groups an EXISTING user is IN, but I can't find a query
that adds a NEW user_id to a specific group in the table user_groups.
I can add the appropriate query to insert a user_id, group_id pair to the
user_groups table. That's no problem. I'm just trying to understand how
www.fusebox.org does it. There might be a bit of black magic here that
would be interesting to learn.
best, paul
At 11:05 AM 10/16/00 -0400, you wrote:
>Paul,
>
>There is a great article in the November 2000 issue of CFDJ which outlines a
>security system similar to Steve Nelson's. The article is called "permission
>framework". This article may give you some insight.
>
>Shane Witbeck
>Webmaster
>
>-----Original Message-----
>From: paul smith [mailto:[EMAIL PROTECTED]]
>Sent: Monday, October 16, 2000 10:57 AM
>To: Fusebox
>Subject: Fusebox.org Code
>
>
>I'm going through the Member portion of the
>Fusebox.org CF code I downloaded.
>
>I can see where the User_Group is determined
>for an existing user (in act_login.cfm) when
>a user logs in.
>
>But I can't seem to find where a group is
>assigned when a new user registers. Where
>is this done?
>
>best, paul
>
>PS> Are the custom tags in the zip download
>up to date?
>
>----------------------------------------------------------------------------
>--
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
