Lines Matching refs:query

158             $this->model->sqlite->query("UPDATE {$this->get_table_name()} SET state=?, closed_by=?, close_date=? WHERE id=?",
167             $this->model->sqlite->query("UPDATE {$this->get_table_name()} SET state=? WHERE id=?", $state, $this->id);
184         $this->model->sqlite->query("UPDATE {$this->get_table_name()} SET private=? WHERE id=?", $private, $this->id);
187         $this->model->sqlite->query("UPDATE task SET private=? WHERE thread_id=?", $private, $this->id);
192         $this->model->sqlite->query('UPDATE thread SET last_activity_date=? WHERE id=?',
211         $r = $this->model->sqlite->query($sql, $this->id);
230         $r = $this->model->sqlite->query($q, $this->id, $user_id);
269         $this->model->sqlite->query($sql, $this->id, $user_id);
309             $this->model->sqlite->query($q, $this->id, $user_id);
334         $this->model->sqlite->query($q, $this->id, $user_id);
350         $r = $this->model->sqlite->query('SELECT * FROM label JOIN thread_label ON label.id = thread_label.label_id
366         $r = $this->model->sqlite->query('SELECT id FROM label WHERE id=?', $label_id);
386         $r = $this->model->sqlite->query('DELETE FROM thread_label WHERE thread_id=? AND label_id=?',$this->id, $label_id);
394         $r = $this->model->sqlite->query("SELECT id FROM thread_comment WHERE (type='cause' OR type='risk' OR type='opportunity') AND thread_id=?",
422         $res = $this->model->sqlite->query("SELECT state FROM task WHERE thread_id = ?
429         $res = $this->model->sqlite->query("SELECT thread_comment.id FROM thread_comment
596         $r = $this->model->sqlite->query("SELECT COUNT(*) FROM thread_comment WHERE thread_id=?",