Registration Module
Posted: Wed Jul 02, 2008 4:18 pm
I have recently taken over the development of a cmsms site.
Goal: Give roles to users. Assign number 1 representing "data entry" to a client id.
Three tables, security, security_role_owner, and security_role_enrollment.
Security has the field person_id, we need to grab the MAX from there.
Security_role_owner has the field security_role_id we need to grab number 1 out of there.
Security_role_enrollment has the fields security_role_id which the number 1 from field security_role_id from table security_role_owner will need to be inserted. Also has client_id which will have the MAX from the field person_id in table security.
So, In the table security_role_enrollment, the field security_role_id should have the value of 1, and the field client_id should have the MAX value (aka newest members person_id number).
Now if only someone could put that in php form =]
When I do it with my little experience I receive errors.
Goal: Give roles to users. Assign number 1 representing "data entry" to a client id.
Three tables, security, security_role_owner, and security_role_enrollment.
Security has the field person_id, we need to grab the MAX from there.
Security_role_owner has the field security_role_id we need to grab number 1 out of there.
Security_role_enrollment has the fields security_role_id which the number 1 from field security_role_id from table security_role_owner will need to be inserted. Also has client_id which will have the MAX from the field person_id in table security.
So, In the table security_role_enrollment, the field security_role_id should have the value of 1, and the field client_id should have the MAX value (aka newest members person_id number).
Now if only someone could put that in php form =]
When I do it with my little experience I receive errors.