Home
last modified time | relevance | path

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

12345678

/plugin/statistics/inc/
H A 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);
76 $sql
[all...]
/plugin/struct/meta/
H A 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, [
[all...]
H A 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/acknowledge/
H A 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, [
[all...]
/plugin/sqlite/_test/
H A 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
[all...]
/plugin/struct/action/
H A 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
[all...]
/plugin/authsqlite/
H A Dauth.php198 $this->_modifyDB($sql);
209 $sql = str_replace('%{uid}', addslashes($uid), $sql);
211 $sql = str_replace('%{user}', addslashes($user), $sql);
212 $sql = str_replace('%{gid}', addslashes($gid), $sql);
213 $sql = str_replace('%{group}', addslashes($group), $sql);
221 $sql = str_replace('%{group}', addslashes($group), $sql);
222 $this->_modifyDB($sql);
253 $sql = str_replace('%{pass}', addslashes($pwd), $sql);
254 $sql = str_replace('%{name}', addslashes($name), $sql);
255 $sql = str_replace('%{email}', addslashes($mail), $sql);
[all …]
/plugin/extendpage/meta/
H A DAssignments.php61 $res = $this->sqlite->query($sql);
79 $sql = 'SELECT last_insert_rowid()';
80 $res = $this->sqlite->query($sql);
107 $res = $this->sqlite->query($sql, $id);
132 $sql = 'DELETE FROM assignments_patterns';
133 $ok = (bool) $this->sqlite->query($sql);
136 $sql = 'DELETE FROM assignments';
138 $sql = 'UPDATE assignments SET assigned = 0';
140 $ok = $ok && (bool) $this->sqlite->query($sql);
208 $sql = 'SELECT assignments_patterns.page
[all …]
/plugin/structpublish/meta/
H A 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/sqlite/
H A DSQLiteDB.php136 * @param string $sql
141 public function query($sql, ...$parameters)
149 $stmt = $this->pdo->prepare($sql);
155 'sql' => &$sql,
168 'sql' => $sql,
182 * @param string $sql
187 public function exec($sql, ...$parameters)
189 $stmt = $this->query($sql,
112 query($sql, ...$parameters) global() argument
158 exec($sql, ...$parameters) global() argument
181 queryAll($sql, ...$params) global() argument
197 queryRecord($sql, ...$params) global() argument
253 queryValue($sql, ...$params) global() argument
271 queryKeyValueList($sql, ...$params) global() argument
[all...]
H A Dhelper.php159 * @param string ...$args - the arguments of query(), the first is the sql and others are values
167 $sql = $this->prepareSql($args);
168 return $this->adapter->query($sql);
182 * - string $sql - the statement
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));
392 SQLstring2array($sql) global() argument
403 doTransaction($sql, $sqlpreparing = true) global() argument
[all...]
/plugin/fedauth/Auth/OpenID/
H A 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 …]
H A 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'] =
H A 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'] =
H A 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/openid/Auth/OpenID/
H A 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 …]
H A 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'] =
H A 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'] =
H A 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/rating/
H A Dhelper.php63 $sql = "SELECT sum(value) FROM ratings WHERE page = ?";
64 $res = $sqlite->query($sql, $ID);
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);
119 $sql = $sqlbegin . "WHERE date >= ? " . $sqlend;
[all …]
/plugin/issuelinks/helper/
H A Ddb.php30 $sql = 'REPLACE INTO opts VALUES (?, ?)';
31 $db->query($sql, [$key, $value]);
100 $res = $db->query($sql, [$key]);
144 $ok = $db->query($sql, $vals);
174 * @param string $sql the query
192 $res = $db->query($sql, $conditional);
230 $db->query($sql, $vals);
238 $sql .= ' AND repository_id = ?';
242 $sql .= ' AND id = ?';
319 $sql = '
[all …]
/plugin/struct/types/
H A DTag.php58 $sql = $this->buildSQLFromContext($context);
64 $rows = $sqlite->queryAll($sql, $opt);
78 * Create the sql to query the database for tags to do autocompletion
84 * @return string The sql with a single "?" placeholde for the search value
88 $sql = '';
91 $sql .= "SELECT DISTINCT value
98 $sql .= "SELECT DISTINCT col{$context->getColref()} AS value
103 $sql .= "AND ( D.pid = '' OR (";
104 $sql .= "PAGEEXISTS(D.pid) = 1\n";
105 $sql
[all...]
/plugin/structpublish/action/
H A Dmigration.php23 * which processes updateXXXX.sql files
72 $sql = "REPLACE INTO opts (val,opt) VALUES ($version,'dbversion_structpublish')";
73 $ok = $ok && $sqlite->query($sql);
90 $sql = 'SELECT opt, val FROM opts WHERE opt=? OR opt=?';
91 $vals = $sqlite->queryAll($sql, ['dbversion', 'dbversion_structpublish']);
126 $sql = io_readFile(DOKU_PLUGIN . 'structpublish/db/update0001.sql', false);
127 $sqlArr = Tools::SQLstring2array($sql);
128 foreach ($sqlArr as $sql) {
129 $ok = $ok && $sqlite->query($sql);
[all...]
/plugin/bez/mdl/
H A 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,
[all...]
/plugin/starred/
H A Dhelper.php60 $sql = "DELETE FROM stars WHERE pid = ? AND login = ?";
61 $db->exec($sql, [$pageid, $user]);
65 $db->exec($sql, [$pageid, $user, time()]);
90 $sql = "SELECT stardate FROM stars WHERE pid = ? AND login = ?";
91 return (int)$db->queryValue($sql, [$pageid, $user]);
115 $sql = "SELECT pid, stardate FROM stars WHERE ";
118 $sql .= 'lower(login) = lower(?)';
120 $sql .= 'login = ?';
122 $sql .= " ORDER BY stardate DESC";
124 $sql .= ' LIMIT ' . $limit;
[all …]

12345678