Lines Matching refs:abbr
112 * @param string $abbr id
116 public function updateProject($pageid, $abbr = '', $name = '', $from = 0, $to = 0) { argument
119 if(!$abbr) $abbr = noNS($pageid);
124 if(!$page_id) dbg(['no page id',$pageid,$abbr,$name]);
125 …es = $sqlite->query('INSERT OR IGNORE INTO project (page_id, abbr) VALUES (?,?)', $page_id, $abbr);
128 $res = $sqlite->query("SELECT id FROM project WHERE page_id = ? AND abbr = ?", $page_id, $abbr);
139 $task_id = $this->updateTask($project_id,$abbr,$name);
150 * @param string $abbr
154 public function updateTask($project_id,$abbr,$name) { argument
157 …ite->query('INSERT OR IGNORE INTO task (project_id,abbr,active) VALUES (?,?,1)',$project_id,$abbr);
159 $res = $sqlite->query("SELECT id FROM task WHERE project_id = ? AND abbr = ?", $project_id,$abbr);
233 * @param string $abbr id
237 public function getProject($pageid, $abbr = '') { argument
240 if(!$abbr) $abbr = noNS($pageid);
246 $res = $sqlite->query("SELECT id FROM project WHERE page_id = ? AND abbr = ?", $page_id, $abbr);