/plugin/data-au/admin/ |
H A D | aliases.php | 65 $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'); 86 $sqlite->query('ROLLBACK TRANSACTION'); 90 $sqlite->query("COMMIT TRANSACTION"); 97 $sqlite = $this->dthlp->_getDB(); 98 if(!$sqlite) return; 103 $res = $sqlite->query($sql); [all …]
|
H A D | clean.php | 65 $sqlite = $this->dthlp->_getDB(); 66 if(!$sqlite) return; 68 $res = $sqlite->query("SELECT pid, page FROM pages"); 69 $rows = $sqlite->res2arr($res); 74 $sqlite->query('DELETE FROM dataau WHERE pid = ?',$row['pid']); 75 $sqlite->query('DELETE FROM pages WHERE pid = ?',$row['pid']);
|
/plugin/data/admin/ |
H A D | aliases.php | 73 $sqlite = $this->dthlp->getDB(); 74 if (!$sqlite) return; 76 $sqlite->getPdo()->beginTransaction(); 78 $sqlite->exec('DELETE FROM aliases'); 91 $sqlite->saveRecord('aliases', $row); 93 $sqlite->getPdo()->commit(); 97 $sqlite->getPdo()->rollBack(); 106 $sqlite = $this->dthlp->getDB(); 107 if (!$sqlite) return; 112 $rows = $sqlite [all...] |
H A D | clean.php | 12 * Let admin remove non-existing pages from sqlite db 69 $sqlite = $this->dthlp->getDB(); 70 if (!$sqlite) return; 72 $rows = $sqlite->queryAll('SELECT pid, page FROM pages'); 77 $sqlite->exec('DELETE FROM data WHERE pid = ?', $row['pid']); 78 $sqlite->exec('DELETE FROM pages WHERE pid = ?', $row['pid']);
|
/plugin/struct/meta/ |
H A D | Schema.php | 5 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 [all...] |
H A D | Assignments.php | 19 protected $sqlite; 51 $this->sqlite = $helper->getDB(); 63 $this->patterns = $this->sqlite->queryAll($sql); 77 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]); 98 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]); 105 $pagerows = $this->sqlite->queryAll($sql, [$table]); 131 $tablerows = $this->sqlite->queryAll($sql, [$pid]); 154 $ok = (bool)$this->sqlite->query($sql); 161 $ok = $ok && (bool)$this->sqlite->query($sql); 179 return (bool)$this->sqlite 17 protected $sqlite; global() variable in dokuwiki\\plugin\\struct\\meta\\Assignments [all...] |
H A D | SchemaBuilder.php | 5 use dokuwiki\plugin\sqlite\SQLiteDB; 48 protected $sqlite; 69 $this->sqlite = $this->helper->getDB(); 84 $this->sqlite->query('BEGIN TRANSACTION'); 99 $this->sqlite->query('ROLLBACK TRANSACTION'); 102 $this->sqlite->query('COMMIT TRANSACTION'); 158 $this->sqlite->query($sql, [$this->table, $this->time, $this->user, $config]); 159 $this->newschemaid = $this->sqlite->queryValue('SELECT last_insert_rowid()'); 188 $ok = $this->sqlite->saveRecord('types', $newEntry); 190 $newTid = $this->sqlite 47 protected $sqlite; global() variable in dokuwiki\\plugin\\struct\\meta\\SchemaBuilder [all...] |
/plugin/data-au/syntax/ |
H A D | related.php | 36 $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/data/syntax/ |
H A D | related.php | 41 $sqlite = $this->dthlp->getDB(); 42 if (!$sqlite) return false; 47 $rows = $sqlite->queryAll($data['sql']); 80 $sqlite = $this->dthlp->getDB(); 81 if (!$sqlite) return false; 92 $rows = $sqlite->queryAll($sql, $col, $id); 97 $in = implode(',', array_map([$sqlite->getPdo(), 'quote'], $values)); 98 $cond[] = " ( T1.key = " . $sqlite->getPdo()->quote($col) . 119 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col); 151 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite [all...] |
/plugin/webdavclient/ |
H A D | helper.php | 161 if(!$sqlite) 179 if(!$sqlite) 197 if(!$sqlite) 214 if(!$sqlite) 252 if(!$sqlite) 368 if(!$sqlite) 420 if(!$sqlite) 458 if(!$sqlite) 477 if(!$sqlite) 494 if(!$sqlite) [all …]
|
/plugin/bez/mdl/ |
H A D | SubscriptionFactory.php | 12 $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 [all...] |
H A D | ThreadFactory.php | 14 $r = $this->model->sqlite->query('SELECT create_date FROM thread ORDER BY id LIMIT 1'); 15 $date = $this->model->sqlite->res2single($r); 42 $r = $this->model->sqlite->query($sql, $from, $to); 53 $r = $this->model->sqlite->query($sql); 66 $r = $this->model->sqlite->query($sql, $from, $to); 71 $r = $this->model->sqlite->query($sql); 90 $r = $this->model->sqlite->query($sql, $from, $to, $from, $to); 97 $r = $this->model->sqlite->query($sql); 128 $r = $this->model->sqlite->query($sql, $from, $to); 147 $r = $this->model->sqlite [all...] |
/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/fksnewsfeed/inc/ORM/ |
H A D | ModelStream.php | 23 …$res = $this->sqlite->query('SELECT * FROM priority o JOIN news n ON o.news_id=n.news_id WHERE str… 25 $ars = $this->sqlite->res2arr($res); 27 $service = new ServiceNews($this->sqlite); 29 $priority = ModelPriority::createFromArray($this->sqlite, $ar); 57 $res = $this->sqlite->query('SELECT * FROM dependence WHERE parent=?', $this->streamId); 58 $service = new ServiceStream($this->sqlite); 59 foreach ($this->sqlite->res2arr($res) as $row) { 70 $res = $this->sqlite->query('SELECT * FROM dependence WHERE child=?', $this->streamId); 71 $service = new ServiceStream($this->sqlite); 72 foreach ($this->sqlite->res2arr($res) as $row) {
|
/plugin/struct/helper/ |
H A D | imexport.php | 11 use dokuwiki\plugin\sqlite\SQLiteDB; 19 private $sqlite; 39 $this->sqlite = $helper->getDB(false); 40 if (!$this->sqlite instanceof SQLiteDB) return; 42 $schemaName = $this->sqlite->escape_string($schemaName); 47 $pattern = $this->sqlite->escape_string($pattern); 51 $this->sqlite->doTransaction($sql); 66 $this->sqlite = $helper->getDB(false); 67 if (!$this->sqlite instanceof SQLiteDB) return []; 70 $patterns = $this->sqlite 15 private $sqlite; global() variable in helper_plugin_struct_imexport [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/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/bez/action/ |
H A D | migration.php | 31 if ($event->data['sqlite']->getAdapter()->getDbName() !== 'b3p') { 46 /** @var helper_plugin_sqlite $sqlite */ 47 $sqlite = $data['sqlite']; 58 $db = $sqlite->getAdapter()->getPdo(); 79 /** @var helper_plugin_sqlite $sqlite */ 80 $sqlite = $data['sqlite']; 91 $db = $sqlite->getAdapter()->getPdo(); 113 * @param helper_plugin_sqlite $sqlite [all...] |
/plugin/top/_test/ |
H A D | date.test.php | 18 $sqlite = $top_helper->getDBHelper(); 21 $sqlite->query($sql,'wiki:start',3,'','201407'); 22 $sqlite->query($sql,'wiki:start',2,'','201401'); 23 $sqlite->query($sql,'wiki:start',6,'','201201'); 24 $sqlite->query($sql,'wiki:start',1,'',null); 25 $sqlite->query($sql,'en:wiki:start',8,'en','201201'); 26 $sqlite->query($sql,'en:wiki:start',1,'en','201303'); 27 $sqlite->query($sql,'de:wiki:start',6,'de','201201');
|
/plugin/bibtex4dw/lib/ |
H A D | bibtexrender.php | 25 public static $sqlite = array(); variable in bibtexrender_plugin_bibtex4dw 33 'sqlite' => false, 92 $this->_conf['sqlite'] = $this->plugin->getConf('sqlite'); 98 if ($this->_conf['sqlite']) { 99 $this->sqlite = plugin_load('helper', 'sqlite'); 100 if(!$this->sqlite){ 101 msg('You asked for using the sqlite plugin but it is not installed. Please install it', -1); 105 if(!$this->sqlite [all...] |
/plugin/combo/ComboStrap/ |
H A D | Event.php | 60 $sqlite = Sqlite::createOrGetBackendSqlite(); 72 $version = $sqlite->getVersion(); 76 // https://www.sqlite.org/lang_returning.html 80 // https://www.sqlite.org/lang_delete.html#optional_limit_and_order_by_clauses 81 if ($sqlite->hasOption("SQLITE_ENABLE_UPDATE_DELETE_LIMIT")) { 84 $request = $sqlite->createRequest() 112 $request = $sqlite->createRequest() 132 $request = $sqlite->createRequest() 193 $sqlite = Sqlite::createOrGetBackendSqlite(); 214 $request = $sqlite [all...] |
/plugin/sqlite/helper/ |
H A D | db.php | 6 * DokuWiki Plugin sqlite (Helper Component) 16 protected $sqlite; 32 $this->sqlite = plugin_load('helper', 'sqlite'); 35 if (!$this->sqlite->init('sqlite', DOKU_PLUGIN . 'sqlite/db/')) { 36 $this->sqlite = null; 45 return $this->sqlite; 14 protected $sqlite; global() variable in helper_plugin_sqlite_db
|
/plugin/approve/ |
H A D | admin.php | 36 $sqlite = $db_helper->getDB(); 48 $sqlite->query('DELETE FROM maintainer WHERE id=?', $assignment['id']); 49 $helper->updatePagesAssignments($sqlite); 59 $sqlite->storeEntry('maintainer', $data); 61 $helper->updatePagesAssignments($sqlite); 80 $sqlite = $db_helper->getDB(); 86 $res = $sqlite->query('SELECT * FROM maintainer ORDER BY namespace'); 87 $assignments = $sqlite->res2arr($res);
|
/plugin/telleveryone/ |
H A D | api.php | 10 $sqlite = $db_helper->getDB(); variable 16 $res = $sqlite->query("SELECT value FROM config WHERE key='token'"); 17 if ($sqlite->res2single($res) != $INPUT->str('token')) { 22 $res = $sqlite->query('SELECT id, timestamp, user, message_html FROM log 24 $arr = $sqlite->res2arr($res);
|
/plugin/approve/action/ |
H A D | migration.php | 34 if ($event->data['sqlite']->getAdapter()->getDbname() !== 'approve') { 54 protected function insertOrIgnore(helper_plugin_sqlite $sqlite, $table, $entry) { argument 59 return $sqlite->query($sql, array_values($entry)); 64 /** @var helper_plugin_sqlite $sqlite */ 65 $sqlite = $data['sqlite']; 66 $db = $sqlite->getAdapter()->getDb(); 77 $sqlite->storeEntry('maintainer',[ 84 $sqlite->storeEntry('maintainer',[ 92 $sqlite [all...] |