[SOLVED] CBsubs: Field plugin, show/hide module and more..

hello

1) When using CBsubs field plugin (for example for add a value on plan activation), it is mentioned "CB fields changing on plan activation and deactivation" but this mean if a user renew before expiration an existent and always active plan, the value set will not be added? Or by "activation" this mean also "renewal" ??


2) Actually if I want use "Modules which access depends on this plan" feature, I'm supposed to select all modules I want be accessible and keep unselected the one who need to have an active subscription. I wondering if is possible to do the opposite... In fact if I add later news "public" module, it will necessary to not forget to re-configure all plans. I think is more logic to set module who access depend on plan instead the opposite.

I miss something ?


3) Time ago I setup a Query field "cb_trimmedtext" with this code:

SELECT SUBSTRING(`cb_presentation`,1,250) FROM `jos_comprofiler` WHERE `user_id` = '[user_id]'

The goal of this field is to be used inside User List trough a Delimiter field for display only the first 250 characters contained inside Editor Textarea field "cb_presentation".

In practice all work fine but I just noticed the trimmed text display a backslash before words who contain quote (french language). For example instead to display "L'immeuble" I get "L\'immeuble"

When I look on the Textarea field "cb_presentation" itself, no backslash are displayed.

Any idea why this happen ?


4) I want use "Image Gallery" who allow to choose a predefined Avatar and delete all default image for put my own. If later I update CB, those default image will be again added or not ?



thank

1) When using CBsubs field plugin (for example for add a value on plan activation), it is mentioned "CB fields changing on plan activation and deactivation" but this mean if a user renew before expiration an existent and always active plan, the value set will not be added? Or by "activation" this mean also "renewal" ??

Activation means anything that activates the plan. This could be renewal, upgrade, or new subscription. CBSubs uses a status and a reason for that status. So for example the Status is "A" (activation), but the Reason is "U" (upgrade).

2) Actually if I want use "Modules which access depends on this plan" feature, I'm supposed to select all modules I want be accessible and keep unselected the one who need to have an active subscription. I wondering if is possible to do the opposite... In fact if I add later news "public" module, it will necessary to not forget to re-configure all plans. I think is more logic to set module who access depend on plan instead the opposite.

You select the modules you want accessible based off an activation subscription to that plan. So for example if I select "Latest Articles" module then I won't be able to see that module until I've actively subscribed to that plan. You can't do the reverse.

3) Time ago I setup a Query field "cb_trimmedtext" with this code:

SELECT SUBSTRING(`cb_presentation`,1,250) FROM `jos_comprofiler` WHERE `user_id` = '[user_id]'

The goal of this field is to be used inside User List trough a Delimiter field for display only the first 250 characters contained inside Editor Textarea field "cb_presentation".

In practice all work fine but I just noticed the trimmed text display a backslash before words who contain quote (french language). For example instead to display "L'immeuble" I get "L\'immeuble"

When I look on the Textarea field "cb_presentation" itself, no backslash are displayed.

Any idea why this happen ?

Check the value within your _comprofiler database and see if it's escaped there as well. The CB Query Field doesn't strip slashes so it's probably escaped in database and the query result is just displaying what's in database.

4) I want use "Image Gallery" who allow to choose a predefined Avatar and delete all default image for put my own. If later I update CB, those default image will be again added or not ?

If you install CB again then yes those defaults will be installed again, but your images should be fine assuming you didn't name them the same. Simply delete them on every update of CB.

About 3)

I looked inside DB for related user, but the value displayed is well formatted without slashe.

I tried to change the field name contained inside the Query with another who is not wysiwyg and the result is the same.

I tried also to include my delimiter (the one who display Query field) inside the profile and the result is worst because I get now "L\\\'immeuble" that mean wih 3 slashe !!

Maybe the Query need to be modified for avoid this issue ?

Any suggestion ?

Try displaying the query field as a regular field instead of substituting it through a delimiter field. It's possible the substitution it self is adding the escaping. For example set the query field to display on profile and see if it looks fine on profile.

Of course.. :blush: :whistle:

I tried to use Query field alone (I wonder finally why I decided to use delimiter..but if I remember well I got in the past some case where value was not displayed, except trough delimiter) but I get always the slashe.

Any other idea ?

So even if you display just the query field without a substitution it's still displaying slashes? If is the case then it's a bug, but not sure if CB is adding the slashes or if the database result is returned with slashes. Please confirm and will review plugins source to see if a bug is present.