[Phpwiki-talk] SQL brain teaser

[Gary B. <ga...@in...>]

Hi guys,

In a fit of pique I added some new functionality which is implemented just
like %%Mostpopular%%. The code will probably not be of too much use to
you, since I only implemented it as MySQL, you'll probably want to
implement it using the new plugin architecture, and Jeff just rearranged
the database architecture anyway. Nevertheless, you might find the query
useful in case you add it, but since it is late and I am feeling cheeky I
have decided to present it as a puzzle. The first one to guess it doesn't
win a prize ;-)

   select topage from $WikiLinksStore
            left join $WikiPageStore on topage=pagename
    where frompage!='$RecentChanges'
      and frompage!='$TextFormattingRules'
      and pagename is NULL
    group by topage
    order by topage

(`echo QnatyvatYvaxf | tr A-Za-z N-ZA-Mn-za-m' for the answer, and you can
find the full patch in http://inauspicious.org/files/phpwiki/)

No cheating ;-)

Later,
Gary

[ ga...@in... ][ GnuPG 85A8F78B ][ http://inauspicious.org/ ]