Lines Matching refs:col
85 foreach (array_keys($data['cols']) as $col) {
92 $rows = $sqlite->queryAll($sql, $col, $id);
98 $cond[] = " ( T1.key = " . $sqlite->getPdo()->quote($col) .
108 $col = $data['sort'][0];
110 if ($col == '%pageid%') {
112 } elseif ($col == '%title%') {
116 if (!$tables[$col]) {
117 $tables[$col] = 'T' . (++$cnt);
118 $from .= ' LEFT JOIN data AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = pages.pid';
119 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col);
122 $order = ', ' . $tables[$col] . '.value ' . $data['sort'][1];
134 $col = $filter['key'];
137 if ($col == '%pageid%') {
141 } elseif ($col == '%title%') {
148 if (!$tables[$col]) {
149 $tables[$col] = 'T' . (++$cnt);
150 $from .= ' LEFT JOIN data AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = pages.pid';
151 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col);
154 $where .= ' ' . $filter['logic'] . ' ' . $tables[$col] . '.value ' . $filter['compare'] .