[Mediawiki-l] Re: need mysql geek :D touchgraph experiment

[FxParlant]

Hi,

The problem I'm facing, is that I must have in a first query, the pages 
with their different namespaces(0 or 14) and titles, and in a second 
one, the links between them.

As you all know, some links are in the "links" table, and some other are 
in the "categgorylinks" (or am I mistaken).

The problem is that I MUST NOT (unless I want my engine to die) have 
links from pages who are not mentioned in the first query. Unfortunately 
most of the links in "categorylinks", as mentioned by Richard, are not 
yet created in the cur table. Furthermore, it is also very difficult to 
restrict the pair of links from the "links" table, to be BOTH with 
namespace=0 or namespace=14.

Nevertheless here is the "result" I could manage, only with the category 
pages of my site.

http://www.fxparlant.net/Special:Touchgraph
(there must be a mistake in the html because the applet fails in 
Firefox... but works in IE)...just move the first node

Thanks to Jamie and Richard, for their support ... I'm off to bed :D

See you all tomorrow
François



Jamie Bliss wrote:
> For clarification, you mean category pages with categories on them?
> 
> On Apr 9, 2005 4:06 PM, Richard Holton <richholton at gmail.com> wrote:
> 
>>Ok. First you'll need to create the new table. Something like:
>>
>>CREATE TABLE foo (
>>  foo_from int unsigned NOT NULL default 0,
>>  foo_to     int unsigned NOT NULL default 0,
>>  UNIQUE KEY foo_from (foo_from ,foo_to),
>>  KEY (foo_to)
>>);
>>
>>Then, fill in the new table from what already exists in CategoryLinks and Cur
>>
>>INSERT  INTO foo (foo_from, foo_to)
>>SELECT cl_from, cur_id FROM categoryLinks, cur
>>WHERE cur_namespace=14 AND cur_title = cl_to
>>
>>This (in effect) takes each record in the  categoryLinks table and
>>finds the matching record in cur based on a match between cur_title
>>and cl_to. If the resulting record in cur is also from namespace 14,
>>then it takes the cl_from in categoryLinks and the cur_id from cur and
>>writes those as a record to the new "foo" database.
> 
> 
> Would [[:Category:Foo]] type links be included in this? (This makes a
> normal link to the page Category:Foo).
> 
> -- Jamie
> -------------------------------------------------------------------
> http://endeavour.zapto.org/astro73/
> Thank you to JosephM for inviting me to Gmail!
> Have lots of invites. Gmail now had 2GB.