3 <title>ewiki administration + database tools</title>
4 <link rel="stylesheet" type="text/css" href="t_config.css">
5 <style type="text/css">
8 border-bottom: 1px dashed #663388;
20 display: block; /* huh! */
21 margin: -14px; /* two pixel less cause of previous border */
22 padding: 12px; /* has no impact in img or following text */
23 text-decoration: none;
24 background-color: #cc7733;//#aaaacc;
25 border: solid 2px #aa5511;//#555599;
26 -moz-border-radius:9px; border-radius:9px;
33 <h1 class="title" style="height:50px; padding:0px;">
34 <img src="../tlogo.png" width="75" height="50" align="center" style="background:#cc7733;">
38 The following web-based utilities provide raw access to your Wikis
39 database and allow for common administration tasks. They are separate from
40 the main wiki and are inaccessible without password for obvious reasons.
41 <small>You can however use the account "<tt>readonly</tt>" with password
42 "<tt>test</tt>" on your local computer or our demo site.
46 <table border="0"><tr>
47 <td width="35%" valign="top" class="add-border-right">
51 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAADFBMVEUAAAAAAAC8LiksjCERIu3UAAAAAXRSTlMAQObYZgAAAD5JREFUeNpjYAAB0QggoaUFJKRWAAmhJSACxJLKAhIaXGBFDAcYGEKDgYSDPJBTYAMkaj4ACf8LQCI8AKIGAGOKCg8vHdTeAAAAAElFTkSuQmCC" width="64" height="64" border="0" alt="flags" align="left">
52 <h4><a href="t_flags.php">page flags</a></h4>
53 Every page can have multiple control flags and feature settings
54 enabled, like _DISABLED, _READONLY, _APPENDONLY, ... But this tool
55 does not show all of them.
60 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAACVBMVEUAAAAAAADONzcw6FexAAAAAXRSTlMAQObYZgAAAERJREFUeNodidEJwCAQQ1+guIOdxhGc46bxoyOcBZ3SYEJCeIGr7ijVKVnSFYnmHmivBvH5Dg8ZoT+hzAXvMKytwmNfHYJHDxfYjsA2AAAAAElFTkSuQmCC" width="64" height="64" border="0" alt="cross" align="left">
61 <h4><a href="t_remove.php">remove pages</a></h4>
62 You can completely delete unused or unwanted pages from the database.
63 This tool even analyzes all entries and gives you recommendations on
69 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQBAMAAADt3eJSAAAAD1BMVEUhAADDOjoAAACOjo7/xyjEYm6/AAAAAXRSTlMAQObYZgAAAFlJREFUeNptzdEJwDAIBFAbHCAXMkAwG8QFFNx/pmjpZ+/nHocg0U+Y2MiqKewdOrvNxNMDwQVzRCQ8Mb3gwEQhAAxJVO1DDJGtuoiHVhL7Q1M9InnbRFZ9usosDDMBVYGFAAAAAElFTkSuQmCC" width="64" height="64" border="0" alt="fire" align="left">
70 <h4><a href="t_holes.php">strip old versions</a></h4>
71 Every page edit adds an "archive version", which is good to revert
72 unwanted changes. You should however clean up a few and free database
73 space from time to time.
78 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAADFBMVEUAAAACAgKOjo46Ss62+ZtpAAAAAXRSTlMAQObYZgAAADpJREFUeNpjYBB1YGBgiApgYGDMmwIk9i0BEv+/H2BgrANyGeKAEhAljCAWA5gIAREicEIURLAygAEACaEJal8yqKQAAAAASUVORK5CYII=" width="64" height="64" border="0" alt="glass" align="left">
79 <h4><a href="t_checklinks.php">check link directory</a></h4>
80 Can check external hyperlinks, if you have pages which collect such
87 This tool from the plugins/admin/ section allows to <b>delete</b> and
88 <b>rename</b> a <label for="control_id">page</label>, or to set the
89 <b>flags</b> or <b>meta data</b> fields in it:<br>
90 <form action="t_control.php" action="GET" style="display:inline">
91 <input id="control_id" name="id" value="" size="12">
92 <input type="submit" value="go">
98 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAACVBMVEXJECsDAjUdViGp0fNsAAAAAXRSTlMAQObYZgAAADJJREFUeNpjYAAB0UBXBwYIC8ZgEAlxhbJEXQJhLFHXBSB6AVCWaxWQASREQ0WgYiAAAA6pCBrk7pmjAAAAAElFTkSuQmCC" width="64" height="64" border="0" alt="text+" align="left">
99 <h4><a href="t_textinsert.php">text insert</a></h4>
100 Insert a collection of plain text files as wiki pages into the database
101 (no versioned files). The files must already reside on the Web server
102 (like files init-pages/ dir).
107 <img src="about:text.gif" width="64" height="64" border="0" alt="loadin" align="left">
108 <h4><a href="t_textupload.php">TextUpload</a></h4>
109 If you don't have this powerful plugin loaded, then you can access it
110 at least from here, and upload pages from many different file formats
111 and even multiple pages packed in .zip or .tar files.
117 </td><!--..........................................................-->
118 <td width="35%" valign="top" class="add-border-right">
121 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQBAMAAADt3eJSAAAAElBMVEUAAAAAAACJGxvEKRuJiYkjrxbbTxXCAAAAAXRSTlMAQObYZgAAAD1JREFUeNpjYIABRkEgEAAxlJWUlHEwlIyNjSAMIAAzVFxcoAwVFyeBUGSGiIuLY2hoKMR4OIMBRiMYSAAA47cKWIk/7S4AAAAASUVORK5CYII=" width="64" height="64" border="0" alt="disk+" align="left">
122 <h4><a href="t_backup.php">backup</a></h4>
123 Archives all your pages in backup files (available in different
124 formats) for archival / later emergency restoration. You need a
125 writeable data directory on your Web server.
130 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQBAMAAADt3eJSAAAAElBMVEUAAAAAAACJGxvEKRseGaiJiYllJQk1AAAAAXRSTlMAQObYZgAAAEBJREFUeNpjYIABRkEgEAAxlJWUlHEwlIyNjSAMIBBxADJUQ0OhDNXQIFSGaGhoIIgBBixQhgsQQARcXOBCCDUAFf8L8n8A9ksAAAAASUVORK5CYII=" width="64" height="64" border="0" alt="disk↓" align="left">
131 <h4><a href="t_restore.php">restore</a></h4>
132 Restore your database from archived backup files, which you must
133 upload before into a directory on the Web server.
138 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAACVBMVEVtPQltPQnWnFV6PYqaAAAAAXRSTlMAQObYZgAAAChJREFUeNpjYEADrA5AQkCAgYExNNSBgW3VqgkYxKxlyARraGgAQjsA/JIPevMXtUEAAAAASUVORK5CYII=" width="64" height="64" border="0" alt="suitcase" align="left">
139 <h4><a href="t_transfer.php">transfer file</a></h4>
140 Use this tool to quickly get a backup of all Wiki pages or to restore
141 it later. You directly upload or get a data file in binary format,
142 which eases moving pages from one installation to another. With the
143 <a href="../?MiniDump">MiniDump</a> plugin you could get a tar.
148 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAADFBMVEVtPQk4ODgdViHTEBAMndy/AAAAAXRSTlMAQObYZgAAADhJREFUeNpjYIADVhARGgAkAgIaQMTi/0DuaiCRteoAQ0DWqj9AsdV/gPKLDwCJ5v9Agvk/AyoAAJ5tERMP1xoGAAAAAElFTkSuQmCC" width="64" height="64" border="0" alt="A→E" align="left">
149 <h4><a href="t_convertdb.php">database convert</a></h4>
150 This tool can migrate pages from a few known foreign Wiki databases to
151 the DB scheme used by ewiki. It can also export back to PhpWiki now.
156 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAACVBMVEX///8AAAC6GxuVy9DtAAAAAXRSTlMAQObYZgAAADdJREFUeNpjYAABUVdRBggQCQmFskRZHaAsLY1VUJbGigUdDAodHSuArBUrGDgaOjoYNEAEHAAAWwMLw86WwOoAAAAASUVORK5CYII=" width="64" height="64" border="0" alt="SPAM" align="left">
157 <h4><a href="t_revert.php">mass revert</a></h4>
158 Use this tool to undo mass changes made by an attacker or an automated
159 wiki garbaging script. The offending revisions are discovered by
160 providing the IP or host name under which the edits were stored.
165 <h4><a href="t_searchandreplace.php">search and replace</a></h4>
166 Provides a global search feature, which can even use regex to find
167 string occourences and replace them with defined text fragments. It
168 can run a safe dry test.
173 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAAM1BMVEUAAAAXGBYgIR9+CwwuLy03OTY8Pjs/QT5ERkNHSUbhDhJSVFFZW1hgYl9pa2iBg4AAAQAqadZ7AAAAAXRSTlMAQObYZgAAAFhJREFUeNpdjdEWgCAIQydCiWb5/1+bpVS0w8vudhiAnCP6vRr+Qm34HM2rukKTsLADxEEfcJOV5w8/YnmXwGZmJJ+KA9YpQnBIE8Gpyg8U9YRr8mA7diacq98CwbkZKA8AAAAASUVORK5CYII=" width="64" height="64" border="0" alt="antenna" align="left">
174 <h4><a href="t_sync.php">sync</a></h4>
175 Transfer the contents of <t>this</i> Wikis database onto a remote
176 installation or the other way round. Useful for editing pages offline,
177 while keeping a public Wiki installation up-to-date.
183 </td><!--..........................................................-->
184 <td width="30%" valign="top">
186 <h3 style="letter-spacing:1px;"><nobr>power toys</nobr></h3>
188 Some of the older and more simple tools on the left have been surpassed
189 by more powerful/combined ones (which on the other hand are then not
190 easier to use for everyone).
196 <h4><a href="t_commander/">commander</a></h4>
197 The <i>WikiCommander</i> provides an easy file viewer like interface
198 to inspect and modify pages and all their internal flags and fields.
199 You can also delete, rename or duplicate pages. It even provides a
200 shell-like interface for inserting common actions into a
203 So this effectively replaces a few of the early utilities.
208 <h4><a href="t_ewikictl.php">ewikctl/web</a></h4>
209 <tt>ewikictl</tt> is a powerful <b>commandline</b> utility, but you need
210 shell (ssh) access on the Web server to use it. There is however
211 now this web-based frontend for all other users, which gives access
212 to most of its commands.
217 <h4><a href="t_setupwiz.php">setup wizard</a></h4>
218 With the SetupWizard you can more easily create a custom
219 <tt>config.php</tt> script or even a <tt>monsterwiki.php</tt> file
220 (combination of the ewiki core and plugin files). This saves you
221 looking into <a href="../?README.plugins">README.plugins</a> if you
222 can live without a few advanced features.
227 <h4><a href="cron.d/">run cron.d/</a></h4>
228 If you haven't a cron daemon you can start the automated database
229 admin tools by hand on occassion. They however need a bit
230 configuraton prior use (very little of it is enabled per default).
238 If you had the right plugins loaded, you'd also get in-Wiki
239 powertools like:</small>
241 · <a href="../?WikiDump">WikiDump</a> and the enhanced
242 <a href="../?WikiDump2">WikiDump2</a> can make a tarball with static
243 .html files from all your pages<br>
244 · use <a href="../?TextUpload">TextUpload</a> for uploading many pages
245 in a ZIP or Tarball<br>
246 · <a href="../?MiniDump">MiniDump</a> to get a tarball with raw text
247 of all pages (for later reinsertion)<br>