I suggest to add two new fields to the database (cur table) * cur_namespace (varchar) so articles can be distinguished by namespace without using the "LIKE" MySQL query (this was mentioned before) * cur_is_redirect (boolean) so #REDIRECT pages can be excluded likewise
As you can see, I now try to discuss things instead of just doing them ;)
Magnus
On dim, 2002-05-12 at 02:29, Magnus Manske wrote:
I suggest to add two new fields to the database (cur table)
- cur_namespace (varchar) so articles can be distinguished by namespace
without using the "LIKE" MySQL query (this was mentioned before)
Should there be a separate title-without-namespace field as well, or would cur_title now be that?
We want to be able to group things by namespace (ie, count the talk pages) but also group things by title ignoring namespace (ie, watchlist includes an article and any talk/whatever pages).
- cur_is_redirect (boolean) so #REDIRECT pages can be excluded likewise
Not a bad idea! Might it be even easier to make it a string field which contains the name of the page being redirected to? This would save parsing the #REDIRECT [[x]] line or relying on the link tables when doing mass checks in, eg, "links to this page".
-- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org