Lines Matching refs:pages
71 * Fills the page index with all unknown pages from the fulltext index
76 $pages = idx_getIndex('page', '');
77 $sql = "INSERT OR IGNORE INTO pages (page, lastmod) VALUES (?,?)";
80 foreach ($pages as $page) {
170 $sql = "DELETE FROM pages WHERE page = ?";
190 $sql = "REPLACE INTO pages (page, lastmod) VALUES (?,?)";
280 JOIN pages B
361 // insert new patterns and gather affected pages
362 $pages = [];
371 // patterns may overlap, so we need to gather all affected pages first
374 if (isset($pages[$page])) {
375 $pages[$page] .= ',' . $assignees;
377 $pages[$page] = $assignees;
385 foreach ($pages as $page => $assignees) {
398 * Get all known pages that match the given pattern
405 $sql = "SELECT page FROM pages WHERE MATCHES_PAGE_PATTERN(?, page)";
406 $pages = $this->db->queryAll($sql, $pattern);
408 return array_column($pages, 'page');
424 FROM acks A, pages B
469 * Get all pages that a user needs to acknowledge and/or the last acknowledgement infos
485 JOIN pages B
532 FROM pages A
592 FROM acks A, pages B