LLMS_Quiz_Data::get_average_grade( string $period = 'current' )
Retrieve avg grade of quiz attempts within the period
Parameters Parameters
- $period
-
(string) (Optional) date period [current|previous]
Default value: 'current'
Return Return
(int)
Source Source
File: includes/class.llms.quiz.data.php
public function get_average_grade( $period = 'current' ) {
global $wpdb;
$grade = $wpdb->get_var(
$wpdb->prepare(
"
SELECT ROUND( AVG( grade ), 3 )
FROM {$wpdb->prefix}lifterlms_quiz_attempts
WHERE quiz_id = %d
AND update_date BETWEEN %s AND %s
",
$this->post_id,
$this->get_date( $period, 'start' ),
$this->get_date( $period, 'end' )
)
);
return $grade ? $grade : 0;
}
Expand full source code Collapse full source code View on GitHub
Changelog Changelog
| Version | Description |
|---|---|
| 3.16.0 | Introduced. |