Forums / General / Change node posistion with the use of SQL update quires into the backend.
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.
CheersTore
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_treeeznodeassignment
I thing you need to delete or modify the usersession too, because the groups are stored int he sessiontable -> 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/
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0002 secs