I'm loving the Wikipedia PHP Script, and solving
my all my
install problems except one. I'm not quite sure how to edit
the tinyblog user_rights field so that I can become a sysop
of my own site! Does anyone have a php script or an SQL query
to do it?
If you're using the Phase III software (the stuff in the
"newcodebase" directory, then just use this SQL query:
UPDATE user SET user_rights='sysop,developer' WHERE user_id=X;
(where X is your user id, which you can determine with s SELECT
query). In the Phase II software, replace "sysop" and "developer"
with "is_sysop" and "is_developer". If you only want one or the
other, omit the comma.
Also, this might not be the place, but I've
noticed how cool the
wikipedia.com's mod_rewrite is, but I don't know how to use it?
Is there a simple setup text file on how to use mod_rewrite with
In general, using "mod_rewrite" and "simple" in the same sentence
is a non-sequitur. The full documentation is on Apache's site.
The incantation used at wikipedia.org
RewriteRule ^/wiki/(.*)$ /w/wiki.phtml?title=$1 [NE]
RewriteRule ^/w/wiki.phtml(.*) /w/wiki.phtml$1
RewriteRule ^/wiki$ /w/wiki.phtml
RewriteRule ^/$ /w/wiki.phtml
RewriteRule ^/wiki.phtml/(.*)$ /w/wiki.phtml/$1 [NE]
RewriteRule ^/wiki.phtml$ /w/wiki.phtml
This is with the software installed in the "/w" directory
(I don't like installing stuff in the document root--it's too
inflexible for later changes. But those last two lines make
it look as if it's installed at root). If you install the
scripts in a different directory, or want different URLs,
modify the above appropriately.