Hi Menzer.
Thanks for the detailed bug report.
I have been doing some testing, and I have a new implementation of the my_certificates function, which seems to be working. It would be great if you can test it.
Just replace my_certificates function in moodle/auth/joomdle/auth.php by this one:
Code:
function my_certificates ($username)
{
global $CFG, $DB;
$username = utf8_decode ($username);
$username = strtolower ($username);
$user = get_complete_user_data ('username', $username);
$user_id = $user->id;
$cursos = enrol_get_users_courses ($user->id, true);
if (!count ($cursos))
return array ();
$c_ids = array ();
foreach ($cursos as $curso)
{
$c_ids[] = $curso->id;
}
$ids_str = implode (',', $c_ids);
$params = array ($user_id, $ids_str);
$certs = $DB->get_records_sql("SELECT c.name, c.id
FROM {$CFG->prefix}certificate c
LEFT JOIN {$CFG->prefix}certificate_issues ci ON c.id = ci.certificateid
WHERE ci.userid = ?
AND c.course in (?)
ORDER BY c.name DESC", $params);
$c = array ();
foreach ($certs as $cert)
{
$coursemodule = get_coursemodule_from_instance ("certificate", $cert->id);
$certificate['id'] = $coursemodule->id;
$certificate['name'] = $cert->name;
$certificate['date'] = $cert->certdate;
$c[] = $certificate;
}
return $c;
}
Please test and let us know if it solves the problem.
