Lines Matching defs:pid
127 $queries = array(array('DELETE FROM taggings WHERE pid = ? AND tagger = ?', $id, $user));
129 $queries[] = array('INSERT INTO taggings (pid, tagger, tag, lang) VALUES(?, ?, ?, ?)', $id, $user, $tag, $lang);
147 * @param string $type What field to return 'tag'|'pid'
165 if (isset($filter['pid'])) $queryBuilder->setPid($filter['pid']);
327 $filter = array('pid' => $INFO['id']);
354 'pid' => $INFO['id'],
383 $order_fields = array('pid', 'tid', 'taggers', 'ns', 'count');
393 $query = 'SELECT "pid",
396 GROUP_SORT(GROUP_CONCAT(GET_NS("pid")), \', \') AS "ns",
397 GROUP_SORT(GROUP_CONCAT("pid"), \', \') AS "pids",
400 WHERE "pid" GLOB ? AND GETACCESSLEVEL(pid) >= ' . AUTH_READ
417 * @return array ['pid' => ['tag1','tag2','tag3']]
421 SELECT pid, GROUP_CONCAT(tag) AS tags
423 GROUP BY pid
431 array_column($db->res2arr($res), 'tags', 'pid')
467 $insertQuery .= 'SELECT pid, ?, tagger, lang FROM taggings';
469 $where .= ' AND GETACCESSLEVEL(pid) >= ' . AUTH_EDIT;
511 * @param string $pid
517 public function modifyPageTag($pid, $formerTagName, $newTagName) {
522 'SELECT pid FROM taggings WHERE CLEANTAG(tag) = ? AND pid = ?',
524 $pid
534 'DELETE FROM taggings WHERE pid = ? AND CLEANTAG(tag) = ?',
535 $pid,
540 'UPDATE taggings SET tag = ? WHERE pid = ? AND CLEANTAG(tag) = ?',
542 $pid,
566 $queryBody = 'FROM taggings WHERE pid GLOB ? AND (' .
577 $affectedPagesQuery= 'SELECT DISTINCT pid ' . $queryBody;
594 WHERE NOT PAGEEXISTS(pid)
608 $db->query('UPDATE taggings SET pid = ? WHERE pid = ?', $newName, $oldName);
646 $queryBuilder->setField('pid');
652 if (isset($parsedQuery['pid'])) $queryBuilder->setPid($parsedQuery['pid']);
687 $sql = 'SELECT pid from taggings where CLEANTAG(tag) = CLEANTAG(?)';
694 $pid = $page['pid'];
695 $html .= '<li><a href="' . wl($pid) . '" target="_blank">' . $pid . '</li>';
842 foreach ($pids as $pid) {
843 if (auth_quickaclcheck($pid) >= AUTH_EDIT) {
900 $html .= '<tr><td>' . $row['pid'] . '</td><td>' . $row['tags'] . '</td></tr>';
1011 $query = 'SELECT "pid",
1014 WHERE NOT PAGEEXISTS(pid)
1015 GROUP BY pid