Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 25 of 191) sorted by relevance

12345678

/plugin/statistics/inc/
DStatisticsQuery.class.php16 $sql = "SELECT ref_type, COUNT(*) as cnt
21 $result = $this->hlp->runSQL($sql);
31 $sql = "SELECT COUNT(DISTINCT session) as sessions,
38 $result = $this->hlp->runSQL($sql);
47 $sql = "SELECT COUNT(*) as cnt
51 $result = $this->hlp->runSQL($sql);
64 $result = $this->hlp->runSQL($sql);
69 $sql = "SELECT AVG(views) as cnt
72 $result = $this->hlp->runSQL($sql);
85 $sql = "SELECT AVG(end - dt)/60 as time
[all …]
/plugin/acknowledge/
Dhelper.php77 $sql = "INSERT OR IGNORE INTO pages (page, lastmod) VALUES (?,?)";
85 $this->db->exec($sql, [$page, $lastmod]);
170 $sql = "DELETE FROM pages WHERE page = ?";
171 $this->db->exec($sql, $page);
190 $sql = "REPLACE INTO pages (page, lastmod) VALUES (?,?)";
191 $this->db->exec($sql, [$page, $lastmod]);
204 $sql = "UPDATE assignments SET pageassignees = '' WHERE page = ?";
205 $this->db->exec($sql, $page);
219 $sql = "REPLACE INTO assignments ('page', 'pageassignees') VALUES (?,?)";
220 $this->db->exec($sql, [$page, $assignees]);
[all …]
/plugin/struct/meta/
DAssignments.php62 $sql = 'SELECT * FROM schema_assignments_patterns ORDER BY pattern';
63 $this->patterns = $this->sqlite->queryAll($sql);
76 $sql = 'REPLACE INTO schema_assignments_patterns (pattern, tbl) VALUES (?,?)';
77 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]);
97 $sql = 'DELETE FROM schema_assignments_patterns WHERE pattern = ? AND tbl = ?';
98 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]);
104 $sql = 'SELECT pid FROM schema_assignments WHERE tbl = ?';
105 $pagerows = $this->sqlite->queryAll($sql, [$table]);
130 $sql = 'SELECT tbl FROM schema_assignments WHERE pid = ?';
131 $tablerows = $this->sqlite->queryAll($sql, [$pid]);
[all …]
DSchema.php72 $sql = "SELECT *
80 $sql = "SELECT *
87 $schema = $this->sqlite->queryAll($sql, $opt);
102 $sql = "SELECT SC.*, T.*
108 $rows = $this->sqlite->queryAll($sql, [$this->id]);
196 $sql = "DROP TABLE ";
197 $this->sqlite->query($sql . 'data_' . $this->table);
198 $this->sqlite->query($sql . 'multi_' . $this->table);
200 $sql = "DELETE FROM schema_assignments WHERE tbl = '$this->table'";
201 $this->sqlite->query($sql);
[all …]
/plugin/struct/action/
Dmigration.php59 $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND name LIKE 'multi_%'";
60 $tables = $sqlite->queryAll($sql);
64 $sql = "ALTER TABLE $table ADD COLUMN latest INT DEFAULT 1";
65 $sqlite->query($sql);
82 $sql = "SELECT sql, name FROM sqlite_master
85 $tables = $sqlite->queryAll($sql);
88 $sql = "SELECT MAX(id) AS id, tbl, islookup FROM schemas
91 $schemas = $sqlite->queryAll($sql);
98 $sql = $table['sql'];
104 … $sql = preg_replace('/pid (\w* ?NOT NULL|\w* ?PRIMARY KEY)/', 'pid TEXT DEFAULT ""', $sql);
[all …]
/plugin/sqlite/_test/
DSQLiteDBTest.php42 $sql = "SELECT * FROM testdata WHERE keyword=?";
44 $stmt = $db->query($sql, ['music']);
55 $sql = "SELECT ? AS first, ? AS second, ? AS third";
57 $result = $db->queryRecord($sql, ['one', 'two', 'three']);
60 $result = $db->queryRecord($sql, 'one', 'two', 'three');
63 $sql = "SELECT :first AS first, :second AS second, :third AS third";
65 $result = $db->queryRecord($sql, ['first' => 'one', 'second' => 'two', 'third' => 'three']);
73 $sql = "INSERT INTO testdata (keyword, value) VALUES (?, ?)";
74 $insid = $db->exec($sql, ['test', 'test']);
77 $sql = "UPDATE testdata SET value=? WHERE keyword=?";
[all …]
/plugin/authsqlite/
Dauth.php127 $sql = $this->_createSQLFilter($this->conf['getUsers'], $filter);
130 if(($result = $this->_queryDB($sql))) {
153 $sql = $this->_createSQLFilter($this->conf['getUsers'], $filter);
154 $sql .= " ".$this->conf['SortOrder'];
155 if($limit) $sql .= " LIMIT $limit";
156 if($first) $sql .= " OFFSET $first";
157 $result = $this->_queryDB($sql);
197 $sql = str_replace('%{group}', addslashes($group), $this->conf['addGroup']);
198 $this->_modifyDB($sql);
206 $sql = $this->conf['addUserGroup'];
[all …]
/plugin/extendpage/meta/
DAssignments.php60 $sql = 'SELECT * FROM assignments_patterns ORDER BY pattern';
61 $res = $this->sqlite->query($sql);
76 $sql = 'REPLACE INTO assignments_patterns (pattern, page, pos) VALUES (?,?,?)';
77 $ok = (bool) $this->sqlite->query($sql, array($pattern, $page, $pos));
79 $sql = 'SELECT last_insert_rowid()';
80 $res = $this->sqlite->query($sql);
99 $sql = 'DELETE FROM assignments_patterns WHERE id = ?';
100 $ok = (bool) $this->sqlite->query($sql, array($id));
106 $sql = 'SELECT pid FROM assignments WHERE pattern_id = ?';
107 $res = $this->sqlite->query($sql, $id);
[all …]
/plugin/structpublish/meta/
DAssignments.php60 $sql = 'SELECT * FROM structpublish_assignments_patterns ORDER BY pattern';
61 $this->patterns = $this->sqlite->queryAll($sql);
75 … $sql = 'REPLACE INTO structpublish_assignments_patterns (pattern, user, status) VALUES (?,?,?)';
76 $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
113 …$sql = 'DELETE FROM structpublish_assignments_patterns WHERE pattern = ? AND user = ? AND status =…
114 $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
120 $sql = 'SELECT pid FROM structpublish_assignments WHERE user = ? AND status = ?';
121 $pagerows = $this->sqlite->queryAll($sql, [$user, $status]);
163 $sql = 'DELETE FROM structpublish_assignments_patterns';
164 $ok = (bool) $this->sqlite->query($sql);
[all …]
/plugin/openid/Auth/OpenID/
DPostgreSQLStore.php25 $this->sql['nonce_table'] =
31 $this->sql['assoc_table'] =
42 $this->sql['set_assoc'] =
52 $this->sql['get_assocs'] =
56 $this->sql['get_assoc'] =
60 $this->sql['remove_assoc'] =
63 $this->sql['add_nonce'] =
68 $this->sql['clean_nonce'] =
71 $this->sql['clean_assoc'] =
84 $this->connection->query($this->sql['set_assoc']['update_assoc'],
[all …]
DMySQLStore.php25 $this->sql['nonce_table'] =
33 $this->sql['assoc_table'] =
44 $this->sql['set_assoc'] =
48 $this->sql['get_assocs'] =
52 $this->sql['get_assoc'] =
56 $this->sql['remove_assoc'] =
59 $this->sql['add_nonce'] =
62 $this->sql['clean_nonce'] =
65 $this->sql['clean_assoc'] =
DSQLiteStore.php22 $this->sql['nonce_table'] =
26 $this->sql['assoc_table'] =
31 $this->sql['set_assoc'] =
34 $this->sql['get_assocs'] =
38 $this->sql['get_assoc'] =
42 $this->sql['remove_assoc'] =
45 $this->sql['add_nonce'] =
48 $this->sql['clean_nonce'] =
51 $this->sql['clean_assoc'] =
DDatabaseConnection.php39 * @param string $sql An SQL string with placeholders. The
51 function query($sql, $params = []) argument
81 * @param string $sql An SQL string with placeholders. The
92 function getOne($sql, $params = []) argument
101 * @param string $sql An SQL string with placeholders. The
111 function getRow($sql, $params = []) argument
119 * @param string $sql An SQL string with placeholders. The
129 function getAll($sql, $params = []) argument
/plugin/fedauth/Auth/OpenID/
DPostgreSQLStore.php25 $this->sql['nonce_table'] =
31 $this->sql['assoc_table'] =
42 $this->sql['set_assoc'] =
52 $this->sql['get_assocs'] =
56 $this->sql['get_assoc'] =
60 $this->sql['remove_assoc'] =
63 $this->sql['add_nonce'] =
68 $this->sql['clean_nonce'] =
71 $this->sql['clean_assoc'] =
84 $this->connection->query($this->sql['set_assoc']['update_assoc'],
[all …]
DMySQLStore.php25 $this->sql['nonce_table'] =
33 $this->sql['assoc_table'] =
44 $this->sql['set_assoc'] =
48 $this->sql['get_assocs'] =
52 $this->sql['get_assoc'] =
56 $this->sql['remove_assoc'] =
59 $this->sql['add_nonce'] =
62 $this->sql['clean_nonce'] =
65 $this->sql['clean_assoc'] =
DSQLiteStore.php22 $this->sql['nonce_table'] =
26 $this->sql['assoc_table'] =
31 $this->sql['set_assoc'] =
34 $this->sql['get_assocs'] =
38 $this->sql['get_assoc'] =
42 $this->sql['remove_assoc'] =
45 $this->sql['add_nonce'] =
48 $this->sql['clean_nonce'] =
51 $this->sql['clean_assoc'] =
DDatabaseConnection.php39 * @param string $sql An SQL string with placeholders. The
51 function query($sql, $params = array()) argument
80 * @param string $sql An SQL string with placeholders. The
91 function getOne($sql, $params = array()) argument
99 * @param string $sql An SQL string with placeholders. The
109 function getRow($sql, $params = array()) argument
116 * @param string $sql An SQL string with placeholders. The
126 function getAll($sql, $params = array()) argument
/plugin/sqlite/
DSQLiteDB.php136 * @param string $sql
141 public function query($sql, ...$parameters) argument
149 $stmt = $this->pdo->prepare($sql);
155 'sql' => &$sql,
168 'sql' => $sql,
182 * @param string $sql
187 public function exec($sql, ...$parameters) argument
189 $stmt = $this->query($sql, ...$parameters);
193 if ($count && preg_match('/^INSERT /i', $sql)) {
205 * @param string $sql
[all …]
Dhelper.php167 $sql = $this->prepareSql($args);
168 return $this->adapter->query($sql);
190 $sql = trim(array_shift($args));
191 $sql = rtrim($sql, ';');
193 if (!$sql) {
204 $qmc = substr_count($sql, '?');
207 'Expected ' . $qmc . ' got ' . $argc . ' - ' . hsc($sql));
210 'Expected ' . $qmc . ' got ' . $argc . ' - ' . hsc($sql));
214 $parts = explode('?', $sql, $argc + 1);
216 $sql = '';
[all …]
/plugin/structpublish/action/
Dmigration.php77 $sql = "REPLACE INTO opts (val,opt) VALUES ($version,'dbversion_structpublish')";
78 $ok = $ok && $sqlite->query($sql);
95 $sql = 'SELECT opt, val FROM opts WHERE opt=? OR opt=?';
96 $vals = $sqlite->queryAll($sql, ['dbversion', 'dbversion_structpublish']);
131 $sql = io_readFile(DOKU_PLUGIN . 'structpublish/db/update0001.sql', false);
132 $sqlArr = Tools::SQLstring2array($sql);
133 foreach ($sqlArr as $sql) {
134 $ok = $ok && $sqlite->query($sql);
150 $sql = "SELECT rid, pid, latest, col1, max(col4) FROM $this->table GROUP BY pid, col1";
151 $latest = $sqlite->queryAll($sql);
[all …]
/plugin/rating/
Dhelper.php63 $sql = "SELECT sum(value) FROM ratings WHERE page = ?";
64 $res = $sqlite->query($sql, $ID);
68 $sql = "SELECT value FROM ratings WHERE page = ? AND rater = ?";
69 $res = $sqlite->query($sql, $ID, $this->userID());
95 $sql = "DELETE FROM ratings WHERE page = ?";
96 $res = $sqlite->query($sql, $page);
113 $sql = $sqlbegin . $sqlend;
114 $res = $sqlite->query($sql, $num);
116 $sql = $sqlbegin . "WHERE lang = ? " . $sqlend;
117 $res = $sqlite->query($sql, $lang, $num);
[all …]
/plugin/issuelinks/helper/
Ddb.php30 $sql = 'REPLACE INTO opts VALUES (?, ?)';
31 $db->query($sql, [$key, $value]);
99 $sql = 'SELECT val FROM opts WHERE opt = ?';
100 $res = $db->query($sql, [$key]);
143 $sql = "REPLACE INTO $table ($keys) VALUES ($wlds)";
144 $ok = $db->query($sql, $vals);
166 $sql = "SELECT secret FROM webhooks WHERE service = ? AND repository_id = ?";
167 $secrets = $this->sqlArrayQuery($sql, [$service, $repo]);
174 * @param string $sql the query
179 private function sqlArrayQuery($sql, $conditional) argument
[all …]
/plugin/approve/helper/
Ddb.php48 $sql = 'SELECT page, approver, hidden FROM page';
49 return $this->db->queryAll($sql);
54 $sql = 'SELECT approver FROM page WHERE page=? AND hidden != 1';
55 return $this->db->queryRecord($sql, $page_id);
60 $sql = 'SELECT value FROM config WHERE key=?';
61 return $this->db->queryValue($sql, $key);
76 $sql = 'UPDATE page SET hidden=? WHERE page=?';
77 $this->db->query($sql, $hidden, $page_id);
193 …$sql = 'SELECT page.page AS id, page.approver, revision.rev, revision.approved, revision.approved_…
199 $pages = $this->db->queryAll($sql, $namespace.'*', $filter);
[all …]
/plugin/struct/types/
DTag.php60 $sql = $this->buildSQLFromContext($context);
66 $rows = $sqlite->queryAll($sql, $opt);
90 $sql = '';
93 $sql .= "SELECT DISTINCT value
100 $sql .= "SELECT DISTINCT col{$context->getColref()} AS value
105 $sql .= "AND ( D.pid = '' OR (";
106 $sql .= "PAGEEXISTS(D.pid) = 1\n";
107 $sql .= "AND GETACCESSLEVEL(D.pid) > 0\n";
108 $sql .= ")) ";
110 $sql .= "AND D.latest = 1\n";
[all …]
/plugin/bez/mdl/
DThreadFactory.php33 $sql = "SELECT thread_participant.user_id,
42 $r = $this->model->sqlite->query($sql, $from, $to);
44 $sql = "SELECT user_id,
53 $r = $this->model->sqlite->query($sql);
63 $sql = "SELECT COUNT(*)*1.0/COUNT(DISTINCT thread_id) AS kpi
66 $r = $this->model->sqlite->query($sql, $from, $to);
68 $sql = "SELECT COUNT(*)*1.0/COUNT(DISTINCT thread_id) AS kpi
71 $r = $this->model->sqlite->query($sql);
82 $sql = "SELECT COUNT(DISTINCT user_id)
90 $r = $this->model->sqlite->query($sql, $from, $to, $from, $to);
[all …]

12345678