/plugin/notification/action/ |
H A D | cron.php | 45 $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 D | migration.php | 50 $sqlite = $db_helper->getDB(); 53 $sqlite->storeEntry('cron_check',
|
/plugin/ireadit/action/ |
H A D | ireadit.php | 45 $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 D | move.php | 32 $sqlite = $db_helper->getDB(); 39 $sqlite->query('UPDATE ireadit SET page=? WHERE page=?', $new, $old);
|
H A D | migration.php | 90 $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 D | db.php | 18 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 D | helper.php | 120 $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 D | list.php | 128 $sqlite = $db_helper->getDB();
|
/plugin/do/ |
H A D | domd5changed.php | 10 $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 D | syntax.php | 56 $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 D | admin.php | 47 $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 D | notification.php | 48 $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 D | db.php | 18 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 D | helper.php | 13 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 D | Vagrantfile | 14 dw_extensions = "dev sqlite struct"
|
/plugin/watchcycle/ |
H A D | action.php | 126 /** @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 D | admin.php | 49 /** @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 D | db.php | 18 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 D | plugin.info.txt | 6 desc Simple addressbook using the sqlite-plugin
|
H A D | syntax.php | 379 $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 D | README.md | 5 …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 D | action.php | 64 $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 D | db.php | 18 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 D | helper.php | 47 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 D | AbstractModel.php | 13 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;
|