Change node posistion with the use of SQL update quires into the backend.

Next topic

Author	Message
Tore Skobba	Monday 26 April 2004 4:45:04 am Hi all I am currently implementing a solution where users are positioned automatically in a user group depending on what they set an EZSelection to. Example: User selects “Class of” to 2004, he should then be assigned to the user group “Class of 2004” and get that user group access privileges. This I have solved with an SQL script which update the EzContentObjectTree and EzNodeAssignment tables correctly in the Ez database. Afterwards, I am running the “updateniceurls.php” script. My question is simply if this is enough? Should this work or is the location of the nodes stored anywhere else to? Based on my own tests it seems to work, but I just want to be a bit surer before eventual releasing into the production server. Cheers Tore
Björn Dieding@xrow.de	Tuesday 27 April 2004 4:38:26 am I would have done this with a workflow triggered after publish You need the change values in 2 table ezcontentobject_tree eznodeassignment I thing you need to delete or modify the usersession too, because the groups are stored int he session table -> ezsession Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/

Author

Message

Monday 26 April 2004 4:45:04 am

Hi all

I am currently implementing a solution where users are positioned automatically in a user group depending on what they set an EZSelection to.

Example: User selects “Class of” to 2004, he should then be assigned to the user group “Class of 2004” and get that user group access privileges.

This I have solved with an SQL script which update the EzContentObjectTree and EzNodeAssignment tables correctly in the Ez database. Afterwards, I am running the “updateniceurls.php” script. My question is simply if this is enough? Should this work or is the location of the nodes stored anywhere else to? Based on my own tests it seems to work, but I just want to be a bit surer before eventual releasing into the production server.

Cheers
Tore

Björn Dieding@xrow.de

Tuesday 27 April 2004 4:38:26 am

I would have done this with a workflow triggered after publish

You need the change values in 2 table
ezcontentobject_tree
eznodeassignment

I thing you need to delete or modify the usersession too, because the groups are stored int he session
table -> ezsession

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/