/plugin/magento/ |
H A D | auth.php | 390 foreach( $dbh->query( $sql ) as $row ) { 442 $sql = "select user_id entity,password hash from admin_user where user_id = {$entity};"; 444 foreach( $dbh->query( $sql ) as $row ) { 509 foreach( $dbh->query( $sql ) as $row ) { 539 foreach( $dbh->query( $sql ) as $row ) { 571 foreach( $dbh->query( $sql ) as $row ) { 604 foreach( $dbh->query( $sql ) as $row ) { 641 foreach( $dbh->query( $sql ) as $row ) { 659 foreach( $dbh->query( $sql ) as $row ) { 691 … $sql = "select role_id id,role_name name from admin_role where role_type = 'G' order by role_id;"; [all …]
|
/plugin/git/ |
H A D | helper.php | 118 $this->sqlite->query($sql); 144 $this->sqlite->query($sql); 458 $sql = "SELECT timestamp FROM git WHERE repo = 'local'"; 459 $res = $this->sqlite->query($sql); 477 $sql = "SELECT status FROM git WHERE repo = 'local'"; 478 $res = $this->sqlite->query($sql); 494 $res = $this->sqlite->query($sql); 511 $sql = "SELECT status FROM git WHERE repo = 'upstream'"; 512 $res = $this->sqlite->query($sql); 548 $this->sqlite->query($sql); [all …]
|
/plugin/addressbook/ |
H A D | action.php | 72 …$sql = "select * from addresslist WHERE instr(lower(surname || firstname || tel1 || tel2 || fax ||… 73 …for ($c=1;$c<count($text);$c++) $sql .= " AND instr(lower(' ' || surname || firstname || tel1 || t… 74 $sql .= " ORDER BY $order LIMIT 20"; 76 $query = $sqlite->query($sql); 79 if ($sqlite->res2count($sqlite->query($sql)) == 0) {
|
/plugin/authgooglesheets/vendor/google/apiclient-services/src/Spanner/ |
H A D | ExecuteSqlRequest.php | 51 public $sql; variable in Google\\Service\\Spanner\\ExecuteSqlRequest 170 public function setSql($sql) argument 172 $this->sql = $sql; 179 return $this->sql;
|
/plugin/combo/ComboStrap/ |
H A D | PageSql.php | 19 const CANONICAL = "sql"; 21 private $sql; variable in ComboStrap\\PageSql 30 $this->sql = $text; 35 * @param MarkupPath|null $contextualPage - the page where the sql applies to 51 $input = InputStream::fromString($this->sql); 63 $this->listener = new PageSqlTreeListener($lexer, $parser, $this->sql, $contextualPage); 85 return $this->sql;
|
/plugin/structstatus/ |
H A D | action.php | 63 $sql = "SELECT MAX(id) AS id, tbl FROM schemas GROUP BY tbl"; 64 $schemas= $sqlite->queryAll($sql); 77 $sql = 'REPLACE INTO opts(opt,val) VALUES ("dbversion_structstatus", ' . $version . ')'; 78 $sqlite->query($sql); 143 $sql = 'SELECT opt, val FROM opts WHERE opt=? OR opt=?'; 144 $vals = $sqlite->queryAll($sql, ['dbversion', 'dbversion_structstatus']);
|
/plugin/data-au/ |
H A D | helper.php | 509 $dataau['sql'] = str_replace('%user%', $_SERVER['REMOTE_USER'], $dataau['sql']); 510 …$dataau['sql'] = str_replace('%groups%', implode("','", (array) $USERINFO['grps']), $dataau['sql']… 512 $dataau['sql'] = str_replace('%now%', dformat(null, '%d-%m-%Y'), $dataau['sql']); 515 $dataau['sql'] = $this->makeTranslationReplacement($dataau['sql']);
|
/plugin/data/ |
H A D | helper.php | 535 * Replace placeholders in sql 544 $data['sql'] = str_replace('%user%', $INPUT->server->str('REMOTE_USER'), $data['sql']); 545 $data['sql'] = str_replace('%groups%', implode("','", $USERINFO['grps'] ?? []), $data['sql']); 547 $data['sql'] = str_replace('%now%', dformat(null, '%Y-%m-%d'), $data['sql']); 550 $data['sql'] = $this->makeTranslationReplacement($data['sql']);
|
/plugin/dbquery/ |
H A D | helper.php | 88 * @param string $sql 92 public function prepareStatement(\PDO $pdo, $sql, $parameters) argument 103 $sql = str_replace(':groups', join(',', $groupids), $sql); 105 $sth = $pdo->prepare($sql); 109 if (strpos($sql, $key) === false) continue; // skip if parameter is missing
|
/plugin/strata/driver/ |
H A D | driver.php | 137 * This implementation looks for a file called 'setup-@driver@.sql' and executes all SQL statements in that file. 150 $sqlfile = DOKU_PLUGIN . "strata/sql/setup-$driver.sql"; 152 $sql = io_readFile($sqlfile, false); 153 $lines = explode("\n",$sql); 157 $sql = ''; 161 $sql .= $line; 165 $sql = explode(';', $sql); 170 foreach($sql a [all...] |
/plugin/davcal/vendor/sabre/dav/tests/Sabre/DAV/PropertyStorage/Backend/ |
H A D | PDOMysqlTest.php | 18 foreach($setupSql as $sql) { 20 if (!trim($sql)) continue; 21 $pdo->exec($sql);
|
H A D | PDOSqliteTest.php | 18 foreach($setupSql as $sql) { 20 if (!trim($sql)) continue; 21 $pdo->exec($sql);
|
/plugin/sql/ |
H A D | plugin.info.txt | 1 base sql 5 name sql plugin 7 url http://dokuwiki.org/plugin:sql
|
/plugin/struct/meta/ |
H A D | SearchCloud.php | 19 * @return array ($sql, $opts) The SQL and parameters to execute 84 [$sql, $opts] = $QB->getSQL(); 85 return [$sql . $this->limit, $opts]; 107 [$sql, $opts] = $this->getSQL(); 110 $res = $this->sqlite->query($sql, $opts); 111 if ($res === false) throw new StructException("SQL execution failed for\n\n$sql");
|
H A D | PageMeta.php | 41 $sql = "SELECT pid, title, lasteditor, lastrev, lastsummary FROM titles WHERE pid = ?"; 42 $data = $this->sqlite->queryRecord($sql, [$this->pid]); 51 $sql = "REPLACE INTO titles (pid, title, lasteditor, lastrev, lastsummary) VALUES (?,?,?,?,?)"; 52 $this->sqlite->query($sql, [$this->pid, $this->title, $this->lasteditor, $this->lastrev, $this->lastsummary]);
|
H A D | SchemaBuilder.php | 157 $sql = "INSERT INTO schemas (tbl, ts, user, config) VALUES (?, ?, ?, ?)"; 158 $this->sqlite->query($sql, [$this->table, $this->time, $this->user, $config]); 318 $sql = "CREATE TABLE $tbl ( 326 $ok = $ok && (bool)$this->sqlite->query($sql); 329 $sql = "CREATE TABLE $tbl ( 340 $ok = $ok && (bool)$this->sqlite->query($sql); 354 $sql = " ALTER TABLE $tbl ADD COLUMN col$index DEFAULT ''"; 355 if (!$this->sqlite->query($sql)) {
|
/plugin/sqlite/ |
H A D | admin.php | 56 $exportfile = $conf['tmpdir'] . '/' . $this->db->getDbName() . '.sql'; 58 header('Content-Type: text/sql'); 59 header('Content-Disposition: attachment; filename="' . $this->db->getDbName() . '.sql";'); 71 $sql = Tools::SQLstring2array(file_get_contents($importfile)); 74 foreach ($sql as $s) { 85 $this->querySaver->saveQuery($INPUT->str('name'), $INPUT->str('sql')); 122 $form->addTextarea('sql')->addClass('edit'); 130 if ($INPUT->has('sql')) $this->showQueryResults($INPUT->str('sql')); 171 * @param string $sql 163 showQueryResults($sql) global() argument [all...] |
/plugin/structpublish/helper/ |
H A D | db.php | 50 $sql = 'SELECT pid FROM titles'; 51 $list = $sqlite->queryAll($sql); 73 $sql = 'SELECT pid FROM structpublish_assignments WHERE pid = ? AND assigned = 1'; 74 return (bool) $sqlite->queryAll($sql, $pid);
|
/plugin/fksnewsfeed/inc/ORM/ |
H A D | AbstractService.php | 35 …$sql = 'INSERT INTO ' . $this->table . ' (' . join(',', array_keys($data)) . ') VALUES( ' . join(… 37 return (bool)$this->sqlite->query($sql, 43 $sql = 'UPDATE ' . $this->table . ' SET ' . join(',', array_map(function ($key) { 46 $this->sqlite->query($sql,
|
/plugin/data-au/syntax/ |
H A D | related.php | 83 $sql = "SELECT A.value 88 $res = $sqlite->query($sql, $col, $id); 154 $sql = "SELECT pages.pid, pages.page as page, pages.title as title, COUNT(*) as rel 164 $sql .= ' LIMIT ' . ($dataau['limit']); 167 return $sql;
|
H A D | cloud.php | 108 $sql = "SELECT dataau.value AS value, COUNT(dataau.pid) AS cnt 114 $sql .= ' HAVING cnt >= ' . $dataau['min']; 116 $sql .= ' ORDER BY cnt DESC'; 118 $sql .= ' LIMIT ' . $dataau['limit']; 121 return $sql;
|
/plugin/data/syntax/ |
H A D | related.php | 44 if (!$data['sql']) return true; // sql build 47 $rows = $sqlite->queryAll($data['sql']); 87 $sql = "SELECT A.value 92 $rows = $sqlite->queryAll($sql, $col, $id); 163 $sql = "SELECT pages.pid, pages.page as page, pages.title as title, COUNT(*) as rel 173 $sql .= ' LIMIT ' . ($data['limit']); 176 return $sql;
|
H A D | cloud.php | 117 $sql = "SELECT data.value AS value, COUNT(data.pid) AS cnt 123 $sql .= ' HAVING cnt >= ' . $data['min']; 125 $sql .= ' ORDER BY cnt DESC'; 127 $sql .= ' LIMIT ' . $data['limit']; 130 return $sql; 168 $rows = $sqlite->queryAll($data['sql']);
|
/plugin/bez/action/ |
H A D | migration.php | 49 $sql = file_get_contents($file); 50 if($sql === false) { 55 preg_match_all('/.*?(?(?=BEGIN)BEGIN.*?END)\s*;/is', $sql, $matches); 82 $sql = file_get_contents($file); 83 if($sql === false) { 88 preg_match_all('/.*?(?(?=BEGIN)BEGIN.*?END)\s*;/is', $sql, $matches); 123 $sql = file_get_contents($file); 124 if ($sql === false) { 129 preg_match_all('/.*?(?(?=BEGIN)BEGIN.*?END)\s*;/is', $sql, $matches);
|
/plugin/bez/mdl/ |
H A D | Thread_commentFactory.php | 117 $sql = "SELECT type, COUNT(type) AS 'cnt' 122 $r = $this->model->sqlite->query($sql, $from, $to); 124 $sql = "SELECT type, COUNT(type) AS 'cnt' 128 $r = $this->model->sqlite->query($sql);
|