Se trata de la función execute del fichero blocks/configurable_reports/components/filters/fuserfield/plugin.class.php
Hay que añadir a la línea 41 global $DB, $CFG;
Esta función quedaría así
function execute($finalelements,$data){
global $DB, $CFG;
$filter_fuserfield = optional_param(‘filter_fuserfield_’.$data->field,0,PARAM_RAW);
if($filter_fuserfield){
// addslashes is done in clean param
$filter = clean_param(base64_decode($filter_fuserfield),PARAM_CLEAN);
if(strpos($data->field,’profile_’) === 0){
if($fieldid = $DB->get_field(‘user_info_field’,'id’,array(‘shortname’ => str_replace(‘profile_’,”, $data->field)))){
list($usql, $params) = $DB->get_in_or_equal($finalelements);
$sql = “fieldid = ? AND data = ? AND userid $usql”;
$params = array_merge(array($fieldid, $filter),$params);
if($infodata = $DB->get_records_select(‘user_info_data’,$sql,$params)){
$finalusersid = array();
foreach($infodata as $d){
$finalusersid[] = $d->userid;
}
return $finalusersid;
}
}
}
else{
list($usql, $params) = $DB->get_in_or_equal($finalelements);
$sql = “$data->field = ? AND id $usql”;
$params = array_merge(array($filter),$params);
if($elements = $DB->get_records_select(‘user’,$sql,$params)){
$finalelements = array_keys($elements);
}
}
}
return $finalelements;
}
Un saludo
