Home
last modified time | relevance | path

Searched refs:sqlite (Results 101 – 125 of 181) sorted by last modified time

12345678

/plugin/notification/action/
H A Dcron.php45 $sqlite = $db_helper->getDB();
54 $res = $sqlite->query('SELECT user, MIN(timestamp) FROM cron_check');
55 $user = $sqlite->res2single($res);
60 $sqlite->query('UPDATE cron_check SET timestamp=? WHERE user=?', date('c'), $user);
83 … $res = $sqlite->query('SELECT plugin, notification_id FROM notification WHERE user=?', $user);
84 $sent_notifications = $sqlite->res2arr($res);
140 $sqlite->storeEntry('notification',
H A Dmigration.php50 $sqlite = $db_helper->getDB();
53 $sqlite->storeEntry('cron_check',
/plugin/ireadit/action/
H A Direadit.php45 $sqlite = $db_helper->getDB();
51 $res = $sqlite->query('SELECT user, timestamp FROM ireadit
55 $readers = $sqlite->res2arr($res);
98 $sqlite = $db_helper->getDB();
103 $sqlite->storeEntry('ireadit', [
124 $sqlite = $db_helper->getDB();
129 $sqlite->query('INSERT INTO ireadit (page,rev,user,timestamp)
H A Dmove.php32 $sqlite = $db_helper->getDB();
39 $sqlite->query('UPDATE ireadit SET page=? WHERE page=?', $new, $old);
H A Dmigration.php90 $sqlite = $data['sqlite'];
91 $db = $sqlite->getAdapter()->getDb();
126 $sqlite = $data['sqlite'];
127 $db = $sqlite->getAdapter()->getDb();
132 $sqlite->storeEntry('meta2', [
138 $sqlite->query('DROP TABLE meta');
147 $sqlite = $data['sqlite'];
148 $db = $sqlite->getAdapter()->getDb();
178 $sqlite->storeEntry('meta', [
193 $sqlite = $data['sqlite'];
[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) {
48 $this->sqlite = null;
51 $this->sqlite->getAdapter()->setUseNativeAlter(true);
58 $this->sqlite = null;
72 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
75 if(!$this->sqlite && $throw) {
78 return $this->sqlite;
88 if (!$this->sqlite) {
[all …]
/plugin/ireadit/
H A Dhelper.php120 $sqlite = $db_helper->getDB();
126 $res = $sqlite->query('SELECT user, timestamp FROM ireadit
130 $readers = $sqlite->res2arr($res);
143 $sqlite = $db_helper->getDB();
167 …$res = $sqlite->query('SELECT page, MAX(rev) as "rev", timestamp FROM ireadit WHERE user=? GROUP B…
170 … $res = $sqlite->query('SELECT page, MAX(rev) as "rev", timestamp FROM ireadit GROUP BY page');
172 while ($row = $sqlite->res_fetch_assoc($res)) {
193 …$res = $sqlite->query('SELECT rev, timestamp FROM ireadit WHERE user=? AND page=? ORDER BY rev DES…
196 … $res = $sqlite->query('SELECT rev, timestamp FROM ireadit WHERE page=? ORDER BY rev DESC', $page);
198 $user_reads = $sqlite->res2arr($res);
/plugin/ireadit/syntax/
H A Dlist.php128 $sqlite = $db_helper->getDB();
/plugin/do/
H A Ddomd5changed.php10 $sqlite = sqlite_open('../../../data/meta/do.sqlite'); variable
12 sqlite_exec($sqlite, 'BEGIN TRANSACTION');
13 $res = sqlite_query($sqlite, $query);
20 …sqlite_exec($sqlite, 'UPDATE tasks SET text = \'' . sqlite_escape_string($row['tasks.text']) . '\'…
23 …sqlite_exec($sqlite, 'UPDATE task_status SET md5 = \'' . $md5 . '\' WHERE md5 = \'' . $row['tasks.…
26 sqlite_exec($sqlite, 'COMMIT');
28 sqlite_close($sqlite);
/plugin/firenews/
H A Dsyntax.php56 $sqlite = $this->sqlConnection($pluginname);
59 $sqlite->query("CREATE TABLE IF NOT EXISTS $tablename
176 $sqlite->query("UPDATE {$tablename}
198 $sqlite->query("DELETE FROM {$tablename}
238 $result = $sqlite->query("SELECT * FROM {$tablename}
298 /** @var helper_plugin_sqlite $sqlite */
299 $sqlite = plugin_load('helper', 'sqlite');
300 if (!$sqlite) {
308 if (!$sqlite->init($dbname, $updatedir)) {
312 return $sqlite;
[all …]
/plugin/structnotification/
H A Dadmin.php47 $sqlite = $db_helper->getDB();
62 $ok = $sqlite->storeEntry('predicate', $predicate);
65 $ok = $sqlite->query('DELETE FROM predicate WHERE id=?', $predicate['id']);
78 $ok = $sqlite->query("UPDATE predicate SET $set WHERE id=?", $predicate);
98 $sqlite = $db_helper->getDB();
116 $res = $sqlite->query($q);
118 $predicates = $sqlite->res2arr($res);
/plugin/structnotification/action/
H A Dnotification.php48 $sqlite = $db_helper->getDB();
49 $event->data['dependencies'][] = $sqlite->getAdapter()->getDbFile();
77 $sqlite = $db_helper->getDB();
86 $res = $sqlite->query($q);
88 $predicates = $sqlite->res2arr($res);
/plugin/structnotification/helper/
H A Ddb.php18 protected $sqlite; variable in helper_plugin_structnotification_db
35 /** @var helper_plugin_sqlite $sqlite */
36 $this->sqlite = plugin_load('helper', 'sqlite');
37 if (!$this->sqlite) {
39 throw new \Exception('Couldn\'t load sqlite.');
44 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
46 throw new \Exception('Couldn\'t load PDO sqlite.');
48 $this->sqlite = null;
51 $this->sqlite
[all...]
/plugin/davcal/
H A Dhelper.php13 protected $sqlite = null; variable in helper_plugin_davcal
300 if(!$sqlite)
348 if(!$sqlite)
368 if(!$sqlite)
391 if(!$sqlite)
414 if(!$sqlite)
448 if(!$sqlite)
502 if(!$sqlite)
537 if(!$sqlite)
687 if(!$sqlite)
[all …]
/plugin/structtemplate/_vagrant/
H A DVagrantfile14 dw_extensions = "dev sqlite struct"
/plugin/watchcycle/
H A Daction.php126 /** @var \helper_plugin_sqlite $sqlite */
127 $sqlite = plugin_load('helper', 'watchcycle_db')->getDB();
128 if (!$sqlite) {
129 msg($this->getLang('error sqlite missing'), -1);
139 $res = $sqlite->query('SELECT * FROM watchcycle WHERE page=?', $page);
140 $row = $sqlite->res2row($res);
155 $sqlite->storeEntry('watchcycle', $entry);
181 $sqlite->query("UPDATE watchcycle SET $set WHERE page=?", $toupdate);
187 $sqlite->query('DELETE FROM watchcycle WHERE page=?', $page);
H A Dadmin.php49 /** @var \helper_plugin_sqlite $sqlite */
50 $sqlite = plugin_load('helper', 'watchcycle_db')->getDB();
119 $res = $sqlite->query($q, $q_args);
120 while ($row = $sqlite->res2row($res)) {
/plugin/watchcycle/helper/
H A Ddb.php18 protected $sqlite; variable in helper_plugin_watchcycle_db
35 /** @var helper_plugin_sqlite $sqlite */
36 $this->sqlite = plugin_load('helper', 'sqlite');
37 if (!$this->sqlite) {
39 throw new \Exception('Couldn\'t load sqlite.');
44 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
46 throw new \Exception('Couldn\'t load PDO sqlite.');
48 $this->sqlite = null;
51 $this->sqlite
[all...]
/plugin/addressbook/
H A Dplugin.info.txt6 desc Simple addressbook using the sqlite-plugin
H A Dsyntax.php379 $query = $sqlite->query($sql);
525 $sqlite->query($sql);
595 $query = $sqlite->query($sql);
596 $res = $sqlite->res2arr($query);
600 if ($sqlite->res2count($sqlite->query($sql)) == 0) {
628 $query = $sqlite->query($sql);
629 $res = $sqlite->res2arr($query);
634 if ($sqlite->res2count($sqlite->query($sql)) == 0) {
673 $query = $sqlite->query($sql);
679 if ($sqlite->res2count($sqlite->query($sql)) == 0) {
[all …]
H A DREADME.md5 …e contacts are stored in a sqlite3-database. The [sqlite-plugin](https://www.dokuwiki.org/plugin:s…
73 * [sqlite-plugin](https://www.dokuwiki.org/plugin:sqlite) / **2020-11-18**
H A Daction.php64 $sqlite = $db_helper->getDB();
76 $query = $sqlite->query($sql);
77 $res = $sqlite->res2arr($query);
79 if ($sqlite->res2count($sqlite->query($sql)) == 0) {
/plugin/addressbook/helper/
H A Ddb.php18 protected $sqlite; variable in helper_plugin_addressbook_db
38 $this->sqlite = plugin_load('helper', 'sqlite');
39 if (!$this->sqlite) {
50 $this->sqlite = null;
53 $this->sqlite->getAdapter()->setUseNativeAlter(true);
60 $this->sqlite = null;
74 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
77 if(!$this->sqlite && $throw) {
80 return $this->sqlite;
90 if (!$this->sqlite) {
[all …]
/plugin/fksnewsfeed/
H A Dhelper.php47 public helper_plugin_sqlite $sqlite; variable in helper_plugin_newsfeed
62 $this->sqlite = $this->loadHelper('sqlite');
64 $this->serviceNews = new ServiceNews($this->sqlite);
65 $this->servicePriority = new ServicePriority($this->sqlite);
66 $this->serviceDependence = new ServiceDependence($this->sqlite);
67 $this->serviceStream = new ServiceStream($this->sqlite);
70 if (!$this->sqlite) {
74 …if (!$this->sqlite->init('newsfeed', DOKU_PLUGIN . $pluginName . DIRECTORY_SEPARATOR . 'db' . DIRE…
96 $res = $this->sqlite->query('SELECT * FROM dependence WHERE parent=?', $streamId);
97 foreach ($this->sqlite->res2arr($res) as $row) {
/plugin/fksnewsfeed/inc/ORM/
H A DAbstractModel.php13 protected helper_plugin_sqlite $sqlite; variable in FYKOS\\dokuwiki\\Extension\\PluginNewsFeed\\Model\\AbstractModel
15 public function __construct(helper_plugin_sqlite $sqlite) { argument
16 $this->sqlite = $sqlite;

12345678