I'll start now to merge my AcadWiki enhancements into CVS.
I need the latest improvements on VersionControl and UserAuth. Good work!
BetterIndex, RandomPage, OrphanPages, WantedPages, improved BackLink,
SeparateListOutput, MagicPages, SplitWordsInTitle, BetterRecentChanges,
optional PageChangeNotification to the admin only, ImageLinks
maybe: locale stuff (this is awful, I just broke my german wiki db after
having recompiled to php-4.0.6)
maybe: localized WikiNameRegexp with TrailingNumbers (optionally)
maybe: multiline code, my ugly hacks for <code> .. </code>, <verbatim> ..
</verbatim>, and <nowiki> .. </nowiki>
how to workaround this mysql 3.23 feature which doesn't work in 3.22?
select pagename from wiki order by rand() limit 1;
the rand() function is defined in 3.22 also, but I wanted to avoid subselects.
$res = mysql_query("select pagename from $WikiPageStore", $dbi["dbc"]);
$rows = mysql_num_rows($res);
$page = mysql_result($res,rand(0,$rows-1));
how can one avoid to checkout all pages by using mysql the rand() function?
LIMIT doesn't accept ROUND($pagecount*rand()),1 as argument.
mysql v3.22.25 doesn't accept this syntax neither:
oh bad. at least attempt 1 is cross-db compatible.
A new user requested feature: display the number of chars in pageinfo, maybe
we need this to produce a community text for a local internet handbook, which
10,000 chars. is this okay to put it into the pageinfo field. I know that
are only static db fields, but the user doesn't care. some convenience figures
imho on the info page.