Lines Matching refs:sql

48         $sql = 'SELECT page, approver, hidden FROM page';
49         return $this->db->queryAll($sql);
54         $sql = 'SELECT approver FROM page WHERE page=? AND hidden != 1';
55         return $this->db->queryRecord($sql, $page_id);
60         $sql = 'SELECT value FROM config WHERE key=?';
61         return $this->db->queryValue($sql, $key);
76         $sql = 'UPDATE page SET hidden=? WHERE page=?';
77         $this->db->query($sql, $hidden, $page_id);
193 …$sql = 'SELECT page.page AS id, page.approver, revision.rev, revision.approved, revision.approved_…
199         $pages = $this->db->queryAll($sql, $namespace.'*', $filter);
222 …   $sql = 'SELECT page AS id, rev, approved, approved_by, ready_for_approval, ready_for_approval_by
224         $revisions = $this->db->queryAll($sql, $page_id);
233         $sql = 'SELECT ready_for_approval, ready_for_approval_by, approved, approved_by, version
235         $page = $this->db->queryRecord($sql, $page_id, $rev);
272 … $sql = 'SELECT rev FROM revision WHERE page=? AND approved IS NOT NULL ORDER BY rev DESC LIMIT 1';
273             return $this->db->queryValue($sql, $page_id);
275 …$sql = 'SELECT rev FROM revision WHERE page=? AND ready_for_approval IS NOT NULL ORDER BY rev DESC…
276             return $this->db->queryValue($sql, $page_id);
278         $sql = 'SELECT rev FROM revision WHERE page=? AND current=1';
279         return $this->db->queryValue($sql, $page_id);
287         $sql = 'UPDATE revision SET approved=?, approved_by=?,
290         $this->db->exec($sql, date('c'), $INFO['client'], $page_id, $page_id);
298         $sql = 'UPDATE revision SET ready_for_approval=?, ready_for_approval_by=?
300         $this->db->exec($sql, date('c'), $INFO['client'], $page_id);
338         $sql = 'SELECT 1 FROM revision WHERE page=? AND rev=?';
339         $exists = $this->db->queryValue($sql, $page_id, $last_change_date);
379         $sql = 'SELECT id, namespace, approver FROM maintainer ORDER BY namespace';
380         return $this->db->queryAll($sql);