|
Thursday 03 May 2007 3:20:55 am
Have a look at the way content classes work and content object attributes are stored in general.
http://ez.no/doc/ez_publish/technical_manual/3_8/concepts_and_basics/content_management/the_content_class
http://ez.no/doc/ez_publish/technical_manual/3_8/concepts_and_basics/content_management/class_attributes
http://ez.no/doc/ez_publish/technical_manual/3_8/concepts_and_basics/content_management/the_content_object
The user content class is described here:
http://ez.no/doc/ez_publish/technical_manual/3_8/reference/content_classes/users/user All that might look a bit strange at first, but the benefit of this concept is its huge flexibility. For example, if you want to look up all users' firstnames you can use this SQL statement:
select * from ezcontentobject_attribute where contentclassattribute_id = 8;
You can look up class attribute ids in the admin area at Setup > Classes.
For example http://<your_host>/<your_ez_siteaccess>/class/view/4
I hope this was useful for you to understand eZ Publish' concept of storing object data.
But in general, if you want to change object data per script you should use the appropriate PHP classes and methods rather than plain SQL.
|