/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 …]
|
/plugin/statistics/inc/ |
H A D | StatisticsLogger.class.php | 71 $sql = "REPLACE INTO " . $this->hlp->prefix . "lastseen 74 $this->hlp->runSQL($sql); 100 $sql = "INSERT DELAYED INTO " . $this->hlp->prefix . "groups 104 $sql .= "( NOW(), '$type', '$group' ),"; 106 $sql = rtrim($sql, ','); 108 $ok = $this->hlp->runSQL($sql); 189 $sql = "INSERT INTO " . $this->hlp->prefix . "search 194 $id = $this->hlp->runSQL($sql); 200 $sql [all...] |
/plugin/sqlite/ |
H A D | QuerySaver.php | 37 $sql = 'INSERT INTO queries (db, name, sql) VALUES (?, ?, ?)'; 38 $this->db->exec($sql, [$this->upstream, $name, $query]); 51 $sql = 'SELECT sql FROM queries WHERE db = ? AND name = ?'; 52 return $this->db->queryValue($sql, [$this->upstream, $name]); 69 $sql = 'DELETE FROM queries WHERE db = ? AND name = ?'; 70 $this->db->exec($sql, [$this->upstream, $name]); 82 $sql = 'SELECT name, sql FRO [all...] |
H A D | Tools.php | 8 * Split sql queries on semicolons, unless when semicolons are quoted 13 * @param string $sql 14 * @return string[] sql queries 16 public static function SQLstring2array($sql) argument 19 $len = strlen($sql); 21 // Simple state machine to "parse" sql into single statements 26 $prev = $i ? $sql[$i - 1] : "\n"; 27 $char = $sql[$i]; 28 $next = $i < ($len - 1) ? $sql[$i + 1] : '';
|
/plugin/struct/action/ |
H A D | move.php | 103 $sql = "UPDATE data_$tbl SET pid = ? WHERE pid = ?"; 104 $this->db->query($sql, [$new, $old]); 107 $sql = "UPDATE multi_$tbl SET pid = ? WHERE pid = ?"; 108 $this->db->query($sql, [$new, $old]); 121 $sql = "UPDATE schema_assignments SET pid = ? WHERE pid = ?"; 122 $this->db->query($sql, [$new, $old]); 136 $sql = "UPDATE titles SET pid = ? WHERE pid = ?"; 137 $this->db->query($sql, [$new, $old]); 156 $sql = "UPDATE multi_$table 163 $sql [all...] |
/plugin/blogtng/helper/ |
H A D | comments.php | 72 $sql = 'SELECT COUNT(pid) as val 76 $sql .= ' AND status = \'visible\''; 160 $sql = "SELECT cid 167 $sql, 206 $sql = "DELETE FROM comments WHERE pid = ?"; 237 $sql = "SELECT title, page, mail 278 $sql = "SELECT A.mail as mail, B.key as key 347 $sql = "INSERT OR REPLACE INTO optin 351 $sql = "INSERT OR IGNORE INTO optin 592 $sql = 'SELECT * [all …]
|
/plugin/top/ |
H A D | helper.php | 67 $sql = "INSERT OR REPLACE INTO toppages (page, value, lang, month) 69 $res = $sqlite->query($sql, $page, $page, $month, $lang, $month); 86 $sql = $sqlbegin . $sqlend; 87 $res = $sqlite->query($sql, $num); 89 $sql = $sqlbegin . "WHERE lang = ? " . $sqlend; 90 $res = $sqlite->query($sql, $lang, $num); 92 $sql = $sqlbegin . "WHERE month >= ? " . $sqlend; 93 $res = $sqlite->query($sql, intval($month), $num); 95 $sql = $sqlbegin . "WHERE lang = ? AND month >= ? " . $sqlend; 96 $res = $sqlite->query($sql, $lang, intval($month), $num);
|
/plugin/openid/Auth/OpenID/ |
H A D | SQLStore.php | 72 protected $sql = []; variable in Auth_OpenID_SQLStore 139 $this->sql = []; 239 if (!array_key_exists($key, $this->sql)) { 241 } else if (!$this->sql[$key]) { 281 if (is_array($this->sql[$k])) { 286 $this->sql[$k] = sprintf($this->sql[$k], $value); 347 return $this->connection->query($this->sql['set_assoc'], 416 $this->sql['remove_assoc'], 489 $sql = $this->sql['add_nonce']; 490 $result = $this->connection->query($sql, [ [all …]
|
/plugin/fedauth/Auth/OpenID/ |
H A D | SQLStore.php | 126 $this->sql = array(); 226 if (!array_key_exists($key, $this->sql)) { 228 } else if (!$this->sql[$key]) { 264 if (is_array($this->sql[$k])) { 270 $this->sql[$k] = sprintf($this->sql[$k], $value); 324 return $this->connection->query($this->sql['set_assoc'], 356 $result = $this->connection->getRow($this->sql['get_assoc'], 387 $this->sql['remove_assoc'], 456 $sql = $this->sql['add_nonce']; 457 $result = $this->connection->query($sql, array($server_url, [all …]
|
/plugin/addressbook/ |
H A D | syntax.php | 379 $query = $sqlite->query($sql); 482 $sql .= ')'; 486 $res = $sqlite->query($sql); 525 $sqlite->query($sql); 593 $sql .= " ORDER BY $order"; 595 $query = $sqlite->query($sql); 628 $query = $sqlite->query($sql); 673 $query = $sqlite->query($sql); 941 $query = $sqlite->query($sql); 946 $sql = "INSERT INTO addresslist [all …]
|
/plugin/authdrupal7/ |
H A D | auth.php | 85 $sql = str_replace('%{drupal_prefix}', $this->getConf('drupalPrefix'), $sql); 86 $result = $this->_queryDB($sql); 187 $sql = str_replace('%{drupal_prefix}', $this->getConf('drupalPrefix'), $sql); 188 $result = $this->_queryDB($sql); 213 $sql = str_replace('%{drupal_prefix}', $this->getConf('drupalPrefix'), $sql); 214 $result = $this->_queryDB($sql); 238 $result = $this->_queryDB($sql); 465 $sql = "LOCK TABLES "; 468 if($cnt++ != 0) $sql .= ", "; 469 $sql .= "$table $mode"; [all …]
|
/plugin/authdrupal8/ |
H A D | auth.php | 80 $sql = str_replace('%{user}', $this->_escape($user), $this->checkPass); 81 $sql = str_replace('%{drupalPrefix}', $this->getConf('prefix'), $sql); 82 $result = $this->_queryDB($sql); 181 $sql = str_replace('%{user}', $this->_escape($user), $this->getUserInfo); 182 $sql = str_replace('%{drupalPrefix}', $this->getConf('prefix'), $sql); 183 $result = $this->_queryDB($sql); 207 $sql = str_replace('%{user}', $this->_escape($user), $this->getGroups); 208 $sql [all...] |
/plugin/top/_test/ |
H A D | date.test.php | 19 $sql = "INSERT INTO toppages (page, value, lang, month) VALUES 21 $sqlite->query($sql,'wiki:start',3,'','201407'); 22 $sqlite->query($sql,'wiki:start',2,'','201401'); 23 $sqlite->query($sql,'wiki:start',6,'','201201'); 24 $sqlite->query($sql,'wiki:start',1,'',null); 25 $sqlite->query($sql,'en:wiki:start',8,'en','201201'); 26 $sqlite->query($sql,'en:wiki:start',1,'en','201303'); 27 $sqlite->query($sql,'de:wiki:start',6,'de','201201');
|
/plugin/authgooglesheets/vendor/google/apiclient-services/src/CloudDataplex/ |
H A D | GoogleCloudDataplexV1EnvironmentEndpoints.php | 29 public $sql; variable in Google\\Service\\CloudDataplex\\GoogleCloudDataplexV1EnvironmentEndpoints 48 public function setSql($sql) argument 50 $this->sql = $sql; 57 return $this->sql;
|
/plugin/datatemplate/syntax/inc/ |
H A D | cache.php | 34 * @param string $sql stripped SQL for hash generation 37 public function checkAndBuildCache($data, $sql, &$dtlist) { argument 59 $cachefile = getCacheName($sql, '.datatemplate'); 74 $res = $sqlite->query($sql); 99 $cache = $this->getData($sql); 117 * @param string $sql the stripped sql for the data request 120 public function getData($sql) { argument 121 $cachefile = getCacheName($sql, '.datatemplate');
|
/plugin/struct/meta/ |
H A D | QueryBuilderWhere.php | 120 $sql = ' '; 121 if (!$first) $sql .= $this->type . ' '; 125 $sql .= '('; 127 $sql .= $where->toSQL($first); 130 $sql .= ' )'; 132 $sql .= $this->statement; 135 return $sql;
|
H A D | QueryBuilder.php | 207 * @return array ($sql, $vals) 229 $sql = 235 $sql .= 240 $sql .= 244 return [$sql, array_values($this->values)]; 255 fixPlaceholders($sql) global() argument
|
/plugin/authgooglesheets/vendor/google/apiclient-services/src/Spanner/ |
H A D | Statement.php | 31 public $sql; variable in Google\\Service\\Spanner\\Statement 64 public function setSql($sql) argument 66 $this->sql = $sql; 73 return $this->sql;
|
H A D | PartitionQueryRequest.php | 33 public $sql; variable in Google\\Service\\Spanner\\PartitionQueryRequest 82 public function setSql($sql) argument 84 $this->sql = $sql; 91 return $this->sql;
|
/plugin/struct/helper/ |
H A D | imexport.php | 43 $sql = []; 44 $sql[] = "DELETE FROM schema_assignments_patterns WHERE tbl = '$schemaName'"; 45 $sql[] = "DELETE FROM schema_assignments WHERE tbl = '$schemaName'"; 48 $sql[] = "INSERT INTO schema_assignments_patterns (pattern, tbl) VALUES ('$pattern','$schemaName')"; 51 $this->sqlite->doTransaction($sql); 69 $sql = 'SELECT pattern FROM schema_assignments_patterns WHERE tbl = ?'; 70 $patterns = $this->sqlite->queryAll($sql, $schemaName);
|
/plugin/issuelinks/_test/ |
H A D | handleIssueLinkSyntax.test.php | 42 $sql = 'SELECT page, project_id, issue_id, type FROM pagerev_issues'; 43 $pagerev_issues = $sqliteHelper->res2arr($sqliteHelper->query($sql, array())); 78 $sql = 'SELECT page, project_id, issue_id, type FROM pagerev_issues'; 79 $pagerev_issues = $sqliteHelper->res2arr($sqliteHelper->query($sql, array())); 103 $sql = 'SELECT page, project_id, issue_id, type FROM pagerev_issues'; 104 $pagerev_issues = $sqliteHelper->res2arr($sqliteHelper->query($sql, array()));
|
/plugin/bez/mdl/ |
H A D | TaskFactory.php | 53 $sql = "SELECT task.id, task.type, task.content_html, task.state, task.cost, task.plan_date, task.close_date, 60 $stmt = $this->model->sqlite->query($sql, $thread->id); 82 $sql = "SELECT task_participant.user_id, 90 $r = $this->model->sqlite->query($sql, $from, $to); 92 $sql = "SELECT user_id, 99 $r = $this->model->sqlite->query($sql); 110 $sql = "SELECT task_program_name, 125 $r = $this->model->sqlite->query($sql, $from, $to); 127 $sql = "SELECT task_program_name, 141 $r = $this->model->sqlite->query($sql); [all...] |
/plugin/guestbook/ |
H A D | basic.class.php | 75 $sql = "SHOW TABLES"; 76 $result = mysql_query($sql); 137 $result = mysql_query($sql); 175 $sql = "SELECT * FROM wiki_guestbook WHERE ID=" . intval($admin) . "; "; 176 $data=mysql_fetch_array(mysql_query($sql)); 254 $sql = "DELETE FROM wiki_guestbook WHERE ID=" . intval($_POST['guestDelete']) . ";"; 255 mysql_query($sql); 267 mysql_query($sql); 279 mysql_query($sql); 314 mysql_query($sql); [all …]
|