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/

eZ debug

Timing:	Jan 18 2025 22:12:10
Script start
Timing:	Jan 18 2025 22:12:10
Module start 'layout'
Timing:	Jan 18 2025 22:12:10
Module start 'content'
Timing:	Jan 18 2025 22:12:10
Module end 'content'
Timing:	Jan 18 2025 22:12:10
Script end

Main resources:

Total runtime	0.0156 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	588.4063	152.6875
Module start 'layout'	0.0057	0.0025	741.0938	39.5078
Module start 'content'	0.0082	0.0055	780.6016	89.3828
Module end 'content'	0.0136	0.0020	869.9844	30.3047
Script end	0.0156		900.2891

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0021	13.4189	14	0.0001
Check MTime	0.0009	5.9506	14	0.0001
Mysql Total
Database connection	0.0011	7.1209	1	0.0011
Mysqli_queries	0.0021	13.5880	3	0.0007
Looping result	0.0000	0.1097	1	0.0000
Template Total	0.0017	10.7	1	0.0017
Template load	0.0008	5.2481	1	0.0008
Template processing	0.0009	5.4462	1	0.0009
Override
Cache load	0.0005	3.1437	1	0.0005
General
dbfile	0.0006	3.8218	8	0.0001
String conversion	0.0000	0.0427	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs