Home
last modified time | relevance | path

Searched refs:db (Results 1 – 25 of 189) sorted by relevance

12345678

/plugin/authucenter/lib/uc_client/model/
H A Dpm.php24 var $db; variable in pmmodel
32 $this->db = $base->db;
57 if($this->db->fetch_array($query)) {
240 $plid = $this->db->insert_id();
242 $pmid = $this->db->insert_id();
249 $pmid = $this->db->insert_id();
266 $plid = $this->db->insert_id();
268 $pmid = $this->db->insert_id();
332 $pmid = $this->db->insert_id();
486 $query = $this->db->query($sql);
[all …]
H A Duser.php14 var $db; variable in usermodel
23 $this->db = $base->db;
27 $arr = $this->db->fetch_first("SELECT * FROM ".UC_DBTABLEPRE."members WHERE uid='$uid'");
136 $uid = $this->db->insert_id();
137 $this->db->query("INSERT INTO ".UC_DBTABLEPRE."memberfields SET uid='$uid'");
166 return $this->db->affected_rows();
185 $this->db->query("DELETE FROM ".UC_DBTABLEPRE."members WHERE uid IN($uids)");
190 return $this->db->affected_rows();
212 while($user = $this->db->fetch_array($query)) {
221 while($user = $this->db->fetch_array($query)) {
[all …]
H A Ddomain.php14 var $db; variable in domainmodel
23 $this->db = $base->db;
28 $this->db->query("INSERT INTO ".UC_DBTABLEPRE."domains SET domain='$domain', ip='$ip'");
30 return $this->db->insert_id();
34 $data = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."domains");
40 $data = $this->db->fetch_all("SELECT * FROM ".UC_DBTABLEPRE."domains LIMIT $start, $ppp");
46 $this->db->query("DELETE FROM ".UC_DBTABLEPRE."domains WHERE id IN ($domainids)");
47 return $this->db->affected_rows();
51 $this->db->query("UPDATE ".UC_DBTABLEPRE."domains SET domain='$domain', ip='$ip' WHERE id='$id'");
52 return $this->db->affected_rows();
H A Dfriend.php14 var $db; variable in friendmodel
23 $this->db = $base->db;
27 …$direction = $this->db->result_first("SELECT direction FROM ".UC_DBTABLEPRE."friends WHERE uid='$f…
29 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."friends SET uid='$uid', friendid='$friendid', comme…
30 …$this->db->query("UPDATE ".UC_DBTABLEPRE."friends SET direction='3' WHERE uid='$friendid' AND frie…
38 return $this->db->insert_id();
44 …$this->db->query("DELETE FROM ".UC_DBTABLEPRE."friends WHERE uid='$uid' AND friendid IN ($friendid…
45 $affectedrows = $this->db->affected_rows();
47 …$this->db->query("UPDATE ".UC_DBTABLEPRE."friends SET direction=1 WHERE uid IN ($friendids) AND fr…
63 …$totalnum = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."friends WHERE $sqladd");
[all …]
H A Dtag.php14 var $db; variable in tagmodel
23 $this->db = $base->db;
27 $arr = $this->db->fetch_all("SELECT * FROM ".UC_DBTABLEPRE."tags WHERE tagname='$tagname'");
32 …$result = $this->db->result_first("SELECT tagtemplates FROM ".UC_DBTABLEPRE."applications WHERE ap…
51 …$return = $this->db->result_first("SELECT count(*) FROM ".UC_DBTABLEPRE."tags WHERE tagname='$data…
53 …$this->db->query("UPDATE ".UC_DBTABLEPRE."tags SET data='$datanew', expiration='".$this->base->tim…
55 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."tags (tagname, appid, data, expiration) VALUES ('$d…
61 …$return = $this->db->result_first("SELECT count(*) FROM ".UC_DBTABLEPRE."tags WHERE tagname='$tagn…
63 …$this->db->query("UPDATE ".UC_DBTABLEPRE."tags SET expiration='0' WHERE tagname='$tagname' AND app…
65 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."tags (tagname, appid, expiration) VALUES ('$tagname…
H A Dmail.php16 var $db; variable in mailmodel
26 $this->db = $base->db;
31 $data = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."mailqueue");
49 $this->db->query("DELETE FROM ".UC_DBTABLEPRE."mailqueue WHERE mailid IN ($ids)");
50 return $this->db->affected_rows();
66 $this->db->query($sql);
67 $insert_id = $this->db->insert_id();
68 …$insert_id && $this->db->query("REPLACE INTO ".UC_DBTABLEPRE."vars SET name='mailexists', value='1…
99 $this->db->query("REPLACE INTO ".UC_DBTABLEPRE."vars SET name='mailexists', value='0'");
140 return $this->db->query("DELETE FROM ".UC_DBTABLEPRE."mailqueue WHERE mailid='$mailid'");
[all …]
/plugin/sqlite/_test/
H A DSQLiteDBTest.php35 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
36 $this->assertInstanceOf(\PDO::class, $db->getPdo());
41 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
44 $stmt = $db->query($sql, ['music']);
53 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
57 $result = $db->queryRecord($sql, ['one', 'two', 'three']);
60 $result = $db
[all...]
/plugin/labeled/
H A Dhelper.php22 static $db;
23 if (!is_null($db)) {
24 return $db;
28 if (is_null($db)) {
33 return $db;
96 $db = $this->getDb();
107 $db = $this->getDb();
120 $db = $this->getDb();
134 $db = $this->getDb();
162 $db = $this->getDb();
[all …]
/plugin/jplayer/vendor/james-heinrich/getid3/getid3/
H A Dextension.cache.sqlite3.php105 private $db; variable in getID3_cached_sqlite3
133 $db = $this->db;
137 $stmt = $db->prepare($sql);
151 $db=$this->db;
152 $db->close();
161 $db = $this->db;
163 $db->exec($sql);
193 $db = $this->db;
226 $db = $this->db;
228 return $db->exec($sql);
[all …]
/plugin/tagging/
H A Dhelper.php20 static $db = null;
21 if ($db !== null) {
22 return $db;
25 /** @var helper_plugin_sqlite $db */
26 $db = plugin_load('helper', 'sqlite');
27 if ($db === null) {
32 $db->init('tagging', __DIR__ . '/db/');
33 $db->create_function('CLEANTAG', array($this, 'cleanTag'), 1);
34 $db
[all...]
/plugin/issuelinks/helper/
H A Ddb.php14 private $db = null; variable in helper_plugin_issuelinks_db
26 $db = $this->getDB();
27 if (!$db) {
67 return $this->db;
77 $db = $this->getDB();
78 if (!$db) return;
83 $db->query('VACUUM');
96 if (!$db) {
135 if (!$db) {
188 if (!$db) {
[all …]
/plugin/starred/
H A Dhelper.php16 protected $db; variable in helper_plugin_starred
25 if($this->db !== null) return $this->db;
29 return $this->db;
48 $db = $this->getDB();
49 if (!$db) return;
61 $db->exec($sql, [$pageid, $user]);
65 $db->exec($sql, [$pageid, $user, time()]);
82 $db = $this->getDB();
83 if (!$db) return false;
106 $db = $this->getDB();
[all …]
/plugin/do/
H A Dhelper.php20 private $db = null; variable in helper_plugin_do
27 $this->db = plugin_load('helper', 'sqlite');
28 if (!$this->db) {
32 if (!$this->db->init('do', dirname(__FILE__) . '/db/')) {
33 $this->db = null;
44 if (!$this->db) {
47 $this->db->query('DELETE FROM tasks WHERE page = ?', $id);
48 $this->db->query('DELETE FROM task_assignees WHERE page = ?', $id);
59 if (!$this->db) {
[all...]
/plugin/freechat/phpfreechat/src/containers/
H A Dmysql.class.php100 $db = $this->_connect($c);
101 if ($db === FALSE)
109 $db_list = mysql_list_dbs($db);
161 $db = $this->_connect();
173 mysql_query($sql_insert, $db);
196 $db = $this->_connect();
256 $db = $this->_connect();
267 mysql_query($sql_insert, $db);
272 mysql_query($sql_update, $db);
290 $db = $this->_connect();
[all …]
/plugin/numbering/scripts/
H A Dgetnum.php18 $db = numberingDB();
22 $number = getNumberingNextNumber($db, $start);
51 function getNumberingNextNumber($db, $start) { argument
53 io_lock($db);
54 $ar = unserialize(io_readFile($db,false));
70 file_put_contents($db,serialize($ar));
71 io_unlock($db);
76 $db = metaFN("numbering:seqnum",'.ser');
77 if(!file_exists($db)) {
78 io_saveFile($db,"", array());
[all …]
/plugin/sqlite/
H A Dadmin.php19 protected $db;
43 if ($INPUT->str('db') && checkSecurityToken()) {
45 $this->db = new SQLiteDB($INPUT->str('db'), '');
46 $this->querySaver = new QuerySaver($this->db->getDBName());
56 $exportfile = $conf['tmpdir'] . '/' . $this->db->getDbName() . '.sql';
57 $this->db->dumpToFile($exportfile);
59 header('Content-Disposition: attachment; filename="' . $this->db->getDbName() . '.sql";');
73 $this->db->getPdo()->beginTransaction();
75 $this->db
18 protected $db = null; global() variable in admin_plugin_sqlite
[all...]
H A DQuerySaver.php9 protected $db;
17 $this->db = new SQLiteDB('sqlite', DOKU_PLUGIN . 'sqlite/db/');
30 'sqlitedb' => $this->db,
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]);
63 'sqlitedb' => $this->db,
69 $sql = 'DELETE FROM queries WHERE db
10 protected $db; global() variable in dokuwiki\\plugin\\sqlite\\QuerySaver
[all...]
/plugin/blogtng/helper/
H A Dsqlite.php13 protected $db = null; variable in helper_plugin_blogtng_sqlite
31 if($this->db === null) {
32 $this->db = plugin_load('helper', 'sqlite');
33 if($this->db === null) {
37 if(!$this->db->init('blogtng', dirname(__FILE__) . '/../db/')) {
38 $this->db = null;
42 return $this->db;
/plugin/aichat/Storage/
H A DSQLiteStorage.php26 protected $db;
36 $this->db = new SQLiteDB('aichat', DOKU_PLUGIN . 'aichat/db/');
37 $this->db->getPdo()->sqliteCreateFunction('COSIM', $this->sqliteCosineSimilarityCallback(...), 2);
48 $record = $this->db->queryRecord('SELECT * FROM embeddings WHERE id = ?', [$chunkID]);
66 $this->db->exec('DELETE FROM embeddings');
68 $this->db->exec('DELETE FROM clusters');
81 $this->db->exec('DELETE FROM embeddings WHERE page = ?', [$page]);
88 $this->db->saveRecord('embeddings', [
107 $this->db
18 protected $db; global() variable in dokuwiki\\plugin\\aichat\\Storage\\SQLiteStorage
[all...]
/plugin/bez/action/
H A Dmigration.php58 $db = $sqlite->getAdapter()->getPdo();
60 // $db->beginTransaction(); // translation already started
62 $res = $db->query($query);
64 $err = $db->errorInfo();
66 $db->rollBack();
70 // $db->commit(); // commit will be done inside SQLiteDB
91 $db = $sqlite->getAdapter()->getPdo();
93 // $db->beginTransaction(); // translation already started
95 $res = $db->query($query);
97 $err = $db
[all...]
/plugin/data/_test/
H A Daction_handle.test.php
/plugin/struct/action/
H A Dmove.php24 protected $db;
49 $this->db = $hlp->getDB(false);
50 if (!$this->db instanceof SQLiteDB) return false;
55 $this->db->query('BEGIN TRANSACTION');
82 $ok = $this->db->query('COMMIT TRANSACTION');
84 $this->db->query('ROLLBACK TRANSACTION');
104 $this->db->query($sql, [$new, $old]);
108 $this->db->query($sql, [$new, $old]);
122 $this->db->query($sql, [$new, $old]);
137 $this->db
20 protected $db = null; global() variable in action_plugin_struct_move
[all...]
/plugin/numbering/
H A Daction.php78 $db = metaFN("numbering:$db_name",'.ser');
80 else $db = metaFN("numbering:seqnum",'.ser');
82 if(!file_exists($db)) {
83 io_saveFile($db,"", array());
85 return $db;
89 $db = $this->numberingDB();
91 io_lock($db);
92 $ar = unserialize(io_readFile($db,false));
108 file_put_contents($db,serialize($ar));
109 io_unlock($db);
/plugin/data-au/_test/
H A Daction_handle.test.php27 $this->db = $this->helper->_getDB();
29 $this->db->query('INSERT INTO pages ( pid, page, title , class , lastmod) VALUES
61 $res = $this->db->query('SELECT pid FROM pages WHERE page = ?','test');
62 $pid = $this->db->res2single($res);
68 $res = $this->db->query('SELECT pid FROM pages WHERE page = ?','test');
69 $pid = (int) $this->db->res2single($res);
/plugin/sql2wiki/action/
H A Dsqlite.php23 protected function queue_put($db, $query_name='') { argument
24 if (!isset($this->queue[$db])) {
25 $this->queue[$db] = [];
29 $this->queue[$db] = true;
32 if (is_array($this->queue[$db])) {
33 $this->queue[$db][$query_name] = true;
41 $db = $query['db'];
43 return isset($queue[$db]) && ($queue[$db]
[all...]

12345678