Lines Matching refs:sqlite

28             $sqlite = $db_helper->getDB();
36         if (!$helper->use_approve_here($sqlite, $INFO['id'])) return;
58             $sqlite = $db_helper->getDB();
66         if (!$helper->use_approve_here($sqlite, $INFO['id'])) return;
68         $last_approved_rev = $helper->find_last_approved($sqlite, $INFO['id']);
83             $sqlite = $db_helper->getDB();
93         if (!$helper->use_approve_here($sqlite, $INFO['id'], $approver)) return;
96         $res = $sqlite->query('SELECT MAX(version)+1 FROM revision
98         $next_version = $sqlite->res2single($res);
103         $sqlite->query('UPDATE revision
120             $sqlite = $db_helper->getDB();
130         if (!$helper->use_approve_here($sqlite, $INFO['id'])) return;
133         $sqlite->query('UPDATE revision SET ready_for_approval=?, ready_for_approval_by=?
151             $sqlite = $db_helper->getDB();
162         if (!$helper->use_approve_here($sqlite, $INFO['id'], $approver)) return;
165         $last_approved_rev = $helper->find_last_approved($sqlite, $INFO['id']);
191             $sqlite = $db_helper->getDB();
201         if (!$helper->use_approve_here($sqlite, $INFO['id'], $approver)) return;
208         $res = $sqlite->query('SELECT ready_for_approval, ready_for_approval_by,
213         $approve = $sqlite->res_fetch_assoc($res);
214         $last_approved_rev = $helper->find_last_approved($sqlite, $INFO['id']);
247                 $res = $sqlite->query('SELECT rev, current FROM revision
251                 $last_approve = $sqlite->res_fetch_assoc($res);
280             $res = $sqlite->query('SELECT rev, current FROM revision
284             $last_approve = $sqlite->res_fetch_assoc($res);
357             $sqlite = $db_helper->getDB();
363         $res = $sqlite->query('SELECT rev FROM revision
369         return $sqlite->res2single($res);
381             $sqlite = $db_helper->getDB();
411                     $sqlite->query('UPDATE revision SET rev=? WHERE page=? AND rev=?',
416                     $sqlite->query('UPDATE revision SET current=0
420                     $sqlite->storeEntry('revision', [
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);
441                 if ($helper->isPageAssigned($sqlite, $id, $newApprover)) {
444                         'hidden' => $helper->in_hidden_namespace($sqlite, $id) ? '1' : '0'
449                     $sqlite->storeEntry('page', $data);
454                 $sqlite->storeEntry('revision', [