function _quiz_get_duration_intervals in Quiz 6.4
Same name and namespace in other branches
- 8.4 quiz.admin.inc \_quiz_get_duration_intervals()
- 7 quiz.admin.inc \_quiz_get_duration_intervals()
- 7.4 quiz.admin.inc \_quiz_get_duration_intervals()
Returns an array with sql where clauses correscponding to the options in the duration filters.
Return value
$changed_timestamps array of timestamps and sql filters
See also
_quiz_questions_browser_form()
1 call to _quiz_get_duration_intervals()
- _quiz_results_mr_prepare_filter in ./
quiz.admin.inc - Returns sql and parameters to be added in join, where and group clauses in the _quiz_results_mr_data_provider select statement
File
- ./
quiz.admin.inc, line 2703 - Administrator interface for Quiz module.
Code
function _quiz_get_duration_intervals() {
// Create datastructure to help create where clause in the sql for the changed filter...
$durations = array(
NULL,
'> 60',
'> 300',
'> 600',
'> 3600',
'> 28800',
'> 86400',
'< 60',
'< 300',
'< 600',
'< 3600',
'< 28800',
'< 86400',
);
foreach ($durations as $key => &$val) {
if ($val == NULL) {
continue;
}
$durations[$key] = ' AND (time_end - time_start) ' . $val;
}
return $durations;
}