How to programmatically insert a new field in comprofiler and comprofiler_fields

Hello,

I'm trying to use the Joomla API to add a new column to the comprofiler table, and I believe I also need to add a new row for this column in the comprofiler_fields table, please correct me if I'm wrong. I'm just trying to add a new field to be displayed on the user's profile and do all this programmatically. I think doing this through the CB backend, creates a new column in the comprofiler table as well as a new row in the "fields" table.

I'm wondering what is the "recommended" way to do this using the Joomla API, or is it easier to do through the CB API?

Cheers,
V

Simply put, you don't. Use CB API to do so. Once CB API has been included you can make an instance of FieldTable class (note this is a namespaced class) where you'll be able to do a ->store to create a field. See the below on how to include CB API.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18357-including-cb-api-for-usage-outside-of-cb

Below is where the FieldTable class is located.

libraries/CBLib/CB/Database/Table/FieldTable.php

Ok, thanks for the link, Krilieon.

Would I create an instance of the FieldTable class and then use the store function to create the new field, and will it also add the associated columns in the comprofiler table? I'm planning on adding the new fields onUserLogin....

Thanks again,
V

Is there code I should be usinig to close database connection as well or does CB already do that after the store?

Thank you kindly,
V

Would I create an instance of the FieldTable class and then use the store function to create the new field, and will it also add the associated columns in the comprofiler table?

Yes.

Is there code I should be usinig to close database connection as well or does CB already do that after the store?

With Joomla/CB APIs you don't manually open or close the connection. That's all handled further up the chain in the database APIs. Basically doing a ->store opens and closes the connection automatically.

Thanks for you quick response Krileon.

Sorry I have one more question, I had included the code below

and it was working when I called it through a CB auto action.

When I called my function through another page, I now get this error when it tries to add new columns:
I'm creating the new object using this code here: It seems like it is happening inside the field table's store function on this line here: $_PLUGINS->loadPluginGroup( 'user' );

Any insights would be greatly appreciated.

Thanks again.
V