function avg_grade($course_id)
{
global $wpdb;
$_rank = new NamasteRepRank();
$users = $wpdb->get_results($wpdb->prepare("SELECT tU.user_nicename as user_nicename, tU.ID as user_id, tSC.grade as grade\n\t\tFROM {$wpdb->users} tU JOIN " . NAMASTE_STUDENT_COURSES . " tSC ON tSC.user_id = tU.ID\n\t\tAND tSC.course_id=%d\n\t\tWHERE tSC.grade!='' ", $course_id));
$gradepoints = $_rank->get_gradepoints();
$total_points = 0;
foreach ($users as $user) {
if ($user->grade) {
$points = @$gradepoints[$user->grade];
}
if (empty($points)) {
$points = 0;
}
$total_points += $points;
}
// avg points
$avg_points = empty($total_points) ? 0 : round($total_points / sizeof($users));
$gradepoints = array_flip($gradepoints);
$value = @$gradepoints[$avg_points];
if (!$value) {
$value = __('n/a', 'namasterep');
}
return $value;
}
