/plugin/statistics/inc/ ! |
H A D | StatisticsQuery.class.php | 21 $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 D | StatisticsLogger.class.php | 74 $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 D | Assignments.php | 61 $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 D | Schema.php | 70 $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 D | auth.php | 198 $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 D | Assignments.php | 61 $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 D | MySQLStore.php | 25 $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 D | PostgreSQLStore.php | 25 $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 D | SQLiteStore.php | 22 $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 D | DatabaseConnection.php | 39 * @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 D | MySQLStore.php | 25 $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 D | PostgreSQLStore.php | 25 $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 D | SQLiteStore.php | 22 $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 D | DatabaseConnection.php | 39 * @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 D | Assignments.php | 59 $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 D | migration.php | 56 $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 D | helper.php | 70 $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 D | helper.php | 63 $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 D | db.php | 30 $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 D | Tag.php | 63 $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 D | helper.php | 54 $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 D | ThreadFactory.php | 33 $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 D | db.class.php | 66 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 D | dbi.class.php | 55 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 D | extension.cache.sqlite3.php | 137 $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 …]
|