Forums / Developer / Adding Column in Database

Adding Column in Database

Author Message

ez man

Thursday 03 May 2007 12:16:14 am

User ID: 1 Username: xyz Email: xyz@hotmail.com Account status: enabled
is what displayed when http://xyz.com/index.php/usr/content/view/full/1123
is seen in browser currently.

Now, i want to add another field 'Usertype' to be displayed after 'Account status: enabled'
Any suggestion on this?

Because in the table 'ezurl' we have only the following columns
contentobject_id
email
login
password_hash
password_hash_type

Suppose i had column 'usertype' in the above table, how can i add/display value from that table in the url http://xyz.com/index.php/usr/content/view/full/1123

Björn Dieding@xrow.de

Thursday 03 May 2007 1:48:23 am

you have 2 options

1.) create a new user class
2.) create new attribute as an addition to your existsing user class

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 man

Thursday 03 May 2007 3:09:01 am

I created new attribute as follows:
"Usertype [Text line] (id:220)" and added column 'Usertype' in 'ezurl' table.
How can I add 'Usertype' value while registering a new user so that I can display something like :

"User ID: 1 Username: xyz Email: xyz@hotmail.com Account status:enabled usertype:eventregistration"

Currently I am able to display only

"User ID: 1 Username: xyz Email: xyz@hotmail.com Account status:enabled"