Home
last modified time | relevance | path

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

12345678

/plugin/rating/
Dhelper.php15 protected $sqlite = null; variable in helper_plugin_rating
23 if(!is_null($this->sqlite)) return $this->sqlite;
25 $this->sqlite = plugin_load('helper', 'sqlite');
26 if(!$this->sqlite) {
28 $this->sqlite = null;
32 $ok = $this->sqlite->init('rating', __DIR__ . '/db');
35 $this->sqlite = null;
39 return $this->sqlite;
60 $sqlite = $this->getDBHelper();
61 if(!$sqlite) return;
[all …]
/plugin/timetrack/
Dhelper.php64 $sqlite = $this->getDb();
65 if(!$sqlite) return false;
67 $res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
68 $db_user_id = (int) $sqlite->res2single($res);
69 $sqlite->res_close($res);
72 $sqlite->query('INSERT OR IGNORE INTO user (user) VALUES (?)', $user);
74 $res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
75 $db_user_id = (int) $sqlite->res2single($res);
76 $sqlite->res_close($res);
89 $sqlite = $this->getDb();
[all …]
/plugin/struct/action/
H A Dmigration.php6 use dokuwiki\plugin\sqlite\SQLiteDB;
53 * @param SQLiteDB $sqlite
56 protected function migration12($sqlite) argument
60 $tables = $sqlite->queryAll($sql);
65 $sqlite->query($sql);
76 * @param SQLiteDB $sqlite
79 protected function migration16($sqlite) argument
85 $tables = $sqlite->queryAll($sql);
91 $schemas = $sqlite->queryAll($sql);
101 $ok = $ok && $sqlite->query("ALTER TABLE $name RENAME TO temp_$name");
[all …]
/plugin/extendpage/helper/
Ddb.php14 protected $sqlite; variable in helper_plugin_extendpage_db
32 $this->sqlite = plugin_load('helper', 'sqlite');
33 if (!$this->sqlite) {
38 if ($this->sqlite->getAdapter() === null) {
40 $this->sqlite = null;
44 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
46 $this->sqlite = null;
49 $this->sqlite->getAdapter()->setUseNativeAlter(true);
52 if (!$this->sqlite->init('extendpage', DOKU_PLUGIN . 'extendpage/db/')) {
54 $this->sqlite = null;
[all …]
/plugin/structpublish/action/
H A Dmigration.php7 use dokuwiki\plugin\sqlite\SQLiteDB;
8 use dokuwiki\plugin\sqlite\Tools;
44 $sqlite = $helper->getDB();
46 [$dbVersionStruct, $dbVersionStructpublish] = $this->getDbVersions($sqlite);
72 $ok = $ok && $this->$call($sqlite);
78 $ok = $ok && $sqlite->query($sql);
87 * @param SQLiteDB $sqlite
90 protected function getDbVersions($sqlite) argument
96 $vals = $sqlite->queryAll($sql, ['dbversion', 'dbversion_structpublish']);
120 * @param SQLiteDB $sqlite
[all …]
/plugin/addressbook/helper/
Ddb.php18 protected $sqlite; variable in helper_plugin_addressbook_db
38 $this->sqlite = plugin_load('helper', 'sqlite');
39 if (!$this->sqlite) {
46 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
50 $this->sqlite = null;
53 $this->sqlite->getAdapter()->setUseNativeAlter(true);
56 … if (!$this->sqlite->init('addressbook', DOKU_PLUGIN . 'addressbook/db/')) { # Changed plugin name
60 $this->sqlite = null;
74 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
77 if(!$this->sqlite && $throw) {
[all …]
/plugin/telleveryone/helper/
Ddb.php18 protected $sqlite; variable in helper_plugin_telleveryone_db
36 $this->sqlite = plugin_load('helper', 'sqlite');
37 if (!$this->sqlite) {
44 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
48 $this->sqlite = null;
51 $this->sqlite->getAdapter()->setUseNativeAlter(true);
54 if (!$this->sqlite->init('telleveryone', DOKU_PLUGIN . 'telleveryone/db/')) {
58 $this->sqlite = null;
72 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
75 if(!$this->sqlite && $throw) {
[all …]
/plugin/bez/helper/
H A Ddb.php14 protected $sqlite; variable in helper_plugin_bez_db
30 $this->sqlite = plugin_load('helper', 'sqlite');
31 if(!$this->sqlite) {
36 if($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
38 $this->sqlite = null;
41 $this->sqlite->getAdapter()->setUseNativeAlter(true);
44 if(!$this->sqlite->init('b3p', DOKU_PLUGIN . 'bez/db/')) {
46 $this->sqlite = null;
60 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(),0,$len)) {
63 if(!$this->sqlite && $throw) {
[all …]
/plugin/ireadit/helper/
H A Ddb.php18 protected $sqlite; variable in helper_plugin_ireadit_db
36 $this->sqlite = plugin_load('helper', 'sqlite');
37 if (!$this->sqlite) {
44 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
48 $this->sqlite = null;
51 $this->sqlite->getAdapter()->setUseNativeAlter(true);
54 if (!$this->sqlite->init('ireadit', DOKU_PLUGIN . 'ireadit/db/')) {
58 $this->sqlite = null;
72 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
75 if(!$this->sqlite && $throw) {
[all …]
/plugin/structstatus/
Daction.php3 use dokuwiki\plugin\sqlite\SQLiteDB;
45 $sqlite = $helper->getDB();
48 list($dbVersionStruct, $dbVersionStructStatus) = $this->getDbVersions($sqlite);
64 $schemas= $sqlite->queryAll($sql);
66 $sqlite->getPdo()->beginTransaction();
72 $this->$call($sqlite, $schema);
78 $sqlite->query($sql);
80 $sqlite->getPdo()->commit();
82 $sqlite->getPdo()->rollBack();
106 * @param SQLiteDB $sqlite
[all …]
/plugin/structnotification/helper/
H A Ddb.php14 protected $sqlite; variable in helper_plugin_structnotification_db
31 $this->sqlite = plugin_load('helper', 'sqlite');
32 if (!$this->sqlite) {
39 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
43 $this->sqlite = null;
46 $this->sqlite->getAdapter()->setUseNativeAlter(true);
49 if (!$this->sqlite->init('structnotification', DOKU_PLUGIN . 'structnotification/db/')) {
53 $this->sqlite = null;
64 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
67 if (!$this->sqlite) {
[all …]
/plugin/notification/helper/
H A Ddb.php14 protected $sqlite; variable in helper_plugin_notification_db
31 $this->sqlite = plugin_load('helper', 'sqlite');
32 if (!$this->sqlite) {
39 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
43 $this->sqlite = null;
46 $this->sqlite->getAdapter()->setUseNativeAlter(true);
49 if (!$this->sqlite->init('notification', DOKU_PLUGIN . 'notification/db/')) {
53 $this->sqlite = null;
65 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
68 if (!$this->sqlite) {
[all …]
/plugin/extendpage/meta/
DAssignments.php18 protected $sqlite; variable in dokuwiki\\plugin\\extendpage\\meta\\Assignments
50 $this->sqlite = $helper->getDB();
61 $res = $this->sqlite->query($sql);
62 $this->patterns = $this->sqlite->res2arr($res);
63 $this->sqlite->res_close($res);
77 $ok = (bool) $this->sqlite->query($sql, array($pattern, $page, $pos));
80 $res = $this->sqlite->query($sql);
84 $this->propagatePageAssignments($this->sqlite->res2single($res));
100 $ok = (bool) $this->sqlite->query($sql, array($id));
107 $res = $this->sqlite->query($sql, $id);
[all …]
/plugin/davcal/
H A Dhelper.php13 protected $sqlite = null; variable in helper_plugin_davcal
23 * @return sqlite interface or false
27 if($this->sqlite === null)
29 $this->sqlite = new \dokuwiki\plugin\sqlite\SQLiteDB('davcal', DOKU_PLUGIN.'davcal/db/');
30 if(!$this->sqlite)
37 return $this->sqlite;
301 $sqlite = $this->getDB();
302 if(!$sqlite)
306 $res = $sqlite->query($query, $color, $calid);
349 $sqlite = $this->getDB();
[all …]
/plugin/ireadit/action/
H A Dmigration.php56 protected function insertOrIgnore(helper_plugin_sqlite $sqlite, $table, $entry) { argument
61 return $sqlite->query($sql, array_values($entry));
90 $sqlite = $data['sqlite'];
96 $sqlite->query('DELETE FROM ireadit WHERE timestamp IS NULL');
98 $res = $sqlite->query('SELECT page,meta FROM meta');
99 while ($row = $sqlite->res_fetch_assoc($res)) {
107 …$res2 = $sqlite->query('SELECT user FROM ireadit WHERE page=? AND rev=? AND user=?', $page, $last_…
108 $existsAlready = $sqlite->res2single($res2);
110 $sqlite->storeEntry('ireadit', [
125 $sqlite = $data['sqlite'];
[all …]
/plugin/fksnewsfeed/inc/ORM/
DAbstractService.php18 protected helper_plugin_sqlite $sqlite; variable in FYKOS\\dokuwiki\\Extension\\PluginNewsFeed\\ORM\\AbstractService
20 … public function __construct(helper_plugin_sqlite $sqlite, string $table, string $modelClassName) { argument
22 $this->sqlite = $sqlite;
27 …$res = $this->sqlite->query('SELECT * FROM ' . $this->table . ' WHERE ' . $this->table . '_id = ?'…
29 return ($this->modelClassName)::createFromArray($this->sqlite, $res);
37 return (bool)$this->sqlite->query($sql,
46 $this->sqlite->query($sql,
55 $res = $this->sqlite->query('SELECT max(' . $this->table . '_id) FROM ?', $this->table);
56 return (int)$this->sqlite->res2single($res);
61 $res = $this->sqlite->query('SELECT * FROM ?', $this->table);
[all …]
/plugin/davcard/
Dhelper.php14 protected $sqlite = null; variable in helper_plugin_davcard
25 * @return sqlite interface or false
29 if($this->sqlite === null)
31 $this->sqlite = plugin_load('helper', 'sqlite');
32 if(!$this->sqlite)
38 if(!$this->sqlite->init('davcard', DOKU_PLUGIN.'davcard/db/'))
40 $this->sqlite = null;
45 return $this->sqlite;
147 $sqlite = $this->getDB();
148 if(!$sqlite)
[all …]
/plugin/struct/helper/
H A Ddb.php12 use dokuwiki\plugin\sqlite\SQLiteDB;
18 protected $sqlite; variable in helper_plugin_struct_db
27 $this->sqlite = new SQLiteDB('struct', DOKU_PLUGIN . 'struct/db/');
30 $this->sqlite->getPdo()->sqliteCreateFunction('STRUCT_JSON', [$this, 'STRUCT_JSON'], -1);
33 … $this->sqlite->getPdo()->sqliteCreateFunction('STRUCT_LOOKUP', [$this, 'STRUCT_LOOKUP'], -1);
36 $this->sqlite->getPdo()->sqliteCreateFunction('IS_PUBLISHER', [$this, 'IS_PUBLISHER'], -1);
46 if (!$this->sqlite instanceof SQLiteDB) {
60 return $this->sqlite;
70 if (!$this->sqlite) return;
71 $file = $this->sqlite->getDbFile();
[all …]
/plugin/structpublish/meta/
H A DAssignments.php5 use dokuwiki\plugin\sqlite\SQLiteDB;
18 protected $sqlite; variable in dokuwiki\\plugin\\structpublish\\meta\\Assignments
50 $this->sqlite = $helper->getDB();
61 $this->patterns = $this->sqlite->queryAll($sql);
76 $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
88 $this->sqlite->query('BEGIN TRANSACTION');
94 $ok = $ok && $this->sqlite->query('COMMIT TRANSACTION');
96 $this->sqlite->query('ROLLBACK TRANSACTION');
114 $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
121 $pagerows = $this->sqlite->queryAll($sql, [$user, $status]);
[all …]
/plugin/webdavclient/
Dhelper.php14 protected $sqlite = null; variable in helper_plugin_webdavclient
33 * @return sqlite interface or false
37 if($this->sqlite === null)
39 $this->sqlite = plugin_load('helper', 'sqlite');
40 if(!$this->sqlite)
46 if(!$this->sqlite->init('webdavclient', DOKU_PLUGIN.'webdavclient/db/'))
48 $this->sqlite = null;
53 return $this->sqlite;
160 $sqlite = $this->getDB();
161 if(!$sqlite)
[all …]
/plugin/data-au/admin/
Daliases.php65 $sqlite = $this->dthlp->_getDB();
66 if(!$sqlite) return;
68 $sqlite->query("BEGIN TRANSACTION");
69 if (!$sqlite->query("DELETE FROM aliases")) {
70 $sqlite->query('ROLLBACK TRANSACTION');
84 if (!$sqlite->query("INSERT INTO aliases (name, type, prefix, postfix, enum)
86 $sqlite->query('ROLLBACK TRANSACTION');
90 $sqlite->query("COMMIT TRANSACTION");
97 $sqlite = $this->dthlp->_getDB();
98 if(!$sqlite) return;
[all …]
/plugin/struct/meta/
H A DSchema.php5 use dokuwiki\plugin\sqlite\SQLiteDB;
24 protected $sqlite; variable in dokuwiki\\plugin\\struct\\meta\\Schema
64 $this->sqlite = $helper->getDB();
87 $schema = $this->sqlite->queryAll($sql, $opt);
108 $rows = $this->sqlite->queryAll($sql, [$this->id]);
194 $this->sqlite->query('BEGIN TRANSACTION');
197 $this->sqlite->query($sql . 'data_' . $this->table);
198 $this->sqlite->query($sql . 'multi_' . $this->table);
201 $this->sqlite->query($sql);
204 $this->sqlite->query($sql);
[all …]
/plugin/top/
Dhelper.php12 protected $sqlite = null; variable in helper_plugin_top
16 $this->sqlite = plugin_load('helper', 'sqlite');
17 if (!$this->sqlite) {
22 if (!$this->sqlite->init('top', __DIR__ . '/db')) {
34 return $this->sqlite;
62 $res = $this->sqlite->query($sql, $page, $page, $month, $lang, $month);
63 $this->sqlite->res_close($res);
80 $res = $this->sqlite->query($sql, $num);
83 $res = $this->sqlite->query($sql, $lang, $num);
86 $res = $this->sqlite->query($sql, intval($month), $num);
[all …]
/plugin/data-au/syntax/
Drelated.php36 $sqlite = $this->dthlp->_getDB();
37 if(!$sqlite) return false;
42 $res = $sqlite->query($dataau['sql']);
43 if(!$sqlite->res2count($res)) return true; // no rows matched
44 $rows = $sqlite->res2arr($res);
75 $sqlite = $this->dthlp->_getDB();
76 if(!$sqlite) return false;
88 $res = $sqlite->query($sql, $col, $id);
89 while($value = $sqlite->res_fetch_assoc($res)) {
95 $cond[] = " ( T1.key = " . $sqlite->quote_string($col) .
[all …]
/plugin/bez/mdl/
H A DSubscriptionFactory.php12 $r = $this->model->sqlite->query($q, $token);
13 return $this->model->sqlite->res2single($r);
24 $this->model->sqlite->query($q, $user_id);
31 $this->model->sqlite->query($q, $this->model->user_nick);
41 $this->model->sqlite->query($q, $this->model->user_nick);
50 $r = $this->model->sqlite->query($q, $this->model->user_nick);
51 $mute = $this->model->sqlite->res2single($r);
66 $r = $this->model->sqlite->query($q, $user);
67 $token = $this->model->sqlite->res2single($r);
70 $this->model->sqlite->storeEntry($this->get_table_name(),
[all …]

12345678