Home
last modified time | relevance | path

Searched refs:sql (Results 51 – 75 of 186) sorted by last modified time

12345678

/plugin/combo/db/combo/
H A DREADME.md8 * Create a file `updateXXXXX.sql` where `XXXXX` = `XXXX+1`
/plugin/data/syntax/
H A Dcloud.php117 $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']);
H A Drelated.php44 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 Dtable.php228 $data['sql'] = $this->buildSQL($data);
268 $rows = $sqlite->queryAll($data['sql']);
697 $sql = "SELECT " . implode(', ', $select) . "
710 $sql .= ' LIMIT ' . ($data['limit'] + 1);
714 return $sql;
718 * Handle request paramaters, rebuild sql when needed
737 $data['sql'] = $this->buildSQL($data);
741 $data['sql'] .= ' OFFSET ' . ((int)$_REQUEST['dataofs']);
/plugin/data/
H A Dhelper.php535 * 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/data/admin/
H A Daliases.php111 $sql = 'SELECT * FROM aliases ORDER BY name';
112 $rows = $sqlite->queryAll($sql);
/plugin/statistics/inc/
H A DStatisticsLogger.class.php71 $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...]
H A DStatisticsQuery.class.php16 $sql = "SELECT ref_type, COUNT(*) as cnt
21 $result = $this->hlp->runSQL($sql);
31 $sql = "SELECT COUNT(DISTINCT session) as sessions,
38 $result = $this->hlp->runSQL($sql);
47 $sql = "SELECT COUNT(*) as cnt
51 $result = $this->hlp->runSQL($sql);
64 $result = $this->hlp->runSQL($sql);
69 $sql = "SELECT AVG(views) as cnt
72 $result = $this->hlp->runSQL($sql);
76 $sql
[all...]
/plugin/statistics/
H A Daction.php178 $sql = "SELECT `info` FROM " . $hlp->prefix . "history WHERE `dt` = DATE(NOW())";
179 $result = $hlp->runSQL($sql);
/plugin/farmer/_animal/data/pages/wiki/
H A Dsyntax.txt385 The following language strings are currently recognized: //4cs, 6502acme, 6502kickass, 6502tasm, 68000devpac, abap, actionscript-french, actionscript, actionscript3, ada, algol68, apache, applescript, asm, asp, autoconf, autohotkey, autoit, avisynth, awk, bascomavr, bash, basic4gl, bf, bibtex, blitzbasic, bnf, boo, c, c_loadrunner, c_mac, caddcl, cadlisp, cfdg, cfm, chaiscript, cil, clojure, cmake, cobol, coffeescript, cpp, cpp-qt, csharp, css, cuesheet, d, dcs, delphi, diff, div, dos, dot, e, epc, ecmascript, eiffel, email, erlang, euphoria, f1, falcon, fo, fortran, freebasic, fsharp, gambas, genero, genie, gdb, glsl, gml, gnuplot, go, groovy, gettext, gwbasic, haskell, hicest, hq9plus, html, html5, icon, idl, ini, inno, intercal, io, j, java5, java, javascript, jquery, kixtart, klonec, klonecpp, latex, lb, lisp, llvm, locobasic, logtalk, lolcode, lotusformulas, lotusscript, lscript, lsl2, lua, m68k, magiksf, make, mapbasic, matlab, mirc, modula2, modula3, mmix, mpasm, mxml, mysql, newlisp, nsis, oberon2, objc, objeck, ocaml-brief, ocaml, oobas, oracle8, oracle11, oxygene, oz, pascal, pcre, perl, perl6, per, pf, php-brief, php, pike, pic16, pixelbender, pli, plsql, postgresql, povray, powerbuilder, powershell, proftpd, progress, prolog, properties, providex, purebasic, pycon, python, q, qbasic, rails, rebol, reg, robots, rpmspec, rsplus, ruby, sas, scala, scheme, scilab, sdlbasic, smalltalk, smarty, sql, systemverilog, tcl, teraterm, text, thinbasic, tsql, typoscript, unicon, uscript, vala, vbnet, vb, verilog, vhdl, vim, visualfoxpro, visualprolog, whitespace, winbatch, whois, xbasic, xml, xorg_conf, xpp, yaml, z80, zxbasic//
/plugin/approve/action/
H A Dmigration.php58 $sql = "INSERT OR IGNORE INTO $table ($keys) VALUES ($vals)";
59 return $sqlite->query($sql, array_values($entry));
/plugin/ireadit/action/
H A Dmigration.php60 $sql = "INSERT OR IGNORE INTO $table ($keys) VALUES ($vals)";
61 return $sqlite->query($sql, array_values($entry));
/plugin/openid/Auth/OpenID/
H A DMDB2Store.php320 $sql = "";
330 $sql = sprintf("SELECT handle, secret, issued, lifetime, assoc_type " .
335 $sql = sprintf("SELECT handle, secret, issued, lifetime, assoc_type " .
341 $assoc = $this->connection->getRow($sql, $types, $params);
H A DDatabaseConnection.php39 * @param string $sql An SQL string with placeholders. The
51 function query($sql, $params = []) argument
81 * @param string $sql An SQL string with placeholders. The
92 function getOne($sql, $params = []) argument
101 * @param string $sql An SQL string with placeholders. The
111 function getRow($sql, $params = []) argument
119 * @param string $sql An SQL string with placeholders. The
129 function getAll($sql, $params = []) argument
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 DSQLStore.php72 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 …]
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'] =
/plugin/blogtng/helper/
H A Dcomments.php72 $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 …]
H A Dentry.php176 $sql = "DELETE FROM entries WHERE pid = ?";
177 $ret = $this->sqlitehelper->getDB()->query($sql,$this->entry['pid']);
/plugin/authdrupal8/
H A Dauth.php80 $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/elasticsearch/vendor/elasticsearch/elasticsearch/src/Elasticsearch/
H A DClient.php232 protected $sql; variable in Elasticsearch\\Client
303 $this->sql = new SqlNamespace($transport, $endpoint);
1854 * Returns the sql namespace
1856 public function sql(): SqlNamespace function in Elasticsearch\\Client
1858 return $this->sql;
/plugin/elasticsearch/vendor/elasticsearch/elasticsearch/docs/build/Elasticsearch/
H A DClient.asciidoc86 * <<Elasticsearch_Clientsql_sql,`sql()`>>
1226 .`sql()`
1231 Returns the sql namespace
/plugin/ckgedit/ckeditor/
H A Dcontents-default.css404 background-image: url(images/fileicons/sql.png);
H A Dcontents.css1 …l(images/fileicons/cpp.png)}a.mf_sql{background-image:url(images/fileicons/sql.png)}a.mf_bz2{backg…

12345678