function _quiz_question_browser_prepare_filter_sql in Quiz 8.4

Same name and namespace in other branches

1. 6.4 quiz.admin.inc \_quiz_question_browser_prepare_filter_sql()
2. 7 quiz.admin.inc \_quiz_question_browser_prepare_filter_sql()
3. 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 1179

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 (isset($_SESSION[$pre . 'title']) && drupal_strlen($_SESSION[$pre . 'title']) > 0) {
    $filter_sql .= ' AND n.title LIKE \'%s%%\'';
    $filter_params[] = $_SESSION[$pre . 'title'];
  }
  if (isset($_SESSION[$pre . 'name']) && 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;
}