AND module_id > 0 GROUP BY module_id", $terms, $course_id); foreach ($result as $row) { $mid = $row->module_id; if ($mid == MODULE_ID_UNITS) { // course inits $chart->growWithPoint($langCourseUnits, $row->tot_dur); } else { // other modules $chart->growWithPoint($modules[$mid]['title'], $row->tot_dur); } } $chart_error = $langDurationExpl; break; } if (isset($_POST['btnUsage'])) { $chart->normalize(); $tool_content .= $chart->plot($chart_error); } $letterlinks = ''; $result = Database::get()->queryArray("SELECT LEFT(a.surname, 1) AS first_letter FROM user AS a LEFT JOIN course_user AS b ON a.id = b.user_id WHERE b.course_id = ?d GROUP BY first_letter ORDER BY first_letter", $course_id); foreach ($result as $row) { $first_letter = $row->first_letter; $letterlinks .= '<a href="?course=' . $course_code . '&first=' . urlencode($first_letter) . '">' . q($first_letter) . '</a> '; } $user_opts = '<option value="-1">' . $langAllUsers . "</option>"; $user_opts .= '<option value="0">' . $langAnonymous . "</option>";