I could not find any docu on the matter.
I need to run a query on a jDownloads field. First I tried the Method "Query" with a static cat ID which worked, but I need to pull the cat IDs from my custom cb field. So I tried this code with Methode "PHP (create function)":
Code:
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->SELECT(cb_mycheckboxsubfield)
->FROM(#__comprofiler)
->WHERE(user_id=[user_id]);
$db->setQuery($query);
$catidString = str_replace ('|*|', ',',$db->loadResult());
$query = $db->getQuery(true);
$query->UPDATE(#__jdownloads_cats)
->SET(cat_description='[lastname]')
->WHERE cat_id IN ($catidString);
That gives an error:
Parse error: syntax error, unexpected T_OBJECT_OPERATOR, expecting ')' in .../components/com_comprofiler/plugin/user/plug_cbautoactions/models/code.php(59) : runtime-created function on line 4 Fatal error: Function name must be a string in .../components/com_comprofiler/plugin/user/plug_cbautoactions/models/code.php on line 60
What do I need to do to make that work?
krileon
