Tuesday 03 January 2006 5:36:48 am
Hi, I have a slight problem concerning how to manipulate a users usergroup via a SQL-query. The application I'm coding is supposed to let a user insert a one time code (provided to her via SMS) into a table, and when the code is accepted by the system, it should place the user in usergroup Z I've been searching through the database for some sort of cross-reference table that tells eZ that user X is part of usergroup Y but to no avail. The ugly solution would be to make a separate table in the database, telling if user X has inserted the code and having the webpage query that table every time the user tries to access a restricted part of the site. But a solution just placing the user in the correct usergroup would be a lot prettier. Any suggestions or pointers in the right direction is highly appreciated!
|