/plugin/combo/db/combo/ |
H A D | README.md | 8 * Create a file `updateXXXXX.sql` where `XXXXX` = `XXXX+1`
|
/plugin/data/syntax/ |
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']);
|
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 | table.php | 228 $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 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/data/admin/ |
H A D | aliases.php | 111 $sql = 'SELECT * FROM aliases ORDER BY name'; 112 $rows = $sqlite->queryAll($sql);
|
/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...] |
H A D | StatisticsQuery.class.php | 16 $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 D | action.php | 178 $sql = "SELECT `info` FROM " . $hlp->prefix . "history WHERE `dt` = DATE(NOW())"; 179 $result = $hlp->runSQL($sql);
|
/plugin/farmer/_animal/data/pages/wiki/ |
H A D | syntax.txt | 385 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 D | migration.php | 58 $sql = "INSERT OR IGNORE INTO $table ($keys) VALUES ($vals)"; 59 return $sqlite->query($sql, array_values($entry));
|
/plugin/ireadit/action/ |
H A D | migration.php | 60 $sql = "INSERT OR IGNORE INTO $table ($keys) VALUES ($vals)"; 61 return $sqlite->query($sql, array_values($entry));
|
/plugin/openid/Auth/OpenID/ |
H A D | MDB2Store.php | 320 $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 D | DatabaseConnection.php | 39 * @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 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 | 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 …]
|
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'] =
|
/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 …]
|
H A D | entry.php | 176 $sql = "DELETE FROM entries WHERE pid = ?"; 177 $ret = $this->sqlitehelper->getDB()->query($sql,$this->entry['pid']);
|
/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/elasticsearch/vendor/elasticsearch/elasticsearch/src/Elasticsearch/ |
H A D | Client.php | 232 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 D | Client.asciidoc | 86 * <<Elasticsearch_Clientsql_sql,`sql()`>> 1226 .`sql()` 1231 Returns the sql namespace
|
/plugin/ckgedit/ckeditor/ |
H A D | contents-default.css | 404 background-image: url(images/fileicons/sql.png);
|
H A D | contents.css | 1 …l(images/fileicons/cpp.png)}a.mf_sql{background-image:url(images/fileicons/sql.png)}a.mf_bz2{backg…
|