69      * @param string $status
72     public function addPattern($pattern, $user, $status)  argument
76         $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
107      * @param string $status
110     public function removePattern($pattern, $user, $status)  argument
114         $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
121         $pagerows = $this->sqlite->queryAll($sql, [$user, $status]);
126             $ok = $ok && $this->deassignPage($row['pid'], $user, $status);
144         foreach ($rules as $status => $users) {
146                 $this->assignPage($pid, $user, $status);
184      * @param string $status
187     public function assignPage($page, $user = null, $status = null)  argument
190         return (bool) $this->sqlite->query($sql, [$page, $user, $status]);
200     public function deassignPage($page, $user, $status)  argument
203         return (bool) $this->sqlite->query($sql, [$page, $user, $status]);
273             $status = $row['status'];
277             $result[$pid][$user][$status] = (bool) $row['assigned'];