imported>Import: Imported current content

2026-01-28T11:54:25Z

Imported current content

New page

[[PhpWiki]] is non standard and not well supported lately. [[WikiWorld]] moved to a [[http://eies.org new server]] with [[http://php.net php5]]. Running WikiWorld failed miserably using either the php4 version it was using or importing into the latest php5 version, so [[WE]] decided it was time to convert to a more standard wiki, the one used by [[http://wikipedia.org Wikipedia]].

We used shell and sed like this:

http://meta.wikimedia.org/wiki/Documentation:PhpWiki_conversion

I enhanced it to encode bare [[WikiWord]]s, %%% newlines, and <verbatim> markups

<pre>
cat phpwikiconvert
# typeset markup
s/_$[^_]*$_/''\1''/g # italic -- OK
s/\*$[^\*]*$\*/'''\1'''/g # boldface -- OK
s!=$[^=]*$=!<code>\1</code>!g # fixed-width -- OK

# header markup -- OK
s/!!!$.*$$/==\1==/g
s/!!$.*$$/===\1===/g
s/!$.*$$/====\1====/g

# table markup (hopefully)
s!$[^|][^|]*$|!\1||!g
s!^|!|-\n|!g # convert row start -- OK
s!.*plugin OldStyleTable.*!\{\|! # convert table start -- mostly OK
s!^?>$!\|\}! # convert table end -- mostly OK

# link markup
s!\[$.*$|$http.*$]![\2 \1]!g # url format -- OK
s!\[$.*$|$.*$\]![\2|\1]!g # switch display and link text -- OK
s!\[$[^]]*$\]![[\1]]!g # double bracketize -- OK
s!\[\[$http.*$\]\]![\1]!g # undo double-bracketing urls by above -- OK

# redirects
s!<?plugin RedirectTo page=$.*$?>!#REDIRECT [[\1]]!

# quotes
s!"!\\"!g

# %%% newlines - jim
s/!%%%/<br>/
s/<verbatim>/<pre>/
s!</vertatim>!</ pre>! # take out space b4 running - jim
#wikiwords - jim - allowing numbers added afterwards
s/^$[A-Z][a-z0-9][a-z0-9]*[A-Z][A-Za-z0-9]*$/[[\1]]/
s/ $[A-Z][a-z0-9][a-z0-9]*[A-Z][A-Za-z0-9]*$/ [[\1]]/g
</pre>

Files in the converted directory containing double back slashes got errors which I fixed by hand

grep -l "\\\\\\\\" * # will list any having double slashes

Files orginally having space in the name were not loaded with spaces in the name so I updated the load script to fix that.
<pre>
for file in *; do
title=`echo $file|sed 's!/!/!g;s|_| |g'|perl -n -e "print ucfirst;"`
cat <<END | mysql -u <username> -p<password> <databasename>
INSERT INTO page
(page_id, page_namespace, page_title, page_counter, page_restrictions, page_is_redirect, page_is_new, page_random, page_touched, page_latest, page_len)
VALUES
(NULL,0, "$title", 0,'', 0, 1, RAND(), NOW() 0, 0, LENGTH("`cat $file`"));

INSERT INTO text (old_id, old_text, old_flags)
VALUES (NULL, "`cat $file`", "utf-8");

INSERT INTO revision
(rev_id, rev_page, rev_text_id, rev_comment, rev_minor_edit, rev_user, rev_user_text, rev_timestamp)
SELECT NULL, page_id, LAST_INSERT_ID(),"PhpWikiMigration", 0, 1 ,"Admin", NOW() 0 FROM page WHERE page_title = "$title";

UPDATE page,revision
SET page.page_latest = LAST_INSERT_ID()
WHERE page.page_id = revision.rev_page

PhpWiki2MediaWiki - Revision history

imported>Import: Imported current content