Lines Matching refs:pid
90 foreach ($pids as $pid) {
91 $this->updatePageAssignments($pid);
120 $sql = 'SELECT pid FROM structpublish_assignments WHERE user = ? AND status = ?';
126 $ok = $ok && $this->deassignPage($row['pid'], $user, $status);
135 * @param string $pid
137 public function updatePageAssignments($pid, $reload = false)
142 $rules = $this->getPageAssignments($pid, true);
146 $this->assignPage($pid, $user, $status);
189 $sql = 'REPLACE INTO structpublish_assignments (pid, user, status, assigned) VALUES (?, ?, ?, 1)';
202 $sql = 'UPDATE structpublish_assignments SET assigned = 0 WHERE pid = ? AND user = ? AND status = ?';
239 $sql = 'SELECT user, status FROM structpublish_assignments WHERE pid = ? AND assigned = 1';
257 $sql = 'SELECT pid, user, status, assigned FROM structpublish_assignments WHERE 1=1';
265 $sql .= ' ORDER BY pid, user, status';
271 $pid = $row['pid'];
274 if (!isset($result[$pid])) {
275 $result[$pid] = array();
277 $result[$pid][$user][$status] = (bool) $row['assigned'];