function opigno_statistics_app_query_status_from_course_and_user in Opigno Statistics App 7

Get the course status for a user (status = if the user has passed or not)

File

includes/opigno_statistics_app.queries.inc, line 166

Code

function opigno_statistics_app_query_status_from_course_and_user($course_nid, $user_uid) {
  return db_query("\n    SELECT status\n    FROM {opigno_statistics_user_course}\n    WHERE uid = :uid\n    AND course_nid = :nid\n    ORDER BY timestamp\n    DESC\n    LIMIT 1\n  ", array(
    ':uid' => $user_uid,
    ':nid' => $course_nid,
  ))
    ->fetchField();
}