Forums / Developer / Extending the Usertable

Extending the Usertable

Author Message

John Moritz

Saturday 05 April 2008 8:47:23 am

I am planing to migrate my Community which is administrated with phpmyadmin to ezPublish. My existing Community is something like a social network. User can tell something about their life like Birthday, Favorite books or movies... At the Moment the Basic Informations are in one Usertable, together with Password and Nick, and extra Information in an extra Table wich is referenced by the UserID.

When i migrate to ezPublish how should i do this. Extend the existing "ezuser" Table manualy, and make 2 extra tables with further informations? Maybe i overlooked something and there are some built in Tools to extend the Usertable. In the past i worked with a Bulletin Board called Invision Power Board. On this BB i could extend the Useriniformations over the Admin Backend. Never needed phpmyadmin or somoething else, no handcoding. The user then had more options in their Profile and me as admin had the possibility to change the Details in the Backend.

I am sure i could do it my way and code everything by hand, but if there is a solution out there it would be helpful to get those Informations.

Carlos Revillo

Saturday 05 April 2008 10:10:24 am

well, i think you don't need make any changes to that ezuser table. i mean, you can add attributes to the user class through the admin interface. so, these new attributes (birthday date, favourite movies and so on) will be part of the data_map of the object for the users, along with firstname, picture and so on.

favourite movies could be a relation objects to other type of objects, for example.

Maybe this contrib
http://ez.no/developer/contribs/import_export/user_creator
could help you with your work.

John Moritz

Monday 07 April 2008 8:39:46 am

Thanks Carlos, this was exactly what i am searchin for. Just added attributes to my Users, perfect!

eZ debug

Timing: Jan 20 2025 17:36:05
Script start
Timing: Jan 20 2025 17:36:05
Module start 'content'
Timing: Jan 20 2025 17:36:06
Module end 'content'
Timing: Jan 20 2025 17:36:06
Script end

Main resources:

Total runtime1.0811 sec
Peak memory usage4,096.0000 KB
Database Queries194

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0064 587.7031180.8438
Module start 'content' 0.00640.9517 768.5469496.8906
Module end 'content' 0.95810.1230 1,265.4375333.4844
Script end 1.0811  1,598.9219 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.3562210.0002
Check MTime0.00140.1313210.0001
Mysql Total
Database connection0.00080.076510.0008
Mysqli_queries1.017094.07021940.0052
Looping result0.00180.16681920.0000
Template Total1.056997.820.5284
Template load0.00200.187720.0010
Template processing1.054897.567920.5274
Template load and register function0.00010.009810.0001
states
state_id_array0.00040.040610.0004
state_identifier_array0.00140.132020.0007
Override
Cache load0.00160.1509140.0001
Sytem overhead
Fetch class attribute can translate value0.00090.081830.0003
Fetch class attribute name0.00110.097430.0004
XML
Image XML parsing0.00040.039830.0001
class_abstraction
Instantiating content class attribute0.00000.000830.0000
General
dbfile0.00530.4944210.0003
String conversion0.00000.000430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 10
 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs