Lines Matching refs:pid
103 // update pid definitions
104 $sql = preg_replace('/pid (\w* ?NOT NULL|\w* ?PRIMARY KEY)/', 'pid TEXT DEFAULT ""', $sql);
111 $sql = str_replace(')', ', rid INTEGER, PRIMARY KEY(pid,rid) )', $sql);
134 // transfer pid to rid
135 $s = sprintf('INSERT INTO data_%s SELECT *, pid FROM temp_data_%s', $name, $name);
139 $s = sprintf('INSERT INTO multi_%s SELECT *, pid FROM temp_multi_%s', $name, $name);
144 $s = "UPDATE data_$name SET pid = ''";
148 $s = "UPDATE multi_$name SET pid = ''";
232 * was always ["", <previous-pid-aka-new-rid>]. For page references it is ["<previous-pid>", 0]
257 $s = 'SELECT pid, rid, rev, ' . implode(', ', $colnames) . " FROM data_$name";
262 [$pid, $rid, $rev, $colref, $rowno, $fixes] = $this->getFixedValues($row);
267 WHERE pid = ?
270 $params = [$pid, $rid, $rev];
277 $s = "SELECT colref, pid, rid, rev, row, value FROM multi_$name";
282 [$pid, $rid, $rev, $colref, $rowno, $fixes] = $this->getFixedValues($row);
287 WHERE pid = ?
292 $params = [$pid, $rid, $rev, $colref, $rowno];
397 $pid = $row['pid'];
407 if (in_array($col, ['pid', 'rid', 'rev', 'colref', 'row'])) {
410 preg_match('/^\["",(?<pid>.*?\D+.*?)\]$/', $value, $matches);
411 if (!empty($matches['pid'])) {
412 $fixes[$col] = '["' . $matches['pid'] . '",0]';
420 return [$pid, $rid, $rev, $colref, $rowno, $fixes];