Lines Matching refs:sqlite
64 $sqlite = $this->getDb();
65 if(!$sqlite) return false;
67 $res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
68 $db_user_id = (int) $sqlite->res2single($res);
69 $sqlite->res_close($res);
72 $sqlite->query('INSERT OR IGNORE INTO user (user) VALUES (?)', $user);
74 $res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
75 $db_user_id = (int) $sqlite->res2single($res);
76 $sqlite->res_close($res);
89 $sqlite = $this->getDb();
91 $res = $sqlite->query("SELECT id FROM page WHERE page = ?", $page);
92 $page_id = (int) $sqlite->res2single($res);
95 $sqlite->query('INSERT OR IGNORE INTO page(page) VALUES (?)',$page);
102 $res = $sqlite->query("SELECT id FROM page WHERE page = ?", $page);
103 $page_id = (int) $sqlite->res2single($res);
117 $sqlite = $this->getDb();
125 …$res = $sqlite->query('INSERT OR IGNORE INTO project (page_id, abbr) VALUES (?,?)', $page_id, $abb…
128 $res = $sqlite->query("SELECT id FROM project WHERE page_id = ? AND abbr = ?", $page_id, $abbr);
129 $project_id = (int) $sqlite->res2single($res);
130 $sqlite->res_close($res);
137 …$sqlite->query("UPDATE project SET name = ?, `from` = ?, `to` = ? WHERE id = ?", $name, $from, $to…
155 $sqlite = $this->getDb();
157 …$res = $sqlite->query('INSERT OR IGNORE INTO task (project_id,abbr,active) VALUES (?,?,1)',$projec…
159 $res = $sqlite->query("SELECT id FROM task WHERE project_id = ? AND abbr = ?", $project_id,$abbr);
160 $task_id = (int) $sqlite->res2single($res);
161 $sqlite->res_close($res);
168 $sqlite->query("UPDATE task SET name = ?, active = 1 WHERE id = ?", $name, $task_id);
181 $sqlite = $this->getDb();
183 $task_abbrs = $sqlite->quote_and_join($task_abbrs);
185 $sqlite->query("UPDATE task SET active = 0
199 $sqlite = $this->getDb();
201 …$sqlite->query('UPDATE user_time SET value = ?, update_time = ? WHERE id = ?', $value, time(), $us…
214 $sqlite = $this->getDb();
216 …$sqlite->query('INSERT INTO user_time (update_time,user_id,task_id, date, value) VALUES (?,?,?,?,?…
238 $sqlite = $this->getDb();
246 $res = $sqlite->query("SELECT id FROM project WHERE page_id = ? AND abbr = ?", $page_id, $abbr);
247 $project_id = (int) $sqlite->res2single($res);
248 $sqlite->res_close($res);
258 $sqlite = $this->getDb();
260 $res = $sqlite->query("SELECT
267 $data = $sqlite->res2single($res);
273 $sqlite = $this->getDb();
275 $res = $sqlite->query("SELECT
287 $data = $sqlite->res2arr($res);
293 $sqlite = $this->getDb();
295 $res = $sqlite->query("SELECT pr.id
301 $data = $sqlite->res2arr($res);
309 $sqlite = $this->getDb();
311 $res = $sqlite->query("SELECT
317 $data = $sqlite->res2row($res);
324 $sqlite = $this->getDb();
328 $res = $sqlite->query("SELECT
344 $data = $sqlite->res2arr($res);
356 $sqlite = $this->getDb();
357 if(!$sqlite) return false;
358 $res = $sqlite->query('SELECT
365 $db_id = (int) $sqlite->res2single($res);
366 $sqlite->res_close($res);
374 $sqlite = $this->getDb();
375 if(!$sqlite) return false;
380 $res = $sqlite->query("SELECT u.id
384 $db_user_id = (int) $sqlite->res2single($res);
385 $sqlite->res_close($res);
390 $sqlite = $this->getDb();
394 $res = $sqlite->query("SELECT
413 $data = $sqlite->res2arr($res);
419 $sqlite = $this->getDb();
423 $res = $sqlite->query("SELECT
435 $data = $sqlite->res2arr($res);
447 $sqlite = $this->getDb();
449 $res = $sqlite->query("SELECT
458 $data = $sqlite->res2row($res);
464 $sqlite = $this->getDb();
466 $res = $sqlite->query("SELECT
472 ut.task_id NOT IN (".$sqlite->quote_and_join($task_ids).")",
475 $data = $sqlite->res2single($res);
494 $sqlite = $this->getDb();
502 $cond_project = " pr.id IN (".$sqlite->quote_and_join($project_ids).") AND ";
506 $res = $sqlite->query("SELECT
526 $data = $sqlite->res2arr($res);
538 $sqlite = $this->getDb();
546 $cond_project = " pr.id IN (".$sqlite->quote_and_join($project_ids).") AND ";
550 $res = $sqlite->query("SELECT
562 $taskdata = $sqlite->res2arr($res);
568 $sqlite = $this->getDb();
569 if(!$sqlite) return false;
579 $res = $sqlite->query("SELECT
597 $data = $sqlite->res2arr($res);
603 $sqlite = $this->getDb();
604 if(!$sqlite) return false;
606 $res = $sqlite->query("SELECT
621 $data = $sqlite->res2arr($res);
632 $sqlite = $this->getDb();
634 $res = $sqlite->query("SELECT
648 $data = $sqlite->res2arr($res);
658 $sqlite = $this->getDb();
660 $res = $sqlite->query("SELECT
669 $data = $sqlite->res2row($res);
676 $sqlite = $this->getDb();
677 if(!$sqlite) return false;
678 $res = $sqlite->query("SELECT
687 $data = $sqlite->res2single($res);
693 $sqlite = $this->getDb();
695 $res = $sqlite->query("SELECT
704 $data = $sqlite->res2single($res);