[Mediawiki-l] Re: need mysql geek :D touchgraph experiment
FxParlant
f-x.p at laposte.net
Sat Apr 9 23:13:16 UTC 2005
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.
More information about the MediaWiki-l
mailing list