COLLECTED BY
Organization:
Internet Archive
The Internet Archive discovers and captures web pages through many different web crawls. At any given time several distinct crawls are running, some for months, and some every day or longer. View the web archive through the
Wayback Machine.
Content crawled via the
Wayback Machine Live Proxy mostly by the Save Page Now feature on web.archive.org.
Liveweb proxy is a component of Internet Archive?s wayback machine project. The liveweb proxy captures the content of a web page in real time, archives it into a ARC or WARC file and returns the ARC/WARC record back to the wayback machine to process. The recorded ARC/WARC file becomes part of the wayback machine in due course of time.
The Wayback Machine - https://web.archive.org/web/20130330033506/http://lists.wikimedia.org/pipermail/wikitech-l/2005-April/016297.html
[Wikitech-l] Category array
Richard Holton richholton at gmail.com
Sun Apr 10 12:14:27 UTC 2005
On 4/10/05, Richard Holton <richholton at gmail.com> wrote:
> On 4/9/05, Dennis Schaaf <dennis.schaaf at gmail.com> wrote:
> > Hi,
> >
> > I'm trying to play around with the category page a little bit. Everything would
> > be a lot easier if I could just somehow get an array with all pages listed in
> > category x. Can you guys give me some hints on how to create such a function?
> > Unfortunately the databaselayout does not talk about categorylinks.
> >
> Dennis,
>
> cl_to is the name of the category.
> cl_from is the id of the page that belongs to that category -- matches cur_id
> cl_sortkey gives the page name that should be used when sorting the
> category list.
>
> So,
> SELECT cl_from FROM categoryLinks WHERE cl_to="Albania"
> will return a table with the cur_id's for all pages in category Albania
>
> -- Rich Holton
>
> [[W:en:User:Rholton]]
>
Also, as GeraldM points out in a separate thread, if you're looking to
do this for a large installation like Wikipedia, some categories may
grow quite large--perhaps into 10's of thousands of pages (think of
category:stub). So, depending on how and where you want to use this,
PHP arrays may be impractical.
-Rich Holton
--
[[W:en:User:Rholton]]
More information about the Wikitech-l mailing list