Lines Matching refs:q
371 $q = 'SELECT * FROM task_participant WHERE task_id=? AND user_id=?';
373 $q .= ' AND removed=0';
375 $r = $this->model->sqlite->query($q, $this->id, $user_id);
452 $q = "UPDATE task_participant SET $set WHERE task_id=? AND user_id=?";
453 $this->model->sqlite->query($q, $this->id, $user_id);
472 $q = "UPDATE task_participant SET removed=1 WHERE task_id=? AND user_id=?";
473 $this->model->sqlite->query($q, $this->id, $user_id);
486 $q = "SELECT id, private FROM thread_view WHERE id = ? AND state IN ('opened', 'done')";
487 $r = $this->model->sqlite->query($q, $thread_id);
494 $q = "UPDATE task SET type='correction', thread_id=?";
496 $q .= ", private=1";
498 $q .= " WHERE id=?";
499 $this->model->sqlite->query($q, $thread_id, $this->id);
507 $q = "UPDATE task SET type='program', thread_id='', thread_comment_id='', private=0 WHERE id=?";
508 $this->model->sqlite->query($q, $this->id);