Table Details

Next topic

Author	Message
ez man	Thursday 03 May 2007 12:47:12 am Hi User account information is stored in ezuser table. Where is firstname,lastname,signature information stored in ezpublish cms?
Silke Fox	Thursday 03 May 2007 2:20:35 am Hi, users are handled in the same manner as other content objects in eZ Publish. So firstname, lastname etc. are stored in the ezcontentobject_attribute table. Hope that helps. Silke
ez man	Thursday 03 May 2007 2:39:31 am Table 'ezcontentobject_attribute' has the following columns: attribute_original_id int(11) contentclassattribute_id contentobject_id int(11) data_float float data_int int(11) data_text longtext data_type_string id int(11) language_code varchar(20) language_id int(11) sort_key_int int(11) sort_key_string varchar(255) version Can you tell me where firstname,lastname,signature are stored here?
Silke Fox	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.