function _quiz_question_browser_prepare_filter_sql in Quiz 7
Same name and namespace in other branches
- 8.4 quiz.admin.inc \_quiz_question_browser_prepare_filter_sql()
- 6.4 quiz.admin.inc \_quiz_question_browser_prepare_filter_sql()
- 7.4 quiz.admin.inc \_quiz_question_browser_prepare_filter_sql()
Returns sql to be added in where clause in the browsers select statement
Parameters
$filter_params: params to be sent as parameter to db_query. (array)
Return value
$filter_sql sql to be added to where statement in browser(string)
See also
_quiz_questions_browser_form()
File
- ./
quiz.admin.inc, line 1485 - Administrator interface for Quiz module.
Code
function _quiz_question_browser_prepare_filter_sql(&$filter_params) {
$pre = 'quiz_question_browser_';
$changed_timestamps = _quiz_get_interval_timestamps('changed');
$filter_sql = '';
if (drupal_strlen($_SESSION[$pre . 'title']) > 0) {
$filter_sql .= ' AND n.title LIKE \'%s%%\'';
$filter_params[] = $_SESSION[$pre . 'title'];
}
if (drupal_strlen($_SESSION[$pre . 'name']) > 0) {
$filter_sql .= ' AND u.name LIKE \'%s%%\'';
$filter_params[] = $_SESSION[$pre . 'name'];
}
if (isset($_SESSION[$pre . 'type']) && $_SESSION[$pre . 'type'] !== '0') {
$filter_sql .= ' AND n.type = \'%s\'';
$filter_params[] = $_SESSION[$pre . 'type'];
}
if (isset($_SESSION[$pre . 'changed'])) {
$filter_sql .= $changed_timestamps[$_SESSION[$pre . 'changed']]['sql'];
}
return $filter_sql;
}