We'ld like to offer community-wide search for titles and decriptions of a field which has type "Gallery" (in addition to let users search inside Gallery).
As there's apparently no Gallery Searchbot avail. we'ld like let cbsearchbot search a CB field type text.
CB field would have to get data from DB as follows:
SELECT CONCAT( title, ' ', description ) FROM `jos_comprofiler_plugin_gallery_items`
WHERE user_id = '[userid]'
AND CONCAT( title, description ) IS NOT NULL;
What is appropiate way to convert DB rows into a simple CB text field via Auto Action triggered by OnAfterUserUpdate/OnAfterUpdateUser?
1) Code Action and PHP program reading DB?
2) Query Action and facilitating variables? If yes ... how to do it?
Would heartly appreciate any help on this toipic.
Thank you.
krileon
