Hello guys

How can I make the comprofiler id or the user_id fields show in the profile so that this info can be seen by registered users in the front end and used for searches in the lists.

I tried to create a new field and to document it automatically after registration with the CB Queries plugin but I could not figure out how to write the query... and using this method seems overkill.

I also tried the CB Query Field plugin but I could not figure out either and clicking on the plugin gave me a white screen error (so I unpublished it).

I read somewhere that there was a MySQL field plugin but I could not find it...

Finally and ideally, I would not want regular registered users to see their user ID info in their profile... only the users with higher proviledges...

Hope you can help and thanks for the great work...

John

Hi,

you can find the MySQL Plugin. Just enter "Mysql field" into the search box on the top of the page. The first entry will direct you to the plugin.

In my opinion it´s not a good idea to give the ID´s to users.
I don´t understand why to make that ID searchable, there are lot´s of other fields and parameters you could choose to find any information to fetch a special user.

Within a professional membership there´s a powerful plugin in the incubator called "CB Conditional Plugin". That would allow you to display tabs, fields etc. to a predefined constallation such as status, ids or any situation you like.

Regards
Some1new

I have plug_cbqueryfield-102 installed. Is it normal that I get a blank screen when I click on the plugin to check its parameters?

anyway... CB Query field or delimiter would not work because the field would not be searchable.

On the other hand, It seems to me that if I used CB Queries, the file would be searchable since the value of the field would simply be copied and pasted.

Here is the substitution query I tried with both CB Query field and CB Queries (as an automated query that runs after the registration and for registered users only...)

INSERT `#__jos_comprofiler` ( `cb_nameoffield` ) VALUES ( [user_id] )

It does not work.

Thanks

John

Oops...

Thanks for the code... I'll try asap with CB Queries as it works very well on my system.

How would this code need to be modified to copy the email of the profile owner into a new field in jos_comprofiler?

I need to send email notification to profile-owners and I have no clue as where to find this email. I assume that it is encrypted somewhere and need to be extracted somehow.

Thanks

John