1 !!! Database and Wiki Backup Tools
3 It is recommended to do daily backups of your database and/or your wiki pages.
5 In this directory are some sample scripts, which could help to setup your
6 cronjobs, on the server or even remotely (zipdump or dumpserial).
11 # daily serial pgsrc dump
12 DEFAULT_DUMP_DIR = /var/www/wikidb/pgsrc
13 nice /usr/bin/lwp-request -P -d -m GET "http://localhost/wiki/?action=dumpserial"
15 # pgsrc rcs update (local history)
19 nice wiki2omega -u /wiki $DEFAULT_DUMP_DIR | \
20 scriptindex /var/lib/omega/data/wiki /var/lib/omega/scripts/wiki2index.script \
21 > /var/log/omega/updateindex-wiki.log
23 # check uploads for viri
24 date >> /var/www/virus-found/scan.log
25 nice clamdscan -l /var/www/virus-found/scan.log --move=/var/www/virus-found /var/www/html/phpwiki/uploads
28 !!! Xapian Fulltext Search Integration
30 See http://www.xapian.org/
32 * wiki2omega - perl script to update the database from wiki plaintext files or live dumps
33 * wiki2index.script - xapian scriptindex definition
36 This is a sample template section for search.tmpl to use xapian as external search engine.
38 <h5>Fulltext Search</h5>
39 <form id="searchform2" action="/cgi-bin/omega"
40 method="get" accept-charset="<?php echo $charset?>" style="display:inline" class="searchform">
41 <?php $s = $request->getArg('s') ? $request->getArg('s') : _("Search"); ?>
42 <input type="hidden" name="DEFAULTOP" value="AND" />
43 <input name="P" size="18" maxlength="256"
44 value="<?php echo $s?>"
45 onfocus="if (this.value == '<?php echo _("Search")?>') {this.value = '';}"
46 onmouseout="window.status=''; return true;"
47 onmouseover="window.status='<?php echo _("Quick Search")?>'; return true;"
48 type="text" id="search2"
49 title="<?php echo _("Search term(s)") ?>" />
50 <div align="right" style="padding-right:10px;">
51 <input type="submit" name="searchtype" value="fulltext" class="searchButton" title="External Fulltext Search">
55 This displays the result not in a wiki layout. However the omega layout can be tuned.
56 == Open Office to Phpwiki converter
58 Convert Open Office 2.3 (or later), Star Office, MS Word or MS Office Documents to Phpwiki.
62 You first have to install (once for all) the Open Office to Phpwiki converter.
64 To install the export filter:
65 * Start Open Office 2.3 (or later)
66 * From //Tool// choose //XML Filter Settings//
67 * Choose //New// and in //General// fill the form with the following data:
68 ** Filter name: //Phpwiki//
69 ** Application: //~OpenOffice.org Writer (.odt)//
70 ** Name of file type: //Phpwiki//
71 ** File extention: //txt//
72 * Choose //Transformation// and fill the form with the following data:
73 ** //XSLT for Export//: put the full path to **phpwiki/admin/odt2phpwiki.xsl**
75 === Open Office Converter Usage
77 Open your Word document in Open Office.
79 Select //Export...// in the //File// menu, then select //Phpwiki// in //File format// menu.
81 You will get a text file ({{{.txt}}}). Copy and paste the content of this file in your wiki page.
83 Please note the following:
84 * Tables will always be bordered ({{{class="bordered"}}}), regardless they are or not in Word; you might want to change this in the generated content.
85 * If there was a table of contents in your Word file, you can delete it and replace it with the ~CreateToc plugin (use the TOC button from the Edit Toolbar).
86 * If there were images in your document, you should also upload them in the wiki.