Home
last modified time | relevance | path

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

1234567

/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.php63 $res = $this->sqlite->query($sql);
107 $res = $this->sqlite->query($sql, $table);
135 $res = $this->sqlite->query($sql, $pid);
160 $ok = (bool) $this->sqlite->query($sql);
163 $sql = 'DELETE FROM schema_assignments';
258 $sql .= ' AND tbl = ?';
262 $sql .= ' AND assigned = 1';
265 $sql .= ' ORDER BY pid, tbl';
267 $res = $this->sqlite->query($sql, $opts);
336 $res = $this->sqlite->query($sql, $ts);
[all …]
H A DSchema.php76 $sql = "SELECT *
84 $sql = "SELECT *
91 $res = $this->sqlite->query($sql, $opt);
108 $sql = "SELECT SC.*, T.*
206 $sql = "DROP TABLE ?";
211 $this->sqlite->query($sql, $this->table);
216 $sql = "SELECT T.id
221 $sql = "DELETE FROM types WHERE id IN ($sql)";
224 $sql = "SELECT id
227 $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/acknowledge/
H A Dhelper.php68 $sql = "DELETE FROM pages WHERE page = ?";
69 $sqlite->query($sql, $page);
84 $sqlite->query($sql, $page, $lastmod);
97 $sqlite->query($sql, $page, $assignees);
110 $sql = "DELETE FROM assignments WHERE page = ?";
111 $sqlite->query($sql, $page);
130 $result = $sqlite->query($sql, $page);
149 $sql = "SELECT ack
156 $result = $sqlite->query($sql, $page, $user);
177 $result = $sqlite->query($sql, $page, $user);
[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 = 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/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);
109 … $sql = preg_replace('/(PRIMARY KEY ?\([^\)]+?)(\))/', ' rid INTEGER, $1, rid $2', $sql, -1, $cnt);
112 $sql = str_replace(')', ', rid INTEGER, PRIMARY KEY(pid,rid) )', $sql);
199 $res = $sqlite->query($sql);
201 $sql = $t[0]['sql'];
202 $sql = str_replace('islookup INTEGER,', '', $sql);
[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.php65 $res = $sqlite->query($sql, $opt);
91 $sql = '';
94 $sql .= "SELECT DISTINCT value
106 $sql .= "AND ( D.pid = '' OR (";
107 $sql .= "PAGEEXISTS(D.pid) = 1\n";
108 $sql .= "AND GETACCESSLEVEL(D.pid) > 0\n";
109 $sql .= ")) ";
111 $sql .= "AND D.latest = 1\n";
112 $sql .= "AND value LIKE ?\n";
113 $sql .= 'ORDER BY value';
[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/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/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 …]
/plugin/sqlite/
H A Dhelper.php125 $res = $this->query($sql);
203 $sql = io_readFile($file, false);
205 $sql = $this->SQLstring2array($sql);
210 if(!$this->doTransaction($sql)) {
292 * @param string $sql
295 public function SQLstring2array($sql) { argument
297 $len = strlen($sql);
304 $prev = $i ? $sql[$i-1] : "\n";
305 $char = $sql[$i];
370 foreach($sql as $s) {
[all …]

1234567