Lines Matching refs:r
211 $r = $this->model->sqlite->query($sql, $this->id);
212 $pars = $this->model->sqlite->res2arr($r);
230 $r = $this->model->sqlite->query($q, $this->id, $user_id);
231 $par = $this->model->sqlite->res2row($r);
350 $r = $this->model->sqlite->query('SELECT * FROM label JOIN thread_label ON label.id = thread_label.label_id
352 $arr = $this->model->sqlite->res2arr($r);
366 $r = $this->model->sqlite->query('SELECT id FROM label WHERE id=?', $label_id);
367 $label_id = $this->model->sqlite->res2single($r);
385 /** @var \PDOStatement $r */
386 $r = $this->model->sqlite->query('DELETE FROM thread_label WHERE thread_id=? AND label_id=?',$this->id, $label_id);
387 if ($r->rowCount() != 1) {
394 $r = $this->model->sqlite->query("SELECT id FROM thread_comment WHERE (type='cause' OR type='risk' OR type='opportunity') AND thread_id=?",
396 $arr = $this->model->sqlite->res2arr($r);
450 $r = $this->model->thread_commentFactory->get_from_thread($this, array(), 'id DESC', 1);
451 $thread_comment = $r->fetch();
596 $r = $this->model->sqlite->query("SELECT COUNT(*) FROM thread_comment WHERE thread_id=?",
598 $comments_count = $this->model->sqlite->res2single($r);