Forums / Developer / Adding Column in Database

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Adding Column in Database

« 
Previous topic
|
Developer
|
Next topic
 »
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 X

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

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"