Lines Matching refs:lastmod
77 $sql = "INSERT OR IGNORE INTO pages (page, lastmod) VALUES (?,?)";
82 $lastmod = @filemtime(wikiFN($page));
83 if ($lastmod) {
85 $this->db->exec($sql, [$page, $lastmod]);
178 * @param int $lastmod timestamp of last non-minor change
180 public function storePageDate($page, $lastmod, $newContent)
190 $sql = "REPLACE INTO pages (page, lastmod) VALUES (?,?)";
191 $this->db->exec($sql, [$page, $lastmod]);
279 $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, C.ack FROM assignments A
283 ON A.page = C.page AND ( (C.user = ? AND C.ack > B.lastmod) )
428 AND A.ack >= B.lastmod";
483 $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, MAX(C.ack) AS ack
527 $filterClause = ' AND ACK >= A.lastmod ';
531 $sql = "SELECT A.page, A.lastmod, B.user, MAX(B.ack) AS ack
551 'lastmod' => $acknowledgements[0]['lastmod'],
574 return $info['ack'] < $info['lastmod'];
591 SELECT A.page, A.user, B.lastmod, max(A.ack) AS ack
612 $filterClause = " HAVING ack >= $alias.lastmod ";
615 $filterClause = " HAVING (ack IS NULL) OR (ack < $alias.lastmod) ";
618 $filterClause = " HAVING ack < $alias.lastmod ";