help for PHP Script

Hi,

Firstly sorry for my bad english. I would wish to update a particular field value in a Community Builder table after renewal payment validation. My table name is #_comprofiler and the field name is cb_cotisation. I've made tests but they don't seem play well. Anybody could check syntax of my srcipt that I have tape on PHP Script Settings of my plan, in Scription Active Script field.

Thanks a lot.

Hi

The only thing wrong is $row object doesn't contain osm_Numero_adherent (this is a custom field, so it's value is stored in different database table)

The easiest way to do make this script works is:

1. Login to administrator area of your site

2. Access to this URL:

domain.com/administrator/index.php?optio...d_id=ID_OF_THE_FIELD

- domain.com/administrator must be replaced with administrator URL of your site
- ID_OF_THE_FIELD must be replaced with id of the custom field osm_Numero_adherent

When you do that, the system will create a new field osm_Numero_adherent in table #__osmembership_subscribers, store value of that field into the table and you can use it in the script

Try to do that and check it again, it should work as expected

Tuan