Lines Matching refs:query
96 $res = $sqlite->query('SELECT MAX(version)+1 FROM revision
103 $sqlite->query('UPDATE revision
133 $sqlite->query('UPDATE revision SET ready_for_approval=?, ready_for_approval_by=?
208 $res = $sqlite->query('SELECT ready_for_approval, ready_for_approval_by,
247 $res = $sqlite->query('SELECT rev, current FROM revision
280 $res = $sqlite->query('SELECT rev, current FROM revision
363 $res = $sqlite->query('SELECT rev FROM revision
411 $sqlite->query('UPDATE revision SET rev=? WHERE page=? AND rev=?',
416 $sqlite->query('UPDATE revision SET current=0
429 $sqlite->query('DELETE FROM page WHERE page=?', $id);
434 $sqlite->query('DELETE FROM revision WHERE page=? AND rev=?', $id, $rev);
436 $sqlite->query('UPDATE revision SET current=0 WHERE page=? AND current=1', $id);