/plugin/data/ |
H A D | action.php | 57 $sqlite = $this->dthlp->getDB(); 58 if (!$sqlite) return; 62 $pid = (int) $sqlite->queryValue('SELECT pid FROM pages WHERE page = ?', $id); 65 $sqlite->exec('DELETE FROM data WHERE pid = ?', $pid); 66 $sqlite->exec('DELETE FROM pages WHERE pid = ?', $pid);
|
H A D | requirements.txt | 2 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
|
/plugin/data/admin/ |
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']);
|
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...] |
/plugin/data/syntax/ |
H A D | cloud.php | 85 $sqlite = $this->dthlp->getDB(); 86 if (!$sqlite) return false; 107 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col); 119 WHERE data.key = " . $sqlite->getPdo()->quote($ckey) . " 155 $sqlite = $this->dthlp->getDB(); 156 if (!$sqlite) return false; 168 $rows = $sqlite->queryAll($data['sql']);
|
H A D | entry.php | 230 $sqlite = $this->dthlp->getDB(); 231 if (!$sqlite) return false; 239 $sqlite->getPdo()->beginTransaction(); 270 $sqlite->query("DELETE FROM DATA WHERE pid = ?", $pid); 292 $sqlite->getPdo()->commit(); 294 $sqlite->getPdo()->rollBack(); 320 $sqlite = $this->dthlp->getDB(); 321 if (!$sqlite) return false; 323 return call_user_func_array(array(&$sqlite, 'query'), $args);
|
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...] |
H A D | table.php | 253 $sqlite = $this->dthlp->getDB(); 254 if (!$sqlite) return false; 268 $rows = $sqlite->queryAll($data['sql']); 586 $sqlite = $this->dthlp->getDB(); 587 if (!$sqlite) return false; 606 $from .= ' AND ' . $tables[$key] . ".key = " . $sqlite->getPdo()->quote($key); 643 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col); 680 $from2 .= ' AND ' . $table . ".key = " . $sqlite->getPdo()->quote($col); 685 ' DATARESOLVE(' . $table . '.value,' . $sqlite->getPdo()->quote($filter['colname']) . ') ' .
|
/plugin/randomtables/helper/ |
H A D | helper.php | 12 /** @var helper_plugin_sqlite $sqlite */ 13 $sqlite = plugin_load('helper', 'sqlite'); 15 if(!$sqlite){ 16 msg('This plugin requires the sqlite plugin. Please install it', -1); 20 if(!$sqlite->init('randomtables', DOKU_PLUGIN . 'randomtables/db/')){ 24 return $sqlite;
|
/plugin/sql2wiki/ |
H A D | README | 3 Save results of sqlite queries into page syntax.
|
H A D | plugin.info.txt | 6 desc Save results of sqlite queries into page syntax.
|
/plugin/sql2wiki/action/ |
H A D | sqlite.php | 3 use dokuwiki\plugin\sqlite\QuerySaver; 4 use dokuwiki\plugin\sqlite\SQLiteDB;
|
/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);
|
H A D | helper.php | 8 * @param helper_plugin_sqlite $sqlite 11 public function no_apr_namespace(helper_plugin_sqlite $sqlite) { argument 14 $res = $sqlite->query('SELECT value FROM config WHERE key=?', $key); 15 $no_apr_namespaces_db = $sqlite->res2single($res); 19 $sqlite->query('UPDATE config SET value=? WHERE key=?', $no_apr_namespaces_conf, $key); 21 $res = $sqlite->query('SELECT page, hidden FROM page'); 22 $pages = $sqlite->res2arr($res); 26 $in_hidden_namespace = $this->in_hidden_namespace($sqlite, $id, $no_apr_namespaces_conf); 30 $sqlite->query('UPDATE page SET hidden=? WHERE page=?', $new_hidden, $id); 39 * @param helper_plugin_sqlite $sqlite 44 use_approve_here(helper_plugin_sqlite $sqlite, $id, & $approver = null) global() argument 63 find_last_approved(helper_plugin_sqlite $sqlite, $id) global() argument 75 get_hidden_namespaces_list(helper_plugin_sqlite $sqlite, $no_apr_namespaces = null) global() argument 95 in_hidden_namespace(helper_plugin_sqlite $sqlite, $id, $no_apr_namespaces = null) global() argument 110 weighted_assignments(helper_plugin_sqlite $sqlite) global() argument 139 isPageAssigned(helper_plugin_sqlite $sqlite, $id, & $pageApprover = null, $weighted_assignments = null) global() argument 173 updatePagesAssignments(helper_plugin_sqlite $sqlite) global() argument [all...] |
/plugin/approve/helper/ |
H A D | db.php | 18 protected $sqlite; variable in helper_plugin_approve_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/approve/syntax/ |
H A D | table.php |
|
/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...] |
H A D | notification.php | 37 $sqlite = $db_helper->getDB(); 38 $event->data['dependencies'][] = $sqlite->getAdapter()->getDbFile();
|
H A D | prettyprint.php | 17 $sqlite = $db_helper->getDB(); 28 if (!$helper->use_approve_here($sqlite, $INFO['id'], $approver)) return; 45 $res = $sqlite->query('SELECT ready_for_approval, ready_for_approval_by, 50 $approve = $sqlite->res_fetch_assoc($res);
|
H A D | approve.php | 28 $sqlite = $db_helper->getDB(); 36 if (!$helper->use_approve_here($sqlite, $INFO['id'])) return; 58 $sqlite = $db_helper->getDB(); 66 if (!$helper->use_approve_here($sqlite, $INFO['id'])) return; 68 $last_approved_rev = $helper->find_last_approved($sqlite, $INFO['id']); 83 $sqlite = $db_helper->getDB(); 93 if (!$helper->use_approve_here($sqlite, $INFO['id'], $approver)) return; 96 $res = $sqlite->query('SELECT MAX(version)+1 FROM revision 98 $next_version = $sqlite->res2single($res); 103 $sqlite [all...] |
H A D | cache.php | 44 $sqlite = $db_helper->getDB(); 45 $cache->depends['files'][] = $sqlite->getAdapter()->getDbFile();
|
H A D | move.php | 30 $sqlite = $db_helper->getDB(); 40 $sqlite->query('UPDATE revision SET page=? WHERE page=?', $new, $old);
|
H A D | revisions.php | 21 $sqlite = $db_helper->getDB(); 29 if (!$helper->use_approve_here($sqlite, $INFO['id'])) return; 31 $res = $sqlite->query('SELECT rev, approved, ready_for_approval 34 $approve_revisions = $sqlite->res2arr($res);
|
/plugin/notification/helper/ |
H A D | cron.php | 11 protected $sqlite; variable in helper_plugin_notification_cron 17 $this->sqlite = $db_helper->getDB(); 25 $res = $this->sqlite->query('SELECT user from cron_check'); 26 $ourUsers = $this->sqlite->res2arr($res); 39 $this->sqlite->storeEntry('cron_check',
|
H A D | db.php | 18 protected $sqlite; variable in helper_plugin_notification_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; 70 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)… 73 if (!$this->sqlite) { 77 return $this->sqlite; 87 if (!$this->sqlite) { [all …]
|