Home
last modified time | relevance | path

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

123456789

/plugin/questionnaire/
Dhelper.php15 protected $db; variable in helper_plugin_questionnaire
24 if ($this->db === null) {
26 $this->db = new SQLiteDB('questionnaire', DOKU_PLUGIN . 'questionnaire/db/');
27 $this->db->getPdo()->exec('PRAGMA foreign_keys = ON');
35 return $this->db;
46 $db = $this->getDB();
47 if (!$db) return null;
50 return $db->queryRecord($sql, $page);
62 $db = $this->getDB();
72 $db->saveRecord('questionnaires', $record);
[all …]
/plugin/authucenter/lib/uc_client/model/
Dpm.php24 var $db; variable in pmmodel
32 $this->db = $base->db;
44 …$pm = $this->db->fetch_first("SELECT * FROM ".UC_DBTABLEPRE."pm_indexes i LEFT JOIN ".UC_DBTABLEPR…
46 …$pms = $this->db->fetch_all("SELECT t.*, p.*, t.authorid as founderuid, t.dateline as founddatelin…
56 …$query = $this->db->query("SELECT * FROM ".UC_DBTABLEPRE."pm_members WHERE plid='$plid' AND uid='$…
57 if($this->db->fetch_array($query)) {
129 …$query = $this->db->query("SELECT plid FROM ".UC_DBTABLEPRE."pm_lists WHERE min_max IN (".$this->b…
130 while($thread = $this->db->fetch_array($query)) {
134 …$this->db->query("UPDATE ".UC_DBTABLEPRE."pm_members SET isnew='$newstatus' WHERE plid IN (".$this…
138 …$this->db->query("UPDATE ".UC_DBTABLEPRE."pm_members SET isnew='$newstatus' WHERE plid IN (".$this…
[all …]
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'");
32 …$arr = $this->db->fetch_first("SELECT * FROM ".UC_DBTABLEPRE."members WHERE username='$username'");
37 $arr = $this->db->fetch_first("SELECT * FROM ".UC_DBTABLEPRE."members WHERE email='$email'");
70 …$data = $this->db->result_first("SELECT count(*) FROM ".UC_DBTABLEPRE."mergemembers WHERE appid='"…
88 …$data = $this->db->result_first("SELECT username FROM ".UC_DBTABLEPRE."members WHERE username='$us…
115 …$email = $this->db->result_first("SELECT email FROM ".UC_DBTABLEPRE."members WHERE email='$email'…
135 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."members SET $sqladd username='$username', password=…
136 $uid = $this->db->insert_id();
[all …]
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();
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…
37 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."friends SET uid='$uid', friendid='$friendid', comme…
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…
[all …]
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…
Dmail.php16 var $db; variable in mailmodel
26 $this->db = $base->db;
31 $data = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."mailqueue");
37 …$data = $this->db->fetch_all("SELECT m.*, u.username, u.email FROM ".UC_DBTABLEPRE."mailqueue m LE…
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…
77 …$users = $this->db->fetch_all("SELECT uid, username, email FROM ".UC_DBTABLEPRE."members WHERE uid…
[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->queryRecord($sql, 'one', 'two', 'three');
65 $result = $db->queryRecord($sql, ['first' => 'one', 'second' => 'two', 'third' => 'three']);
71 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
74 $insid = $db->exec($sql, ['test', 'test']);
[all …]
/plugin/labeled/
Dhelper.php22 static $db;
23 if (!is_null($db)) {
24 return $db;
27 $db = plugin_load('helper', 'sqlite');
28 if (is_null($db)) {
32 if($db->init('labeled', dirname(__FILE__).'/db/')){
33 return $db;
96 $db = $this->getDb();
99 $db->query('INSERT INTO labeled (id, label) VALUES (?,?)', $id, $label);
107 $db = $this->getDb();
[all …]
/plugin/approve/helper/
H A Ddb.php9 protected $db; variable in helper_plugin_approve_db
15 $this->db = new SQLiteDB('approve', DOKU_PLUGIN . 'approve/db/');
25 return $this->db->getDbFile();
34 $this->db->getPdo()->beginTransaction();
42 $this->db->getPdo()->commit();
49 return $this->db->queryAll($sql);
55 return $this->db->queryRecord($sql, $page_id);
61 return $this->db->queryValue($sql, $key);
66 $this->db->saveRecord('config', ['key' => $key, 'value' => $value]);
77 $this->db->query($sql, $hidden, $page_id);
[all …]
/plugin/jplayer/vendor/james-heinrich/getid3/getid3/
Dextension.cache.sqlite3.php105 private $db; variable in getID3_cached_sqlite3
132 $this->db = new SQLite3($file);
133 $db = $this->db;
137 $stmt = $db->prepare($sql);
151 $db=$this->db;
152 $db->close();
161 $db = $this->db;
163 $db->exec($sql);
165 $stmt = $db->prepare($sql);
193 $db = $this->db;
[all …]
/plugin/acknowledge/
Dhelper.php17 protected $db; variable in helper_plugin_acknowledge
29 if ($this->db === null) {
31 $this->db = new SQLiteDB('acknowledgement', __DIR__ . '/db');
34 … $this->db->getPdo()->sqliteCreateFunction('AUTH_ISMEMBER', [$this, 'auth_isMember'], -1);
35 … $this->db->getPdo()->sqliteCreateFunction('MATCHES_PAGE_PATTERN', [$this, 'matchPagePattern'], 2);
52 return $this->db;
79 $this->db->getPdo()->beginTransaction();
85 $this->db->exec($sql, [$page, $lastmod]);
87 $this->db->getPdo()->rollBack();
92 $this->db->getPdo()->commit();
[all …]
/plugin/aichat/Storage/
DSQLiteStorage.php26 protected $db; variable in dokuwiki\\plugin\\aichat\\Storage\\SQLiteStorage
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->exec('VACUUM');
120 $result = $this->db->queryAll(
[all …]
/plugin/issuelinks/helper/
Ddb.php14 private $db = null; variable in helper_plugin_issuelinks_db
26 $db = $this->getDB();
27 if (!$db) {
31 $db->query($sql, [$key, $value]);
44 if (null === $this->db) {
65 $this->db = $sqlite;
67 return $this->db;
77 $db = $this->getDB();
78 if (!$db) return;
80 $db->query('DELETE FROM issues');
[all …]
/plugin/starred/
Dhelper.php16 protected $db; variable in helper_plugin_starred
25 if($this->db !== null) return $this->db;
28 $this->db = new SQLiteDB('starred', __DIR__ . '/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;
[all …]
/plugin/statistics/
DQuery.php15 protected SQLiteDB $db; variable in dokuwiki\\plugin\\statistics\\Query
27 $this->db = $hlp->getDB();
126 $result = $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
156 … $result = $this->db->queryRecord($sql, [$this->tz, $this->tz, $this->from, $this->tz, $this->to]);
176 $count = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
191 … $data['avgpages'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
199 … $data['timespent'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
206 … $data['logins'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
213 …$data['registrations'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to…
219 $data['current'] = $this->db->queryValue($sql);
[all …]
DLogger.php21 protected SQLiteDB $db; variable in dokuwiki\\plugin\\statistics\\Logger
64 $this->db = $this->hlp->getDB();
101 $this->db->getPdo()->beginTransaction();
117 $this->db->getPdo()->commit();
167 $this->db->exec(
183 $this->db->exec(
218 $this->db->exec(
242 $this->db->exec('DELETE FROM groups WHERE user = ?', $this->user);
255 $this->db->exec($sql, $params);
276 $this->db->exec($sql, [$domain, $this->user]);
[all …]
/plugin/sqlite/
H A Dadmin.php19 protected $db; variable in admin_plugin_sqlite
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->exec($s);
77 $this->db->getPdo()->commit();
80 $this->db->getPdo()->rollBack();
[all …]
/plugin/do/
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) {
65 $this->db->query(
[all …]
/plugin/freechat/phpfreechat/src/containers/
Dmysql.class.php100 $db = $this->_connect($c);
101 if ($db === FALSE)
109 $db_list = mysql_list_dbs($db);
115 $result = mysql_query($query, $db);
118 $errors[] = _pfc("Mysql container: create database error '%s'",mysql_error($db));
121 mysql_select_db($c->container_cfg_mysql_database, $db);
134 $result = mysql_query($query, $db);
137 $errors[] = _pfc("Mysql container: create table error '%s'",mysql_error($db));
161 $db = $this->_connect();
169 $res = mysql_query($sql_count, $db);
[all …]
/plugin/numbering/scripts/
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/doxycode/helper/
Dbuildmanager.php52 protected $db = null; variable in helper_plugin_doxycode_buildmanager
75 if ($this->db === null) {
77 $this->db = new SQLiteDB('doxycode', DOKU_PLUGIN . 'doxycode/db/');
106 if ($this->db === null) {
114 $row = $this->db->queryRecord('SELECT * FROM Tasks WHERE TaskID = ?', [$config['taskID']]);
121 $id = $this->db->exec(
129 $id = $this->db->exec(
142 $id = $this->db->exec(
172 $new = $this->db->saveRecord('Jobs', $data);
240 if ($this->db === null) {
[all …]
/plugin/linkcheck/
Dhelper.php12 private $db=null; #use getdb() to access this. variable in helper_plugin_linkcheck
50 if(!isset($this->db)){
51 if($file=$this->getdbfile()) $this->db=linkcheck_db($file);
52 else $this->db=false;
54 return $this->db;
83 $db=&$this->getdb();
87 $id_=$db->escapeString($id);
89 foreach(linkcheck_db_query($db,$query) as $row){
97 $urls_=array_map([$db,'escapeString'],$deleteurls);
101 $db->exec($query);
[all …]
/plugin/tagging/
H A Dhelper.php27 static $db = null;
28 if ($db !== null) {
29 return $db;
34 $db = new SQLiteDB('tagging', __DIR__ . '/db/');
36 $db->getPdo()->sqliteCreateFunction('CLEANTAG', [$this, 'cleanTag'], 1);
37 $db->getPdo()->sqliteCreateFunction(
47 $db->getPdo()->sqliteCreateFunction('GET_NS', 'getNS', 1);
49 return $db;
154 $db = $this->getDB();
155 $db->exec('BEGIN TRANSACTION');
[all …]
/plugin/blogtng/helper/
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;

123456789