[SOLVED] How to get the url of image field

Hello,

I made an image-field in CB called cb_banners.

I also made an autoaction that after every update of the image-field it sets the link of the new image in a table per sql (#__banners).

Everything works fine, but if I use [cb_banners] it always set the complete URL with Domain-Name like " simple-quality.de/images/comprofiler/cb_banner_64_5120ad070ebac.jpg " in the field.

For the Joomla-banner-component I just need the path like: "images/comprofiler/cb_banner_64_5120ad070ebac.jpg" without " simple-quality.de/ " in the beginning.

In "#__comprofiler"-table it only saves the file-name like "cb_banner_64_5120ad070ebac.jpg".

Any chanche to get only the filname or the filename with path (without simple-quality.de )?

Greetings, Roland

Use CSV output for the fields substitution. Working example as follows.

[cb:userfield field="avatar" output="csv" /]

This will append live_site to it for you. Alternative is to append live_site your self using the below substitution.

[cb:config param="live_site" /]

Hello,

the first once don't work..

I used in autoaction: UPDATE `#__banners` SET `params` = '{"imageurl":"[cb:userfield field="cb_banner" output="csv" /]","width":"","height":"","alt":"Simple-Quality-Usermeeting 2013"}' WHERE `id` = '[cb_bannerid]'

And got: {"imageurl":" simple-quality.de/images/comprofiler/cb_banner_64_51224c331cb07.jpg ","width":"","height":"","alt":"Simple-Quality-Usermeeting 2013"}

But I need the url without the live_site: {"imageurl":"images/comprofiler/cb_banner_64_51224c331cb07.jpg","width":"","height":"","alt":"Simple-Quality-Usermeeting 2013"}

Any idea how I can get just the filed-value (filename) without live-site?

Thanks for your help.

Greetings,

Roland

Just build the path manually and add the substitution to it as follows.

images/comprofiler/[cb_bannerid]

Being a query you could also use SQL replacement functions to replace the live site. Example as follows.

REPLACE( '[cb:userfield field="avatar" output="csv" /]', '[cb:config param="live_site" /]/', '' )

images/comprofiler/[cb_bannerid]
=> don't work because [cb_bannerid] also gives the complete url (with simple-quality.de ....)

REPLACE( '[cb:userfield field="avatar" output="csv" /]', '[cb:config param="live_site" /]/', '' )
=> The replace works...

Here the query I used in autoaction:
UPDATE `#__banners` SET `params` = CONCAT('{"imageurl":"',REPLACE( '[cb:userfield field="cb_banner" output="csv" /]', '[cb:config param="live_site" /]/', '' ), '","width":"","height":"","alt":"Simple-Quality-Usermeeting 2013"}') WHERE `id` = '[cb_bannerid]'

Thanks a lot!