Lines Matching refs:sqlite

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);
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);
269         $this->model->sqlite->query($sql, $this->id, $user_id);
300             $this->model->sqlite->storeEntry('thread_participant', $values);
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
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);
373         $this->model->sqlite->storeEntry('thread_label',
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=?",
396         $arr = $this->model->sqlite->res2arr($r);
422         $res = $this->model->sqlite->query("SELECT state FROM task WHERE thread_id = ?
425         return $this->model->sqlite->res2count($res);
429         $res = $this->model->sqlite->query("SELECT thread_comment.id FROM thread_comment
433         $causes_without_tasks = $this->model->sqlite->res2count($res);
596         $r = $this->model->sqlite->query("SELECT COUNT(*) FROM thread_comment WHERE thread_id=?",
598         $comments_count = $this->model->sqlite->res2single($r);