Home
last modified time | relevance | path

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

12345678

/plugin/statistics/inc/ !
H A DStatisticsQuery.class.php21 $result = $this->hlp->runSQL($sql);
38 $result = $this->hlp->runSQL($sql);
137 $sql = "SELECT $TIME as time,
196 $sql = "SELECT $TIME as time,
203 return $this->hlp->runSQL($sql);
213 return $this->hlp->runSQL($sql);
231 return $this->hlp->runSQL($sql);
251 return $this->hlp->runSQL($sql);
261 return $this->hlp->runSQL($sql);
272 return $this->hlp->runSQL($sql);
[all …]
H A DStatisticsLogger.class.php74 $this->hlp->runSQL($sql);
106 $sql = rtrim($sql, ',');
108 $ok = $this->hlp->runSQL($sql);
194 $id = $this->hlp->runSQL($sql);
203 $this->hlp->runSQL($sql);
234 $this->hlp->runSQL($sql);
242 $sql = "SELECT ip
461 $this->hlp->runSQL($sql);
488 $this->hlp->runSQL($sql);
513 $ok = $this->hlp->runSQL($sql);
[all …]
/plugin/struct/meta/ !
H A DAssignments.php61 $res = $this->sqlite->query($sql);
105 $res = $this->sqlite->query($sql, $table);
133 $res = $this->sqlite->query($sql, $pid);
158 $ok = (bool)$this->sqlite->query($sql);
161 $sql = 'DELETE FROM schema_assignments';
256 $sql .= ' AND tbl = ?';
260 $sql .= ' AND assigned = 1';
263 $sql .= ' ORDER BY pid, tbl';
265 $res = $this->sqlite->query($sql, $opts);
334 $res = $this->sqlite->query($sql, $ts);
[all …]
H A DSchema.php70 $sql = "SELECT *
78 $sql = "SELECT *
85 $res = $this->sqlite->query($sql, $opt);
101 $sql = "SELECT SC.*, T.*
199 $sql = "DROP TABLE ?";
204 $this->sqlite->query($sql, $this->table);
209 $sql = "SELECT T.id
214 $sql = "DELETE FROM types WHERE id IN ($sql)";
217 $sql = "SELECT id
220 $sql = "DELETE FROM schema_cols WHERE sid IN ($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/openid/Auth/OpenID/ !
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 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 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/fedauth/Auth/OpenID/ !
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 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 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/structpublish/meta/ !
H A DAssignments.php59 $res = $this->sqlite->query($sql);
121 $res = $this->sqlite->query($sql, [$user, $status]);
170 $sql = 'DELETE FROM structpublish_assignments_patterns';
171 $ok = (bool) $this->sqlite->query($sql);
174 $sql = 'DELETE FROM structpublish_assignments';
176 $sql = 'UPDATE structpublish_assignments SET assigned = 0';
178 $ok = $ok && (bool) $this->sqlite->query($sql);
247 $res = $this->sqlite->query($sql, [$page]);
271 $sql .= ' AND assigned = 1';
274 $sql .= ' ORDER BY pid, user, status';
[all …]
/plugin/struct/action/ !
H A Dmigration.php56 $res = $sqlite->query($sql);
82 $res = $sqlite->query($sql);
90 $res = $sqlite->query($sql);
99 $sql = $table['sql'];
105 … $sql = preg_replace('/pid (\w* ?NOT NULL|\w* ?PRIMARY KEY)/', 'pid TEXT DEFAULT ""', $sql);
112 $sql = str_replace(')', ', rid INTEGER, PRIMARY KEY(pid,rid) )', $sql);
211 $res = $sqlite->query($sql);
213 $sql = $t[0]['sql'];
214 $sql = str_replace('islookup INTEGER,', '', $sql);
250 $res = $sqlite->query($sql);
[all …]
/plugin/acknowledge/ !
H A Dhelper.php70 $sqlite->query($sql, $page);
93 $sqlite->query($sql, $page, $lastmod);
106 $sqlite->query($sql, $page, $assignees);
120 $sqlite->query($sql, $page);
137 $result = $sqlite->query($sql, $page);
156 $sql = "SELECT ack
183 $sql = "SELECT MAX(ack)
288 $sql = "SELECT assignee
291 $result = $sqlite->query($sql, $page);
336 $result = $sqlite->query($sql, $page);
[all …]
/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.php63 $res = $sqlite->query($sql, $opt);
89 $sql = '';
92 $sql .= "SELECT DISTINCT value
104 $sql .= "AND ( D.pid = '' OR (";
105 $sql .= "PAGEEXISTS(D.pid) = 1\n";
106 $sql .= "AND GETACCESSLEVEL(D.pid) > 0\n";
107 $sql .= ")) ";
109 $sql .= "AND D.latest = 1\n";
110 $sql .= "AND value LIKE ?\n";
111 $sql .= 'ORDER BY value';
[all …]
/plugin/starred/ !
H A Dhelper.php54 $sql = "DELETE FROM stars WHERE pid = ? AND login = ?";
55 $db->query($sql, $pageid, $user);
59 $db->query($sql, $pageid, $user, time());
82 $sql = "SELECT stardate FROM stars WHERE pid = ? AND login = ?";
83 $res = $db->query($sql, $pageid, $user);
107 $sql = "SELECT pid, stardate FROM stars WHERE ";
110 $sql .= 'lower(login) = lower(?)';
112 $sql .= 'login = ?';
114 $sql .= " ORDER BY stardate DESC";
116 $sql .= ' LIMIT ' . $limit;
[all …]
/plugin/bez/mdl/ !
H A DThreadFactory.php33 $sql = "SELECT thread_participant.user_id,
44 $sql = "SELECT user_id,
53 $r = $this->model->sqlite->query($sql);
71 $r = $this->model->sqlite->query($sql);
82 $sql = "SELECT COUNT(DISTINCT user_id)
92 $sql = "SELECT COUNT(DISTINCT user_id)
97 $r = $this->model->sqlite->query($sql);
111 $sql = "SELECT label_name,
130 $sql = "SELECT label_name,
157 $sql = "SELECT label_name,
[all …]
/plugin/authucenter/lib/uc_client/lib/ !
H A Ddb.class.php66 function result_first($sql) { argument
67 $query = $this->query($sql);
71 function fetch_first($sql) { argument
72 $query = $this->query($sql);
76 function fetch_all($sql, $id = '') { argument
78 $query = $this->query($sql);
92 $this->halt('MySQL Query Error', $sql);
95 $this->histories[] = $sql;
154 function halt($message = '', $sql = '') { argument
159 $this->query($sql);
[all …]
H A Ddbi.class.php55 function result_first($sql) { argument
56 $query = $this->query($sql);
60 function fetch_first($sql) { argument
61 $query = $this->query($sql);
65 function fetch_all($sql, $id = '') { argument
67 $query = $this->query($sql);
81 $this->halt('MySQL Query Error', $sql);
84 $this->histories[] = $sql;
147 function halt($message = '', $sql = '') { argument
152 $this->query($sql);
[all …]
/plugin/jplayer/vendor/james-heinrich/getid3/getid3/ !
H A Dextension.cache.sqlite3.php137 $stmt = $db->prepare($sql);
162 $sql = $this->getQuery('delete_cache');
163 $db->exec($sql);
164 $sql = $this->getQuery('set_version');
165 $stmt = $db->prepare($sql);
195 $stmt = $db->prepare($sql);
207 $sql = $this->getQuery('cache_file');
208 $stmt = $db->prepare($sql);
227 $sql = $this->getQuery('make_table');
228 return $db->exec($sql);
[all …]

12345678